Skip to content

Oracle Database Sharding on OCI Marketplace

Bharath Ramaprasad edited this page Jun 16, 2020 · 17 revisions

Deploying Oracle Database Sharding on Oracle Cloud Marketplace

Finding Oracle Database Sharding on Oracle Cloud (OCI) Marketplace

Finding Oracle database on Public cloud marketplace

  1. Choose IaaS and then followed by OCI.

Oracle Database Sharding can be found on the featured list right at the top of the OCI applications on Oracle public marketplace.

Oracle Database Sharding on OCI Public Marketplace

Oracle Database Sharding on OCI Public Marketplace Featured Applications

  1. Go directly to the following listing link at :
    Oracle Database Sharding Listing on Oracle Cloud Public Marketplace

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.

Fill in the required details to configure variables.

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.

Managing Oracle Database Sharding created from OCI Marketplace

  • Click on the left hamburger Menu. Choose Resource Manager under Solutions and Marketplace.
  • Select the stack that you created from marketplace.
  • Click on Edit Stack.

Scaling Shards

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

Scaling Shard Directors

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.

Terminating Oracle Database Sharding created from Oracle Cloud Marketplace

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.

Product Documentation

For more details on Oracle Database Sharding and usage please refer to the product documentation. https://www.oracle.com/database/technologies/high-availability/sharding.html