[ClusterLabs] MySQL cluster with auto failover

[Antony Stone]

On Wednesday 06 September 2023 at 17:01:24, Damiano Giuliani wrote:

> Everything is clear now.
> So the point is to use pacemaker and create the floating vip and bind it to
> sqlproxy to health check and route the traffic to the available and healthy
> galera nodes.

Good summary.

> It could be useful let pacemaker manage also galera services?

No; MySQL / Galera needs to be running on all nodes all the time.  Pacemaker 
is for managing resources which move between nodes.

If you want something that ensures processes are running on machines, 
irrespective of where the floating IP is, look at monit - it's very simple, 
easy to configure and knows how to manage resources which should run all the 
time.

> Do you have any guide that pack this everything together?

No; I've largely made this stuff up myself as I've needed it.


Antony.

-- 
This sentence contains exacly three erors.

                                                   Please reply to the list;
                                                         please *don't* CC me.