Posts tagged Replication
A common replication error
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 [...]
Updated: Monolith Toolkit – MyS...
Updated the release, sure it’s only been a matter of hours but I added the standard cnf files for 2,4,8 and 16GB server installations. Also added the rhcluster-wrapper script that can be used to run just about anything on the active database node when using mysql in an active/passive setup.
Download here: http://code.google.com/p/mon [...]
Monolith Toolkit – MySQL DBA to...
Today I decided to package all of my various scripts together into a useful toolkit. Some are perl, some are shell script. These scripts are, in general, one off scripts that I wrote in order to get things done that weren’t available at the time. Now they’re nicely organized and will receive updates at the google code repo.
So f [...]
