Mysql – Rebuild thesql slave from scratch

MySQLmysql-replicationmysql5

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt.

Now I stopped my mysql slave but want to start it again and rebuild everything from scratch. Is there a way to do this? Without locking the master…

I also think the binlog file should be reset. So everything is clean again.

Any ideas?

Best Answer

if you use innodb engine on the master - just use mysqldump with --skip-lock-tables, --single-transaction and --master-data=2 switches.

if your slave is only logically corrupted - try pt-table-sync with lock=0 option

Related Solutions

Mysql slave fails to resume from master if master restarted

It sounds like restarting the master wipes out the binary logs, for some reason. MySQL won't do that by itself; it is either receiving the command RESET MASTER at some point, or something in the server's startup is clearing out /var/run.

MySQL Master-Master Replication of ALL databases. How

This is how i did it for both masters

log-bin = mysqld-bin
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=mysql
log-slave-updates
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=mysql
relay-log=mysqld-relay-bin

Best Answer

Related Solutions

Mysql slave fails to resume from master if master restarted

MySQL Master-Master Replication of ALL databases. How

Related Topic