Cloud Backup:Register an on-premises MySQL database

Procedure

1. Log on to the Cloud Backup console.

2. In the left-side navigation pane, choose Backup > Database Backup. In the top navigation bar, select a region. On the Database Backup page, click the MySQL tab. On the Local Database Instance tab, click Register Database Instance.

3. In the Add Client panel, install a Cloud Backup client as prompted.

   1. Download and decompress the Cloud Backup client for Linux.

      You can right-click the package to obtain the download link and use a command similar to wget to download the Cloud Backup client for Linux to the on-premises server.

      wget https://a-hbr-resource-shanghai.oss-cn-shanghai.aliyuncs.com/unibackup/hbr-uni-install-linux.tar.gz

      Run the tar command to decompress the Cloud Backup client for Linux.

      tar -zxvf hbr-uni-install-linux.tar.gz

   2. Log on to the on-premises server and run the command to activate the Cloud Backup client for Linux.

      You can obtain the following sample command from the Cloud Backup console:

      sudo ./client init local-uni --uniUserInfoToken "eyJ1cmwiOiJodHRwczovL2EtaGJyLXJlc291cmNlLWhhbmd6aG91Lm9zcy1jbi1oYW5nemhvdS1pbnRlcm5hbC5hbGl5dW5jcy5jb20vY2xpZW50L2luc3RhbGwvZGJhY2t1cF9hZ2VudC9saW51eDY0LzguMC4yOTI5Mi0xLjAyODU3NzYuZGJnLyIsImhvc3QiOiIxMDAuMTAzLjguMTE2IiwicG9ydCI6NjAzMDUsIm15c3FsQWdlbnQiOiJZZXMiLCJtc3NxbEFnZW50IjoiTm8iLCJvcmFjbGVBZ2VudCI6Ik5vIiwidmVyc2lvbiI6IjguMC4yOTI5Mi0xLjAyODU3NzYuZGJnIiwiYWNjZXNzS2V5IjoiMzI1OGE3NDJmNzU4ZmFjNmVhMGRhMjEwZDRiZjA5NjAiLCJ1c2VTc2wiOiJZZXMiLCJhZ2VudCI6Im15c3FsIiwidXNlclRva2VuIjoiMDVUR0IwNUUiLCJyZWdpb25JZCI6ImNuLWhhbmd6aG91Iiwic291cmNlVHlwZSI6Ik1ZU1FMIn0="

   After you register the MySQL database, Cloud Backup installs a backup client on each node of the MySQL database. On the Local Database Instance tab, you can view the installation status of the Cloud Backup client on each node of the MySQL database. You can also upgrade a Cloud Backup client based on your business requirements.

4. Grant permissions to the backup account and reactivate the backup client.

   1. Return to the console. Find the database that you want to reactivate and choose More > Reactivate in the Actions column.

   2. In the Activate Instance dialog box, configure the parameters and click OK. The following table describes the parameters.

      Parameter	Description
      Database Account	The username of the database instance. The minimum permission set of the user is RELOAD, LOCK TABLES, REPLICATION, and PROCESS. For more information, see Before you begin.
      Password	The user password.

More operations

To delete a registered database, perform the following steps:

1. Log on to the on-premises server and run the following command to uninstall the Cloud Backup client for Linux:

   • CentOS

     sudo rpm --erase "dbackup3-agent-mysql"
     sudo rpm --erase "dbackup3-agent"
     sudo rpm --erase "dbackup3-common"

   • Ubuntu

     sudo dpkg -r "dbackup3-agent-mysql" "dbackup3-agent" "dbackup3-common"

2. On the Local Database Instance tab, find the MySQL database that you want to delete and choose More > Unregister Instance in the Actions column.

3. In the dialog box that appears, click OK.