The Dell EMC XtremIO X2 all-flash array is an ideal storage platform for running online transaction processing (OLTP), online analytical processing (OLAP), or mixed workloads. It delivers high IOPS, ultrawide bandwidth, and consistent submillisecond latency for databases of all sizes.
We chose the XtremIO X2 storage array for our use cases to highlight its innovative management capability in Kubernetes/Docker environments. The use cases show how DBAs and system administrators can use the XtremIO/Kubernetes CSI 1.0 plug-in to deploy a SQL Server 2019 Linux container with persistent storage hosted by the XtremIO X2 array.
In Use Case 2, we show the use of XtremIO Virtual Copies. For provisioning, the developer uses a protected copy, or “gold master,” of the AdventureWorks database, which is maintained on the XtremIO X2 array. XtremIO Virtual Copies makes provisioning copies of gold master databases easy. In our use case, we use Kubernetes to create a copy of our AdventureWorks database through the XtremIO Virtual Copies capability. This approach enables easy provisioning of multiple consistent copies of the database. After destructive testing, the developer restores the database from XtremIO Virtual Copies.