Database Cloning for IT Directors
In the next two minutes, I will share some information that will help you help your organization grow revenue by releasing new application features faster, with better quality, at lower cost.
UAT, DEV, and QA teams demand clones of production databases so that they can test the software against real data instead of some dummy data. But the challenge is.. You just can’t treat clones of a multi-terabyte database fast enough.
Imagine 10 clones of a 15 terabyte database. It’ll take many hours and that also needs a ton of storage. And you just can’t spare 150 terabytes of storage for database clones.
Yes, you might consider using storage snapshots, but that comes with a couple of challenges. First challenge is production and test/dev clones work off the same production storage, which might quickly become a bottleneck.
The second challenge is that it’s too hard to manage scripts, to achieve database consistent snapshots using storage snapshots for a wide variety of databases.
Fortunately, there are solutions out there that can help you. Let’s look at some of the critical capabilities that you should consider. An ideal solution should allow DEV and QA testers to provision dozens of clones of multi terabyte databases in just minutes.
You don’t have to spend a dime on extra storage because these clones are not physical clones. They are virtual database clones that don’t take any extra physical storage. That’s creating 10 clones of a 15 terabyte database should just need 15 terabytes instead of 150 terabytes. That’s massive storage savings.
You should be able to set up role based access controls to control access to these database clones and also automate sensitive data masking using existing BBS scripts or any masking tool. An ideal solution to support a wide variety of databases such as Microsoft SQL Server, Oracle, SAP HANA, MySQL, PostGreSQL, DB2, and other Enterprise Databases, both on premises, as well as in a public cloud.
Also, as an option on certain storage areas like pure storage, where the penalty of storage snapshots is very, very minimal. It should allow provisioning of database consistent virtual database clones using storage snapshots.
If the same solution can also help you with backup and disaster recovery, with instant recovery at no extra license cost in a private or public cloud, even better.
The bottom line is this. You can help your CIO in the organization delivery more features more quickly with higher quality and reduce costs and burden with a modern database cloning tool. Actifio has all these capabilities and many more. On an average, our customers have reduced their average cloning time from 11 days to just 18 minutes. And in many situations, Actifio has introduced more than 70% savings with database cloning as compared to our competitors.
Learn more details about how Actifio works and how it can introduce so much cost savings for you.