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
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
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