Hey guys, trying to setup one of my VPS' as a load balancer (both using centmin lemp stack btw.) Would anyone happen to know how to keep them both always synced? Would this require the web application to do everything on two databases or is there some better solution? I currently have a failover server setup but the fo server has 2hour old data (using cron to dump the mysql db). Maybe @eva2000 would know?
Web / TCP load balancing = Haproxy and Nginx Filesystem = NFS and GlusterFS are common. Others like csync2/lsyncd combo MySQL = MySQL Cluster, Percona or MySQL Galera Cluster, MySQL replication, Tungsten Replicator Replication etc You're on your own for most of these. GlusterFS basic guide at GlusterFS EPEL YUM Repository packages for CentOS 6.5 & 7.0 | Centmin Mod Community