Buying an RDS for MySQL DB Instance
Scenarios
This section describes how to buy a DB instance on the RDS console.
RDS for MySQL supports the yearly/monthly and pay-per-use billing modes. It allows you to tailor your compute resources and storage space to your business needs.
You can create multiple read replicas when you are buying single-node or primary/standby DB instances.
Precautions
RDS for MySQL supports encryption of data in transit during primary/standby replication. To use this function, you need to submit a service ticket to request required permissions before purchasing an instance. After an instance is created, manually enable SSL for it.
Preparations
- Sign up for a HUAWEI ID and enable Huawei Cloud services.
- For fine-grained permissions management on Huawei Cloud resources, use Identity and Access Management (IAM) to create a user and user group and grant the user specific operation permissions. For details, see Creating a User and Granting Permissions.
Procedure
- Go to the Buy DB Instance page.
- On that page, click the Custom Config tab, select a billing mode, configure information about your instance, and click Buy.
- Basic Settings
Figure 1 Basic Settings
Table 1 Basic Settings 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.
Billing Mode
Yearly/monthly and pay-per-use billing modes are available to meet your requirements in different scenarios.
- Yearly/Monthly: A prepaid billing mode in which you pay for resources before using it. Bills are settled based on the subscription period. The longer the subscription, the bigger the discount. This mode is a good option for long-term, stable services.
- Pay-per-use: A postpaid billing mode. You pay as you go and just pay for what you use. The DB instance usage is calculated by the second but billed every hour. If your instance has been used for less than one hour, you will be billed based on the actual duration. This mode allows you to adjust resource usage easily. You neither need to prepare for resources in advance, nor end up with excessive or insufficient preset resources.
- Engine Options
Table 2 Engine Options Parameter
Description
DB Engine
Select MySQL.
DB Engine Version
Select 8.0 or 5.7. MySQL 5.6 is only available for existing instances. 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
- 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.
- Single: uses a single-node architecture, which is less expensive than primary/standby DB instances. It is suitable for development and testing of microsites, and small- and medium-sized 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. After a DB instance is created, you can change its storage type. For details, see Changing a Storage Type.
- Cloud SSD or Ultra-high I/O
Stores data in cloud disks for decoupled storage and compute. The maximum throughput is 350 MB/s.
- For RDS for MySQL instances, this storage type is normally displayed as Cloud SSD, but for existing instances in certain regions it is displayed as Ultra-high I/O.
- The supported IOPS depends on the I/O performance of the Elastic Volume Service (EVS) disk. For details, see the description about ultra-high I/O in Disk Types and Performance of the Elastic Volume Service Service Overview.
- Extreme SSD
Uses 25GE network and RDMA technologies to provide you with up to 1,000 MB/s throughput per disk and sub-millisecond latency.
The supported IOPS depends on the I/O performance of the EVS disk. For details, see the description about extreme SSD in Disk Types and Performance of the Elastic Volume Service Service Overview.
NOTE:If you have purchased the Dedicated Distributed Storage Service (DSS), only the storage type that you have selected when you buy the DSS service is displayed.
AZ
An AZ is a physical region where resources use independent power supply and networks. AZs are physically isolated but interconnected through an internal network. You can select different AZs for your primary and standby instances for cross-AZ disaster recovery.
To achieve high reliability, RDS will automatically deploy your primary and standby instances in different physical servers even if you deploy them in the same AZ. If you attempt to deploy your primary and standby instances in the same AZ in a Dedicated Computing Cluster (DCC) and there is only one physical server available, the creation will fail.
- Instance Configuration
Figure 2 Specifications and storage
Table 3 Instance Configuration Parameter
Description
Instance Class
Refers to the vCPUs and memory of a DB instance. Different instance classes support different numbers of database connections and maximum IOPS.
For details about instance classes, see RDS for MySQL Instance Classes.
After a DB instance is created, you can change its instance class. For details, see Changing a DB Instance Class.
NOTE:Only general-enhanced DB instances are allowed for a DCC.
Resource Type
- EVS
- DSS
NOTE:
This option is displayed only when you have purchased Dedicated Distributed Storage Service (DSS).
Storage Pool
Displayed only when you select DSS for Resource Type. The storage pool is secure because it is physically isolated from other pools.
Storage Space
Contains the system overhead required for inodes, reserved blocks, and database operation.
After a DB instance is created, you can scale up its storage space. For details, see Scaling Up Storage Space.
Enable autoscaling
If the storage type is cloud SSD or extreme SSD, you can enable storage autoscaling. If the available storage drops to a specified threshold, autoscaling is triggered.- Enable autoscaling: If you select this option, autoscaling is enabled.
- Trigger If Available Storage Drops To: If the available storage drops to a specified threshold or 10 GB, autoscaling is triggered.
- Autoscaling Limit: The default value range is from 40 to 4,000, in GB. The limit must be no less than the storage of the DB instance.
NOTE:If you specify a read replica when creating a primary DB instance and enable storage autoscaling for the primary DB instance, storage autoscaling is also enabled for the read replica by default.
Disk Encryption
Enabling disk encryption enhances data security but reduces the database's read and write performance by 5%.
Key Name: indicates the tenant key. Select one from the drop-down list. If no key is available, click Create Key and configure parameters to create one. For details, see Creating a Custom Key in the Data Encryption Workshop User Guide.
After disk encryption is enabled, the following restrictions apply:
- If you enable disk encryption during instance creation, the disk encryption status and the key cannot be changed later.
- Enabling disk encryption will not encrypt backup data stored in Object Storage Service (OBS). To enable backup data encryption, contact customer service.
- Keep the key secure. Once the key is disabled, deleted, or frozen, your instance will be inaccessible and its data may not be restored.
If disk encryption is enabled but backup data encryption is not enabled, you can restore the data to a new instance from backups.
If both disk encryption and backup data encryption are enabled, the data cannot be restored.
NOTE:- If a shared KMS key is used, the corresponding CTS events are createdatakey and decrydatakey. Only the key owner can receive the events.
- Basic Settings and Connectivity
Figure 3 Basic Settings and Connectivity
Table 4 Basic Settings and Connectivity Parameter
Description
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.
- If you intend to create multiple DB instances and read replicas at a time, the allowed length for each instance name will change.
- If you buy multiple DB instances at a time, their names will include a four-digit suffix. For example, if you specify instance here, the names will be instance-0001, instance-0002, and so on. If existing instances' suffixes have already reached up to 0010, the new instance names will start from instance-0011.
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. After a DB instance is created, you can reset the password. For details, see Resetting the Administrator Password to Restore root Access.
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.
After a DB instance is created, you can reset this password. For details, see Resetting the Administrator Password to Restore root Access.
Confirm Password
Must be the same as Administrator Password.
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 about how to create a VPC, see Creating a VPC with a Subnet.
To use a shared VPC, select a VPC that another account shares with the current account from the drop-down list.
VPC owners can share the subnets in a VPC with one or multiple accounts through Resource Access Manager (RAM). Through VPC sharing, you can easily configure, operate, and manage multiple accounts' resources at low costs. For more information about VPC and subnet sharing, see VPC Sharing.
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 create RDS DB instances and cannot be disabled.
- IPv4 address:
A floating IPv4 address is automatically assigned when you create a DB instance. You can also enter an unused floating IPv4 address in the subnet CIDR block. After the DB instance is created, you can change the floating IP address.
- IPv6 address:
A DB instance assigned a floating IPv6 address will be created only when the vCPUs and memory you selected support IPv6 addresses.
A floating IPv6 address is automatically assigned during instance creation and cannot be specified. After the DB instance is created, this floating IP address cannot be changed. If no IPv6 subnets are available, submit a service ticket.
Requirements for available private IP addresses in a subnet hosting your DB instance:
- When creating a single-node DB instance, ensure that there are at least two available private IP addresses.
- If you also need to create single-node read replicas, there should be at least four available private IP addresses.
- If you need to create HA read replicas, there should be at least six available private IP addresses.
- When creating a primary/standby DB instance, ensure that there are at least three available private IP addresses.
If you also need to create HA read replicas, there should be at least seven available private IP addresses.
Figure 4 Viewing available private IP addressesDatabase 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.
Security Group
Enhances security by controlling access to RDS from other services. In addition, a network access control list (ACL) can help control inbound and outbound traffic of subnets in your VPC. 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.
- Additional Options
Table 5 Additional Options Parameter
Description
Enterprise Project
If your account has been associated with an enterprise project, select the target project from the Enterprise Project drop-down list.
For more information about enterprise projects, see Enterprise Management User Guide.
Parameter Template
Contains engine configuration values that can be applied to one or more DB instances of the same DB engine.
In the drop-down list, you can select a default parameter template, high-performance parameter template, or custom parameter template in the current region as required.
- A default parameter template contains DB engine defaults and system defaults that are configured based on the engine, compute class, and storage space allocated of an instance. Default parameter templates cannot be modified, but you can create your own parameter template to change parameter settings.
- High-performance parameter templates are only available for RDS for MySQL 5.7 and 8.0. Compared with standard parameter templates, high-performance templates provide higher read/write speed but lower data security. For details, see Creating a Parameter Template.
- You can select a custom parameter template and change the parameter values as required. The changes to parameter values in a custom parameter template are not applied to your instance until you apply the template to the instance. For details, see Creating a Parameter Template.
If you select a custom parameter template when creating a DB instance, specification-related parameters (including back_log, innodb_io_capacity_max, max_connections, innodb_io_capacity, innodb_buffer_pool_size, and innodb_buffer_pool_instances) in the custom template are not applied. Instead, the default values are used.
You can modify the instance parameters as required after the DB instance is created. For details, see Modifying Parameters of an RDS for MySQL Instance.
Time Zone
You need to select a time zone for your instance based on the region hosting your instance. You can select a time zone during instance creation and change it later as needed.
Table Name
Specifies whether table names are case sensitive.
The case sensitivity of table names (lower_case_table_names) for created RDS for MySQL 8.0 instances cannot be changed.
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.
If your organization has configured tag policies for RDS, add tags to DB instances based on the policies. If a tag does not comply with the policies, DB instance creation may fail. Contact your organization administrator to learn more about tag policies.
After a DB instance is created, you can view its tag details on the Tags page. For details, see RDS for MySQL Tags.
Certificate
(Optional) Specifies the certificate created by Cloud Certificate Manager (CCM). The default certificate is the system certificate that is automatically generated. You can also select another certificate from the drop-down list.
NOTICE:If you want to specify a certificate when creating a DB instance, submit a service ticket to request required permissions.
- Read Replica
Table 6 Read Replica Parameter
Description
Read Replica
You can determine whether to create read replicas when creating a DB instance.
- By default, Skip is selected.
- If you select Create, read replicas are named with "read" and two digits appended to the primary instance name by default. For example, if the primary instance name is instance-0001, the first read replica will be named instance-0001-read-01. The network and storage configurations of read replicas are the same as those of the primary instance.
Replica Type
- HA read replica: If the physical server where the primary read replica resides fails, the standby read replica automatically takes over workloads from the primary read replica.
- Read replica: If you want to buy single-node read replicas, you are advised to buy more than one single-node read replica and enable database proxy. That way, if one read replica fails, the database proxy can route traffic to other read replicas or the primary DB instance. When you purchase a single-node read replica, select the same value for Table Name as the DB instance.
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. After a DB instance is created, you can change its storage type. For details, see Changing a Storage Type.
- Cloud SSD or Ultra-high I/O
Stores data in cloud disks for decoupled storage and compute. The maximum throughput is 350 MB/s.
- For RDS for MySQL instances, this storage type is normally displayed as Cloud SSD, but for existing instances in certain regions it is displayed as Ultra-high I/O.
- The supported IOPS depends on the I/O performance of the Elastic Volume Service (EVS) disk. For details, see the description about ultra-high I/O in Disk Types and Performance of the Elastic Volume Service Service Overview.
- Extreme SSD
Uses 25GE network and RDMA technologies to provide you with up to 1,000 MB/s throughput per disk and sub-millisecond latency.
The supported IOPS depends on the I/O performance of the EVS disk. For details, see the description about extreme SSD in Disk Types and Performance of the Elastic Volume Service Service Overview.
NOTE:If you have purchased the Dedicated Distributed Storage Service (DSS), only the storage type that you have selected when you buy the DSS service is displayed.
Read Replica AZ
By default, read replicas are deployed in an AZ different from that of its primary instance.
Instance Class
You can select an instance class different from that of the primary instance for a read replica. To prevent a creation failure, long delay, and high load of a read replica, it is recommended that the instance class of the read replica be at least equal to that of the primary instance.
Read Replica Quantity
You can create a maximum of five read replicas for each DB instance. After a DB instance is created, the system automatically triggers the creation of read replicas.
If you intend to create primary/standby DB instances and set Read Replica Quantity to 1, a pair of primary/standby DB instances and a read replica will be created.
- Required Duration and Quantity
Table 7 Required Duration and Quantity 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.
If you want to set this parameter to 5 years, the restrictions are as follows:
- You need to obtain the required permissions by submitting a service ticket.
- This setting is supported only in CN North-Beijing4, CN East-Shanghai1, CN South-Guangzhou, and CN Southwest-Guiyang1.
- This setting is supported only with general-purpose instances.
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-renewal 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.
If you have any questions about the price, click Pricing details at the bottom of the page.
The performance of your DB instance depends on its configurations. Hardware configuration items include the instance specifications, storage type, and storage space.
- Basic Settings
- Confirm the instance information.
- For pay-per-use instances, confirm the specifications.
- If you need to modify your settings, click Previous.
- If you do not need to modify your settings, click Submit.
- For yearly/monthly instances, confirm the order.
- If you need to modify your settings, click Previous.
- If you do not need to modify your settings, click Pay Now to go to the payment page. Select a payment method and complete the payment.
- For pay-per-use instances, confirm the specifications.
- To view and manage your DB instance, go to the Instances page.
Figure 5 Instance successfully purchased
- 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.
- Go to the Buy DB Instance page.
- On the Quick Config page, set basic parameters.
Only mandatory parameters are provided on the Quick Config page. To configure more parameters, see Custom Purchase.
The following parameter settings are only for reference. Tailor your settings to your workloads.
Figure 6 Basic SettingsTable 8 Basic Settings Parameter
Example Value
Description
Region
CN-Hong Kong
The region where your resources are located.
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.
Billing Mode
Pay-per-use
Yearly/monthly and pay-per-use billing modes are available to meet your requirements in different scenarios.
- Yearly/Monthly: A prepaid billing mode in which you pay for resources before using it. Bills are settled based on the subscription period. The longer the subscription, the bigger the discount. This mode is a good option for long-term, stable services.
- Pay-per-use: A postpaid billing mode. You pay as you go and just pay for what you use. The DB instance usage is calculated by the second but billed every hour. If your instance has been used for less than one hour, you will be billed based on the actual duration. This mode allows you to adjust resource usage easily. You neither need to prepare for resources in advance, nor end up with excessive or insufficient preset resources.
DB Engine Version
8.0
The database version.
DB Instance Type
Primary/Standby
The architecture type of an instance.
Primary/Standby: An HA architecture. In a primary/standby pair, each instance has the same instance class. When a primary instance is being created, a standby instance is provisioned along with it to provide data redundancy. The standby instance is invisible to you after being created.
Instance Class
General-purpose | 2 vCPU | 4 GB
The vCPUs and memory of an instance.
Storage
Cloud SSD | 100 GB
The storage space of an instance.
It contains the system overhead required for inodes, reserved blocks, and database operation.
Disk Encryption
Disable
Enabling disk encryption improves data security, but slightly affects the read and write performance of the database.
If a shared KMS key is used, the corresponding CTS events are createdatakey and decrydatakey. Only the key owner can receive the events.
- Set parameters for Additional Options.
Figure 7 Additional Options
Table 9 Additional Options Parameter
Example Value
Description
VPC
default_vpc
The virtual network in which your instance is located. A VPC can isolate networks for different workloads.
If no VPC is available, click Create VPC. After a VPC is created, click
. For details, see Creating a VPC with a Subnet.
Subnet
default_subnet
A subnet provides dedicated network resources that are logically isolated from other networks for network security.
Security Group
default
It can enhance security by controlling access to RDS for MySQL from other services.
Enterprise Project
default
If your account has been associated with an enterprise project, select the target project from the Enterprise Project drop-down list.
For more information about enterprise projects, see the Enterprise Management User Guide.
Table Name
Case insensitive
Whether table names are case sensitive. Restoration may fail if the case sensitivity settings of table names on the source and target instances are different.
The case sensitivity of table names for created RDS for MySQL 8.0 instances cannot be changed.
Quantity
1
The number of instances to be created in a batch.
- Click Buy.
- To view and manage your DB instance, go to the Instances page.
Figure 8 Instance successfully purchased
- 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.
Follow-up Operations
After a DB instance is created, you can enter a description for it. For details, see Changing a DB Instance Description.
The default database port is 3306. You can change it after a DB instance is created. To ensure data and instance security, you are advised to change the database port in a timely manner. For details, see Changing a Database Port.
FAQ
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot