Copy data management (CDM) is an approach to reducing storage consumption that involves eliminating the unnecessary duplication of production data.
For example, there is typically a production DB with development, testing and staging copies. Often, the dev/test/staging copies are created by restoring a backup of the production DB.
This approach has several challenges:
- Each dev/test/staging copy takes up additional space on the storage system, even though data is 99% the same.
- It can take several hours to restore large databases from backup
- Sometimes, the database team has to log tickets with the backup team to trigger the restores
- Data masking (if required) is performed manually
- Additional work sometimes required to provision the DB copy to the appropriate host and then spin up the DB
The aim of Spectrum Copy Data Management is to solve these challenges without requiring additional hardware.
Spectrum Copy Data Management works with the storage to create application aware, incremental snapshots of the DB, connect them to the relevant host (physical or virtual) and then spin up the DB.
This approach provides several key benefits:
Benefit 1 - Save Storage Capacity
By leveraging incremental snapshots instead you can drastically reduce the amount of storage required. For example, a 1TB production DB with dev/test/staging copies requires ~4TB of storage. Using incremental snapshots via Spectrum Copy Data Management reduces this to ~1.1TB of required storage.
It's all good to have incremental snapshots BUT how to you make them available to your DB admins? You can very well give DBA's access to the SAN.
With Spectrum Copy Data Management the DBA's get access to a self service portal. This let's them restore only the DB's that they are allowed to access. They can also run data masking scripts and choose which host to restore the DB to. (Provided they have permissions of course)
Because the data is held in a incremental snapshot it can be provisioned to the hosts very quickly. I.e. In a matter of seconds or minutes.
Human beings seem born with an innate ability to create exorbitant amounts of data a never clean it up.
With Spectrum Copy Data Management, you chose the retention period once and the software automatically cleans up the old copies.
- DB1 take hourly snapshots and keep them for a week.
- DB2 take daily snapshots and keep them for a month.
- DB2 take 4 hourly snapshots, keep them for 2 weeks. Replicate them to secondary site and keep these copies for 1 month.
Spectrum Copy Data Management is a OVF virtual appliance for VMware.
Once deployed you give it access to vCenter, your DB's and your storage. This allows it to manage the automations and workflows detailed above.
You can download a trial version of the software here.
Be the first to ask as question. Post your question in the comments and I will update the FAQ.