Here's my tentative agenda for sessions I am interested in at the MySQL Conference:
Monday

• MySQL 5.1 In-depth
• Real-World MySQL Performance Tuning

Tuesday

• Using Stored Routines for MySQL Administration
• MySQL 5.1's Log Tables
• …

I've been working on how to efficiently compare and synchronize data between two tables on different MySQL servers. I've also been working on a tool, sort of like rsync for database tables, which implements both algorithms. I profiled it to see how well the comparison algorithms work on real data. This article is about the results.

The 38th edition of Log Buffer, the weekly review of database blogs, has been published on Padgraig O’Sullivan’s Padraig’s Blog. Don’t forget, Log Buffer uses a distributed editorship. It needs your perspectives, so if you want to try your hand at editing and publishing an edition, please read the Log Buffer homepage for more [...]

The first version of this code failed to work on 5.1 so here is a version that does:

if(DATABASE_REPLICATION_CHECK)
{
$result = mysql_query("show slave status;");
$row = mysql_fetch_assoc($result);
if( ($row['Slave_IO_Running']!='Yes') || ($row['Slave_SQL_Running']!='Yes') )
{
$fp = fopen('tmp/halt', 'w+');
fclose($fp);
header('Location: index.php');
}
}

Remember to add something like:

if(file_exists('tmp/halt')) exit('Unable to complete request at this time');

at the start of your app execution so as to stop users entering data that can cause all kinds of living nightmares when it comes to patching the data together.
--
Copyright 2006-2008 Andrew Rose [rose.andrew@gmail.com] [andrewrose.co.uk]

i finally got tired of the index pages on the mysql mailing lists looking like ezmlm-cgi, so i cribbed some design from the perl mailing lists and now the by-thread index pages include who participated in a thread. i didn?t steal the pagination of busy months. yet.

i need to package up more of the bits of code driving the mysql mailing lists. there are some quirks, but i like the way it all fits together.

i also need to put in the few hours it would take to make it possible to post to the lists from the web interface.

I’ve been working on how to efficiently compare and synchronize data between two tables on different MySQL servers. I’ve also been working on a tool, sort of like rsync for database tables, which implements both algorithms. I profiled it to see how well the comparison algorithms work on real data. This article is about the results. The data and profiling results I used a sample of real data from a production database.

Dear Kettle fan,

Next month, the MySQL Conference & Expo 2007 takes place in Santa Clara. I was invited to do 2 talks over there:

• Addressing data chaos using MySQL and Kettle, a 60 minute presentation on Wed Apr-25th, 10:45-11:45
• Exploiting MySQL 5.1 for advanced BI applications, a 90 minute presentaiton on Tue Apr-24th, 16:40-18:15

For a complete overview of all the great sessions that will take place, go here.

Feel free to join us for a Birds of a feather session on Tuesday evening, right after my talk. Joining me there are …

Big insider news on James Governor’s blog. If you don’t know who James Governor and Redmonk are, you should. They are giving the bigwigs (Gartner, IDC, Forrester et alia) a run for their money in technology analysis. Anyway, the news is this, and the details are very sketchy:

MySQL has signed a million euro deal The client is [...]

When I was in the UK last week, I read an article in the Sunday Times called The Good Manager.  The article was a summary of management principles written 60 some years ago by WJ King in a book called "The Unwritten Laws of Business."  The ideas are basic, but powerful.  While it's unlikely that even the most gifted managers follow all the rules all of the time, they are good inspiration.  Managing is not rocket science and just doing a good job on the basics can have a lot of impact. Rather than attempt to summarize the ideas, I encourage you to read the article in the Times. 

• Times Online: …

I've been invited to speak at RIT-2007 which stands for "Russian Internet Technologies" conference. It takes place 16-17 April in Moscow, Russia. It looks like this is going to be biggest Russian conference on Internet technologies so far with many large Russian Internet projects sending their delegates. You can check out conference sessions schedule here.

Andrew Aksyonoff, the author of Sphinx Search Engine will also be giving a talk there.

The day following the conference April 18 I'm giving full day "Master Class"/Training on MySQL Performance.

Even though this post is in English the conference and training will be in Russian language