Tutorial: Sentora Panel in a HA / Clustered Environment - ADVANCED USERS ONLY

[Me.B]

On my testing maschine i replaced mysql, after the installation been compleded, by a MariaDB galera setup.
This worked without any changes to the sentora setup and could be used for a ha/failover clustering of the database to.

J.

So you kept your MySQL DB local and then replicate it an external DB server?

Only issue with not changing the config files is that they resolve to localhost (127.0.0.1), so if your DB fails locally for whatever reason Sentora, Apps / Services etc won't know to look at the second external DB server.

But if you go through a load balancer it would detect that MariaDB1 failed and send all SQL requests to MariaDB2

But please correct me if I am misunderstanding your setup.

if you user a DNS for MySQL with short TTL that get updated in case of failure that would do the trick.

We can also set a php test if server fails switch to backup server but that means too changing some how the default config.