Using Percona as a backend for Rancher server

Rancher 1.x
1

Do you support using Percona XtraDB Cluster as the backend for Rancher server?
I have a 3-node percona cluster that I set up to use initially for a Rancher 2.0 setup, but It got errors about DML commands on a table without a primary key:

Caused by: liquibase.exception.DatabaseException: (conn:65) Percona-XtraDB-Cluster prohibits use of DML command on a table (rancher2.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER

I checked the tables, and the DATABASECHANGELOG has no primary key set.

To see if it was just a problem with Rancher 2.0, I tried pointing a new Rancher 1.6.10 to the same cluster, and I see the same errors in the container logs. Is there a workaround to getting Rancher to use a Percona cluster?

2

We are looking into this. This is coming from the library we use to do database maintenance/migrations: liquibase.

Here are two issues referencing it:
https://liquibase.jira.com/browse/CORE-2086
https://liquibase.jira.com/browse/CORE-1909

You aren’t the first to request this. Here are some open issues:
https://github.com/rancher/rancher/issues/9301
https://github.com/rancher/rancher/issues/9329

We’ll target a fix in an upcoming release.

3

Thank you for the update!