Feature Request: Failover Scheduler Events in MySQL 5.1+

chusiang / mysql-master-master

Automatically exported from code.google.com/p/mysql-master-master

GNU General Public License v2.0

1 stars 1 forks source link

Feature Request: Failover Scheduler Events in MySQL 5.1+ #34

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

In the event one host is promoted to the writer role, MMM should (in
addition to setting read_only OFF) also enable the event scheduler. 
Conversely, when the writer role is taken away from a host, MMM should
disable the event scheduler.

-- Ryan Lowe

Original issue reported on code.google.com by ryan.a.l...@gmail.com on 9 Mar 2009 at 7:25

GoogleCodeExporter commented 9 years ago

To add a possible implementation idea:

set @@global.read_only = 1/*!51000 , @@global.event_scheduler = 0*/

Original comment by baron.schwartz on 9 Mar 2009 at 7:27