thanks for your replies. I actually need the 2 servers to be in sync in real time. this is because i have a job site, and i want to applicants to access data from server 1 and recruiters on server 2. the reason being, the recruiters are the ones paying, and being in the same box as the applicants, their queries are very slow!
what I have in mind is to have all php codes in box1, and when data are inserted/updated/deleted, it saves to both box1 and box2.
The recruiters will still use box1 to log in, but their data will come from box2.
This means that everytime I do insert/update/delete statements, I will do so once for box1 and another for box2.
Do you guys see any problems here? Box 1 is generating a lot of mysql cpu overhead, but memory is stable at 30%.
The only overhead this configuration will make is the 2 sql commands instead of 1, but since the commands are issued to separate boxes, it shouldn't have THAT much effect. right?
cheers!
FYI - box 1 is dedicated server, and I just made an order for box 2