Sorry if this isn’t the right place to ask this, but the Percona name keeps popping up on Google.
So I have 2 servers dedicated to run to MySQL server 5.5 on QNX, configured with Master-Master replication (asynchronous). We’re using just one server to run queries, you could say that we have an Active / Passive mode.
I have been told the server suddenly can’t perform queries and the connection to the database dies. The client program is written in C and we’re thinking of doing some kind of fail over when the connection dies, maybe on application level. But I’m sure a load balancer would be a better solution.
In any case, this switch to a new master node could have problems due to replication lag, there could be data loss and maybe un-synced tables.
I have read that MySQL 5.5 has semi-sync replication, would this be a good solution to have after switching the database node when it fails??