Hi all, One website is based on LAMP(Linux+Apache+MySQL+PHP)(that is our case).We donot have very big tables or complicated database design.We only have one database. Because the php code is a third-party product we donot want to make much modification on the code. But when it comes to the underlying MySQL deployment,it is a problem. To loadbalance to write requests(insert,update...) from web program,we have some options to follow. One is master-master replication with a loadbalancer in front of the two MySQL master servers,and the loadbalancer could be LVS(it has been put into our production for years with stability and performance) or mysql-proxy(I am not sure of its stability in production). The other one is MySQL Cluster which is composed by some data nodes and mysql nodes and one management node. Our consideration is that the underlying MySQL server farm is transparent from the web program.
Any suggestions will be welcomed. Thank you in advance. Yours Xu Feng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
