Buying a DB Instance and Connecting to It Using the mysql Client

• Basic configuration
  Figure 1 Basic configuration
  

  Table 1 Basic configuration

  Parameter	Example	Description
  Billing Mode	Pay-per-use	Billing mode of an instance. 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. 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. Serverless: The instance capacities automatically change based on application requirements. You can start using the DB instance first and then pay as you go.
  Region	CN-Hong Kong	Region where an instance is deployed. NOTE: You cannot change the region of an instance once it is purchased.

• Resource selection
  Figure 2 Resource selection
  

  Table 2 Resource selection

  Parameter	Example	Description
  DB Engine Version	TaurusDB V2.0	DB engine and version.
  Kernel Version	2.0.60.241220	DB kernel version. For details about the updates in each minor kernel version, see TaurusDB Kernel Version Release History. NOTE: To specify the kernel version when buying an instance, submit a request by choosing Service Tickets > Create Service Ticket in the upper right corner of the management console. To buy a multi-primary instance, select kernel version 2.0.45.230950 or 2.0.57.240900.
  Creation Method	Create new	How an instance is created.
  Edition Type	Enterprise	Enterprise Edition is an enterprise-grade cloud-native database with high scalability and performance. It is fully compatible with open-source MySQL 8.0. It decouples compute from storage and uses Huawei-developed Data Function Virtualization (DFV), which scales to up to 128 TB per instance. A failover can be complete within seconds. High-value capabilities such as read/write splitting, operator pushdown, a serverless framework, and HTAP are also supported. It provides the high availability and superior performance of a commercial database at the price of an open-source database.
  DB Instance Type	Primary/Standby	A primary/standby instance can contain one primary node and 1 to 15 read replicas. The primary node processes read and write requests, and the read replicas process only read requests. If the primary node becomes unavailable, TaurusDB automatically fails over to a read replica. Primary/Standby instances apply to medium- and large-sized enterprises in the Internet, taxation, banking, and insurance sectors.
  AZ Type	Multi-AZ	An AZ is a physical region where resources have their own independent power supply and networks. AZs are physically isolated but interconnected through an internal network. Some regions support both single-AZ and multi-AZ deployment and some only support single-AZ deployment. Single AZ: The primary node and read replicas are deployed in the same AZ. Multi-AZ: The primary node and read replicas are deployed in different AZs to achieve higher availability and reliability. It is suitable for workloads that require cross-AZ DR or are insensitive to cross-AZ latency.
  Storage Type	DL6	The original Shared storage. The default storage type of TaurusDB instances created before July 2024 is Shared storage, while that of TaurusDB instances created in July 2024 and beyond is DL6. DL6-based instances achieve zero RPO with a 3-AZ deployment and deliver better performance and higher peak throughput. They are suitable for core application systems that are sensitive to performance and have demanding requirements on storage I/O during peak hours, such as those in finance, e-commerce, government, and gaming.

• Instance options
  Figure 3 Specifications and storage
  

  Table 3 Specifications and storage

  Parameter	Example	Description
  Instance Specifications	Dedicated 2 vCPUs | 4 GB	vCPUs and memory of an instance.
  CPU Architecture	x86	x86 instances use Intel® Xeon® Scalable processors and feature robust and stable computing performance. When working on high-performance networks, the instances provide the additional performance and stability that enterprise-class applications demand.
  Nodes	2	This parameter is mandatory for primary/standby and multi-primary instances.
  Storage	-	It contains the system overhead required for inodes, reserved blocks, and database operations.
  Backup Space	-	TaurusDB provides free backup space equal to the amount of your used storage. After the free backup space is used up, you will be billed for the additional space on a pay-per-use basis.
  TDE	Disabled	Transparent Data Encryption (TDE) encrypts data files and backup files using certificates to implement real-time I/O encryption and decryption. This function effectively protects the security of databases and data files.

  Figure 4 Network
  

  Table 4 Network

  Parameter	Example	Description
  VPC	default_vpc	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 and Subnet. NOTICE: After a TaurusDB instance is created, the VPC cannot be changed.
  Subnet	default_subnet	A subnet provides dedicated network resources that are logically isolated from other networks for network security.
  Security Group	default	A security group enhances security by controlling access to TaurusDB from other services.

  Figure 5 Setting an administrator password
  

  Table 5 Database configuration

  Parameter	Example	Description
  DB Instance Name	TaurusDB-985e	DB instance name.
  Administrator Password	-	The default administrator account is root. The administrator password must consist of 8 to 32 characters and contain at least three of the following: uppercase letters, lowercase letters, digits, and special characters (~!@#%^*-_=+?,()&$|.). Enter a strong password and periodically change it to improve security and defend against threats such as brute force cracking attempts. Keep this password secure. If lost, the system cannot retrieve it. After a DB instance is created, you can reset this password. For details, see Resetting the Administrator Password.
  Confirm Password	-	Enter the administrator password again.

• Advanced settings
  Figure 6 Advanced settings and required quantity
  

  Table 6 Advanced settings and required quantity

  Parameter	Example	Description
  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 Enterprise Management User Guide.
  Parameter Template	Default-TaurusDB V2.0	Contains engine configuration values that can be applied to one or more instances.
  Time Zone	-	You need to select a time zone for your instance based on the region hosting your instance. The time zone is selected during instance creation and cannot be changed after the instance is created.
  Table Name	Case insensitive	Specifies whether table names are case sensitive. This option cannot be changed later. Case sensitive: Table names are case sensitive. Case insensitive: Table names are case insensitive and are stored in lowercase letters by default.
  Tag	-	Tags a DB instance. This parameter is optional. Adding tags helps you better identify and manage your DB instances. Each DB instance can have up to 20 tags.
  Quantity	1	You can buy DB instances in batches. The default value is 1. The value ranges from 1 to 10.

• If there is a Linux ECS, go to 3.
• If there is a Windows ECS, see Buying a DB Instance and Connecting to It Using MySQL-Front.
• If no ECS is available, go to 2.

To download the mysql client to the ECS, bind an EIP to the ECS. The ECS must be in the same region, VPC, and security group as the DB instance for mutual communications.

For details about how to purchase a Linux ECS, see Purchasing an ECS in Elastic Cloud Server Getting Started.

• If they are in the same region and VPC, go to Step 3: Test Connectivity and Install the mysql Client.
• If they are in different regions, buy another ECS or DB instance. The ECS and DB instance in different regions cannot communicate with each other. To reduce network latency, deploy your DB instance in the region nearest to your workloads.
• If they are in different VPCs, change the VPC of the ECS to that of the DB instance. For details, see Changing a VPC.

You are advised to use a mysql client running a version later than that of the DB instance.

wget https://dev.mysql.com/get/mysql-community-client-8.0.21-1.el6.x86_64.rpm

rpm -ivh --nodeps mysql-community-client-8.0.21-1.el6.x86_64.rpm

• If any conflicts occur during the installation, add the replacefiles parameter to the command and install the client again.

  rpm -ivh --replacefiles mysql-community-client-8.0.21-1.el6.x86_64.rpm

• If a message is displayed prompting you to install a dependency package during the installation, add the nodeps parameter to the command and install the client again.

  rpm -ivh --nodeps mysql-community-client-8.0.21-1.el6.x86_64.rpm

mysql -h <host> -P <port> -u <userName> -p

Example:

mysql -h 192.*.*.* -P 3306 -u root -p

Enter password:

Figure 10 Connection succeeded

create database db_test;

Figure 11 Creating a database

create table t_test(id int(4), name char(20), age int(4));

Figure 12 Creating a table

insert into t_test(id, name, age) values(1, 'zhangsan', 30);

Figure 13 Inserting data

select * from t_test;

Figure 14 Querying data

update t_test set age=31 where id=1;

Figure 15 Updating data

select * from t_test where id=1;

Figure 16 Querying the updated data

delete from t_test where id=1;

Figure 17 Deleting table data

drop table t_test;

Figure 18 Deleting a table structure

drop database db_test;

Figure 19 Deleting a database