Deploying Shared Storage SG for a SQL Cluster on Tencent Cloud

This article, authored by Li Sida – a Microsoft MVP, certified instructor, and system operations engineer – demonstrates how to deploy a shared storage (SG) for a SQL Cluster on Tencent Cloud.

It follows the previous two articles on creating a SQL Cluster on QCloud and focuses on the SG role, which provides three storage components: a quorum disk, a production data disk, and a reserved spare disk. The shared storage is implemented using the built‑in iSCSI server of Windows Server 2012 R2.

Server information used in the demo :

编号

服务器名称

生产IP

存储IP

心跳IP

对外VIP

1

Q-DC01

192.168.108.188

无

无

2

Q-SG01

192.168.108.206

10.11.11.231

无

3

Q-SQL01

192.168.108.254

10.11.11. 10.10.10.2

4

Q-SQL02

192.168.108.114

10.11.11. 10.10.10.234

Step‑by‑step deployment :

Connect to Q‑SG01 and install the iSCSI Server role (default options, no additional settings).

Install MPIO and enable iSCSI multi‑path support.

Open Disk Management to verify that the iSCSI‑attached disks are initialized.

Create partitions on the iSCSI disks (volumes are treated as disks).

In Server Manager, open the iSCSI Server UI and create the first virtual disk (used as the quorum disk). Choose a dynamic disk type, set a target name, and add the two SQL nodes (Q‑SQL01 and Q‑SQL02) as initiators.

Repeat the process to create the second virtual disk (used for production data). Use a fixed size for better performance.

After the targets are created, log into the SQL nodes, launch the iSCSI Initiator, delete any automatically discovered IPs, then manually add the target IP address via the Advanced tab.

Connect both SQL01 and SQL02 to the iSCSI targets, verify the disks appear in Disk Management, and finally reboot the nodes to complete the storage preparation.

The article includes numerous screenshots illustrating each UI step. It concludes by linking to the previous two articles in the series and invites readers to follow future posts.