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