I have being employing mk-table-sync to synchronise tables from a master to slave on mysql 5.1. Unfortunately, while differences are correctly detected, modifications done on the master (DELETE,REPLACE,ecc.) do not seem to be propagated to the slave. SHOW SLAVE STATUS doesn't reveal connection issues.
Basically, doing
mk-table-sync -v --execute --databases=forum --sync-to-master
h=localhost,D=forum,t=user
# Syncing D=forum,h=localhost,t=user
# DELETE REPLACE INSERT UPDATE ALGORITHM START END EXIT DATABASE.TABLE
# 0 7 0 0 Chunk 14:35:00 14:35:01 2 forum.user
repeatedly gives always the same results, without an actual change to the slave.
Log on the slave:
Log on the master:
Same goes for DELETEs done on the master and for every other table in the replicated db.
Any ideas?
Thanks in advance
