Explore tens of thousands of sets crafted by our community.
Database Replication Techniques
5
Flashcards
0/5
Snapshot Replication
Snapshot Replication involves copying and distributing data and database objects exactly as they appear at a specific moment in time. It is useful when changes occur infrequently and a bit of staleness in data is acceptable.
Peer-to-Peer Replication
Peer-to-Peer Replication distributes data across multiple servers where each server functions as both a publisher and subscriber. It ensures data consistency across a distributed system and is used for load balancing and fault tolerance.
Multi-Master Replication
Multi-Master Replication allows multiple nodes to handle write operations. Changes are replicated to all nodes. It is used for achieving high availability and redundancy in systems that can tolerate eventual consistency.
Merge Replication
Merge Replication allows changes from multiple databases to be combined into a single database. It can handle conflicting changes and is used in systems where updates can happen at various sites such as mobile applications.
Transactional Replication
Transactional Replication provides a continuous stream of changes to the data, maintaining a near real-time copy of the database across systems. It's ideal for systems that need up-to-date data and can support more frequent data transfers.
© Hypatia.Tech. 2024 All rights reserved.