Before you use the features of ApsaraDB MyBase, you must create instances on the hosts in your ApsaraDB MyBase dedicated cluster. The instances are created on the hosts based on the resource allocation policy that is selected.

Prerequisites

Hosts are created in an ApsaraDB MyBase for MySQL dedicated cluster. For more information, see Create hosts in an ApsaraDB MyBase for MySQL dedicated cluster.

Background information

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

Procedure

  1. Log on to the ApsaraDB MyBase console.
  2. In the upper-left corner of the page, select a region.
  3. In the left-side navigation pane, click Clusters. On the page that appears, find the ApsaraDB MyBase for MySQL dedicated cluster in which you want to create an instance and click Details in the Actions column.
  4. In the left-side navigation pane, click Instances. On the page that appears, click Create Instance.
  5. Configure the parameters described in the following table.
    Parameter Description
    Dedicated Cluster The dedicated cluster in which you want to create the instance.
    Database Engine The database engine of the instance. It is automatically set to MySQL and cannot be changed.
    Current Version The version of the database engine.
    Storage Engine The storage engine of the instance. It is automatically set to InnoDB. This parameter is available only when you set Engine Version to 8.0.
    Edition The edition of the instance. For more information about instance editions, see Overview.
    Note High-availability Edition is supported for instances that run MySQL 8.0, 5.7, or 5.6. Master-replica Edition is supported for instances that run MySQL 8.0 or 5.7.
    Primary Instances The number of primary Master-replica Edition instances. By default, this parameter is set to 1.
    Note This parameter is available only when you set Edition to Master-replica Edition.
    Parameter Template The parameter template of the instance.
    Note This parameter is available only when you set Edition to High-availability Edition.
    Time Zone The time zone of the instance.
    Table Name Case Sensitivity Specifies whether the names of the tables in the instance are case-sensitive.
    Storage Type The storage type of the instance.
    Note
    • If you set Edition to High-availability Edition, Local SSD and Enhanced SSD (ESSD) are available.
      • If you select Enhanced SSD (ESSD), you can select Disk Encryption to encrypt data. For more information, see Data encryption.
      • If you select Enhanced SSD (ESSD), Automatic Storage Expansion is automatically selected. You can specify the trigger conditions and upper limit for automatic storage expansion. When an automatic storage expansion is triggered, the storage space automatically expands by 5 GB or 15% of the current storage space, whichever value is greater.
    • If you set Edition to Master-replica Edition, only Enhanced ESSD (ESSD) is available.
    Instance Specifications The specifications of the instance.
    Storage Capacity The storage capacity of the instance. If you set Edition to High-availability Edition, you can set the Automatic Storage Expansion parameter.
    Automatic Storage Expansion Specifies whether the primary instance supports automatic storage expansion.
    • If you select Automatic Storage Expansion, you must set the Available Storage Space and Maximum Storage parameters.
      Note If the current available storage space is less than or equal to the threshold, an automatic storage expansion is triggered.
    • If you clear Automatic Storage Expansion, automatic storage expansion is not supported.
    Note This parameter is available only when you set Edition to High-availability Edition.
    Zone of Primary Instance
    • Deployment Method
    • Zone
    • vSwitch
    The network settings of the primary instance.
    • You can select Default Policy or Specified Host for the deployment method.
      Note
      • If you select Default Policy, the balanced allocation policy is used. In this case, the system preferentially deploys instances on the hosts that have the smallest load.
      • If you select Specified Host, you must select the hosts on which you want to deploy the instance.
    • The zone of the host within the dedicated cluster is displayed.
    • The vSwitch to which the host is connected is displayed. If no vSwitches are available, you can click Create VSwitch to create a vSwitch.
    Note This parameter is available only when you set Edition to Master-replica Edition.
    Recommended Architecture The architecture of the Master-replica Edition instance. You can select Standalone or Master-replica.
    Note This parameter is available only when you set Edition to Master-replica Edition.
    Read-only Instance The zone and vSwitch of the read-only instance and the failover status. You can click Create Read-only Instance to create more read-only instances.
    Note
    • This parameter is available only when you set Recommended Architecture to Master-replica.
    • When you set Recommended Architecture to Master-replica, you can specify a maximum of five read-only instances and three zones.
    Deployment Method The deployment method of the instance. You can select Default Policy or Specified Host.
    Note
    • This parameter is available only when you set Edition to High-availability Edition.
    • If you select Default Policy, the balanced allocation policy is used. In this case, the system preferentially deploys instances on the hosts that have the smallest load.
    • If you select Specified Host, you must select the hosts on which you want to deploy the instance.
    Network Settings
    • VPC
    • Zone
    • vSwitch
    The network settings of the instance.
    • By default, the virtual private cloud (VPC) of the dedicated cluster in which the instance resides is displayed.
    • The zone of the host within the dedicated cluster is displayed.
    • The vSwitch to which the host is connected is displayed. If no vSwitches are available, you can click Create VSwitch to create a vSwitch.
    Note This parameter is available only when you set Edition to High-availability Edition.
    Billing Method The billing method of the instance. It is automatically set to Pay-as-you-go.
    Note If the instance is deployed on a host that uses ESSDs, you must pay for the disk space allocated to the instance. This is because you are charged only for computing resources when you purchase a host that uses ESSDs. You can purchase subscription storage plans to reduce storage costs. A storage plan can be used to offset the storage costs of pay-as-you-go instances within the same region as the storage plan.
  6. Click Create.
    Note In the left-side navigation pane, you can choose Instances > MySQL to view the creation progress and status of the instance.

References

Learn more

You can join the DingTalk group 32484333 to obtain technical support from database experts, view success stories, and engage with experts on live streams that are provided on a regular basis.