How to deploy highly available SQL Server 2017 on Linux on GKE
Kubernetes is an open-source container orchestration system for automating deployment, scaling and management of containerized applications. Running a SQL Server database on Kubernetes is a topic of discussion nowadays as Kubernetes provides ways to provision stateful containers using persistent volumes, statefulsets, etc. The following
post is a
tutorial we recently published on Google's Partner Solutions that demonstrates how to provision a single instance of SQL Server 2017 on Linux on
GKE using
Regional persistent disks. The deployment provides synchronous replication between two zones, thus providing resiliency against zone failure. The walkthrough will show you how to create a GKE cluster, create a Kubernetes secret, create the StorageClass and PersistentVolumeClaim, set up and deploy SQL Server, connect to SQL Server, and most importantly, simulate a zone failure.
This deployment might not be suitable for mission-critical or large workloads. Instead, Pythian recommends this deployment for smaller workloads in production, development, and staging environments.
Thank you to
@ronpanto for proving support and reviewing ;-)
Enjoy!
Share this
You May Also Like
These Related Stories
How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error
How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error
Sep 30, 2019
2
min read
Oracle E-Business Suite and 12cR1 database in Extended support - What to do?
![](https://www.pythian.com/hubfs/Imported_Blog_Media/mos_download_msg.png)
Oracle E-Business Suite and 12cR1 database in Extended support - What to do?
Oct 30, 2019
2
min read
Ansible Inventory Automation Using Consul and Orchestrator
Ansible Inventory Automation Using Consul and Orchestrator
Nov 13, 2020
4
min read
No Comments Yet
Let us know what you think