So say you have two mySQL servers called A and B. A and B are in a circular replication ring meaning

A replicates from B
B replicates from A

In addition, log-slave-updates is on, so if one server of either A or B goes down you can recover all the data from either side.

Therefore, here are some steps.
Take a snapshot of a server in the ring, with your favorite backup tool (mine is ibbackup)

When either server A or B dies, restore from said backup. Here are the steps. Let us assume server A goes down, and backups are done from server B.

restore the backup of server B to server A

On server-A turn off log-slave-updates (you will see why on the next line)
Add replicate-same-server-id on server A to …

My MySQL Conference presentation on Tuesday discussed my practical findings on how Infobright's technology works in developing a MySQL-based data warehouse. I also touched on a more high-level question of how to select a technology for a different kinds of data-related problem areas, and this article expands on that discussion.

As pointed out by several other speakers at the conference, the balance of CPU, memory and storage has changed significantly in the last 10 years. Two important throughput factors on a per-thread basis have flattened out: CPU cycles per second are in fact dropping as power and cooling have become limiting factors, and the number of IO operations per device have only been increasing linearly, though Flash technologies have leaped on the latter front. However, two other factors are continuing to grow on …

To begin to profile the Calpont multi-threaded, distributed hash join capabilities, we used one of the queries from Igor Babaev's BKA presentation from UC '08.  Detail was not provided on class of server used in the BKA presentation, so this isn't a direct comparison, only an approximation.  The bench started with 1 Calpont performance module (our distributed tier) - a Dell 8 core server with 16 GB memory.  We then extended the demo to understand how scaling our distributed tier impacted the join rate. 

The query was a join between two DBT3 tables; Lineitem and Part.  The number of rows varies by a scale factor (sf), for example sf1 is ~1GB, sf10 is ~10GB, sf100 is ~100GB. 

Rows (Millions)
Table             sf1     sf10     sf100
…

Oracle risks alienating MySQL's developers, given that it might have little incentive to ensure its future success. This could provide fodder for a fruitful fork--by Red Hat.

Did you get your certification during the User Conference? If so, be sure to stop by the MySQL Certified Professionals LinkedIn page and request membership! Congratulations on your certification!!MySQL DBA & Programming Blog by Mark Schoonover

Did you get your certification during the User Conference? If so, be sure to stop by the MySQL Certified Professionals LinkedIn page and request membership! Congratulations on your certification!!MySQL DBA & Programming Blog by Mark Schoonover

Today is the final day to take a MyQL Certification exam at the Users Conference. Save money with the special $25 price from the regular $200.

Are you new to MySQL -- try the associate exam? It is designed for those with 6 weeks to 6 months of experience with MySQL.

Or do you consider yourself at Guru level but do not have your Cluster DBA cert? Today is your chance to prove your skill.

There apparently was T-shirts for speakers at the MySQL Conference but a few of us speakers have not received them - it was not clear where to get them from in the conference hall and there was confusion when I asked other speakers when I asked them as they did not know. Well - it seems that there was a conference T-Shirt but it was from the conference hall (which is now all packed up and gone) .

One of the most interesting themes I have been paying attention to at this years Mysql users conference is techniques to create highly available storage volumes without spending a million dollars on a SAN or NAS infrastructure using companies like EMC or Network Appliance or IBM.

At least 3 options exist that I was not aware of before:

Amazon Elastic Block Store: as part of Amazon's EC2 web services you can have a virtual block level device available from your EC2 instance. Using this block level device you can either mount a typical linux filesystem and access the device with standard file access system calls or you can even do raw IO against the device without a filesystem. The data is stored on amazon's cloud, and is thus relatively highly available. As with all Amazon services you only pay for what you use. I was quoted performance numbers around 100 MB / sec which seems quite reasonable. You can only mount the …

Once again, I was unable to attend all of the sessions I wanted to at this year's User Converence, but I was happy to make it to Bob Burgess' talk on bash scripting with mysql. The slides and examples aren't up yet, but when they are (which may be as you read this, check the last link), they would probably also be a great tutorial.

So, I got bore\^D\^D\^D\^D inspired later that day to put some of the practices into use, and worked up a script to run mysqlslap in various ways against a server, and then added a couple funcitons to try it out on each storage engine. The script is below in its entirety - bash scripters, please be kind in your comments. No, I didn't write all this just for the pun in the …