Please enable JavaScript.
Coggle requires JavaScript to display documents.
ReadReplica - Coggle Diagram
ReadReplica
Applicable
Read intensive transactions
Eventual consistency (near real time)
Application
Mechanism in the application to query ReadReplica
Simple /Complex inner queries
Identify transactions
Performance
Read intensive transactions
Load on the main server
no of connections > high
Scaling (compute/I/O)
Source DB - cannot take traffic due to maintenance
Disaster Recovery
Promoting replica to Main DB
oracle
active data guard
block data
Oracle golden gate
Not applicable
Strict read after write consistency