MySQL Slave failing because of master corruption
Running an old MySQL 4.X and have setup Replication. The problem is that the Slave stops every time with error 1034.
Error
<-- snip
caused different errors on mast er and slave. Error on master: 'Incorrect key file for table: '%-.64s'. Try to r epair it' (1034), Error on slave: 'no error' (0). Default database
-->
This is always happening and I suspect that could be due to the large DB (roughly around 3-6GB) with jobs doing massive deletes everyday.
Each time this happens, I reset master, stop and reset slave and dump the whole DB from master, scp to the slave and import, start slave. This sometimes causes tables to still be not in sync. Can you please advise on what is the best way for the master and slave to be in sync when this issue arises?
|