Re: distributed databases?

In article <71pt0s$13t$1_at_nnrp1.dejanews.com>,   AlterMann_at_my-dejanews.com wrote:
>
>
> 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
>

Hi,

 Modify the application so that the same transaction will be issued to both databases. The keypoint is that a commit should be made on both databases successfully or no commit at all.

Xuening Sun

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