Solution Architecture, Unix, Linux and Databases

Introduction   In this bog I will demonstrate how we can migrate an existing SQL Server database running on either a Bare Metal or Virtualised environment to a container platform running on Pure Storage and the Pure Storage Plugin. Overview of Environment Source environment Virtual machine on ESX 7 Windows 2016 SQL Server 2016 SSMS 18.4 Database - Demo  Target Environment Docker 19.03 Oracle Linux 7.6 Pure Storage Plugin 3.10 Step 1 - Backup Source DB I am using SSMS UI to backup the database for this example, you can just as easily backup the database using T-SQL. Lets Select some data in the table before we backup, so we can compare it to after we migrate to the container Backup up the Database Step 2 - Copy DB backup      Once we have completed the database backup we need to copy it over the docker host, I'm not covering the copy process in this blog, however if you have any questions please feel free to contact me at cbannayan@purestorage.com Step 3 - Create a new SQL Server Co

  In this blog I will show you how can we can install Portainer ( A  platform-agnostic tool for managing containerized applications ) to manage Oracle database containers and persistent volumes running Pure Storage FlashArray   Install Portainer Portainer runs as container, so installing it is just like installing any other container on Docker. Note: Docker and the Oracle container image is already installed - if you want more detail on that check out - http://bannaych.blogspot.com/2021/02/oracle-19c-database-clones-using-pure.html Lets create a persistent volume to run Portainer on, using the Pure Docker plugin # docker volume create port_vol port_vol Lets create the Portainer container # docker run -d -p 8000:8000 -p 9000:9000 --name=portainer --restart=always \ -v /var/run/docker.sock:/var/run/docker.sock -v port_vol:/data \ portainer/portainer-ce Lets confirm the new Portainer container is running # docker ps CONTAINER ID IMAGE