My favorites | Sign in
Project Logo
             
New issue | Search
for
| Advanced search | Search tips
Issue 34: Feature Request: Failover Scheduler Events in MySQL 5.1+
2 people starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  ryan.a.lowe
Type-Defect
Priority-Medium


Sign in to add a comment
 
Reported by ryan.a.lowe, Mar 09, 2009
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
Comment 1 by baron.schwartz, Mar 09, 2009
To add a possible implementation idea:

set @@global.read_only = 1/*!51000 , @@global.event_scheduler = 0*/
Sign in to add a comment

Hosted by Google Code