I’ll keep this short. Let’s say you run “mysql> show slave status\G” and you see the following error:
Last_Error: Error 'Unknown or incorrect time zone: 'Etc/UTC'' on query. Default database: 'db_name'. Query: 'INSERT INTO table SET column = CONVERT_TZ('2009-01-24', '-8:00', '+00:00')'
It’s a simple fix. Exit out of MySQL and run the following command – this works on Redhat, I’ve not tried it on other flavors.
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo|mysql -u root -p
Log back into MySQL and run the following.
mysql> stop slave;
mysql> start slave;
mysql> show slave status\G;
The error should be gone and the slave should be catching up to the master now. Problem solved.
Archive for January, 2009
A common replication error
Jan 28
I’m pleased to announce that I’ll be using FusionCharts for the upcoming release of Kontrollbase. So far there are 54 separate graphs that will be available as default for server monitoring. I’ve finished the code for the master graph page, a whopping total of 188 lines of PHP. Not bad considering how it loads the graphs via an array and abtracted function. Much cleaner that the previous version used in Monolith. No more JPGraphs!
The graphs feature a quick loading animation during the xml processing phase, and then have hover-over transparent data points to keep the page clean of static date points. Here’s an example of the graphs – keep in mind there is no CSS on the page, it’s just a test page for the graphs.
