Table of Contents
- Title and Copyright Information
- Preface
-
Changes in This Release for Oracle Sharding
-
Changes in Oracle Database 18c
-
New Features
- User-Defined Sharding Method
- Support for PDBs as Shards
- Support for Oracle GoldenGate Replication
- Centralized Diagnostics
- Multi-Shard Query Consistency Level
- Sharding Support for JSON, LOBs and Spatial Objects
- Optimizer Enhancements for Multi-Shard Queries
- Shard Replacement
- Oracle RAC Sharding
- UCP Support for Data-Dependent Routing to Oracle Sharding Middle Tiers
- Other Changes
-
New Features
-
Changes in Oracle Database 18c
- 1 Overview of Oracle Sharding
- 2 Sharded Database Schema Design
- 3 Physical Organization of a Sharded Database
- 4 Sharding Methods
- 5 Design Considerations for Sharded Database Applications
-
6
Request Routing in a Sharded Database Environment
- Direct Routing to a Shard
- Queries and DMLs with Proxy Routing in a Sharded Database
- Creating Affinity Between Middle-Tier Connection Pools and Shards
- 7 Shard-Level High Availability
-
8
Sharded Database Deployment
- Introduction to Sharded Database Deployment
- Oracle Sharding Prerequisites
- Installing Oracle Database Software
- Installing the Shard Director Software
- Creating the Shard Catalog Database
- Setting Up the Oracle Sharding Management and Routing Tier
- Creating and Deploying a System-Managed Sharded Database
- Creating and Deploying a User-Defined SDB
- Creating and Deploying a Composite SDB
- Using Transparent Data Encryption with Oracle Sharding
- 9 Migrating Data to a Sharded Database
-
10
Sharded Database Lifecycle Management
- Managing the Sharding-Enabled Stack
- Monitoring a Sharded Database
- Backing Up and Recovering a Sharded Database
- Modifying a Sharded Database Schema
- Managing Sharded Database Software Versions
- Shard Management
- Chunk Management
- Shard Director Management
- Region Management
- Shardspace Management
- Shardgroup Management
- Services Management
- 11 Troubleshooting Oracle Sharding
- Index