distributed databases?

I have a problem that I couldn't find a solution for neither on the web nor searching dejanews, so I hope it's not been answered ten times already. :-)

we have several (two at the moment, with option to scale higher) database servers that are accessed from webservers. however, they don't only read data, they also write (statistics, mostly). the database is "mirrored", i.e. both servers do the same job, it's two for load-balancing and redundancy reasons. our current problem is keeping those write operations synchronized. ideally, the web-servers should be abstracted from the db-servers, so they don't have to care about them at all. for all they know, they connect to some machine and talk with it. that it might be the other one the next time should be transparent.

please give me some pointers to possible solutions that we can check.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 09:48:44 CST