MySQL Forums
Forum List  »  Replication

Re: Replication lagging in VM
Posted by: Rick James
Date: February 21, 2016 07:03PM

That variable (when =1) says to "flush stuff to disk at every COMMIT". The flush is via fsync, which has to go through some kind of hoops on a VM since you really have an OS inside an OS. It does seem reasonable that the variable caused replication delay only on your VMs.

Since a main purpose of using =1 is to assure that stuff is written to disk even in the event of a power failure, consider this... If you lose the VM, you don't lose the data; you have other copies of it. That is, go ahead and set the variable to 0, but plan on rebuilding the Slave if the VM dies; don't simply assume it will survive a crash.

Options: ReplyQuote


Subject
Views
Written By
Posted
1251
February 17, 2016 11:47AM
Re: Replication lagging in VM
1099
February 21, 2016 07:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.