Oracle Database Sharding on OCI Marketplace
- Choose IaaS
- Choose Oracle Cloud Infrastructure
- Select Oracle Database Sharding from the list of Featured Apps.
Oracle Database Sharding can be found on the featured list right at the top of the OCI applications on Oracle public marketplace.
- Go directly to the following listing link at :
Oracle Database Sharding Listing on Oracle Cloud Public Marketplace
- Once you login to the OCI console, Click on the left hamburger navigation menu.
- Next, select OCI marketplace under solutions & marketplace section in the left navigation menu.
- Next, you should be able to immediately find Oracle Database Sharding in the Featured Apps.
- If you don't find Oracle Database Sharding for some reason, then search for it in the marketplace search bar.
- Click on the Oracle Database Sharding Tile which will bring up the listing for Oracle Database Sharding.
Oracle Database Sharding Listing
Fill in the required Stack information after clicking on Launch instance on the Oracle Database Sharding Marketplace product page
- Name - Name of the Stack. It has a default name and provides a date time stamp. You can edit this detail, if required.
- Description - Description that you provide while creating the Stack.
- Create In Compartment – It defaults to the compartment you had selected on the Oracle Database Sharding Marketplace page before clicking on Launch stack.
- Terraform Version - It defaults to 0.12x.
- Tags (optional) – Tags are a convenient way to assign a tracking mechanism but are not mandatory. You can assign a tag of your choice for easy tracking. You have to assign a tag for some environments for cost analysis purposes.
Click Next.
Oracle Sharded Database General Configuration
- SHARDED DATABASE NAME - The name is used as the sharded database name as well as a prefix for all sharded database resource display names. The name specified must be unique within the subnet.
- SHARDING METHOD
- DATABASE SOFTWARE EDITION
- CHOOSE STORAGE MANAGEMENT SOFTWARE
- CHOOSE A LICENSE TYPE
- DATABASE VERSION
Shard configuration
- SHARD SHAPE
- NUMBER OF PRIMARY SHARDS - The number of primary shard catalog databases. The total number of Shard catalog databases provisioned is determined by the value of the Replication Factor chosen. Shard Catalogs will be uniformly distributed across all availability domains in the current region and across fault domains within each availability domain.
- SHARD DATABASE AVAILABLE STORAGE SIZE IN GB
Shard Catalog configuration
- SHARD CATALOG SHAPE
- NUMBER OF PRIMARY SHARD CATALOGS
- SHARD CATALOG DATABASE AVAILABLE STORAGE SIZE IN GB
Replication configuration
- REPLICATION FACTOR - Choose a replicaton factor. The total number of shard databases provisioned will be equal to the number of primary shards selected above multiplied by the chosen Replication Factor. The total number of primary catalog databases that will be provisioned will be equal to the Replication Factor chosen.
Shard Director configuration
- SHARD DIRECTOR SHAPE
- NUMBER OF SHARD DIRECTORS - Choose the number of shard directors to be deployed.
Network Settings
- CREATE NEW NETWORK - Check this to create a new regional network (recommended if this is your first sharded database) or Uncheck to use an existing regional network from a previously created sharded database
- VCN NETWORK COMPARTMENT- Compartment for new or existing Virtual Cloud Network (VCN)
- VCN - Existing VCN to use for sharded database if not creating a new network
- SUBNET NETWORK COMPARTMENT - Compartment for new or existing Subnet
- CHOOSE A REGIONAL SUBNET - Existing Regional Subnet to use for sharded database if not creating a new network.
ssh configuration
- SSH PUBLIC KEY - Public key for allowing SSH access to the sharded database hosts.
- On the Review page, review the information you provided and then click Create.
- After clicking Create, you will be navigated to the Stacks Job Details page. You can monitor the creation of the Oracle Database Sharding using this page.
- Upon completion, you can now view the output pane on the left for connection information to Oracle Sharded Database.
- Click on the left hamburger navigation Menu. Choose Resource Manager under Solutions and Marketplace.
- Select the stack that you created from marketplace.
- Click on Edit Stack.
Shards can be scaled in (decreased) or out (decreased) based on user requirements and as needed without affecting performance of queries per second(qps) or transactions per second (tps) and with zero downtime.
-
Update the number of Shard Directors
-
Review and Save changes
- Next click on Terraform Actions → Apply
Shard directors can be scaled in (decreased) or out (decreased) based on user requirements and as needed without affecting performance and with zero downtime.
The steps for scaling are the same as scaling shards as shown in the previous section.
To terminate an Oracle Sharded Database created from OCI marketplace in the past, follow the steps below :
- Click on the left hamburger Menu. Choose Resource Manager under Solutions and Marketplace.
- Select the stack that you created from marketplace.
- Click on Terraform Actions → Destroy. Once you click this all Sharded database resources including any user data will be deleted from OCI.
- Once the destroy has completed the jobs section will show that the destroy job has been successfully completed.
For more details on Oracle Database Sharding and usage please refer to the Product page.
For product documentation, please refer to the product release documentation
For GDSCTL CLI commands to manage sharded database manually once deployed on OCI, please refer to the Sharding GDSCTL CLI command reference