We have two computers connected to internet.
let one be called remote and one local.
A mysql server runs in the live remote database .
We want to synchronise the data in remote database tables to the data in local tables.
Current Strategy: we transfer the files from the remote database ( .ISM , .ISD ,.frm ) to the data directory of local databse at restart the local database.
Problem: There has been instances of table corruption in local database.
Constraint: we don't want to log updates of remote databse throucg -l option for perfofance concerns. We cannot bring down the remote mysql server.
Any Solutions : ?