PolarDB:Create a database

Limits

You can create a PolarDB-X 1.0 database only in the console. Creating a PolarDB-X 1.0 database by using SQL statements is not supported.

Procedure

1. Log on to the PolarDB-X 1.0 console.

2. In the top navigation bar, select the region where the instance is deployed.

3. Find the instance and click the instance ID to go to the Basic Information page.

4. In the upper-right corner of the Basic Information page of the instance, click Create Database.
5. In the dialog box that appears, select a Partition Mode as needed and configure the corresponding parameters.
   • If you select Horizontal Partitioning, perform the following steps.
     1. In the Enter Basic Information step, configure the following parameters and click Next.

        Parameter	Description
        Partition Mode	Select Horizontal Partitioning. Note PolarDB-X 1.0 can distribute data to multiple database shards and table shards based on sharding rules. Horizontal partitioning implements the horizontal scale-out of databases and linearly increases the overall storage capacity and concurrent throughput.
        Storage Type	You can select POLARDB for MySQL (Recommended) or RDS for MySQL as the storage type. In this topic, RDS for MySQL is used as an example.
        Database Name	Enter a name for the database. Note The database name must meet the following requirements: It can contain only lowercase letters, digits, and underscores (_). It must start with a letter and cannot exceed 24 characters in length.
        Character Set	You can select utf8, gbk, latin1, or utf8mb4 as the character set.
        Link Password	Enter a link password for the database. Note The link password must meet the following requirements: It must be 8 to 30 characters in length. It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and underscores (_).
        Confirm Password	Enter the link password again to confirm it.

     2. In the Select ApsaraDB RDS Instance step, select the target RDS instance, click the icon to move it from the list on the left to the list on the right, and then click Next.
   • If you select Vertical Partitioning, configure the following parameters and click Next.

   Parameter	Description
   Partition Mode	Select Vertical Partitioning. Note You can import multiple existing databases from different PolarDB for MySQL clusters or ApsaraDB RDS for MySQL instances at a time, use PolarDB-X 1.0 instance-level accounts for unified authorization management, and then use a single PolarDB-X 1.0 connection to run joint queries and transactional writes across databases that reside on multiple ApsaraDB RDS instances.
   Storage Type	You can select POLARDB for MySQL (Recommended) or RDS for MySQL as the storage type. In this topic, RDS for MySQL is used as an example.
   Add Database	Select the target RDS instance from the list of available instances. Select the target database from the existing databases of the RDS instance, and click the icon to move it to the list on the right.
   Character Set	You can select utf8, gbk, latin1, or utf8mb4 as the character set.
   Account Type	You can Create Account or Select Existing Account.
   Database Account	Enter the name of the new account to create. Note This parameter is available only when Create Account is selected for Account Type.
   Link Password	Enter a link password for the database. Note The link password must meet the following requirements: It must be 8 to 30 characters in length. It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and underscores (_).
   Confirm Password	Enter the link password again to confirm it. This parameter is available only when Horizontal Partitioning is selected, or when a new account is created in Vertical Partitioning mode.

6. In the Precheck step, wait until the precheck result shows Successful, and then click Next.
7. In the Preview step, confirm the database information and click Next to complete the database creation.