Agent--Mysql(3.2)
1.1 Create a New MySQL Instance
Prerequisites
- Create a new user.
- Create a new storage repository.
- Create a new service plan.
- A MySQL service has been installed and is accessible.
Steps
Step 1: Click [Backup Service] - [Database] in the system menu, then select the server name in the list to enter the database instance page.
Step 2: Click the [Add] button in the upper-right corner of [Instance]. The following dialog box is displayed:
Step 3: Configure the instance information, and click [Next Step].
Step 4: Configure whether to use XtraBackup.
Fill in the required parameters. The parameter descriptions are as follows:
| Parameter Name | Parameter Description | Setting Principle |
|---|---|---|
| Database Type | Single selection, required; MySQL is selected by default | Only MySQL is currently supported |
| Server Name | Single selection, required; options are the servers where MySQL is located | Select the name of the server where MySQL is located |
| Instance Name | Text input box, required | No length or special-character restrictions are currently enforced |
| DB Username | Input box, required | Enter the MySQL username |
| Password | Password input, required | Enter the MySQL password |
| UNIX Username | Input box, required | Enter the UNIX username, such as root |
| Socket/Endpoint | Input box, required | Enter the path to mysql.sock |
| Binary Directory | Input box, required | Enter the correct MySQL binary directory |
| Log Data Directory | Input box, required | Enter the correct directory where the MySQL logs are stored |
| Configuration File | Input box, required | Enter the path to the mysql.cnf file |
| XtraBackup Setting | Disabled by default | A MySQL backup method that requires the installation of third-party dependency packages |
Step 5: Click [Confirm]. The frontend displays a message indicating that the addition was successful.
1.2 Create a New MySQL Backup Set
Prerequisites
- A MySQL instance has been created.
Steps
Step 1: Click [Backup Service] - [Database], select the server name, and then select [Backup Set] in the list.
Step 2: Click the [Add] button in the upper-right corner of [Backup Set]. The following dialog box is displayed. Fill in the required parameters. The following screenshots show database backup, instance backup, and log backup, respectively:
Step 3: The parameter descriptions for adding a backup set are as follows:
| Parameter Name | Parameter Description | Setting Principle |
|---|---|---|
| Instance | Single selection, required; the current MySQL instance can be selected | Not selected by default |
| Backup Set Name | Text input box, required | No more than 50 characters; special symbols are not supported |
| Instance Name | Text input box, required | No length or special-character restrictions are currently enforced |
| Discovery | Non-parameter | The database is rescanned by default |
| Database | Multiple selection, required | A database included in another backup set cannot be selected |
| Data Stream Count | Numeric type | The value cannot exceed 200; a value below 10 is recommended |
| Configuration Method | Single selection, required | Basic Configuration or Advanced Configuration |
| Service Plan | Single selection, required | Select an appropriate plan |
Step 4: Click [Confirm]. The frontend displays a message indicating that the addition was successful.
1.3 MySQL Database Backup
Prerequisites
- A MySQL backup set has been configured.
Steps
Step 1: Click [Backup Service] - [Database], select the server name, and then select [Backup Set] in the list.
Step 2: Click [Backup].
Step 3: Select Full, click [Confirm], and wait for the message Backup job submitted successfully.
Step 4: After the backup job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the backup set job.
Step 5: After the backup is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the backup set job. The job status is Completed.
1.4 MySQL Log Backup
Prerequisites
- A MySQL instance has been added and a log backup set has been created.
Steps
Step 1: Click [Backup Service] - [Database], select the server name, and then select [Backup Set] in the list.
Step 2: Click [Backup].
Step 3: Select Log, click [Confirm], and wait for the message Backup job submitted successfully.
Step 4: After the backup job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the backup set job.
Step 5: After the backup is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the backup set job. The job status is Completed, indicating that the backup is complete.
1.5 MySQL Instance Backup
Prerequisites
- A MySQL instance has been added and a log backup set has been created.
Steps
Step 1: Click [Backup Service] - [Database], select the server name, and then select [Backup Set] in the list.
Step 2: Click [Backup].
Step 3: Select Full or Incremental, click [Confirm], and wait for the message Backup job submitted successfully. (For the first backup, Incremental is automatically converted to Full.)
Step 4: After the backup job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the backup set job.
Step 5: After the backup is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the backup set job. The job status is Completed, indicating that the backup is complete.
1.6 MySQL Database Recovery
Prerequisites
- The MySQL database has been backed up.
Steps
Step 1: Click [Backup Service] - [Database] in the system menu.
Step 2: In the [Database] list under the server name, select [Instance] - [Actions] - [Restore].
Step 3: In the restore window, select Database as the recovery type, and click [Next].
Step 4: Select a recovery point. You can query recovery points by Recent Time (a recovery point within the last cycle) or by a time range. Select the job ID of the recovery point.
Step 5: Select Original Machine Recovery as the recovery method, select the target host and target instance, specify the staging directory, and click [Confirm].
Step 6: After the job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the job.
Step 7: After the job is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the job and its status.
1.7 MySQL Database Recovery (from an Instance)
Prerequisites
- The MySQL database has been backed up.
Steps
Step 1: Click [Backup Service] - [Database] in the system menu.
Step 2: In the [Database] list under the server name, select [Instance] - [Actions] - [Restore].
Step 3: In the restore window, select Database (from Full Instance Recovery) as the recovery type, and click [Next].
Step 4: Select a recovery point. You can query recovery points by Recent Time (a recovery point within the last cycle) or by a time range. Select the job ID of the recovery point.
Step 5: Select Original Machine Recovery as the recovery method, select the target host and target instance, specify the staging directory, and click [Confirm].
Step 6: After the job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the job.
Step 7: After the job is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the job and its status.
1.8 MySQL Instance Recovery
Prerequisites
- The MySQL database has been backed up.
Steps
Step 1: Click [Backup Service] - [Database] in the system menu.
Step 2: In the [Database] list under the server name, select [Instance] - [Actions] - [Restore].
Step 3: In the restore window, select Database (from Full Instance Recovery) as the recovery type, and click [Next].
Step 4: Select a recovery point. You can query recovery points by Recent Time (a recovery point within the last cycle) or by a time range. Select the job ID of the recovery point.
Step 5: Select Original Machine Recovery as the recovery method, select the target host and target instance, specify the staging directory, and click [Confirm].
Step 6: After the job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the job.
Step 7: After the job is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the job and its status.
1.9 Restore MySQL to Disk
Prerequisites
- The MySQL backup set has been backed up.
Steps
Step 1: Click [Backup Service] - [Database] in the system menu.
Step 2: In the [Database] list under the server name, select [Instance] - [Actions] - [Restore].
Step 3: In the restore window, select database recovery or full instance recovery, and click [Next].
Step 4: Select the data source. For database recovery, select the appropriate database and backup time. For instance backup, select the corresponding backup job.
Step 5: Select Restore to Disk in the recovery options, enter the required information, and click [Confirm].
Step 6: After the job starts successfully, go to [Monitoring Center] - [Jobs] - [Active Jobs] to view the job.
Step 7: After the job is completed, go to [Monitoring Center] - [Jobs] - [Job History] to view the job and its status. The job status must be Completed for the restore to be successful.