Page Menu
Home
Phorge
Search
Configure Global Search
Log In
Files
F117751086
recover-mariadb.yaml
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Authored By
Unknown
Size
936 B
Referenced Files
None
Subscribers
None
recover-mariadb.yaml
View Options
-
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
Details
Attached
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)
Attached To
Mode
R114 kolab-infrastructure
Attached
Detach File
Event Timeline