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.st...@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/ >
_______________________________________________ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/