Updated on 2024-05-21 GMT+08:00

Creating an HTAP instance

Scenarios

You can create an HTAP instance on the management console.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, locate a GaussDB(for MySQL) instance and click the instance name to go to the Basic Information page.
  5. In the navigation pane on the left, choose HTAP Analysis. On the displayed page, click Create HTAP Instance.
  6. On the Create HTAP Instance page, configure parameters as needed.

    Table 1 Parameter description

    Parameter

    Description

    DB Instance Information

    GaussDB(for MySQL) instance information is displayed, including the instance name, region, DB engine, primary AZ, time zone, billing mode, VPC, subnet, and security group.

    Billing Mode

    Pay-per-use

    DB Instance Type

    Single or primary/standby.

    • Single: There is only one node for an HTAP instance.
    • Primary/Standby: There are two nodes that provide cross-AZ HA. Only the primary node provides services. If the primary node fails and cannot provide services, the standby node will take over services.

    Storage Type

    Extreme SSD and ultra-high I/O.

    • Ultra-high I/O: uses multi-disk striping to balance I/O loads among multiple disks, improving read and write bandwidth. The maximum throughput is 1.7 GB/s.
    • Extreme SSD: uses 25GE network and RDMA to provide you with up to 1 million random read/write performance per disk and low latency per channel.

    AZ

    AZ where the HTAP instance is located.

    Instance Specifications

    Only general-enhanced is available.

    Nodes

    Currently, only single-node HTAP instances without read replicas can be created. A maximum of 10 HTAP instances can be created for each GaussDB(for MySQL).

    Storage Space (GB)

    Storage space that can be used by the HTAP instance.

    • If the storage type is extreme SSD, the default storage space is 40 GB, but it can be scaled up to 32 TB.
    • When the storage type is ultra-high I/O, the default storage space is 50 GB, but it can be scaled up to 32 TB.

    Time Zone

    You need to select a time zone for your instance based on the region it is hosted in. The time zone is selected during instance creation and cannot be changed later.

    Administrator

    The default username is root.

    Administrator Password

    Must consist of 8 to 32 characters and contain at least three of the following types of characters: uppercase letters, lowercase letters, digits, and special characters (~!@#%^*-_=+?,). Enter a strong password and periodically change it to improve security. Periodic password changes protect your account from brute force attacks and other risks.

    Confirm Password

    Must be the same as Administrator Password.

  7. After configuration, click Next.
  8. Confirm the configuration and click Submit.
  9. On the HTAP instance list page, view and manage the HTAP instance.