As like many people in the MySQL community, I am looking at planning out my sessions at the upcoming conference. I have been waiting for an iCal file with the sessions to make it easier to plan and keep track of what sessions I am going to at the conference. Last year one was available, but have not seen one this year to date. I am guessing it may still be in development or overlooked, so I am making mine available for people to use.

I will probably be adding more detail to the calendar as I get a chance, but the majority of the session information should be there. I did a simple transform on the session details that was on the conference website and did a quick check to see that it was all matching.

You can download the

Tags for this post: mysql conference mysqluc2007 mysql presentation …

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 [...]