Building SQL Cluster on Tencent Cloud: Step-by-Step Configuration Guide
This step‑by‑step guide walks readers through securely building a four‑node SQL Server Failover Cluster on Tencent Cloud—covering jump‑server setup, domain controller and storage gateway configuration, AD account creation, internal CLB and DNS setup, network and iSCSI storage configuration, CSV and quorum settings, and final failover verification.
This article provides a comprehensive guide for building a SQL Cluster on Tencent Cloud. It begins with an introduction to the author, Li Sida, a Microsoft MVP and system operations engineer, and references previous articles in the series covering SQL Cluster creation on Tencent Cloud.
The article addresses security considerations on Tencent Cloud, including handling SYN packet warnings and setting up a jump server for secure access. It then proceeds with the SQL Cluster setup, referencing Microsoft's official documentation.
The architecture involves four servers with specific IP configurations: Q-DC01 (domain controller), Q-SG01 (storage gateway), and two SQL nodes (Q-SQL01 and Q-SQL02). The setup includes installing Failover Cluster on SQL nodes, creating a SQLAdmin account in Active Directory, and configuring local administrator permissions.
The guide covers creating an internal CLB for the cluster VIP, configuring DNS records, and setting up the cluster using domain administrator credentials. It details the validation process, network configuration (production, storage, heartbeat, and live migration networks), and storage setup including iSCSI disk addition and CSV configuration.
The article concludes with quorum configuration and verification of resource online status, ensuring proper failover functionality.
Tencent Cloud Developer
Official Tencent Cloud community account that brings together developers, shares practical tech insights, and fosters an influential tech exchange community.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.