public:module:mariadb_database:create_backup_set
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
public:module:mariadb_database:create_backup_set [2021/02/02 13:45] ronnie.chan |
public:module:mariadb_database:create_backup_set [2021/02/02 13:54] ronnie.chan |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| 1. Click the Backup Sets icon. | 1. Click the Backup Sets icon. | ||
| - | {{public:module:mariadb_database:image036.png}} | + | |
| + | | {{public:module:mariadb_database:image036.png}} | | ||
| 2. Create a new backup set by clicking the **Add** button to created new backup set. | 2. Create a new backup set by clicking the **Add** button to created new backup set. | ||
| - | {{public:module:mariadb_database:image038.png?800}} | + | |
| + | | {{public:module:mariadb_database:image038.png?800}} | | ||
| 3. Select the **Backup set type** and name your new backup set and enter the login information for the MariaDB server then click **Next** to proceed. | 3. Select the **Backup set type** and name your new backup set and enter the login information for the MariaDB server then click **Next** to proceed. | ||
| - | {{public:module:mariadb_database:image038.png?800}} | + | |
| + | | {{public:module:mariadb_database:image040.png?800}} | | ||
| - | 4. In the Backup Source menu, select the MariaDB databases you would like to backup. Click Next to proceed. | + | 4. In the Backup Source menu, select the MariaDB databases you would like to backup. Click **Next** to proceed. |
| - | {{public:module:mariadb_database:image040.png?800}} | + | |
| - | NOTE | + | | {{public:module:mariadb_database:image042.png?800}} | |
| - | The ‘information_schema’ and ‘performance_schema’ databases are MariaDB virtual system databases, which contains information about the user databases on the MariaDB instance, are automatically excluded from the backup source. They are read-only and cannot be backed up, therefore they are grayed out and cannot be selected. . | + | |
| - | 5. In the Schedule menu, you can configure a backup schedule for backup job to run automatically at your specified time interval. | + | |
| - | Click Add to add a new schedule or double click on the existing schedule to change the values. Click Next to proceed when you are done setting. | + | <WRAP info> |
| + | The "information_schema" and "performance_schema" databases are MariaDB virtual system databases, which contains information about the user databases on the MariaDB instance, are automatically excluded from the backup source. They are read-only and cannot be backed up, therefore they are grayed out and cannot be selected. | ||
| + | </WRAP> | ||
| + | |||
| + | 5. In the Schedule menu, you can configure a backup schedule for backup job to run automatically at your specified time interval. | ||
| + | |||
| + | | {{public:module:mariadb_database:image044.png?800}} | | ||
| + | |||
| + | Click **Add** to add a new schedule or double click on the existing schedule to change the values. Click Next to proceed when you are done setting. | ||
| + | |||
| + | | {{public:module:mariadb_database:image046.png?800}} | | ||
| - | NOTE | + | <WRAP info> |
| The default backup schedule is daily backup at 3:00 with the backup job will run until completion and the retention policy job will be run immediately after the backup job. | The default backup schedule is daily backup at 3:00 with the backup job will run until completion and the retention policy job will be run immediately after the backup job. | ||
| + | </WRAP> | ||
| - | 6. Select a backup mode and click the “+” sign icon to select a backup storage destination. | + | 6. Select a backup mode and click the "**+**" sign icon to select a backup storage destination. |
| - | 7. Select the backup storage destination. Click on OK to proceed. | + | | {{public:module:mariadb_database:image048.png?800}} | |
| - | Example: AhsayCBS server | + | |
| - | 8. In the Encryption window, the default Encrypt Backup Data option is enabled with an encryption key preset by the system which provides the most secure protection. | + | 7. Select the backup storage destination. Click on **OK** to proceed. |
| - | You can choose from one of the following three Encryption Type options: | + | |
| - | Default – an encryption key with 44 alpha numeric characters will be randomly generated by the system. | + | | {{public:module:mariadb_database:image050.png?800}} | |
| - | User password – the encryption key will be the same as the login password of your AhsayOBM at the time when this backup set is created. Please be reminded that if you change the AhsayOBM login password later, the encryption keys of the backup sets previously created with this encryption type will remain unchanged. | + | |
| - | Custom – you can customize your encryption key, where you can set your own algorithm, encryption key, method, and key length. | + | 8. In the Encryption window, the default **Encrypt Backup Data** option is enabled with an encryption key preset by the system which provides the most secure protection. |
| - | + | ||
| - | NOTE | + | | {{public:module:mariadb_database:image052.png?800}} | |
| - | For best practice on managing your encryption key, refer to the following wiki article. https://wiki.ahsay.com/doku.php?id=public:8015_faq:best_practices_for_managing_encryption_key | + | |
| + | You can choose from one of the following 2 Encryption Type options: | ||
| + | |||
| + | * **Default** – an encryption key with 44 alpha numeric characters will be randomly generated by the system. | ||
| + | * **Custom** – you can customize your encryption key, where you can set your own algorithm, encryption key, method, and key length. | ||
| + | <WRAP indent> | ||
| + | | {{public:module:mariadb_database:image054.png?800}} | | ||
| + | </WRAP> | ||
| + | |||
| + | Click **Next** when you are done setting. | ||
| - | Click Next when you are done setting. | ||
| 9. If you have enabled the Encryption Key feature in the previous step, the following pop-up window shows, no matter which encryption type you have selected. | 9. If you have enabled the Encryption Key feature in the previous step, the following pop-up window shows, no matter which encryption type you have selected. | ||
public/module/mariadb_database/create_backup_set.txt · Last modified: 2021/02/02 14:27 by ronnie.chan
Page Tools
