Table of Contents
- Title and Copyright Information
- Preface
-
1
Oracle Sharding Overview
- What is Sharding
- About Oracle Sharding
- Oracle Sharding as Distributed Partitioning
- Benefits of Oracle Sharding
- Example Applications using Database Sharding
- Flexible Deployment Models
- High Availability in Oracle Sharding
- Sharding Methods
- Client Request Routing
- Query Processing
- High Speed Data Ingest
- Deployment Automation
- Data Migration
- Lifecycle Management of Shards
- Federated Sharding
- What's New in Oracle Sharding 21c
- Where To Go From Here
- 2 Oracle Sharding Architecture and Concepts
- 3 Security in an Oracle Sharding Environment
-
4
Sharded Database Deployment
- Introduction to Sharded Database Deployment
- Planning Your Sharded Database Deployment
- Install the Oracle Database Software
- Install the Shard Director Software
- Create the Shard Catalog Database
- Create the Shard Databases
- Validate the Shard Database
- Configure the Sharded Database Topology
- Deploy the Sharding Configuration
- Create and Start Global Database Services
- Verify Shard Status
- Example Sharded Database Deployment
- 5 Using Oracle Database Sharding in Oracle Cloud Infrastructure
- 6 Sharded Database Schema Design
-
7
Using the Sharding Advisor
- About Sharding Advisor
- Run Sharding Advisor
- Run Sharding Advisor on a Non-Production System
- Review Sharding Advisor Output
- Choose a Sharding Advisor Recommended Configuration
- Sharding Advisor Usage and Options
- Sharding Advisor Output Tables
- Sharding Advisor Output Review SQL Examples
- Sharding Advisor Security
- 8 Migrating to a Sharded Database
-
9
Query and DML Processing
- How Database Requests are Routed to the Shards
- Connecting to the Query Coordinator
- Query Coordinator Operation
- Query Processing for Single-Shard Queries
- Query Processing for Multi-Shard Queries
- Supported Query Constructs and Example Query Shapes
- Supported DMLs and Examples
- Gathering Optimizer Statistics on Sharded Tables
- 10 Developing Applications for the Sharded Database
- 11 Sharding JSON Document Collections
-
12
Sharded Database Administration
- Managing the Sharding-Enabled Stack
- Oracle Globally Distributed Database Users and Roles
-
Backing Up and Recovering a Sharded Database
- Prerequisites to Configuring Centralized Backup and Restore
- Configuring Automated Backups
- Enabling and Disabling Automated Backups
- Backup Job Operation
- Monitoring Backup Status
- Viewing an Existing Backup Configuration
- Running On-Demand Backups
- Viewing Backup Job Status
- Listing Backups
- Validating Backups
- Deleting Backups
- Creating and Listing Global Restore Points
- Restoring From Backup
- Propagation of Parameter Settings Across Shards
- Modifying a Sharded Database Schema
- Managing Sharded Database Software Versions
- Managing Oracle Sharded Database with Enterprise Manager Cloud Control
- Monitoring a Sharded Database
- Shard Management
- Chunk Management
- Shard Director Management
- Region Management
- Shardspace Management
- Shardgroup Management
- Services Management
-
13
Achieving Data Sovereignty with Oracle Sharding
- Overview of Data Sovereignty
- Benefits of Implementing Data Sovereignty with Oracle Sharding
- Implementing Data Sovereignty with Oracle Sharding
-
Use Case of Achieving Data Sovereignty with Oracle Sharding
- Overview of Oracle Sharding Solution
- Deployment Topology of Data Sovereignty with Oracle Sharding
-
Configuring Data Sovereignty with Oracle Sharding
- Configuring VCN Networks in All Three OCI Regions
- Configuring Remote VCN Peering Between All Three Regions
- Configuring Private DNS for Naming Resolution Between the Regions
- Installing a Global Service Manager in Each Region
- Collecting TNS entries for Shard Catalog and Sharded Databases
- Configuring the Shard Catalog
- Configuring the Shard Databases
- Creating Oracle Sharding Global Database
- Implementing a Session-Based Application Context Policy
-
14
Troubleshooting Oracle Sharding
-
Troubleshooting Tips
- Checking the Sharding Method
- Checking the Replication Type
- Checking the Oracle Data Guard Protection Mode
- Checking Which Shards Are Mapped to a Key
- Checking Shard Operation Mode (Read-Only or Read-Write)
- Checking DDL Text
- Checking Chunk Migration Status
- Checking Table Type (Sharded or Duplicated)
- Checking User Type (Local or ALL_SHARD)
- Identifying Tables Created as Sharded Tablespaces
- Checking if Shard DDL is Enabled or Disabled
- Filtering Data by Sharding Key
- Setting the Duplicated Table Refresh Rate
- Oracle Sharding Tracing and Debug Information
- Common Error Patterns and Resolutions for Sharded Databases
-
Troubleshooting Tips
- 15 Oracle Sharding Solutions
- 16 Oracle Sharding Reference