This Ready Solution for Oracle on XtremIO X2 storage provides simple, easy-to-use management through an interface that allows storage administrators to provision storage with little setup or planning. Also, it provides predictable and consistent low-latency performance with sub-0.85 millisecond response times regardless of the workload and environment that can include production, QA, test, or development in typical enterprise applications. Multiple copies might be required for test/development, reporting, or online analytics.
DBAs and test/dev engineers often spend hours managing database creation and refreshing the environments while often being limited by capacity, performance, and number of copies. XtremIO's Integrated Copy Data Management (iCDM) enables you to create XtremIO Virtual Copies (XVCs) from production instantly with no performance impact. These copies can be repurposed for near-real-time analytics, test/dev, or any other use case—all with complete space efficiency.
Protecting the database is easy with XtremIO. There is no need to consider the complexities of RAID type, data file capacity, or load balancing. The data is protected with the XtremIO Data Protection (XDP) proprietary flash-optimized algorithm. XDP is different from RAID in several ways. Because XDP is always working in an all-flash storage array, several criteria were important in the design of this protection scheme. XDP benefits include ultra-low capacity overhead, high levels of data protection in case of double SSD failure, rapid rebuild times, flash endurance, and extreme performance.
In this Ready Solution for Oracle, we use Data Domain to back up and recover an Oracle database. Data Domain benefits are the same as XDP benefits. XtremIO virtual copies provide easy protection and recovery from any operational and logical corruption. XVCs enable the creation of frequent point-in-time copies (according to RPO intervals – seconds, minutes, hours) and use them to recover from any data corruption. An XVC can be kept in the system for as long as it is needed. Recovery using an XtremIO virtual copy is instantaneous and does not impact system performance.
To demonstrate the benefits of this solution, Dell EMC has designed a series of performance tests using OLTP and OLAP databases. OLTP database usage is characterized by small requests for information, such as looking up an inventory item or checking a customer account, and supporting mission-critical back-office applications. ERP and CRM systems can support thousands of users who generate millions of database transactions and require fast response times. In this case, response time is the total amount for the database to respond to a request. For our OLTP tests, we used an aggressive response time goal of under 0.85 milliseconds to measure success.