I have to setup High Availability
and Load balancing
for web(apache-tomcat+mod_jk) and MySQL(where all clients info is stored) server which are running on the same machine(ubuntu server). First I am trying to setup for the MySQL databases with minimal setup of servers(2 or 3).
I heard about master-slave
setup which is not suitable for HA as there is some down time while making the slave a master when master is down.
I also heard about the master-master
setup and is said to have some disadvantages like conflicting problems.
Anybody know any reliable and best setup which could be implemented for production?
EDIT 1:
I have checked setting up master-master
and master-slave
and didn't see any problem or trouble giving in syncing over LAN and I'm not sure these works flawless on production systems. I heard load balancing of mysql databases are possible and may not be possible and I'm not sure of this.
I heard about mysql cluster 7
and seems to be powerful of all the available options but I could not find any proper documentation setup.