The Doppler Quarterly Spring 2017 | Page 19

Figure 2: Common Design Patterns Involving Oracle • Database Replication – The cloud provides a variety of new methods for ensuring data integrity and service availability that differ architecturally from on-premises methods of protection. Cloud migrations will require organizations to look at the methods used for data protection and mod- ify both process and tools to ensure the proper level of availability in the cloud-deployed application. • Performance Optimization Tools – Many organizations rely on third party tools to provide visibility into database performance and enable DBAs to tune queries for optimal performance. When moving to alterna- tive databases, these tools should be validated against the new targets or replaced to ensure DBA visibility is not impacted on new platforms. • Legacy Versions – Many enterprises still run older versions of Oracle to support specific needs, these will often require upgrades prior to migra- tion to alternative platforms to ensure data can be properly exported or replicated to facilitate loading the new environment. Identify Cloud Platform & Database Next, you must decide on your target cloud platform and associated database. While many common databases like EnterpriseDB, SQL Server, MySQL and oth- ers will run on all public cloud vendors, each public cloud vendor has built their own specific capabilities that can lower operations costs and the time necessary fo