Quickstart of a SQL Server cluster with Docker Compose.

Translation for: English.

Project Status: (Development).

https://www.sqlshack.com/configure-sql-server-2017-linux-mssql-conf-available-tools/

...

docker exec -it container-db "bash"

docker exec -it container-mssql-node01 "bash"

volume-remove-mssql01: @docker volume rm -f quickstart-mssql_vol_data_mssql01;

volume-remove-mssql02: @docker volume rm -f quickstart-mssql_vol_data_mssql02;

volume-remove-mssql03: @docker volume rm -f quickstart-mssql_vol_data_mssql03;

volume-remove-mssql-single: @docker volume rm -f quickstart-mssql_vol_data_mssql_single;

...

Dockerfile.single Dockerfile.cluster

https://opensource.com/article/18/8/what-how-makefile

https://docs.microsoft.com/pt-br/sql/linux/sql-server-linux-availability-group-configure-ha?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-availability-group-configure-ha?view=sql-server-2017

MASTER

script-certificate-master.sql

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Master_Key_Password>'; CREATE CERTIFICATE dbm_certificate WITH SUBJECT = 'dbm'; BACKUP CERTIFICATE dbm_certificate TO FILE = '/var/opt/mssql/data/dbm_certificate.cer' WITH PRIVATE KEY ( FILE = '/var/opt/mssql/data/dbm_certificate.pvk', ENCRYPTION BY PASSWORD = 'Private_Key_Password' );

$ cp dbm_certificate.cer /home/app/mssql/certificates/dbm_certificate.cer; $ cp dbm_certificate.pvk /home/app/mssql/certificates/dbm_certificate.pvk;

$ chown mssql:mssql /var/opt/mssql/data/dbm_certificate.*;

script-endpoint.sql

CREATE ENDPOINT [Hadr_endpoint] AS TCP (LISTENER_IP = (0.0.0.0), LISTENER_PORT = 5022) FOR DATA_MIRRORING ( ROLE = ALL, AUTHENTICATION = CERTIFICATE dbm_certificate, ENCRYPTION = REQUIRED ALGORITHM AES ); ALTER ENDPOINT [Hadr_endpoint] STATE = STARTED;

script-availability-group.sql

CREATE AVAILABILITY GROUP [ag1] WITH (CLUSTER_TYPE = NONE) FOR REPLICA ON N'mssql-node01' WITH ( ENDPOINT_URL = N'tcp://mssql-node01:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, SEEDING_MODE = AUTOMATIC, FAILOVER_MODE = MANUAL, SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL) ), N'mssql-node02' WITH ( ENDPOINT_URL = N'tcp://mssql-node02:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, SEEDING_MODE = AUTOMATIC, FAILOVER_MODE = MANUAL, SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL) ), N'mssql-node03' WITH ( ENDPOINT_URL = N'tcp://mssql-node03:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, SEEDING_MODE = AUTOMATIC, FAILOVER_MODE = MANUAL, SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL) )

ALTER AVAILABILITY GROUP [ag1] GRANT CREATE ANY DATABASE;

SECONDARY

$ cp /home/app/mssql/certificates/dbm_certificate.cer /var/opt/mssql/data/dbm_certificate.cer; $ cp /home/app/mssql/certificates/dbm_certificate.pvk /var/opt/mssql/data/dbm_certificate.pvk;

$ chown mssql:mssql /var/opt/mssql/data/dbm_certificate.*;

script-certificate-secondary.sql

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Secondary_Key_Password'; CREATE CERTIFICATE dbm_certificate FROM FILE = '/var/opt/mssql/data/dbm_certificate.cer' WITH PRIVATE KEY ( FILE = '/var/opt/mssql/data/dbm_certificate.pvk', DECRYPTION BY PASSWORD = 'Private_Key_Password' );

script-endpoint.sql

https://docs.microsoft.com/pt-br/sql/linux/sql-server-linux-availability-group-configure-ha?view=sql-server-2017#join-secondary-replicas-to-the-ag

https://linuxhint.com/bash_loop_list_strings/