MySQL Cluster with HA-Proxy over Master-Master Replication for Loadbalancing
Posted on 2014-11-12
i have a question: i must setup a mysql database loadbalancer.
now i have found much tutorials with master-master replication an ha-proxy as balancer.
but then i have found another tutorials with master-master galera cluster soltuion.
now my question:
what i should use?
on our servers there are now 30.000 peoples on the day. the system was is running is drupal.
my mainsystem is debian wheezy.
now i have 4 servers (2 active)
1. intel xeon 3,4 ghz, 32 gb ram, 4 x 1 tb enterprise hdd with raid 10
2. intel xeon 3,4 ghz, 32 gb ram, 4 x 1 tb enterprise hdd with raid 10
3. intel xeon 3,4 ghz, 32 gb ram, 4 x 400 ssd with raid 10
4. intel xeon 3,4 ghz, 32 gb ram, 4 x 400 ssd with raid 10
Currently only server 1 and 2 are active (the servers 3 and 4 was ordered).
the 1 is a webserver, and the 2 is a db server.
the load from the webserver is currently about 30%, the dbserver is heavy loaded...
the website access is very slow (10-15 seconds).
now that is my solution:
server 1 + 2 = webserver loadbalancer
main question: how i can replicate website data throw the both server,
how i can do a fix for session sickness?
second question, db: what is now better as cluster (for speed) a real cluster solution,
or master-master replication with ha proxy?
my msql database is currently 1 gigabyte (each month the database grows up about 100 mb).
how i can optimize my my.cnf configuration file for mysql? how i can find out what my db does?
i mean write, read... and where i must do changes in the configuration?
do you have some infos (any possible tutorials) for me how i can do that to get the website working fine?