@mazeyrat
Thank you for your info about MySQL, but we are using PostgreSQL and I can’t change that…
After some more searching and testing, I came to conclusion, that there is no ‘easy/simple’ automated switch over to backup database in case of primary database failure. I’m talking here about simple systems, not some big corporate solutions.
So one solution is: streaming replication to standby PostgreSQL server; when the primary server fails, manually promote standby server to primary and manually point Ignition to ‘new’ primary Postgres server (new IP).
Second: tag history splitter; I must test this more, but it seems simpler than streaming replication…
I would really like to know how you guys out there doing this (with PostgreSQL)?
Especially when using redundant Ignition gateways?