Comments (1)
I'm also having the same problem. However I would like to add that as far as I
can tell there is no option to handle the failover of events to a new master.
In the case that you have your events set to SLAVESIDE_DISABLED (see the
information_schema.events table) and have the event scheduler running on all
servers, the slave that becomes that master will not start running the events
because the id of the originator has not changed
In the case that you have your events set to ENABLED (see the
information_schema.events table) and have the event scheduler running only on
the master server, the event scheduler will not be enabled on the slave that
gets promoted to the new master.
The plan to get around this for the time being by adding something in our
master_ip_failover_script to enable the event scheduler after re-assigning the
VIP. This way in the case of failover that results from system failure the
event scheudle will be enabled. In the case that it's a planned failover we'll
just manipulate the event schedulers on the servers directly. Admittedly this
is a bit janky and it would be better to have something in the MHA solution to
handle this.
Original comment by [email protected]
on 7 May 2014 at 2:35
from mysql-master-ha.
Related Issues (20)
- mysql innodb locks during checks on slaves
- Plaintext password in output HOT 3
- Not support for detecting poor perfomance masters HOT 1
- Manual switching | alive Old master does't become new slave HOT 3
- MHA automatic failover stop when I shutdown Master machine
- If Active Master goes Down, Slave running MHA manager can become Master?. HOT 2
- MHA IP failover / firewall issues
- got the error during the failover test "Applying all logs succeeded. But starting slave failed" HOT 3
- masterha_check_repl skips all slave checks on MySQL 5.6 with GTID enabled HOT 3
- Do mysql master failover only when there are more than one slaves HOT 3
- Maunal purge_relay_logs crash my replication HOT 2
- Failover aborts due to 1053 - Query partially completed on the master HOT 2
- masterha_manager can not start on 3306 ,but 3313 ok
- Does mysql-master-ha work if I already have traditional mysql replication running? HOT 1
- masterha_check_repl says ssh config failed, BUT masterha_check_ssh was okay HOT 1
- alert-only mode instead of failover
- Master Failover completed successfully. Error Establishing Database Connection. HOT 2
- Documentation not available HOT 1
- masterha_check_repl crashing HOT 2
- MHA Scalability HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-master-ha.