MySql – Calidade Systems

Start a Percona 5.7 cluster after a controlled shutdown

Posted on April 19, 2018

In each node check the content of /var/lib/mysql/grastate.dat version: 2.1 uuid: 9a50c4ec-4332-11e8-8b88-77564bb9f22a seqno: 45 safe_to_bootstrap: 0 select the node with the highest value in seqno and edit the value of safe_to_bootstrap to 1 should be like these version: 2.1 uuid: 9a50c4ec-4332-11e8-8b88-77564bb9f22a seqno: 45 safe_to_bootstrap: 1 in these node run systemctl start mysql@bootstrap.service in the other […]

MySql

How to reclaim or shrink unused space in MySql Ibdata1 file?

Posted on July 4, 2017July 4, 2017

One of my customers calls me, telling that he has problems in his database server, it was giving a lot of errors. In this situations one of the first things to check is free space in hard disk, and bingo disk was full,we found that the biggest usage was in MySql folder, but databases folders […]