Mariadb Galera Cluster Support?

Duane Webber shared this question 4 months ago
Answered

Does use response support a Galera Cluster?

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

Comments (11)

photo
1

Hello Duane,

UseResponse could be installed using only MYSQL

photo
1

I know that it can be installed using only mysql but does the UseResponse database meet the Galera Cluster requirements? I would like to install in a Galera Cluster to offer redundancy for the database. For example, it is recommended that application that run on a Galera Cluster have primary keys for every table. There are other requirements specified in the link provided above.


If the database does not support Galera, can you clarify which requirements it does not meet?

photo
1

As it works only with innodb storage table, our solution won't meet the requirements.

We've never tested it with Galera Cluster, as an option you can make daily backups and clustering won't be required. Even big customers of ours doesn't have any issues

photo
1

innodb storage tables are actually required for Galera so you do meet that requirement. Can you please look through the other requirements to see if there are any differences between the requirements and your implementation. The requirements are minimal.

As a note, Galera is not for backups (these should be done regardless) but rather from HA. Unfortunately sticking a load balancer in front of several databases does not work because the databases need to be syncronized. Your other clients may be using other forms of MySql clustering but Galera is not only easier but also provides master/master replication by design.

photo
1

I don't see requirements for mysql,only for mariadb galera cluster. Please point out at the list of requirements to mysql

photo
1

Mariadb is functionally equivalent to MySql. The requirements are in the following link: https://mariadb.com/kb/en/library/mariadb-galera-cluster-known-limitations/. The 6 under "Limitations from codership.com" are of primary importance. There may be some of importance under the other section.

photo
photo
1

In the system itself there shouldn't be any issues, but in tools, rebuilding indexes won't work and step to backup db while upgrade also won't work.

Everything else should work fine

photo
1

When do indexes need to be rebuilt?

Also, what do you mean by "step to backup db while upgrade"?

photo
1

Indexes need to rebuild very rarely when they are corrupted in db.

When you upgrade system to the latest version, first step is to backup db. Most likely it would fail

photo
1

So I still will be doing regular backups via mysqldump. In the rare case that the indexes become corrupt, can I import the database (from a .sql file) in mysql (no galera cluster), repair the indexes, export the database (via mysqldump), and reinitialize a galera cluster? I assume yes but not sure if there is some gotcha with importing a database with corrupted indexes.


For upgrading, is it possible to manually backup the database thereby skipping the first step?

photo
1

With indexes, yes - you would be able import it and then repair indexes.

With backups while upgrade, we don't have option to skip first step unless its commented in the code directly, but we'll consider this option