Page MenuHomePhorge

recover-mariadb.yaml
No OneTemporary

Authored By
Unknown
Size
936 B
Referenced Files
None
Subscribers
None

recover-mariadb.yaml

- name: Configure kolab-node
hosts: nodes
gather_facts: False
become: yes
user: kolab
tasks:
- name: Initialize galera cluster
ansible.builtin.shell: |
systemctl stop mariadb; \
systemctl stop garbd; \
# TODO in principle we should first select the correct node to bootstrap by comparing the output of:
#sudo mysqld --wsrep-recover, which outputs something like "WSREP: Recovered position: 90823e7a-cf9e-11ef-a4e1-d69a8635a591:1873796",
#and then use that node to bootstrap.
- name: Initialize galera cluster
ansible.builtin.shell: |
sed -i 's/safe_to_bootstrap: 0/safe_to_bootstrap: 1/' /data/mysql/grastate.dat; \
galera_new_cluster
when: mariadb.bootstrap
- name: Start mariadb
ansible.builtin.command: systemctl start mariadb
when: not mariadb.bootstrap
- name: Start garbd
ansible.builtin.command: systemctl start garbd

File Metadata

Mime Type
text/plain
Expires
Sat, Apr 4, 2:49 AM (3 d, 18 h ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
18820548
Default Alt Text
recover-mariadb.yaml (936 B)

Event Timeline