Intelligent Workload Management across Database Replicas Ritika Nevatia
Intelligent Workload Management across Database Replicas Ritika Nevatia Under the supervision of Prasanth Kothuri 19 August 2015 Intelligent Workload Management, Ritika Nevatia 2
One DB, One client 19 August 2015 Intelligent Workload Management, Ritika Nevatia 3
One DB, Many Clients 19 August 2015 Intelligent Workload Management, Ritika Nevatia 4
Replicated DBs, Many clients 19 August 2015 Intelligent Workload Management, Ritika Nevatia 5
Load balanced, Manually 19 August 2015 Intelligent Workload Management, Ritika Nevatia 6
Load balanced, Automatically 19 August 2015 Intelligent Workload Management, Ritika Nevatia 7
What do we use? Manual Load Balancing 19 August 2015 Intelligent Workload Management, Ritika Nevatia 8
Can we do better? 19 August 2015 Intelligent Workload Management, Ritika Nevatia 9
Why GDS? Availability Scalability Performance Manageability 19 August 2015 Intelligent Workload Management, Ritika Nevatia 10
Key features Work Load Management Centralized Framework Work Load Routing Region based Failover Inter database service failover Role Based Global Service Takes care of role transition via Data Guard Load Balancing Run-time Replication lag based Connection 19 August 2015 Intelligent Workload Management, Ritika Nevatia 11
How GDS works? ? 19 August 2015 Intelligent Workload Management, Ritika Nevatia 12
Services Representation Grouping Routing to optimal instance to handle unexpected failovers 19 August 2015 Intelligent Workload Management, Ritika Nevatia 13
How GDS works? ? Implements the Oracle Database service model • GDSCTL • Any combination of • • Oracle Data Guard (Physical Replication) Oracle Golden Gate (Logical Replication) or any other database replication technology 19 August 2015 Intelligent Workload Management, Ritika Nevatia 14
What is GDS made of? ? 19 August 2015 Intelligent Workload Management, Ritika Nevatia 15
GDS Pool GDS Region Global Service Manager GDS Catalog Oracle Notification Servers 19 August 2015 Intelligent Workload Management, Ritika Nevatia 16
Most optimal instance Give me service! The process Service Client GSM Instances Catalog 19 August 2015 Intelligent Workload Management, Ritika Nevatia 17
Use Cases • • • Load Balancing for Replicated Databases Service Failover for Replicated Databases Region Affinity in Oracle Golden. Gate Multi-Master Load Balancing in Oracle Golden. Gate Multi-Master Balancing Oracle Active Data Guard and Oracle Golden. Gate Reader Farms 19 August 2015 Intelligent Workload Management, Ritika Nevatia 18
Load Balancing in Replicas Meriyn 19 August 2015 Budapest Load metrics • Region affinity • Network latency • Load balancing goals • Intelligent Workload Management, Ritika Nevatia 19
Service failovers in Replicas Meriyn 19 August 2015 Budapest Meriyn Budapest Intelligent Workload Management, Ritika Nevatia 20
Thank You Intelligent Workload Management across Database Replicas Ritika Nevatia Under the supervision of Prasanth Kothuri
- Slides: 21