Hello, Has anyone setup aMember Pro with a MariaDB Galera Cluster? If not, any reason it wouldn't work? List of "gotchas": https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/ http://galeracluster.com/documentation-webpages/limitations.html Thanks, Robert
Hello Robert, I see two issue: 1. aMemeber uses GET_LOCK but this function is not supported by this cluster. 2. one aMemeber table require MyISAM engine (am_helpdesk_faq) we use FULLTEXT index in this table but InnoDB does not support it (at least until MySQL 5.6). In case of you do not use helpdesk module you can disregard this item. Best Regards.
Thanks for the quick resposnse. I was hoping it would be easy. The idea of having a redundant 3-node sql cluster for billing is very appealing. It looks like the FULLTEXT issue can be resolved by running a newer MySQL/MariaDB. Do you think working around the GET_LOCK issue is approachable? -Robert
It is possible to use another synchronization way instead of GET_LOCK but it require changes in core files.