All Products
Search
Document Center

Cloud Backup:Register an ECS-hosted MySQL database

Last Updated:Feb 23, 2024

Before you use Cloud Backup to back up a MySQL database deployed on an Elastic Compute Service (ECS) instance, you must register the MySQL database in the Cloud Backup console. When you register a MySQL database, Cloud Backup installs a client on the ECS instance. Then, you can back up the MySQL database.

Prerequisites

  • Cloud Backup is activated. You are not charged for activating Cloud Backup. You are charged for using the database backup feature of Cloud Backup based on the following billable items:

    • Rental of database backup vaults. You are not charged for using a vault in the first 30 days. You are charged after the free-trial period ends. You can store data from various databases.

    • Storage usage of database backup vaults. You are charged for the backup storage based on the storage space occupied by the data that is deduplicated and compressed. A free capacity of 100 GB is provided for each backup vault per month. After the free quota is used up, you are charged based on tiered pricing.

      Note

      You are not charged for using Cloud Backup if you only register a MySQL database in the Cloud Backup console.

    For more information, see Pricing.

  • Cloud Assistant Agent is installed on the ECS instance that hosts the database.

    A Cloud Backup client for ECS must be used together with Cloud Assistant.

    • If you purchased the ECS instance before December 1, 2017, you must manually install Cloud Assistant Agent. For more information, see Install Cloud Assistant Agent.

    • If you purchased the ECS instance on or after December 1, 2017, Cloud Assistant Agent is pre-installed.

  • The username and password that are used to access the MySQL database are obtained.

    The minimum permission set of the user is RELOAD, LOCK TABLES, REPLICATION, and PROCESS.

Usage notes

  • You are not charged for using Cloud Backup if you only register a MySQL database in the Cloud Backup console.

  • Cloud Backup supports a limited number of database versions, operating systems, and backup features. For example, Cloud Backup does not support backup of a MySQL database deployed on Windows. For more information, see the "Supported database versions" section in Overview (ECS-hosted databases).

  • The MySQL backup feature does not support anti-ransomware policies for databases or databases that are deployed in containers.

Procedure

  1. Log on to the Cloud Backup console.

  2. In the left-side navigation pane, choose Back Up > Database Backup.

  3. In the top navigation bar, select a region.

  4. On the Database Backup page, click the MySQL tab.

  5. On the ECS Database Instance tab, click Register Database Instance.

  6. On the Select Database Instance tab in the Register MySQL database instance panel, select the database that you want to register and click Next.

    Note

    All the databases that are deployed on ECS instances in the current region are displayed. If you cannot find the database that you want to register, you can click Discover Database. Cloud Assistant automatically scans all databases and discovers the ECS-hosted databases.

    image.png

  7. In the Config Link Info step, configure the parameters and click OK. The following table describes the parameters.

    Parameter

    Description

    Database Account

    The username of the database.

    The minimum permission set of the user is RELOAD, LOCK TABLES, REPLICATION, and PROCESS.

    Password

    The user password.

    After you register the MySQL database, Cloud Backup installs a client for ECS backup on each node of the MySQL database. On the ECS Database Instance tab, you can view the installation status of the Cloud Backup client on each node of the MySQL database. If a new client version is available, we recommend that you Upgrade the client at the earliest opportunity.

Unregister a MySQL database

Important

After you cancel the database backup, your backup data is deleted and the backup data cannot be restored. Proceed with caution.

If you no longer need to back up a MySQL database, perform the following operations to unregister the database: Click the ECS Database Instance tab. Then, choose More > Unregister Instance in the Actions column of the database.

When you unregister the database, Cloud Backup automatically uninstalls the Cloud Backup client from the ECS instance.

FAQ

What to do next

Precheck an ECS-hosted MySQL database

References