Re: Replication in databases

On Sep 2, 12:05 pm, M2Y <mailtoya..._at_gmail.com> wrote:
> 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.

Isn't that basically what log shipping does anyway? Received on Tue Sep 02 2008 - 06:12:59 CEST