[ClusterLabs] MySQL cluster with auto failover

[Damiano Giuliani]

Thanks for helping really appreciate.

What I miss is how my application can support the connection on a multi
master where 3 ips are available simultaneously.

JDBCmysql driver or similar support a list name/ip of clustered nodes?
Galera provide a unique cluster ip?

Whats the point to create another cluster(pacemaker) for the VIP alongside
galera?

Thanks for the time you spent

Thanks





On Wed, Sep 6, 2023, 2:12 PM Antony Stone <Antony.Stone at ha.open.source.it>
wrote:

> On Wednesday 06 September 2023 at 12:50:40, Damiano Giuliani wrote:
>
> > Looking at some Galera cluster designs on web seems a couple of server
> > proxy are placed in front.
>
> You can certainly do it that way, although some people simply have a
> floating
> virtual IP across the 3 nodes, and clients connect to whichever
> (permanently
> running) MySQL instance has the VIP at the time.
>
> > If I would have only 3 nodes where I clustered MySQL with galera how
> then I
> > have to point my application to the right nodes?
>
> Galera is a "write anywhere, read anywhere" replication system.  You do
> not
> get a "cluster master" which all clients have to write to (or read from),
> so
> clients can simply connect to any node they like.
>
> If you're familiar with standard MySQL master-slave replication, and you
> know
> this can be set up in a master-master configuration, simply regard Galera
> as
> the same outcome but for any number of modes.
>
> One way to ensure that all clients connect to the same node at any given
> time
> is to use pacemaker or similar to run a floating virtual IP between the
> nodes.
> Clients connect to the VIP, and reach either MySQL itself, or the proxy
> (which
> is running on all 3 nodes, same as MySQL is), and the proxy connects to
> the
> real IPs of the 3 nodes.
>
>
> Antony.
>
> --
> +++ Divide By Cucumber Error.  Please Reinstall Universe And Reboot +++
>
>                                                    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/20230906/a2759008/attachment.htm>