Compares and synchronizes MySQL database content
Moderators: Chris Auckland, eddie davis, Michael Christofides
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.
- Posts: 1
- Joined: Tue Mar 19, 2013 7:31 pm
You can call MySQL Data Compare from the command line, by running MDC.exe from the installation directory. You can get the documentation by running:
MDC /? /v
Whilst there isn't a success/failure output (I've added your support to our feature request MSDC-27), others have used the tool to generate the deployment script for the differences and saved that to a folder each time (success would be an empty script).
We'd be interested how you find the tool.
- Posts: 95
- Joined: Wed Apr 20, 2011 6:37 pm
- Location: Red Gate Software
Return to MySQL Data Compare
Who is online
Users browsing this forum: No registered users and 0 guests