Re: Replication in databases

In the last exciting episode, M2Y <mailtoyahoo_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.

Well, yes, you can maintain an order, by some means.

That tends to impose requirements like log shipping, as you need some means to impose the order.

-- 
let name="cbbrowne" and tld="gmail.com" in name ^ "_at_" ^ tld;;
http://linuxdatabases.info/info/finances.html
When sign makers go on strike, is anything written on their signs?