RE: Tutorial: Sentora Panel in a HA / Clustered Environment - ADVANCED USERS ONLY
12-04-2014, 12:29 PM
(12-02-2014, 06:22 PM)j.waibel Wrote: 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.