NYOUG 2018 Fall General Meeting: Oracle Sharding Technical Deep Dive

NYOUG 2018 Fall General Meeting: Oracle Sharding Technical Deep Dive

Oracle Sharding is a response to customer demand for a database architecture that can deliver the combination of linear scalability and complete fault isolation without requiring shared storage or compromising on the enterprise qualities of the Oracle Database: strict consistency, the full power of SQL, developer agility with JSON, security, high availability, backup and recovery, life-cycle management, etc.

OLTP applications designed for Oracle sharding can elastically scale (data, transactions and users) to any level, on any platform, simply by deploying new shards on additional stand-alone servers. The unavailability or slowdown of a shard due to either an unplanned outage or planned maintenance affects only the users of that shard, it does not affect the availability or performance of the application for users of other shards.

Venkata Ravi Kumar Yenugula
YV Ravi Kumar is an Oracle ACE Director and Oracle Certified Master (OCM) with 20 years of experience in Banking, Financial Services and Insurance (BFSI) vertical and played various roles like Senior Database Architect and Production DBA. He is also OCP in Oracle 8i, 9i, 10g, 11g & 12c and Certified in Golden Gate, RAC, Performance Tuning & Oracle Exadata. He has written 90+ articles for OTN-Spanish, OTN-Portuguese, OTN-English, TOAD World, UKOUG, OTech Magazine and Redgate. He is a frequent Oracle speaker in @NYOUG, @OTN, AIOUG, Sangam and IOUG. He designed, architected and implemented Core Banking System (CBS) Database for Central Banks of two countries – India & Mahe, Seychelles. He is a Co-Founder of OraWorld (www.oraworld.com). Learn more from his profile at LaserSoft.