Re: Replication in databases
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 01 Sep 2008 17:06:33 -0300
Message-ID: <48bc4b4b$0$4041$9a566e8b_at_news.aliant.net>
Date: Mon, 01 Sep 2008 17:06:33 -0300
Message-ID: <48bc4b4b$0$4041$9a566e8b_at_news.aliant.net>
M2Y wrote:
> Hello,
>
> I have a fundamental doubt regarding replication in databases.
>
> If the isolation level is set to Serializable, why cant we just ship
> the transaction statements from the master to the backup and replay
> those transactions. Why do we adopt complicated solutions like log
> shipping and all such kind of things for replicating databases.
>
> Thanks,
> Srinivas
The statements might arrive at the slave in a different order and the slave might serialize the transactions differently--for a start. Received on Mon Sep 01 2008 - 22:06:33 CEST