Re: high-availability loadbalanced mysql server farm

2009-01-16 Thread Andy Shellam
Hi, Jake Maul wrote: *If 1/2 your tables are on server A and the other 1/2 are on server B, then you've effectively split the read *and* write load between them. How to do this without modifying the frontend is an exercise left to the reader. :) From what I've read in the past about MySQL P

Re: high-availability loadbalanced mysql server farm

2009-01-16 Thread Jake Maul
If you're looking to load-balance the write requests... sorry, MySQL replication won't help much (if at all). Think about it... every insert/update/delete simply *has* to happen on every server. You only *send* it to one of them, sure... but then it replicates from that one to the other(s) and hap

high-availability loadbalanced mysql server farm

2009-01-14 Thread xufeng
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 underlyi