Author |
Message |
essentialnetworks
Joined: 22 May 2015 Posts: 5
|
Posted: Fri May 22, 2015 8:26 am Post subject: MYSQL Support |
|
|
Do you guys support MYSQL replication without breaking it ? |
|
Back to top |
|
|
TGRMN Software Site Admin
Joined: 10 Jan 2005 Posts: 8763
|
|
Back to top |
|
|
essentialnetworks
Joined: 22 May 2015 Posts: 5
|
Posted: Sat May 23, 2015 3:11 pm Post subject: |
|
|
TGRMN Software wrote: | Running on a Windows server? |
Yes, that is correct |
|
Back to top |
|
|
TGRMN Software Site Admin
Joined: 10 Jan 2005 Posts: 8763
|
Posted: Sun May 24, 2015 11:39 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
|