Posts in category 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 [...]
For the love of god please use the fo...
Let’s begin by assuming you have a server that runs MySQL and lots and lots of traffic flows through it everyday, let’s say… something like 50% of the size of the partition that the mysql binary logs are written to is on, then we will assume the binary log is turned on. Then we assume that expire_logs_days is not set.
What [...]
LOAD INFILE – temporary file cr...
Had a customer issue come through right before I left for the day. Hadn’t seen this happen before and google was not too helpful.
Problem: We had the tmp-dir set as /var/tmp which was on it’s own partition of 5GB. This is a relatively small database of about 15GB. Customer has some replication slaves setup and was running a LOAD [...]
