Hi
As I have had faced issues with mariadb crashing down. I want to setup high availability wordpress sites through HyperDB MySQL replication on another VPS. So in case localhost's MySQL goes down due to any reason, it could easily switch to remote database on another server.
Has anyone done this setup? Need to know the steps / working tutorial to achieve this.
I have two servers running on AAPanel, one with NGINX while other is on Apache, so can I use Apache based AAPanel server to setup high availability master - slave databases?