tencent cloud

Feedback

Creating MySQL Instance

Last updated: 2022-08-29 11:29:19

    This document describes how to create a TencentDB for MySQL instance in the console.

    Prerequisites

    You have registered a Tencent Cloud account and completed identity verification.

    Directions

    1. Log in to the TencentDB for MySQL purchase page, configure the following instance information, and click Buy Now.
    • Billing Mode: Monthly subscription and pay-as-you-go billing are supported.
      • If your business has a stable long-term demand, we recommend you select monthly subscription.
      • If the request volume of your business fluctuates greatly and instantaneously, we recommend you choose pay-as-you-go billing.
    • Region: Select the region where you want to deploy your TencentDB for MySQL instance. We recommend you use the same region as the CVM instance to be connected to. Tencent Cloud services in different regions cannot communicate with each other over the private network. The region cannot be modified after purchase.
    • Database Version: Currently, TencentDB for MySQL supports MySQL 8.0, 5.7, 5.6, and 5.5. For more information on the features of each version, see the official documentation.
    • Engine: Select InnoDB or RocksDB.
      • InnoDB: The most commonly used OLTP storage engine, with complete transaction support and powerful capability of highly concurrent reads/writes.
      • RocksDB: A key-value storage engine, with efficient writing and high compression. If it is selected, the architecture will be two-node.
    • Architecture: Single-node, two-node, or three-node. For more information, see Overview.
    • Data Replication Mode: Async, semi-sync, and strong sync replication modes are supported. For more information, see Database Instance Replication.
    • Source AZ and Replica AZ: Select different source and replica AZs (i.e., multi-AZ deployment) to protect your database from failures and AZ outages.
      Note:

      • If the source and replica are in different AZs, the network sync delay may increase by 2–3 ms.
      • When you purchase Tencent Cloud services, we recommend you select the region closest to your end users to minimize access latency and improve download speed.
    • Instance Type: General or dedicated. For more information, see Resource Isolation Policy.
    • Instance Specs: Select specifications as needed.
    • Hard Disk: The disk space is used to store the files required by MySQL execution.
    • Network: Select the network where the TencentDB for MySQL instance resides, which is "Default-VPC (default)" by default. We recommend you select the same VPC in the same region as the CVM instance to be connected to. Otherwise, the MySQL instance cannot connect to the CVM instance over the private network.
    • Custom Port: The database access port, which is 3306 by default.
    • Security Group: For more information on security group creation and management, see TencentDB Security Group Management.
      Note:

      Port 3306 must be opened for the TencentDB for MySQL instance through the inbound rule of the security group. The instance uses private network port 3306 by default and supports custom port. If the default port is changed, the new port should be opened in the security group.

    • Parameter Template: Besides the system parameter template provided by TencentDB, you can create a custom parameter template. For more information, see Managing Parameter Template.
    • Character Set: LATIN1, GBK, UTF8, and UTF8MB4 character sets are supported. The default value is UTF8. After purchasing the instance, you can change the character set on the instance details page in the console. For more information, see Use Limits > Notes on character set.
    • Table Name Case Sensitivity: Whether the table name is case sensitive. The default value is Enabled.
    • Password Complexity: You can set the password complexity to improve the database security, which is disabled by default. For more information, see Setting Password Complexity.
    • Root Password: Set the password of the root account (the default user name for a new MySQL database is "root"). If you select Set After Creation, you can reset the password after creating the instance.
    • Alarm Policy: You can create an alarm policy to trigger alarms and send messages when the Tencent Cloud resource state changes. For more information, see Alarm Policies (Cloud Monitor).
    • Project: Select a project to which the TencentDB instance belongs. The default project is used.
    • Tag: Categorize and manage resources with tags. For more information, see Tag Overview.
    • Instance Name: Name the instance now or later.
    • Quantity: You can purchase up to ten pay-as-you-go instances in each AZ.
    • Purchase Period: Select the desired duration according to your business needs. The billing mode is monthly subscription, and the longer the purchase period, the higher the discount.
    • Auto-Renewal: Auto-renew the device monthly upon expiration if your account has sufficient balance in the monthly subscription billing mode.
    • Terms of Service: For more information, see Terms of Service.
    1. You will be returned to the instance list after you purchase the instance. The instance will be in the Delivering status. You can use the instance after around 3–5 minutes when its status changes to Running.

    Subsequent operations

    You can access the TencentDB for MySQL instance over both private and public networks from a Windows or Linux CVM instance. For more information, see Connecting to MySQL Instance.

    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support