Hello,

We are conducting a webinar this Thursday @ 10 PST titled "High Availability Solutions for MySQL". We will be exploring the following topics:

• MySQL Replication
• MySQL Cluster
• MySQL Cluster & Replication
• Linux Heartbeat & MySQL Replication
• Linux Heartbeat, DRBD & MySQL
• Load Balancing & MySQL
• MySQL w/ Shared-Storage & Clustering Agents
• Other HA Solutions for MySQL

It is not too late to sign up:

http://www.mysql.com/news-and-events/web-seminars/

Hope you can join us,

Jimmy Guerrero
Sr Product Manager
MySQL

I will be talking about Falcon storage engine at the next Bulgarian user groups meeting in August. If you have some data that could help, please feel free to e-mail me. I am giving a bottle of beer for good link and/or information.

Maybe is good idea to focus on:

Goals of Falcon

What is Falcon

What Falson is not

Falcon is not Cluster SE

When the Falcon will be released

I will prepare my session using public information. This is step 2 of my expreriment to track information and how this information goes to the communities.

Bet you didn't think "Unisys" when you read that subject line, but it's true, all the same. Unisys has done a great job reinventing itself and extending its brand and expertise into new territory, most recently open source software. The firm has strong and growing relationships with MySQL and JBoss, and will increasingly be seen as one of the primary go-to partners for open source.

Julie Giera of Forrester has an interesting report on Unisys' open source services. The report deals primarily with Unisys, but also has interesting things to say about the larger open source services market.

On Unisys she says:

Unisys has announced a set of service offerings, called OASIS, for companies with open source platforms. It is the first time that a major IT service provider has offered a fully integrated set of services - including …

One of the projects I completed last week was the upgrade of the house phone system to the latest version of Trixbox (aka asterisk, aka defunct Asterisk@Home, more to come on that later).

I rarely answer my home phone line though. To even get to my extension you have to know what it is ahead of time, since the message you get when you dial my home phone line is "go away". If you know my extension though you can still get to me, which most likely means you will get my voicemail. All voicemail from the house line is sent to me as email, unlike my cell phone where it sits and rots.

If you can navigate my home phone system, I probably want to hear from you. With the upgrade I wanted my phone system to push data to me. To do this I wanted to integrate it into Laslow (and yes this is the next generation of Wolsal for those who remember it).

Laslow is an AIM bot that I run.

Why AIM? When my …

Many people asked me to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance.

To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported and now available in SHOW STATUS output. Most of them are same as you previously could find in SHOW INNODB STATUS, there are however few which were not available before.

In SHOW INNODB STATUS many values are per second. If you're planning to use these values make sure they are sampled over decent period of time. In the very start of printout Innodb will print:

PLAIN TEXT CODE:

…

I finally took the time to upgrade my MySQL cluster to 5.11 beta in order to test some new features. I have some clusters running with 2 ndb_mgmd nodes , but the ones that are scheduled for upgrade only have 1 management node yet.

So todays goal was getting multinode namagement up and running on 5.11 , and test the fresh --nowait feature for ndbd. Digging back to my older docs told me this would be a 15 minute effort, I'd had to change the config file to have 2 management nodes, restart them. Then change the connection strings for the ndbd's so that they have 2 nodes. Solved.

The first thing I ran into was that on the 2nd node I couldn't connect to ndb_mgmd via ndb_mgm , I could connect to it from a remote machine or while specifying a full connection string with the external ip but not from internally. Off course this was a fine dns problem as it seemed the machine couldn't do lookups for localhost :)

The second thing I …

WebSite: www.cacti.net

Cacti is a complete network graphing solution designed to harness the power of RRDTool’s data storage and graphing functionality. Cacti provides a fast poller, advanced graph templating, multiple data acquisition methods, and user management features out of the box. All of this is wrapped in an intuitive, easy to use interface that makes sense for LAN-sized installations up to complex networks with hundreds of devices.

Cacti is a complete frontend to RRDTool, it stores all of the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating …

WebSite: www.mysql.com

The world’s most popular open source database.

I remember when MySQL was spreading rapidly, mostly due to its ease of use. That was long time ago, apparently. Now we are entering the dark ages of obscure settings, or so it seems, reading some MySQL Cluster setting definitions.
Quoting from the the manual:

TimeBetweenLocalCheckpoints

This parameter is an exception in that it does not specify a time to wait before starting a new local checkpoint; rather, it is used to ensure that local checkpoints are not performed in a cluster where relatively few updates are taking place. In most clusters with high update rates, it is likely that a new local checkpoint is started immediately after the previous one has been completed.

The size of all write operations executed since the start of the previous local checkpoints is added. This …

Have you seen recent eWeek benchmarks which test OpenSource stacks and compare them to .NET ? Here is what was compared and here are results.

Results make me ask number of questions - why WAMP would perform 6 times better than LAMP ? Why Python would be faster than PHP on Windows but slower on Linux ? Without having such basic questions answered I can't accept results as valid. If you run benchmark and something unexpected pops up drill it down - quite frequently it would be configuration problem, bug or something similar.

Well, this is however not my main concern with this benchmark. Here is to start:

No Specifications - Good benchmark starts with specifications. What …