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

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.

M2Y wrote:

The statements might arrive at the slave in a different order and the
slave might serialize the transactions differently--for a start.