122 lines
2.8 KiB
YAML
122 lines
2.8 KiB
YAML
---
|
|
- name: Install software
|
|
package:
|
|
name: "{{ item }}"
|
|
state: present
|
|
with_items: "{{ db_packages }}"
|
|
|
|
|
|
- name: "Quick-Fix MariaDB/systemd problems"
|
|
lineinfile:
|
|
path: /usr/lib/systemd/system/mariadb.service
|
|
regexp: "^SendSIGKILL=no"
|
|
line: "SendSIGKILL=yes"
|
|
backup: yes
|
|
register: db_systemd_fix
|
|
when: ansible_virtualization_type == "lxc"
|
|
|
|
|
|
- name: Reload systemd daemon
|
|
command: /bin/systemctl daemon-reload
|
|
when: db_systemd_fix is changed
|
|
|
|
|
|
- name: 'Enable service "{{ db_servicename }}"'
|
|
service:
|
|
name: "{{ db_servicename }}"
|
|
state: started
|
|
enabled: yes
|
|
|
|
|
|
- name: "Config: Listen on all ip addresses"
|
|
lineinfile:
|
|
path: /etc/mysql/mariadb.conf.d/50-server.cnf
|
|
regexp: "^ *#* *bind-address"
|
|
line: "bind-address = 0.0.0.0"
|
|
backup: yes
|
|
notify: 'Restart MariaDB'
|
|
|
|
|
|
- name: "Config: Set server-id"
|
|
lineinfile:
|
|
dest: /etc/mysql/mariadb.conf.d/50-server.cnf
|
|
regexp: "^ *#* *server-id"
|
|
line: "server-id = {{ db_server_id }}"
|
|
backup: yes
|
|
notify: 'Restart MariaDB'
|
|
|
|
|
|
- name: "Config: Enable binlog"
|
|
lineinfile:
|
|
dest: /etc/mysql/mariadb.conf.d/50-server.cnf
|
|
regexp: "^ *#* *log_bin"
|
|
line: "log_bin = /var/log/mysql/mysql-bin.log"
|
|
backup: yes
|
|
when: db_server_id == 1
|
|
notify: 'Restart MariaDB'
|
|
|
|
|
|
- name: MariaDB create replication user
|
|
mysql_user:
|
|
name: "{{ db_repl_user }}"
|
|
password: "{{ db_repl_password }}"
|
|
priv: '*.*:REPLICATION SLAVE'
|
|
host: "%"
|
|
state: present
|
|
notify: 'Restart MariaDB'
|
|
|
|
|
|
- name: Get MariaDB master state
|
|
mysql_info:
|
|
filter: master_status
|
|
register: db_master_status
|
|
|
|
|
|
- debug:
|
|
msg: "{{ db_server_id }} - {{ db_master_status.master_status }}"
|
|
when: db_debug|default(False) == True
|
|
|
|
|
|
- name: "(Maybe) Restart MariaDB"
|
|
meta: flush_handlers
|
|
|
|
|
|
- name: Get MariaDB master state
|
|
mysql_info:
|
|
filter: master_status
|
|
register: db_master_status_new
|
|
|
|
|
|
- debug:
|
|
msg: "{{ db_server_id }} - {{ db_master_status_new.master_status }}"
|
|
when: db_debug|default(False) == True
|
|
|
|
|
|
- name: "(Master) Reset binlog"
|
|
command: '/usr/bin/mysql -u root -e "RESET MASTER"'
|
|
when: db_server_id == 1 and db_master_status.master_status == {}
|
|
|
|
|
|
- name: "(Slave) Get status"
|
|
mysql_replication:
|
|
mode: getslave
|
|
register: db_slave_status
|
|
|
|
|
|
- debug:
|
|
var: db_slave_status
|
|
when: db_debug|default(False) == True
|
|
|
|
|
|
- name: "(Slave) Setup replication"
|
|
command: '/usr/bin/mysql -u root -e "CHANGE MASTER TO master_host=\"{{ hostvars["db-01"]["ansible_default_ipv4"].address }}\", master_user=\"{{ db_repl_user }}\", master_password=\"{{ db_repl_password }}\", master_use_gtid=current_pos"'
|
|
when: db_server_id != 1 and db_slave_status.Slave_IO_Running|default("No") == "No"
|
|
|
|
|
|
- name: "(Slave) Start slave"
|
|
mysql_replication:
|
|
mode: startslave
|
|
when: db_server_id != 1 and db_slave_status.Slave_IO_Running|default("No") == "No"
|
|
|
|
|