Galera setup in production

[Raymond Xu]

Hello everyone,

I'm interested in Galera, could you show me what's the typical setup of Galera in your production? Or is it stable enough?

Cheers,
Ray

[Daniel Black]

----- Original Message -----
> Hello everyone,
>
> I'm interested in Galera, could you show me what's the typical setup of
> Galera in your production?

3 nodes on independent hardware. More (in odd numbers) if required for additional read scaling at the expense of additional write latency.

Use multicast if possible.

Innodb only (except system tables). All tables with Primary keys - no exceptions.

Take a note of limitations first.

https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/

Test it properly with your application first.

> Or is it stable enough?

yes.


--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.

[raynix]

Thanks Daniel. I'll check the limitations thoroughly.