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.
Thursday, December 1, 2011
Maintenance of Replicated Mysql Server
6:47 AM
No comments
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment