Database clustering with Ignition

Does anyone have experience of using database clustering with Ignition? We’re thinking of using MariaDB Galera Cluster.

Anecdotally, I recall a customer trying to use MySQL Fabric for clustering/HA and it being a complete cluster f&*^. YMMV

We use MySQL innodb cluster.

You need at least 3 nodes.
All tables must have primary Key
So you have to add some pk auto increment for one or 2 igniton tag historian table.

@mazeyrat How reliable has that cluster been. I have been using classic replication up until now and it breaks every now and again. Was it much more difficult than classic master-master replication to setup?

We were having a lot of problems with our replication breaking too. You should take a look at replication with GTIDs. Was a huge improvement for us.