Automation ⁘ Observability Real Application Clusters ⁘ Data Guard ⁘ Sharding Containerization ⁘ Terraform ⁘ Ansible Exadata & Engineered Systems AHF ⁘ TFA ⁘ GIMR ⁘ CHA Sean Scott Oracle ACE Director Data on Kubernetes Community Ambassador Managing Principal Consultant Viscosity North America @ViscosityNA www.viscosityna.com
rights reserved. | Linear Scalability with Oracle Sharding and Data Guard Swingbench Order-Entry Application # of Shards TPS 38 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 50 100 150 200
rights reserved. | Oracle Sharding Demo on Oracle Cloud Infrastructure • Elastically scaled-out to 200 shards on Oracle Cloud – Demonstrated linear scalability of Relational transactions – Demonstrated 11 Million transactions per sec that includes: • 4.5 Million Read-Write Transactions per sec across all 100 Primary shards • 6.5 Million Read-Only Transactions per sec across all 100 Active Standby shards • MAA Sharding provides highest availability – Each shard is protected by Data Guard Fast-Start Failover across Availability Domains – Single Shard Failure resulted in 100% availability for 99% of the application • 1% of the application experienced only 15 seconds blackout Conclusions
rights reserved. | • Korea's number one mobile operator • 65 billion transactions per day • 18TB of data per day • All data processing occurs on Oracle RAC Database running on Exadata 40 • World’s largest stock exchange • ~1 billion database transactions per day • 180,000 messages/sec • ~ 15 TB of data per day • All data captured and processed in an Oracle RAC Database on Exadata Massive Scale Workloads with Oracle Database • One of world's largest law enforcement orgs • ~3 billion transactions per day • ~32 billion queries per day • Database is over 1PB • Deployed on Oracle RAC Database on Exadata
performance, availability SLA • Locate data with intention based on free vs. paid users or by subscription level Free Tier No Performance/Availability SLA Bronze Tier Silver Tier Gold
& performance, no control of data location Top level control of data location Complete control over data location Shard by Consistent Hash Shard by Value/Range Shard by Value/Range + Hash
• Access primarily by the sharding key • Sharding key present in all sharded tables/levels • Join on sharding key • Many attributes become fixed once deployed • 21c - Sharding Advisor Schema Analysis Tool