PolarDB-X 1.0 databases use ApsaraDB RDS for MySQL instances as their storage backend. To ensure Online Transaction Processing (OLTP) stability, use new ApsaraDB RDS for MySQL instances rather than sharing them with other workloads.
PolarDB-X 1.0 supports console-based database creation only. Creating databases with SQL statements is not supported.
Prerequisites
Before you begin, make sure you have:
An active PolarDB-X 1.0 instance
At least one ApsaraDB RDS for MySQL instance to use as the storage backend
Access to the PolarDB for Xscale console
Choose a split mode
PolarDB-X 1.0 supports two partitioning strategies. Choose one based on your data distribution needs:
| Split mode | When to use |
|---|---|
| Horizontal Split | Distribute data across multiple database shards and table shards based on sharding rules. Scales out horizontally to linearly increase overall storage capacity and concurrent throughput. |
| Vertical Split | Federate multiple existing databases from different PolarDB for MySQL clusters or ApsaraDB RDS for MySQL instances under a single PolarDB-X 1.0 endpoint. Enables joint queries and cross-instance transactions through one connection. |
Create a database
Log on to the PolarDB for Xscale console.
In the top navigation bar, select the region where the target instance is located.
Find the target instance and click the instance ID to go to the Basic Information page.
In the upper-right corner of the Basic Information page, click Create Database.
In the dialog box that appears, configure the database based on your chosen split mode.
Horizontal Split
In the Enter Basic Information step, configure the following parameters and click Next.
| Parameter | Description |
|---|---|
| Split Mode | Select Horizontal Split. |
| Storage Type | Select PolarDB for MySQL or RDS for MySQL as the storage backend. |
| Database Name | Enter a name for the database. The name must consist of lowercase letters, digits, and underscores (_), start with a letter, and be 1–24 characters long. |
| Character Set | Select uft8, gbk, latin1, or uft8mb4. |
| Link password | Enter the link password. See Password requirements. |
| Confirm Password | Re-enter the link password. |
In the Select RDS step, select the target ApsaraDB RDS for MySQL instances, click the 
icon to move them to the right side, and click Next.
Vertical Split
Configure the following parameters and click Next.
| Parameter | Description |
|---|---|
| Split Mode | Select Vertical Split. |
| Storage Type | Select PolarDB for MySQL (recommended) or RDS for MySQL as the storage backend. |
| Add Database | Select a target instance from the available ApsaraDB RDS for MySQL instances. Then select the target database and click the icon to move it to the right side. |
| Character Set | Select uft8, gbk, latin1, or uft8mb4. |
| Account Type | Select Create a new account or Select an existing account. |
| Database Account | Enter an account name. Available only when Account Type is set to Create a new account. |
| Link password | Enter the link password. See Password requirements. |
| Confirm Password | Re-enter the link password. Available only when creating a new account. |
In the Precheck step, wait until the result shows Success, and click Next.
In the Preview step, confirm the database information and click Next to complete the creation.
Password requirements
Link passwords must meet the following requirements:
8–30 characters long
Contains at least three of the following character types: uppercase letters, lowercase letters, digits, and underscores (_)