Logo
Pattern

Discover published sets by community

Explore tens of thousands of sets crafted by our community.

Database Replication Techniques

5

Flashcards

0/5

Still learning
StarStarStarStar

Snapshot Replication

StarStarStarStar

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.

StarStarStarStar

Peer-to-Peer Replication

StarStarStarStar

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.

StarStarStarStar

Multi-Master Replication

StarStarStarStar

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.

StarStarStarStar

Merge Replication

StarStarStarStar

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.

StarStarStarStar

Transactional Replication

StarStarStarStar

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.

Know
0
Still learning
Click to flip
Know
0
Logo

© Hypatia.Tech. 2024 All rights reserved.