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.
Subject
Views
Written By
Posted
2130
March 24, 2014 02:43PM
998
March 25, 2014 06:58PM
837
April 09, 2014 07:07AM
Re: Auto-Advancing Master Bin-Log Position
1027
April 10, 2014 03:53PM
924
April 11, 2014 07:35AM
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.