Thursday, December 1, 2011

Maintenance of Replicated Mysql Server

Deleting Binlogs of mysql. ----->

Log into Secondary Server

mysql> show slave status;
Above command will give the file name being read by slave machine.

Go to master and execute--->
mysql> purge binlogs to 'file_name_got_from_above_command'

In case of master to master replication we have to delete binlog from both machines. Do the same as above on both machines.

0 comments:

Post a Comment