How to calculate space needed in preparation for backing up Spectrum's MySQL

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

How can we effectively determine the size of DDMDB and Reporting to estimate recommended free space?

Environment

All supported releases

Resolution

You can see the size of your current databases by going to the $SPECROOT/mysql/data folder and running this command:

du -sh reporting ddmdb

For example:

[spectrum@team-ocss ~]$ cd /usr/Spectrum/mysql/data
[spectrum@team-ocss data]$ du -sh reporting ddmdb
3.3G    reporting
2.7G    ddmdb

Once you have this value, double it; that will be what you will need for space for the backup.  In my example, I would need ~12GB combined, 6.6GB for reporting, and 5.4GB for ddmdb.