One Mysql Database - Two Servers - Advices Needed

[toptalent]

i have a very active php+mysql based site currently hosted on server A. now i want to set up server B as a mirror server to balance the load. (A and B are located in different dcs). please note that due to certain limitations this is the only kind of hardware setup available for me.

the site has a very active mysql activity. database is almost CONSTANTLY updated due to stuff like hit count and user comments. so i want to find a solution that allows the two databases 2b synced fast. when server A's database is updated, server B's should quickly reflect the change and vice versa.

i read about mysql's built in replication function. but it seems 2 me that its not intended for use on a "mirror site". instead its more like a backup solution which is good only one way. (master -> slave)

please kindly post ur recommendations. thanks.

 

[KarveR]

Hmm .. tricky one and I have been looking for something similar.

All I can suggest is this:
Do all updats to server A, send all page reuests to server B and replicate all new info from A->B, at least this way you have evened out the workload. could be a bugger to set up all the new links required tho.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.