Replication
Outline
1. Introduction
Replicated Server
Replicated Resource
Synchronous Replication
Synchronous Replication - Issues
Asynchronous Replication
2. Primary-Copy Replication
Asynchronous Update Propagation
Request Propagation
Products
SQL Server 7.0
SQL Server 7.0 (cont’d)
Oracle 8i
DB2
Failure Handling
Failure Handling (cont’d)
Communications Failures
Majority Consensus
3. Multi-Master Replication
Example of Conflicting Updates A Classic Race Condition
Thomas’ Write Rule
Thomas Write Rule ? Serializability
Multi-Master Performance
Microsoft Access and SQL Server
Generation Numbers (Access/SQL cont’d)
Duplicate Updates (Access/SQL cont’d)
Oracle 8i (revisited)
Oracle 8i Conflict Resolution
4. Other Approaches
Other Approaches (cont’d)
Summary
Email: philbe@microsoft.com
Home Page: http://www.cs.washington.edu/education/courses/593
Download presentation source