Source: thenewstack.io
Configuring for High Availability in Google Cloud PlatformCategory: Database, Data, Infrastructure
Here is a guide for migrating an on-premises SQL Server infrastructure to Google Cloud Platform (GCP), in such a way that you can ensure (HA) or 99.99% uptime of your system, by way of multizone clustering. One of the first questions you’ll need to answer is just what kind of virtual machines (VMs) you’ll need.
Fundamentally, they work in similar ways: Once you’ve settled on the instance size you’ll need to support your SQL Server workloads in GCP, you will create a second instance of the same size in a separate but nearby GCP zone.
Indeed, if you place both your primary and secondary instances of SQL Server in the same zone, GCP will give you an availability service level agreement (SLA) of up to 99.95% availability.
One of the great strengths of GCP is its internal communications infrastructure, and the connections linking the zones within a Google region offer sufficient throughput that your SQL Server instances, even in two separate zones, can communicate quite efficiently.
Fundamentally, they work in similar ways: Once you’ve settled on the instance size you’ll need to support your SQL Server workloads in GCP, you will create a second instance of the same size in a separate but nearby GCP zone.
Indeed, if you place both your primary and secondary instances of SQL Server in the same zone, GCP will give you an availability service level agreement (SLA) of up to 99.95% availability.
One of the great strengths of GCP is its internal communications infrastructure, and the connections linking the zones within a Google region offer sufficient throughput that your SQL Server instances, even in two separate zones, can communicate quite efficiently.
Related Articles
Community Partners
DevOps Careers