cnstechnicalgroup.sqlserver-ha-config

Panoramica Versioni Approfondimenti

Role: cnstechnicalgroup.sqlserver-ha-config

This Ansible role installs SQL Server High Availability Components and sets up communication between primary and secondary hosts for mirroring.

Requirements

  • CentOS 7
  • Ubuntu Xenial Xerus

Role Variables

In this version, you can set the following variables:

Name Optional Default Description
use_hosts_file yes no Use the /etc/hosts file to resolve DNS. Setting this to yes will add entries for the primary and secondary hosts in the /etc/hosts file.
primary_host_ip yes --- IP address of the main server in Always On. This is needed only if use_hosts_file is set to yes.
secondary_host_ip yes --- IP address of the backup server in Always On. This is needed only if use_hosts_file is set to yes.
primary_host_name no --- Name of the primary server being mirrored.
secondary_host_name no --- Name of the secondary server that is mirroring.
sa_password no --- System administrator password for the SQL Server installation; required for setup.
  • If you decide to use the /etc/hosts file to resolve the machines involved in the Availability Group (AG), make sure to add those IP addresses and host names to the /etc/hosts file of the Ansible server. This is important because the Ansible server runs sqlcmd.

Dependencies

This role depends on role-sqlserver-server.

License

GPLv2

Author Information

Created by CNS Technical Group (https://www.cnstechgroup.com/).

Documentation

Example of installation (https://github.com/cnstechnicalgroup/ansible-sqlserver/blob/master/documents/sqlserver-ha-config.md).

Examples

---
- name: Use cnstechnicalgroup.sqlserver-ha-config role 
  hosts: dbservers
  sudo: yes
  roles: 
    - cnstechnicalgroup.sqlserver-ha-config
  gather_facts: yes
  environment:
   SA_PASSWORD: "{{sa_password}}"
   ACCEPT_EULA: "Y"
   MSSQL_PID: "evaluation"
Informazioni sul progetto

Ansible role install SQL Server High Availability Components and configure hosts for mirror communications

role database sqlserver
Installa
ansible-galaxy install cnstechnicalgroup.sqlserver-ha-config
GitHub repository
1 stelle
0 fork
0 problemi aperti
Licenza
gpl-2.0
Download
152
Proprietario