[ClusterLabs] MySQL cluster with auto failover

[Damiano Giuliani]

Everything seems quite clear to me.

But, having single VIP makes a multimaster replica quite useless.

im thinking about using pacemaker to create a cloned VIP binded to a cloned
HA proxy which is health-checking the galera/mysql status  to route the
traffic.

or more easily pacemaker with a single VIP to a single HA proxy which is
roting the traffic to all the heath-checked availables cluster node.
in case a node fails, resoruces (vip and haproxy are started to a different
node)

do you think in can works?

On Thu, Sep 7, 2023, 11:28 AM Antony Stone <Antony.Stone at ha.open.source.it>
wrote:

> 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.
> _______________________________________________
> Manage your subscription:
> https://lists.clusterlabs.org/mailman/listinfo/users
>
> ClusterLabs home: https://www.clusterlabs.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20230907/0fe36f9e/attachment.htm>