Step 1: Buy a DB Instance
Scenarios
This section describes how to buy a DB instance on the management console.
RDS allows you to tailor your compute resources and storage space to your business needs.
Procedure
- Go to the Buy DB Instance page.
- On the displayed page, select a billing mode and configure information about your DB instance. Then, click Next.
- Billing mode
- Basic information
Table 1 Basic information Parameter
Description
Region
Region where your resources are located.
NOTE:Products in different regions cannot communicate with each other through a private network. After a DB instance is created, the region cannot be changed. Therefore, exercise caution when selecting a region.
DB Instance Name
Must start with a letter and consist of 4 to 64 characters. Only letters (case-sensitive), digits, hyphens (-), and underscores (_) are allowed.
DB Engine
Set to MySQL.
DB Engine Version
Different DB engine versions are supported in different regions.
When creating an RDS for MySQL instance, select a proper DB engine version tailored to your workloads. You are advised to select the latest available version because it is more stable, reliable, and secure.
DB Instance Type and AZ
- Primary/Standby: uses an HA architecture with a primary DB instance and a synchronous standby DB instance. It is suitable for production databases of large- and medium-sized enterprises in Internet, Internet of Things (IoT), retail e-commerce sales, logistics, gaming, and other sectors. The standby DB instance improves instance reliability and is invisible to you after being created.
An AZ is a physical region where resources use independent power supply and networks. AZs are physically isolated but interconnected through an internal network.
- Single: uses a single-node architecture, which is more cost-effective than primary/standby DB instances. It is suitable for development and testing of microsites, and small and medium enterprises, or for learning about RDS.
Storage Type
Determines the DB instance read/write speed. The higher the maximum throughput is, the higher the DB instance read/write speed can be.
- Cloud SSD: cloud drives used to decouple storage from compute. The maximum throughput is 350 MB/s.
- Ultra-high I/O: uses the SSD disk type that supports a maximum throughput of 350 MB/s.
Time Zone
You need to select a time zone for your instance based on the region hosting your instance.
- Primary/Standby: uses an HA architecture with a primary DB instance and a synchronous standby DB instance. It is suitable for production databases of large- and medium-sized enterprises in Internet, Internet of Things (IoT), retail e-commerce sales, logistics, gaming, and other sectors. The standby DB instance improves instance reliability and is invisible to you after being created.
- Specifications and storage
Table 2 Specifications and storage Parameter
Description
Instance Class
Refers to the vCPU and memory of a DB instance. Different instance classes support different numbers of database connections and maximum IOPS.
Storage Space (GB)
Contains the file system overhead required for inode, reserved block, and database operation.
NOTE:- Storage space can range in size from 40 GB to 4,000 GB and can be scaled up only by a multiple of 10 GB.
Disk Encryption
- Disable: Data stored in the disk is not encrypted.
- Enable: Enabling disk encryption improves data security, but slightly affects the read and write performance of the database.
- Key Name: indicates the tenant key. You can select an existing key or create a new one.
NOTE:- After an instance is created, the disk encryption status and the key cannot be changed.
- For details about how to create a key, see the "Creating a CMK" section in the Key Management Service User Guide.
- Network and database configuration
Table 3 Network Parameter
Description
VPC
A virtual network in which your RDS DB instances are located. A VPC can isolate networks for different workloads. You can select an existing VPC or create a VPC. For details on how to create a VPC, see "Creating a VPC" in Virtual Private Cloud User Guide.
If no VPC is available, RDS allocates a VPC to you by default.
NOTICE:After a DB instance is created, the VPC cannot be changed.
Subnet
Improves network security by providing dedicated network resources that are logically isolated from other networks. Subnets take effect only within an AZ. The Dynamic Host Configuration Protocol (DHCP) function is enabled by default for subnets in which you plan to create RDS DB instances and cannot be disabled.
A floating IP address is automatically assigned when you create a DB instance. You can also enter an unused IPv4 or IPv6 floating IP address in the subnet CIDR block. After the DB instance is created, you can change the floating IP address.
Security Group
Enhances security by controlling access to RDS from other services. Ensure that the security group you select allows the client to access the DB instance.
When creating a DB instance, you can select multiple security groups. For better network performance, you are advised to select no more than five security groups. In such a case, the access rules of all the selected security groups apply on the instance.
If no security group is available or has been created, RDS allocates a security group to you by default.
Database Port
The default database port is 3306. You can change it after a DB instance is created.
RDS for MySQL instances can use database ports 1024 to 65535, excluding 12017, 33071, and 33062, which are reserved for RDS system use.
Table 4 Database configuration Parameter
Description
Password
- Configure (default setting): Configure a password for your DB instance during the creation process.
- Skip: Configure a password later after the DB instance is created.
NOTICE:
If you select Skip for Password, you need to reset the password before you can log in to the instance.
Administrator
The default login name for the database is root.
Administrator Password
Must consist of 8 to 32 characters and contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_=+?,()&). Enter a strong password and periodically change it for security reasons.
If the password you provide is regarded as a weak password by the system, you will be prompted to enter a stronger password.
Keep this password secure. The system cannot retrieve it.
Confirm Password
Must be the same as Administrator Password.
Parameter Template
Contains engine configuration values that can be applied to one or more DB instances. If you intend to create a primary/standby DB pair, they use the same parameter template.
NOTICE:If you use a custom parameter template when creating a DB instance, the following specification-related parameters in the custom template are not delivered. Instead, the default values are used.
- back_log
- innodb_io_capacity_max
- max_connections
- innodb_io_capacity
- innodb_buffer_pool_size
- innodb_buffer_pool_instances
Table Name
Specifies whether table names are case sensitive. This parameter is supported for RDS for MySQL 8.0 only.
The case sensitivity of table names for created RDS for MySQL 8.0 instances cannot be changed.
Enterprise Project
If your account has been associated with an enterprise project, select the target project from the Enterprise Project drop-down list.
- Tags
Table 5 Tags Parameter
Description
Tag
Tags an RDS DB instance. This parameter is optional. Adding tags to RDS DB instances helps you better identify and manage the DB instances. A maximum of 20 tags can be added for each DB instance.
- Purchase period
Table 6 Purchase period Parameter
Description
Required Duration
This option is available only for yearly/monthly DB instances. The system will automatically calculate the configuration fee based on the selected required duration. The longer the required duration is, the larger discount you will enjoy.
Auto-renew
- This option is available only for yearly/monthly DB instances and is not selected by default.
- If you select this option, the auto-renew cycle is determined by the selected required duration.
Quantity
RDS supports batch creation of DB instances. If you intend to create primary/standby DB instances and set Quantity to 1, a primary DB instance and a synchronous standby DB instance will be created.
The performance of your DB instance depends on its configurations. Hardware configuration items include the instance specifications, storage type, and storage space.
- Confirm the specifications for pay-per-use DB instances.
- If you need to modify your settings, click Previous.
- If you do not need to modify your settings, click Submit.
- Confirm the order for yearly/monthly DB instances.
- If you need to modify your settings, click Previous.
- If you do not need to modify your settings, click Pay Now.
- Select a payment method and complete the payment.
This operation applies only to the yearly/monthly billing mode.
- To view and manage your DB instance, go to the Instances page.
- When your DB instance is being created, the status is Creating. The status changes to Available after the instance is created. To view the detailed progress and result of the creation, go to the Task Center page.
- The automated backup policy is enabled by default. You can change it after the DB instance is created. An automated full backup is immediately triggered once your DB instance is created.
- The default database port is 3306. You can change it after a DB instance is created.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.