MySQL replication & a full disk

To avoid the nasty mess because of a full hard drive, make sure your log files are in control. Things run really wild without diskspace!

If you’re running MySQL replication, run “PURGE MASTER LOGS TO ‘yourbinlogname-bin.00x’” or “PURGE MASTER LOGS BEFORE ‘2007-05-30 10:10:10’;” to safely remove the logs before X. Make sure it’s a number at or before the active log file shown in “SHOW MASTER STATUS”. You can run this safely with active replication.


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *