[ClusterLabs] MySQL cluster with auto failover

[Damiano Giuliani]

Thanks for helping.

Because I still don't know which version will be provided, probably MySQL
enterprise or community.

I was wondering about pacemaker because I know quite well how it works and
I need a vip/automatic failover

Galera seems a different approach that I have to study and test estensively
before  place in production, instead pacemaker is a well know solution to
me.

Is drbd approach obsolete or solid?
About the degraded status I read on web there is a specific configuration?

There is also a good Galera documentation to study?

Thanks

Damiano


On Wed, Sep 6, 2023, 10:37 AM Antony Stone <Antony.Stone at ha.open.source.it>
wrote:

> On Tuesday 05 September 2023 at 22:20:36, Damiano Giuliani wrote:
>
> > Hi guys, I'm about to figure out how setup a pacemaker cluster for MySQL
> > replication.
>
> Why do you need pacemaker?
>
> Why not just set up several machines and configure Galera to handle DB
> replication between them?
>
> If you install MariaDB instead of MySQL it's directly compatible and
> Galera is
> included.
>
> Depending on your distribution you may find that MariaDB is actually what
> you
> get even when you ask for MySQL (eg: Debian).
>
> I don't see the need for pacemaker here.
>
>
> Antony.
>
> --
> "Have you been drinking brake fluid again?  I think you're addicted to the
> stuff."
>
> "No, no, it's alright - I can stop any time I want to."
>
>                                                    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/e1597101/attachment.htm>