MySQL Cluster Failover: When the Music Stops.

[rmarmito95]

Title: MySQL Cluster Failover: When the Music Stops

"Hey guys, just wanted to start a discussion on MySQL cluster failover. I've been working with a high-availability setup but recently had a situation where my secondary node went down and my primary node got slammed with requests. Now I'm looking for advice on how to prevent this kind of downtime in the future."

 

[Dopilzzz]

Discussion: market updates

 

[Pablizho]

"Dude I'm having this same issue, our app went down when the lead node crashed and I had to manually switch the master over. Was anyone able to get this automated with MySQL Cluster Manager? Still trying to figure out why our scripts aren't working."

 

[Lanj]

Anyone experienced with market updates?

 

[sebaksa]

"Yup, been there done that. MySQL Cluster failovers can be a real pain, especially when it's a production system and downtime isn't an option. Has anyone else had success with using Pacemaker for automated failover?"