Directory-Based Distributed Database Roadmap

Set up a directory-based distributed database, including configuring the distributed database, creating schema objects, and doing lifecycle management operations.

1. Deploy a Directory-Based Distributed Database

A directory-based configuration follows the same steps as you would for a user-defined distributed database, with a few differences.

Most of the information you need is found in Oracle Globally Distributed Database Deployment for planning, installing and creating the databases for the distributed database topology.

To configure the topology for Directory-based data distribution, do the following tasks:

1. Create a shard catalog for user-defined data distribution. See Creating a Shard Catalog for a Directory-Based Distributed Database.

2. Add and start shard directors. See Add and Start Shard Directors.

3. Create shardspaces, and shards in those shardspaces. See Add Shardspaces If Needed, Add the Shard CDBs, and Add the Shard PDBs.

4. Create tablespaces in the shardspaces. See User-Defined Data Distribution for examples.

   Note that each tablespace has to be created individually, and explicitly associated with a shardspace.

5. Verify the topology, add shards and host metadata, deploy the configuration, and start global database services. See Oracle Globally Distributed Database Deployment.

2. Create Schema Objects

• To create tables sharded by directory, see Creating Tables Sharded by Directory.

• To add (and remove) keys to the directory, see Managing Keys in a Directory-Based Distributed Database.

3. Run DML and Queries

See DML Support on Tables Sharded by Directory.

4. Perform Lifecycle Operations

Over the lifetime of your directory-based distributed database, you'll need to do tasks such as:

• Add and remove keys. See Managing Keys in a Directory-Based Distributed Database

• Add partitions. See Adding a New Tablespace and Chunks (Partition) in a Shardspace

• Move chunks. See Chunk Management in a Directory-Based Distributed Database.

• Split chunks. See Splitting Partitions (Chunks).

• Query the directory view for metadata. See Sharding Key Directory Public View.