[ClusterLabs] MySQL cluster with auto failover

[Antony Stone]

On Thursday 07 September 2023 at 22:06:25, Damiano Giuliani wrote:

> Everything seems quite clear to me.
> 
> But, having single VIP makes a multimaster replica quite useless.

Why?

> 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.

I don't think I understand the use of the word "cloned" there.

How many Virtual IPs are you considering having?

> 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)

You can do that if you wish, yes.


Antony.

-- 
"640 kilobytes (of RAM) should be enough for anybody."

 - Bill Gates

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