The SQL Server Dba’s Guide to Docker Containers: Agile Deployment Without Infrastructure Lock-in

Description

Get introduced to the world of Docker containers from a SQL Server DBA's perspective. This book explains container technology and how it can improve the deployment of your SQL Server databases without infrastructure lock-in. You will be equipped with the right technical skills to guide stakeholders in your business as they adopt and adapt to new technologies to improve time-to-market and competitiveness. You will learn how to build a lab environment at home on which to build skills that transfer directly into your day job. This book teaches you how to install and configure Docker on both Windows Server and Linux operating systems. You will learn the most common Docker commands that you need to know as a DBA to deploy and manage SQL Server on containers. Support for SQL Server on Linux is new, and this book has your back with guidance on creating Docker images specifically for deployment to a Linux platform. Included is coverage of key Linux commands needed to manage SQL Server on that operating system. By the end of the book you will have learned how to create your own custom SQL Server container images with configuration settings that are specific to your organization, that are capable of being deployed to both Windows Server and Linux. What You Will LearnCreate Docker containers for agile deployment of SQL ServerRun multiple SQL Server instances on a single Linux machineDeploy custom images specific to your organization's needsKnow the benefits and architecture of container technologyInstall and configure Docker on Windows Server and Linux Manage and persist SQL Server data in Docker containers Who This Book Is For Intermediate to senior SQL Server DBAs who are familiar with SQL Server on Windows and want to build their existing skills to deploy and manage SQL Server on Linux and through Docker containers. Readers should have a grasp of relational database concepts and be comfortable with the Transact-SQL language. Table of Contents About the Author About the Technical Reviewer Acknowledgments Introduction Chapter 1: Introduction to Containers The Latest 30-Year-Old Technology Docker – The Company and the Container Runtime The Case for Containers Containers vs. Virtualization Microsoft, Containers, and SQL Server on Linux Summary Chapter 2: Install and Configure Docker on Windows Server Minimum System Requirements Enable Containers Feature in Windows Server 2016 Download and Install the Docker-Microsoft PackageManagement Provider Download and Install the Docker Package Verifying the Docker Engine Installation Docker Desktop for Windows Summary Chapter 3: Install and Configure Docker on Linux Minimum System Requirements Basic Linux Commands You Need to Get Started Installing Docker on CentOS Linux Update the CentOS System Packages Install the Required Dependencies Add the Docker Stable Repository to Your System Install Docker CE Starting the Docker Daemon and Enabling on Startup Installing Docker on Ubuntu Linux Update the Ubuntu System Packages Install the Required Dependencies for Connecting to a Repository over HTTPS Add the Official GPG Key from Docker Add the Docker Stable Repository to Your System Install Docker CE Verifying the Docker Engine Installation Getting Rid of sudo? Summary Chapter 4: The Docker Ecosystem Hello World: Docker Edition How Docker Runs Containers The Docker Ecosystem Docker CLI Docker Daemon Docker Commands Docker Images and Containers Docker Hub Exploring Docker Hub Docker Image Naming Conventions Running SQL Server on Windows Containers Running SQL Server on Linux Containers Beginning to Explore Containers and Images Things to Consider Connecting to the SQL Server Instance Remotely Lifecycle of a Container Summary Chapter 5: Docker Images and Containers A Quick Review (And Then Some…) Behind the Scenes of Pulling Images Fat Manifest? Image Manifest Content Digest Distribution Hash Your Docker Host’s Local Filesystem Union Filesystem Files, Directory Names, and Symbolic Links Stitching Layers: Assembling the Image How a Union FileSystem Works Traversing the Layers The Container Layer Summary Chapter 6: Managing and Administering Containers Configuring the Docker Daemon Working with dockerd Working with daemon.json Changing the Default Image and Container Directory Stopping and Restarting the Docker Daemon Configure the Docker Daemon for Remote Access on CentOS Linux Configure Remote Access to the Docker Daemon with the systemd Unit File Protect the Docker Daemon Socket by Configuring Mutual TLS Encryption Update the daemon.json to Include the Settings for Mutual TLS Encryption Enable Firewall Port to Allow Traffic to Docker Daemon Testing Remote Client Connectivity Cleanup Configure Docker CLI Bash Completion Starting and Stopping Containers Deleting Containers and Images Interacting with Running Containers Sharing Files Between Host and Container Configuring Container Resources Exploring the Container Logs Reviewing the Status of the Docker Daemon Summary Chapter 7: Persisting Data Stateful vs. Stateless Applications Containers Are Ephemeral and Immutable How Cloud Providers Implement Infrastructure- as-a-Service Docker Volumes Attach Volumes to Containers To -v or to --mount Sharing Volumes Between Containers? Leveraging Volumes with SQL Server on Containers Smart SQL Server In-Place Upgrade Summary Chapter 8: Working with SQL Server on Linux SQL Server on Linux Architecture Project Drawbridge SQLOS and SQLPAL Difference Between SQL Server on Windows vs. Linux Installing SQL Server on Linux Manual Installation Unattended Installation Configuring the Firewall A Note on the Linux Firewalls and Docker Configuring SQL Server on Linux Enabling the SQL Server Agent Configuring Default Database Data and Log Directory Configuring Default Database Backup Directory Enabling Trace Flags Viewing All Instance-Level Configuration Settings Working with the Filesystem Important Directories in the Linux Filesystem File Permissions Assigning Permissions to Files and Directories Writing a Simple Linux Bash Script Running the Script Passing Parameters to the Script Adding Conditional Logic in Bash Scripts Summary Chapter 9: Creating Custom SQL Server on Windows Container Images Creating Custom Docker Images Exploring the Dockerfile The File The FROM Instruction The LABEL Instruction The RUN Instruction The COPY Instruction The ADD Instruction The SHELL Instruction The CMD Instruction The ENTRYPOINT Instruction CMD vs. RUN vs. SHELL vs. ENTRYPOINT The WORKDIR Instruction The ENV Instruction Using Escape Characters Putting the Pieces Together with a Dockerfile Build the Custom SQL Server on Windows Image Optimizing the Dockerfile Summary Chapter 10: Creating Custom SQL Server on Linux Container Images Additional Dockerfile Instructions The EXPOSE Instruction The VOLUME Instruction The USER Instruction Build the Custom SQL Server on Linux Image Installing a Specific SQL Server Version Creating a Custom Image That Runs As Non-root Running a Container As Non-root Non-root User and Docker Volumes Optimizing the Dockerfile Running Scripts Inside the Dockerfile Install the SQL Server Command-Line Utilities Write the Bash Script to Check for Backups Run the Bash Script in the Last Instruction Multi-stage Builds Docker Compose and YAML Files Installing Docker Compose Creating a YAML File for Multi-container Apps Summary Chapter 11: Guide to Docker Networking for SQL Server DBAs The docker0 Bridge Virtual Network Adapters Working with and Exposing Ports: Running Multiple SQL Server Instances on Linux via Containers Using the Same Port on Multiple Containers Intra-container Communications Putting It All Together Summary Appendix A: Building a Personal Lab Environment The Need for a Personal Lab Software for the Lab Environment Operating System Virtualization Platform Installing CentOS Linux Server Installing Ubuntu Linux Server Utilizing Public Cloud Resources Provisioning a Linux Docker Host on Microsoft Azure Provisioning a Linux Docker Host on AWS Provisioning a Linux Docker Host on Google Cloud Platform Linux Client Tools Using SSH to Connect to Linux Using WinSCP for Copying Files to Linux SQL Server Client Tools Azure Data Studio mssql-cli Summary Index