The company I am working for requires me to have the MySQL database in a distributed way on the internet servers. I would tell you the situation. Our database is quite a large one and the traffic to the site is also tremendous. So we have lots of image servers/php servers but we had only one database server. Now its time for us to have more than one database server as well because its at the brink where one database server is unable to handle the amount of requests. My question is how can I have multiple database servers and how can I integrate the databases to a consistent level after a period of time. We dont mind having a dummy database server which can go about integrating the data on each of the server.
