Simple play icon Course
Skills

Supporting SQL Server High Availability with Kubernetes

by Michael Otey

Kubernetes is the leading container orchestration platform. This course will teach you how to use Kubernetes to provide high availability for a two-node SQL Server cluster and how-to implement a three-node SQL Server AlwaysOn Availability Group.

What you'll learn

Running SQL Server on Kubernetes is unfamiliar territory for most SQL Server and Kubernetes administrators and developers. In this course, Supporting SQL Server High Availability with Kubernetes, you’ll learn how you can deploy SQL Server containers on Kubernetes for high availability. First, you’ll get some important background on running SQL Server in a container and how SQL Server containers can be managed using Kubernetes. Here, you’ll see how running SQL Server in a container is different from a standalone or virtualized instance as well as getting an understanding of the overall architecture of a SQL Server on Kubernetes solution. Next, you’ll dig into the nitty-gritty details showing how Kubernetes can provide high availability for a two-node SQL Server cluster. You’ll see the actual YAML and kubectl commands that were used to build the cluster and the persistent storage that SQL Server databases require. Then, we’ll dig deeper and you’ll see how you can build and run a three-node SQL Server AlwaysOn Availability Group on Kubernetes. Here again, you’ll see the YAML and kubectl commands required as well as the T-SQL commands that you can use to build a clusterless Availability Group. Finally, you’ll come away with some valuable tips and troubleshooting tools. When you’re finished with this course, you’ll have a fundamental understanding of how to run SQL Server on Kubernetes and how Kubernetes can provide high availability for SQL Server containers. At the end of this course, you’ll come away with 40+ scripts that you can use as a basis for building your own SQL Server and Kubernetes deployments.

Table of contents

Course Overview
1min

About the author

Michael Otey is a contributor for IT Pro Today, Petri, and TechTarget. He is president of TECA Inc. a technical writing, content creation, and consulting company in Portland, Oregon and is a former SQL Server Microsoft MVP. He was also Senior Technical Director for Windows IT Pro and SQL Server Pro where he performed numerous hardware and software product reviews. He covers the topics of SQL Server, Windows Server, data center, virtualization, containers, hardware, storage, the cloud, and system... more

Ready to upskill? Get started