MariaDB Galera Cluster or Percona XtraDB Cluster support

rreynolds's Avatar

rreynolds

01 May, 2014 08:22 PM

Greetings,

Since cascade runs under innodb engine in mysql I was curious if there was anything stopping a database infrastructure set up around the Galera or Percona cluster for Cascade. It would be nice to set up a multimaster enviroment for performance increases and/or offsite hosting. I didn't find any discussion from the search and was wondering.

I'll post the limitations just below.

https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations
http://www.percona.com/doc/percona-xtradb-cluster/5.5/limitation.html

Thanks

Edited: typos

  1. 1 Posted by Ryan Griffith on 07 May, 2014 12:12 PM

    Ryan Griffith's Avatar

    Hi,

    My apologies for the delayed response.

    Unfortunately, we do not have much experience with these products, but our understanding is they are both wrappers around MySQL and the InnoDB engine and should theoretically be able to substitute MySQL.

    For MariaDB, we do not believe there are any transactions that would reach the transaction limits. One red flag is the following:

    The Query cache should not be used with Galera Cluster (source: Codership Google Group)

    We are guessing Galera Cluster has some other mechanism for query caching. Since we do not have much experience with this, are you aware of what this may be?

    Because we do not have much experience with these products and have done no testing with them, we can not officially support them. That being said, if you feel you are comfortable with this, we would love to hear how things work out during and after the process of setting things up and if you do in fact see performance or redundancy improvements.

    Please let me know if you have any questions.

    Thanks!

  2. Ryan Griffith closed this discussion on 13 May, 2014 01:07 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac