Need some help w/ Failover/HA solution
Currently we plan to move from our terrible webhosting provider to a self-hosted solution.
We have 15 simple sites (Joomla and Wordpress) running with around 500-1000 hits per day in total.
This is not much, but we aim to outperform the webhosting provider performance and uptime-wise, so we are going to need a working Failover, resp. HA solution.
I have made good experiences with VULTR and have set up two VPS with them, one in DE and one in NL.
Website data are replicated via DRBD and MySQL Databases are replicated via a MariaDB Galera Cluster.
PHP Sessions are stored in a memcached cluster.
So far everything runs smoothly. When switching between servers I cannot tell the differences Even our shop system is working fine, even when switching servers during checkout.
DNS is provided by rage4 and a third VPS @ iWstack is constantly "wgetting" the primary (DE) server and once it fails to receive the requested site, a call to the rage4 DNS webhook will failover to the NL VULTR server nearly seamlessly.
While this guarantees a downtime of no more than 30 seconds, there are still some caveats.
There are some problems with the DNS cache/TTL in the Internet Explorer (90% of our clients are using it).
Nonetheless, this setup works quite nicely, but there is always space for improvement.
What do you think of this solution? Any suggestions?
Maybe I will play around with rage4 ANY a bit to have "true" failover on the network level.