Oracle GDS Licensing

Oracle Global Data Services (GDS) is a feature of Oracle Database 12c that provides connect-time and run-time load balancing, region affinity, replication lag tolerance based workload routing, and enables inter-database service failover across a set of replicas.

Here are the details of how Oracle GDS is licensed.

  • Databases in a GDS configuration:
    • Must be Database Enterprise Edition (EE) +  Licensed for Oracle Active Data Guard Option and/or Oracle GoldenGate
  • GSM Software
    • No separate license is required
  • GDS Catalog Database
    • No Database EE license is required, if this is a schema in an existing repository (e.g. Oracle Enterprise Manager) database
    • No Database EE license is required (same as Oracle RMAN/EM repository license), if hosted as a separate single instance database
    • If Oracle RAC / Data Guard is used, Oracle RAC Option and Database EE license (for the extra nodes and/or standby) is required

For more information on GDS, do visit OTN GDS portal – https://www.oracle.com/goto/gds

AskTOM Office Hours: Oracle Sharding Session (April 23rd, 2018)

Exploring Oracle Sharding:
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Here is the recording of the Oracle Sharding session that I conducted on April 23rd, 2018.
Description:
Oracle Database with Sharding is a globally distributed multi-model (relational & document) cloud-native (and on-premises) DBMS. It is built on shared-nothing architecture where data is horizontally partitioned across databases that share no hardware or software. It provides linear scalability, fault isolation and geographic data distribution for shard-amenable applications. Sharding does all this while rendering strong consistency, full power of SQL, and the Oracle Database ecosystem. Listen to this recorded session to learn how you can deploy a sharded DB and elastically scale your transactions, database capacity and concurrent users.

 

Highlights:

@1.52 – Introduction to Oracle Sharding

@4:08 – Benefits of Sharding

@6:28 – Architecture and Key Features

@21:02 – Data Modeling and Application Considerations for a Sharded Database (SDB)

@29.51 –  Sharded Schema Creation

@36:14 – Direct Routing against an SDB

@41:23 – Proxy Routing for reporting workload

@48:35 – Results of Oracle Sharding Scalability Characterization study

AskTOM Office Hours: Oracle GDS Session 1 (April 4th, 2018)

Exploring Oracle Global Data Services (GDS):
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Here is the recording of the GDS session that I conducted on April 4th, 2018.
Description:
Oracle GoldenGate and Oracle Active Data Guard allow for distribution of application workloads across replicated databases, but when applications are spread across geodistributed databases, it is a challenge to efficiently use all the databases for best performance and availability. In this AskTom Office hours session, hear from Oracle Product Development experts about how the Global Data Services feature of Oracle Database provides region-based workload routing, load balancing, and service failover across replicas while enabling a seamless distributed private data cloud for your IT. In this session, you will learn how to load-balance read/write workloads in active/active Oracle GoldenGate and to load-balance read-only workloads across Oracle Active Data Guard reader farms, among numerous other use cases.
Highlights: At 2:03, GDS is introduced. At 4:25, GDS architecture is discussed. At 8:15, Deployment steps are covered. For use cases, please go to 15:58.
For the upcoming GDS AskTOM Office Hours sessions, please visit https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:3785:

AskTOM Office Hours: Oracle Sharding (Mar 26th, 2018 : 8 AM PST)

Exploring Oracle Sharding
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join Srinagesh Battula and other members of the Oracle Sharding team to get your questions about sharding in Oracle Database answered.
March 26, 2018 15:00 – 16:00 UTC
UTC 15:00 March 26 2018
US/Pacific 08:00 March 26 2018
US/Eastern 11:00 March 26 2018
Europe/London 16:00 March 26 2018
Asia/Calcutta 20:30 March 26 2018
Asia/Hong_Kong 23:00 March 26 2018
Australia/Sydney 02:00 March 27 2018
It’s the only one you’ll ever need for this Office Hours, taking you back to this page to join the next Q&A session, review upcoming sessions, and check out past sessions.

Visit the Zoom in advance of the session to make sure your browser is properly configured. But note that we will not be sending you the Zoom URL. Instead, you will come back to the AskTOM Office Hours page (URL above) to join the session.

We will take questions via chat (all audio lines will be muted). We will record sessions for later study.

For an audio-only connection, follow these instructions:

Dial (for higher quality, dial a number based on your current location):
US: +1 669 900 6833 or +1 646 558 8656
Meeting ID: 175942660
International numbers available: https://oracle.zoom.us/zoomconference?m=9yJ1LnAX3LsKA__-cuc3TFhsGBHdaMym
Click here for more information on joining a Zoom session by phone.

Oracle Sharding Product Overview

Oracle Sharding is a scale-out relational database architecture where data is horizontally partitioned across multiple discrete databases that share no hardware or software. It provides linear scalability, fault isolation and geographic data distribution for applications designed for a sharded architecture. Checkout this video to learn how Oracle Sharding automates the deployment of sharded databases, supports elastic scaling and automatic rebalancing, direct routing, proxy routing for multi-shard queries. It does all this while rendering strict consistency, full power of SQL, and the proven enterprise qualities of Oracle Database.

AskTOM Office Hours: Oracle Sharding

AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join me, and other members of the Oracle Sharding team to get your questions about sharding in Oracle Database answered.

URL: https://devgym.oracle.com/pls/apex/dg/office_hours/3242

When: 2018-02-26   22:00 UTC  – Oracle Sharding Office Hours

Start Times around the world:

UTC 10:00 PM February 26 2018
US/Pacific 02:00 PM February 26 2018
US/Eastern 05:00 PM February 26 2018
Europe/London 10:00 PM February 26 2018
Asia/Calcutta 03:30 AM February 27 2018
Asia/Hong_Kong 06:00 AM February 27 2018
Australia/Sydney 09:00 AM February 27 2018

And here are some general resources for the Office Hours program:

Landing page https://asktom.oracle.com/pls/apex/f?p=100:500
Promotional Video https://www.youtube.com/watch?v=7_-46aL0xU0

Hope you can join us.

Load Balance the Reader Farm with Oracle GDS

Many organizations maintain one or more replicas of their production databases in local and/or geographically disparate data centers to meet various business requirements such as high availability, disaster recovery, content localization and caching, scalability, optimal performance for local clients or compliance with local laws. Oracle Active Data Guard and Oracle GoldenGate are the strategic replication technologies native to Oracle Database used to synchronize one or more replicated copies for such purposes.

Achieving high performance and high availability by distributing workload across multiple database replicas, however, presents challenges that extend beyond the capabilities of the replication technology. Workload must be intelligently load balanced to effectively utilize all resources and to achieve the best performance.

Oracle Global Data Services (GDS) is a feature of Oracle Database 12c that provides connect-time and run-time load balancing, region affinity, replication lag tolerance based workload routing, and enables inter-database service failover over a set of replicated databases.

In this blog post, I will talk about how you can perform load balancing of your read-only workload across the reader farm (a set of Active Data Guard standby databases or a set of Oracle GoldenGate replicas) using Oracle GDS.

GDS provides connect-time and run-time load balancing (within and across data centers) on a reader farm. In this, client connections are load balanced at the connect time. Connection pool based Oracle Integrated Clients can subscribe to the RLB events and can load balance the workload requests at run-time as well. GDS allows better resource utilization and higher scalability by balancing Read Only workload on an Active Data Guard or Oracle GoldenGate reader farm.

readerfarm.pngFigure 1: Load balancing of Read-Only workloads on a reader farm

The above pictorial depicts GDS enabled for an Active Data Guard or Oracle GoldenGate reader farm with physical standbys/replicas located in both local and remote data centers. Order Entry (Read Write) global service runs on the Primary/Master database. Reporting (Read Only) global Services run on the reader farm. Client connections are load balanced among the Read Only global services running on the reader farm (within or across data centers).

To load balance the read-only workload over the reader farm, the global service should be defined as shown below.

Oracle GoldenGate Example:

In this example, DB01 is the master and DB02, DB03, DB04 are the replicas.

GDSCTL>add service -service reporting_srvc -gdspool sales –preferred DB02, DB03, DB04 -clbgoal LONG –rlbgoal SERVICE_TIME

Active Data Guard Example:

GDSCTL>add service -service reporting_srvc -gdspool sales –preferred_all –role PHYSICAL_STANDBY -clbgoal LONG –rlbgoal SERVICE_TIME

Additional Notes on CLBGOAL and RLBGOAL attributes:

With the CLBGOAL attribute of a global Service, we can attain connect-time load balancing i.e. choosing the least loaded database instance for establishing a new connection.

CLBGOAL supports two values – LONG and SHORT. Use the ‪LONG connection load balancing method for applications that have long-lived connections. This is typical for connection pools and SQL*Forms sessions. ‪LONG is the default connection load balancing goal. Use the ‪SHORT connection load balancing method for applications that have short-lived connections. When using connection pools that are integrated with FAN, set the ‪CLBGOAL to ‪SHORT.

Run-time load balancing is a feature of Oracle connection pools that can distribute client work requests across persistent connections that span databases. GDS supports Runtime load balancing feature of connection pool based clients (OCI, JDBC, ODP.NET, and WLS) that are integrated with the Oracle database, i.e. for a particular work request, “picking” a connection in the pool which belongs to the least loading instance.

RLBGOAL supports two values – SERVICE_TIME and THROUGHPUT. With the RLBGOAL set to SERVICE_TIME, Connection Pools route work requests to DB instances to minimize response time. The load balancing advisory is based on elapsed time for work requests using the service and network latency. With the RLBGOAL set to THROUGHPUT, Connection Pool routes work requests to DB instances to maximize total throughput of the system. The load balancing advisory is based on rate of work completion in the service plus available bandwidth to service.

To learn about how to setup and configure GDS, take a look at the GDS Cookbook: http://www.oracle.com/technetwork/database-features/database-ee/gds-with-ogg-cookbook-4004663.pdf .

For more info on GDS, do visit GDS OTN Portal