MySQL Forums
Forum List  »  Replication

Re: Auto-Advancing Master Bin-Log Position
Posted by: Rick James
Date: April 10, 2014 03:53PM

> the replication itself is not as straightforward as you'd think. Could this possibly compound the heartbeat problem?

Granted, you have an unusual topology.
Almost no one has two instances per machine, hence almost no one need to vary from 3306. Still, these should not matter.

In Windows there is the "AT" command. This functions like Unix's cron and serves a function similar to MySQL's EVENT. You would set it up on the main master, have it run a script that connects to the database and does some simple 'write' function. Presumably your ALTER DATABASE would be fine.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Auto-Advancing Master Bin-Log Position
1027
April 10, 2014 03:53PM


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.