I am interested to know what sort of systems you have in place to handle load balancing. Of both web servers, running apache, PHP etc... but most interestingly mySQL and how do you handle replication problems. I am looking to spread the load of my mySQL database servers accross 4 or 5 servers for a new system and website that will be released soon. I know that a single server wont be able to handle it but on top of that I want failure points so if a connection fails it rolls over. These will be in different datacenters and possibly in a different continent. Thanks.
Are you actually co-locating or are your just getting dedicated servers? If you are actually get collcation space, then load balancers are going to be your friend. Appliances from people like F5 will be able to do a great job especially if you have a lot of traffic.. Any particular reason you are looking to spread yourself out so much to different datacenters? Does your application depend on very very very low roundtrip times, or are you just looking for redunancy in the event of a power outage or plane crash? THe reason I ask this is that there are very few true reasons to go to other datacenters.. People are going to say well google/yahoo/ms/etc do it, yeah but that's because they can create interconnects between datacenters and make themselves look like one big network. I work with VOIP servers everyday so according to your signature if you are looking to improve voice, let me know. I can help out and point you down the right direction.
Hello, No I actually own the servers on the network. My knowledge of mysql redundancy is limited anyway... The main reason for different Datacenters is expansion of network and to limit any outages