Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
SQL Server 2019 Containers on Linux
Executive summary Use case overview Supporting software technology Dell EMC servers and storage Use Case 1: Manual provisioning of a containerized dev/test environment Use Case 2: Automated provisioning of a containerized dev/test environment
Introduction
Step 1: Install Kubernetes
Step 2: Install the XtremIO X2 CSI plug-in
Step 3: Provision SQL Server and REST API containers
Step 4: Provision a database copy
Step 5: Modify database data and protect the database state
Step 6: Run a destructive test and recover the modified database
Step 7: Technical writer provisions modified SQL database
Step 8: Clean up the environment
Use Case 2 review
CSI plug-ins: Additional options from Dell Technologies
Conclusion Appendix A: Solution architecture and component specifications Appendix B: Container resource configuration

Introduction

Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Containers on Linux > Introduction

Introduction

  • In the preceding use case, we showed the manual provisioning of a container with persistent storage from the XtremIO X2 array. The next step in our journey is automating the provisioning of containers and storage, further accelerating the provisioning of the software development environment. Container orchestration becomes essential when hundreds or thousands of containers must be managed. In this use case, a developer provisions a SQL Server container along with database storage by using Kubernetes with the CSI plug-in as a platform as a service (PaaS).

    In Use Case 2:

    1. The Kubernetes administrator performs a custom installation of Kubernetes.
    1. The storage administrator works with the Kubernetes administrator to install the XtremIO X2 CSI plug-in.
    2. The developer provisions a SQL Server and REST API container, using Kubernetes.
    3. The developer creates a copy of the AdventureWorks database, using the CSI plug-in.
    4. The developer modifies the database data and protects the database state, using XtremIO Virtual Copies.
    5. The tester performs destructive testing.
    6. The developer recovers the modified SQL Server database.
    7. The technical writer provisions the modified SQL database.
    8. The developer removes the containers and cleans up the environments.