This is a quick announcement to say that I'll be speaking at HighLoad++ this year (October 12-14 in Moscow).  I'll be presenting on a few topics:

• MySQL Performance Tuning (Conference Session)
• Quick Wins with Third Party Patches for MySQL (Conference Session)
• Performance Optimization for MySQL with InnoDB and XtraDB * (Full day class)

This will mark my first trip to Russia - and oh boy am I excited.  I'm taking a few days vacation after so I can tour around Saint Petersburg.  Want to say hello?  Let me know at morgan-at-percona-dot-com!

* Yes, this is the same as our InnoDB course we taught last week in Santa Clara and …

1. Milestones in the History of Thematic Cartography -- This resource provides a comprehensive view of the history of cartography, with examples of maps created throughout the ages and background information about the contexts within which those maps, visualizations and map making technologies were created. Explore each time period, click on the images and stories found throughout each time line, and read more about the history of creating thematic maps as a means of visualizing data. (via Titine on Delicious)
2. Interview with Larry Ellison (Infoworld) -- Asked about MySQL, "No, we're not going to spin it off," even if asked to by the EU, Ellison said. Lots of detail and …

We'd like to fill the remaining session slots for MySQL University this year. Currently, there are 7 available slots in 2009, as can be seen here:

http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live session time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset, start a Flash-enabled browser on either Windows, Mac OS X, Linux, or Solaris, perform a …

The article was published in July but I noticed it only today. I guess I should pay more attention to my favorite topics when I travel.

The MySQL Innodb storage engine provides ACID compliance, the ‘I’ being isolation. There are four states defined in MySQL with the tx_isolation system variable, READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ and SERIALIZABLE.

Generally MySQL installations do not modify the default value of tx_isolation = REPEATABLE-READ, however I have seen with a number of clients the default value has been changed to READ-COMMITTED. When I attempt to identify the reason why, I have always received the same reason. Oracle uses a default transaction isolation of READ-COMMITTED. See how Oracle Manages Data …

We'd like to fill the remaining session slots for MySQL University this year. Currently, there are 7 available slots in 2009, as can be seen here:

http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live session time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset, start a Flash-enabled browser on either Windows, Mac OS X, Linux, or Solaris, perform a …

We'd like to fill the remaining session slots for MySQL University this year. Currently, there are 7 available slots in 2009, as can be seen here:

http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live session time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset, start a Flash-enabled browser on either Windows, Mac OS X, Linux, or Solaris, perform a …

For those who wonder why my blogging is so low these days (apart from today) .. I`m actually writing more Lines of Code than Blog Entries the last couple of weeks:)

And when I`m not writing code I`m reading :) Either proofreading an upcoming book on Zabbix or reading some of the other books Packt sent me.

Next to that I`m busy preparing my T-Dose presentation

Oh and did I mention a 40 something questions questionnaire about some merger ?

Technorati Tags: …

There is once again a lot of fuzz going on about Open Source Business models,

First on my eyballs was the article that Customers don't seem to like openCore what a big surprise ..

So that's not the one that makes the customers happy ,

Then there is the other side of the coin, the people that create open source
Authors realize the dual licensing model comes hunting back at you after a merger or a hostile acquisition, yes they still have the source code to build on but they can't sell commercial licenses to their customers anymore they way they used to. …

This post is sparked by a recent message on an internet mailing list, where an engineer tried to restore a 40GB MySQL production backup for disaster recovery purposes. Unfortunately, the backup could not be restored and an error is returned from the program. It us unclear (to me) if this is due to a problem with the recovery tool, the original source database or with the backup itself.

I guess the individual never tested RESTORING the backups they were taking, which any production DBA will tell you is absolutely necessary.

Don't let yourself get into the unthinkable situation where all your data is "backed up", but you have no way to restore it. A corrupted, improperly taken or unrecoverable backup is worse than useless, particularly is one's faith is placed in it.

In order to protect your operation:

1) Make regular, logical backups of your data with a tool such as 'mysqldump'. …