Question
Does cPanel support clustering with MariaDB Galera?
Answer
Due to the limitations of the Galera cluster, this would not be something that cPanel can offer support or advice on in regards to configuration and implementation or Galera with cPanel:
- Unsupported explicit locking includes LOCK TABLES, FLUSH TABLES {explicit table list} WITH READ LOCK, (GET_LOCK(), RELEASE_LOCK(),…). Using transactions properly should be able to overcome these limitations. Global locking operators like FLUSH TABLES WITH READ LOCK are supported.
- All tables should have a primary key (multi-column primary keys are supported). DELETE operations are unsupported on tables without a primary key. Also, rows in tables without a primary key may appear in a different order on different nodes.
You can read more on the known limitations here. MariaDB Galera Cluster - Known Limitations