Supported Replication Technologies and Implementation Architectures
Learn how to ensure high availability, efficient workload routing, and centralized management across replicated Oracle database architectures with Oracle GDS.
In environments where databases are replicated for high availability, disaster recovery, or read scaling, Oracle Global Data Services (GDS) provides:
- Global Service Management: GDS creates a global service abstraction, masking the complexity of the underlying replicated databases from applications.
- Workload Routing: GDS intelligently routes client requests to the appropriate database instances based on factors like database role (read-write, read-only), region, replication-lag, and resource capacity.
- Load-balancing: GDS dynamically balances workloads taking into account load conditions and network latency.
- Failover and Switchover: GDS automates data service failover to standby databases in case of failures, ensuring continuous application availability.
- Centralized Management: The GDS catalog provides a central point for managing and monitoring the configuration and health of global services and their associated databases.
Replicated Databases Use Cases
- Disaster Recovery Systems: Replicates a primary database to a standby database for failover in case of a primary system failure.
- Content Management Systems (CMS): Read-heavy websites (such as content delivery, ecommerce, airline reservation systems) that replicate data for faster access across multiple regions.
- Business Intelligence (BI) and Analytics: Replicated databases handle complex, read-heavy queries on a replica while offloading the primary database.
- Customer Relationship Management (CRM) Systems: Replicates customer data for distributed teams, ensuring high availability and quick access to client information.
- Mobile Applications: Ensures low-latency read access to globally distributed user bases by replicating databases in multiple regions.
- Using Oracle Active Data Guard with Global Data Services Configure sessions to move in a rolling manner for Oracle Active Data Guard reader farm.
- Using Oracle GoldenGate with Global Data Services Use this procedure to gracefully transition Oracle GoldenGate replication roles and GDS services, ensuring minimal downtime, data consistency, and availability.
- Using RAFT Replication with Global Data Services Achieve automated, resilient, and consistent replication management with rapid failover for highly available distributed databases using RAFT replication.
- One GDS Infrastructure for Many Replicated Configurations Single GDS infrastructure can support multiple replicated database configurations for high availability, disaster recovery, and read scaling.
Parent topic: Using Global Data Services (Architectures, Use Cases, Application Development)