I have real-time database replication enabled between two MySQL v5.5.29 databases and I need an automated method to determine if the db's are in sync. I would implement a nightly or weekly process to call the utility to verify success or failure.
Can I call the dbcompare utility from a script and parse a return code for success or failure? This would be the same as calling the native MySQL utility mysqldbcompare.exe. While I've used the latter, it's just too slow for pratical use.