Re: Replication in databases
Date: Mon, 1 Sep 2008 21:05:13 -0700 (PDT)
Message-ID: <dc5e86cb-9fd4-4732-b521-353279f25403_at_s9g2000prg.googlegroups.com>
On Sep 2, 1:06 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
> 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.
We can maintain an order of transactions, lets say, commit order and let the backup replay the transactions in that order. Received on Tue Sep 02 2008 - 06:05:13 CEST