SQL Server AG with Docker without Pacemaker

• Prepare the Dockerfile with HA feather
• Build image with Dockerfile just created
• Create the SQL server nodes with the image which with HA feather
• Create the certs ,master key and logins on each nodes
• Sync all certs to each other
• Create AG group and Endpoint on Primary Node
• Two Secondary nodes join AG group
• Create TestDB and add TestDB to AG
• Change roles on each node to test

---

https://github.com/j0bb0/Docker-SQL-AG.git

---

ref

https://cache.one/read/3338800

Note

证书在/tmp会有问题，换个路径存放证书即可