MYSQL Support

essentialnetworks · Joined: 22 May 2015 Posts: 5

Do you guys support MYSQL replication without breaking it ?

TGRMN Software · Site Admin Joined: 10 Jan 2005 Posts: 8758

Running on a Windows server?
_________________
--
TGRMN Software Support
http://www.tgrmn.com
http://www.compareandmerge.com

essentialnetworks · Joined: 22 May 2015 Posts: 5

TGRMN Software · Site Admin Joined: 10 Jan 2005 Posts: 8758

Yes, you can use the VSS to do a replications, see:

http://www.tgrmn.com/web/kb/item33.htm

but to make sure it is a consistent database replication and that MYSQL has written all its data to disk before replicating, you should do a FLUSH TABLES WITH READ LOCK before the replication (ViceVersa can run scripts before replication). This forces unflushed buffers to disk before the replication begins. You can then release the lock as soon as the replication completes.
_________________
--
TGRMN Software Support
http://www.tgrmn.com
http://www.compareandmerge.com