Updated at: 2022-12-09 03:49:50
If your recovery network channel resources are insufficient, you can configure the following options when creating backup jobs:
§ Set flow control to limit backup speed
For how to enable flow control, see Step 4 Select Backup Media and Configure Backup Options. You can obtain the transfer ratio of a backup job by checking the job execution information in the History tab, see History for details.
For how to create a backup policy template, see Backup Policy for details.
§ Enable data deduplication
Before enabling data deduplication, you must create deduplication volume, fingerprint pool and fingerprint library first, see Best Practices for Data Deduplication for details. For how to enable data deduplication, see Step 4 Select Backup Media and Configure Backup Options. You can obtain the deduplication ratio of a backup job by checking the job execution information in the History tab, see History for details. Generally, the more the data repetition, the higher the deduplication ratio. The initial deduplication ratio for GaussDB A database can achieve about 90%, while the ratio for GaussDB T database ranges from 1% to 40%, which is relatively low.
For how to enable data compression for a backup job, see Step 4 Select Backup Media and Configure Backup Options. After the option is enabled, you can choose quick or deep compression. The performance of a backup job with deep compression enabled is slightly worse than that with quick compression enabled. For how to choose appropriate compression type, see Data Compression. You can obtain the actual backup data size by checking the execution information in the History tab, see History for details.
As the compression for GuassDB database is source compression, the data transferred is the data after compression. Generally, the compression ratio of deep compression is between 1/6 and 1/13, and that of quick compression is between 1/2 and 1/9.
§ Set flow control to limit backup speed
For how to enable flow control, see Step 4 Select Backup Media and Configure Backup Options. You can obtain the transfer ratio of a backup job by checking the job execution information in the History tab, see History for details.
F Note: For GAUSSDB T recovery jobs, the speed for flow control must not be lower than 6 MiB/s; otherwise, the recovery may fail.
§ Set appropriate recovery strategy, to avoid business peak hours.For how to create a backup policy template, see Backup Policy for details.
§ Enable data deduplication
Before enabling data deduplication, you must create deduplication volume, fingerprint pool and fingerprint library first, see Best Practices for Data Deduplication for details. For how to enable data deduplication, see Step 4 Select Backup Media and Configure Backup Options. You can obtain the deduplication ratio of a backup job by checking the job execution information in the History tab, see History for details. Generally, the more the data repetition, the higher the deduplication ratio. The initial deduplication ratio for GaussDB A database can achieve about 90%, while the ratio for GaussDB T database ranges from 1% to 40%, which is relatively low.
F Note:
A. Deduplication ratio: (completed backup data size - actual restored data size) / completed backup data size.
B. The ratio values are only for your reference as the deduplication ratio is closely related to the data size and data content. In extreme cases, the ratio can be close to 100% or 0.
§ Enable data compressionA. Deduplication ratio: (completed backup data size - actual restored data size) / completed backup data size.
B. The ratio values are only for your reference as the deduplication ratio is closely related to the data size and data content. In extreme cases, the ratio can be close to 100% or 0.
For how to enable data compression for a backup job, see Step 4 Select Backup Media and Configure Backup Options. After the option is enabled, you can choose quick or deep compression. The performance of a backup job with deep compression enabled is slightly worse than that with quick compression enabled. For how to choose appropriate compression type, see Data Compression. You can obtain the actual backup data size by checking the execution information in the History tab, see History for details.
As the compression for GuassDB database is source compression, the data transferred is the data after compression. Generally, the compression ratio of deep compression is between 1/6 and 1/13, and that of quick compression is between 1/2 and 1/9.
< Previous:
Next: >