It is very interesting how database landscape and infraestructure associated to them can turn into chaos.
Every year/quarter senior management estimates the ammount of HW resources needed for functional requirements. Businesses now are dynamic and fast paced, requirements arrive on a daily basis and can easily overwhelmed planned capacity due to new projects.
Nowadays all is about data, and data is consumed everywhere. So this new requierements I mention about, quicly can turn into proyects (one or more sprints) so they need new data enviroments for developement or testing. This start to generate a very big gap between the amount of HW resources (storage mainly) assign to production in comparison with non production envs. Most of this enviroments once created you cannot get them back, now are part of your landscape. Wasting X times of storage in non prod envs than in prod and may be its a high speed disk and really expensive. Typically, any productive environment has 3 o 4 environments for testing, development or pre production and some other consequent multi purpose environment for different projects. New methodologies and technologies push development to a really agile and dynamic path to create a new environment from scratch. On the other corner, databases are huge and creating a new environment it’s really a challenge process that can takes hours or days. After provisioning the database from a backup or tape we have to thought about masking, may be there are several scripts to mask customers data that take hours or days to finish (when it does correctly). At the end we have a database provisioned, from scratch in several days ( best scenario in several hours). Meanwhile, we have developers, testers and other data consumers waiting (productivity lost). This is the best scenario, but lets imagine we cannot allocate resources for this env and we have to wait for another HW purchase, this process can take months.
I had this challenge on my way, thats when I have started thinking about data/database virtualization and how to generate some sort of virtual copy from a physical one (similar concept as servers virtualization). After a while, I arrived to Delphix.
What is Delphix?
Delphix Dynamic Data Platform is an integrated platform that virtualizes, protects and manages data from private facilities, in the cloud and in hybrid IT environments. Provides self-service access to data users through virtualized and personal data environments.
The three pillars of Delphix Dynamic Data Platform are:
• Application and Data Acceleration: Rapid provisioning of virtualized databases, recording every change for easier rebuilding at any point in time.
• Privacy and data security: companies can avoid the unintentional disclosure of confidential data through its masking, access control and audits.
• Cloud adoption: move data to the cloud in large quantities at once, replicating it for secure provisioning of cloud environments.
What benefits I get with Delphix?
- Up to 95% Time savings in making data environments available (create, restore, etc.).
- Efficiency of operational teams.
- Coordination between teams for refreshing environments is eliminated.
- Up to 90% Storage Savings (Non-Productive Environments).
- Up to 20 virtual copies to reach the size of 1 physical copy.
- Up to 50% Reduction of times in the software life cycle.
- Self Service data to manage them.
- Possibility of provisioning cloud environments securely with masked data.
- Replication between on-premise and cloud of virtual databases masked on-premise.
- Compliance with current data security regulations.
- Through the masking of the data, compliance with the current personal data protection laws is achieved. (GDPR / SOX / PCI / HIPAA)
What are Delphix best use cases and value scenarios?
- Development and Testing enviroments.
- Shorten project/release cycles by 50%
- Reduce non-production storage by 90%
- Eliminate sensitive data risk
- Test with current, high-quality production data
- Cloud & Datacenter Migrations
- Migrate 50% faster
- Significantly reduce storage and bandwidth requirements
- Eliminate data risk in non-production with masking
- Non-disruptively extract data from production
- Governance, Security, and Compliance
- Mask confidential data
- Provide continuous compliance reporting
- Govern and audit data changes
- Manage data delivery, retention, purging from single point of control
- Analytics, Modeling, & Reporting
- Dramatically accelerate time to useful data
- Offload reports, extracts from production
- Eliminate batch windows, extract at any time
- Deliver as many data copies as needed
- Data Protection / Recovery
- Eliminate backup failures
- Provide continuous data protection: improved RPO, RTP
- Repair data in live environments
- Ensure DR across data centers, clouds
Some videos from youtube channel:
1
2
3
4
5
6
7
8
9
10
11
5 minutes in the life of a Delphix DBA
https://www.youtube.com/watch?v=ABxuNKerE4w
Delphix Introduction
https://www.youtube.com/watch?v=rtCZhUxEDxI
Product Demonstration
https://www.youtube.com/watch?v=2B5jcZeNZko&t=3s
Delphix Data Security and Masking
https://www.youtube.com/watch?v=CrJMMhLLIMw
Hope you Enjoy it.
Data journey continues.