edit-icon download-icon

Create a DRDS database

Last Updated: Apr 05, 2018

After a DRDS instance is created, you can create DRDS databases.

Attention:

  • DRDS databases can be created only on the console.

  • When creating a DRDS database, you must select one or more RDS instances as data storage nodes. If you do not have RDS instances, buy at least one before database creation.

Database creation procedure

  1. On the DRDS console, select Instances in the left-side navigation pane.

  2. Click the DRDS instance in which you want to create a database.

  3. On the Basic Information page, click Create Database at the upper-right corner.

  4. Select one or more RDS instances as storage nodes of the DRDS database, click the right arrow, and click Next Step.

    Note:

    • The RDS instances selected as DRDS data storage nodes must meet the following requirements: (1) The instance is a MySQL instance; (2) The instance is in the running state; (3) The RDS is in the same region as the DRDS instance.

    • If a selected RDS instance has a master account, you will be asked to enter the master account and password, which will not be accessed or stored by DRDS and will only be used temporarily in subsequent steps.

  5. Set basic information.

    Creation Type indicates the way to use DRDS.

    • Sharded: Indicates database/table sharding, which splits data into multiple databases and tables according to the sharding rules. The DRDS instance acts as a proxy of SQL. Sharding involves data import/export and SQL function/performance testing and transformation. This may affect the functions and performance of applications.

    • Non-Sharded: The existing RDS databases are transferred to the DRDS instance for proxied access to implement read/write splitting. You only need to change the database connection string, username, and password, without the need to import data or modify code.

  6. Review the database information.

    By default, the DRDS instance creates eight physical databases on one RDS instance. The total number of physical databases is the number of RDS instances multiplied by 8.

  7. Click Next to create the DRDS database.

    The DRDS instance creates the database, account, DRDS system tables, and configurations through RDS APIs or the master account. Wait until the database creation is complete.

    You can view the database creation status in the DRDS database list.

Thank you! We've received your feedback.