Forum Index  ViceVersa HOME         FAQ and Knowledge Base

 FAQForum FAQ   SearchSearch Forum  RegisterRegister 
 ProfileProfile   Log inLog in 

MYSQL Support

 
Post new topic   Reply to topic     Forum Index -> Support
Author Message
essentialnetworks



Joined: 22 May 2015
Posts: 5

PostPosted: Fri May 22, 2015 8:26 am    Post subject: MYSQL Support Reply with quote

Do you guys support MYSQL replication without breaking it ?
Back to top
TGRMN Software
Site Admin


Joined: 10 Jan 2005
Posts: 8758

PostPosted: Sat May 23, 2015 10:02 am    Post subject: Reply with quote

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



Joined: 22 May 2015
Posts: 5

PostPosted: Sat May 23, 2015 3:11 pm    Post subject: Reply with quote

TGRMN Software wrote:
Running on a Windows server?


Yes, that is correct
Back to top
TGRMN Software
Site Admin


Joined: 10 Jan 2005
Posts: 8758

PostPosted: Sun May 24, 2015 11:39 pm    Post subject: Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Support All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © phpBB Group
Copyright © TGRMN Software. TGRMN Software products: