Database clustering with Ignition

Ignition
1

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

2

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

3

We use MySQL innodb cluster.

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html

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.

4

@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?

5

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.