My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed.
I have synced the two lamp servers /var/www folders with unison and work perfectly..
What i am wanting to know is or does anyone know how to synchronize phpmyadmin database for the one website( As this whole setup is for 1 website only..)?
because i use the Load balancer server to direct traffic to either server and the website is on both lamp servers... Just want to know is there a way that i can synchronize the databases as i am using phpmyadmin or can it be done that the 1st lampserver is configured to the phpmyadmin installed on there and that the 2nd lampserver can connect to the 1st lampserver's phpmyadmin is that possible?
first machine: zen load balancer (server) second machine: lampserver (webserver1) holds the website files that sync with webserver 2 third machine: lampserver (webserver2) holds the website files that sync with webserver 1
or should i create another machine that just has phpmyadmin on it and holds the database for website directing the two lamp servers to connect to this machine?? How can this be done??
any help would be much appreciated..
all servers except zen load balancer are running ubuntu 12.04 lTS server OS