Sabtu, 30 September 2017

How to Fix Galera DB Error on restart

  Tidak ada komentar
Someday went i have success install and config MariaDb Galera MySql, my host was down, and some vm got down, went i try to restart mariadb service it's was failed, then i check the error log, and i get message like above, and did this and it was success


Edit : vi /var/lib/mysql/grastate.dat



From :

# GALERA saved state
version: 2.1
uuid:    9b22142d-a46b-11e7-9426-aa112539b203
seqno:   -1
safe_to_bootstrap: 0

To :

# GALERA saved state
version: 2.1
uuid:    9b22142d-a46b-11e7-9426-aa112539b203
seqno:   -1
safe_to_bootstrap: 1



For reference I found website that explain it more detailed :

https://severalnines.com/blog/how-bootstrap-mysqlmariadb-galera-cluster
https://www.linkedin.com/pulse/20140730200902-5707100-galera-mysql-cluster-crash-recovery/
http://galeracluster.com/documentation-webpages/restartingcluster.html



Tidak ada komentar :

Posting Komentar