Create a MyBase MySQL instance

Updated at:

After you create a host, you must create instances in the MyBase dedicated cluster to use all the features of the MyBase dedicated cluster. The system creates these instances on the host based on the resource allocation policy.

Prerequisites

You have created a host with the MySQL database engine. For more information, see Add a MySQL host.

Background information

For more information about ApsaraDB for MyBase, see What is ApsaraDB for MyBase?.

Important

New purchases of MyBase MySQL instances are discontinued starting August 31, 2023. This does not affect existing instances. For more information, see [Notice] New purchases of MyBase MySQL instances are discontinued starting August 31, 2023.

Procedure

  1. Log on to the ApsaraDB for MyBase console.

  2. In the upper-left corner of the page, select a region.

  3. In the navigation pane on the left, click Cluster List. In the Actions column of the target dedicated cluster, click Details.

  4. In the navigation pane on the left, click Instances, and then click Create Instance.

  5. Set the following parameters.

    Parameter

    Description

    Dedicated Cluster

    Select the destination dedicated cluster.

    Database Type

    The database type of the instance is MySQL. This parameter cannot be changed.

    Current Version

    The database version of the instance.

    Storage Engine

    The value is InnoDB. This parameter is available only when you select version 8.0.

    Edition

    The instance edition. For more information about instance editions, see Product editions.

    Note

    The High-availability Edition is supported for instances that run MySQL 8.0, 5.7, and 5.6.

    Parameter Template

    The parameter template for the instance.

    Note

    This parameter is available only when you set Edition to High-availability Edition.

    Time Zone

    The time zone of the instance.

    Case-sensitive Table Names

    Specifies whether table names are case-sensitive.

    Storage Type

    The storage class of the instance.

    Note

    If you select High-availability Edition for the instance edition, the storage class supports Local SSD and Enterprise SSD.

    • If you select enterprise SSD (ESSD), check Disk Encryption to encrypt the disk and protect your data. For more information, see Disk Encryption.

    • If you select ESSD, Auto-extend Storage Space is checked by default. You can set the trigger conditions and the maximum size for auto scaling. When triggered, the system automatically increases the storage space by 5 GB or 15% of the current storage space, whichever is greater.

    Instance Type

    The instance type.

    Storage Capacity

    The storage capacity of the instance. If you set the instance edition to High-availability Edition, you can set the Auto Storage Expansion parameter.

    Auto Storage Expansion

    Specifies whether to enable automatic storage expansion for the primary instance.

    • Enabled: Select the Auto Storage Expansion check box and set the Available Storage and Auto Expansion Upper Limit parameters.

      Note

      Automatic storage expansion is triggered if the available storage is less than or equal to the specified value.

    • Disabled: Clear the Auto Storage Expansion check box.

    Note

    This parameter is available only when you set Edition to High-availability Edition.

    Deployment Policy

    The supported deployment policies are Default Policy and Specify Host.

    Note
    • The default policy is balanced distribution. Instances are preferentially deployed on hosts with no allocated resources or fewer allocated resources.

    • If you select Specify Host, you must manually select the hosts on which to deploy the instance.

    Network Settings

    • VPC

    • Zone

    • VSwitch

    The network configuration of the instance.

    • The VPC of the cluster where the instance resides is used by default.

    • The zones where the hosts in the instance's cluster are located.

    • The vSwitch to which the host belongs. If no vSwitch is available, click Create vSwitch below.

    Billing Method

    Pay-as-you-go.

    Note

    If your instance is deployed on a host that uses cloud disks, the host fee includes only computing costs. You must pay for the storage capacity of the cloud disks when you create the instance. A storage plan is a subscription resource plan for storage capacity. It can be used to offset pay-as-you-go storage capacity bills in the same region. You can purchase a storage plan to reduce storage costs.

  6. Click Create Now.

    Note

    In the navigation pane on the left, click Instance List > MySQL to view the creation progress and status of the instance.

References