While database backup and recovery steps are highly dependent on the DBMS installed, the general process is as follows:
sysadmin@DD6300# ddboost show stats interval 2
sysadmin@DD6300# filesys show compression
The DD6300 affords simple, efficient, and quick database recovery if database failure or corruption occurs. Although recovery procedures vary, depending on the DBMS deployed, the general process is as follows:
The DD Boost agent provides additional details about database recovery and includes template scripts that can be modified to your specific configuration. Consult your DBMS documentation for vendor-specific recovery details.
The Data Domain system provides command-line tools to monitor backup and restore performance elements such as backup/restore throughput, network throughput, and deduplication and compression ratios. The following examples demonstrate how to use these performance tools to monitor the database backup and restore operations.
To monitor the backup throughput, log in to the Data Domain system and run the following command during the backup operation:
$ddboost show stats interval 2
This command shows the DD Boost backup real-time performance statistics that are based on a specified interval (in this example, every 2 seconds.)
The following results show the statistics for a backup operation:
Table 37. Backup and network throughputs for a full backup
Backup KB/s |
Post-comp Written KB/s |
Network in KB/s |
Restore in KB/s |
Network out KB/s |
Backup conn |
Restore conn |
545,611 |
336,549 |
336,613 |
3 |
3 |
4 |
0 |
The first three columns describe:
When you restore a database, run the following command to monitor the restore throughput:
$ddboost show stats interval 2
The following results show the statistics for a restore operation:
Table 38. Restore and network throughputs
Backup KB/s |
Post-comp Written KB/s |
Network in KB |
Restore in KB/s |
Network out KB/s |
Backup conn |
Restore conn |
0 |
0 |
0 |
1,017,593 |
1,017,593 |
0 |
4 |
For the restore operation, the output of the command shows the restore throughput, Network out KB/s (network throughput from the Data Domain system), and the Restore conn (the number of connections of the restore threads).
To monitor the Data Domain and DD Boost data compression ratios, run the following command on the DD Boost system after the backup is completed:
$filesys show compression
For a full backup, this command provides output that is similar to the following example:
Pre-Comp is the data that is scanned by the DBMS and DD Boost software on the database server, while Post-Comp is the amount of the data being backed up and stored in the Data Domain system. The total compression ratio (Total-Comp factor) is:
Pre-Comp/ Post-Comp = 1069.6/753.7 = 1.4x
The reduction percentage is:
(Pre-Comp- Post-Comp)/ Pre-Comp *100 = (1069.6-753.7)/ 1069.6*100= 29.5%
Two other important compression ratios are: