[MDEV-15410] Create documentation for galera_recovery command Created: 2018-02-24 Updated: 2020-07-22 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Documentation, Galera |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Michaël de groot | Assignee: | Ian Gilfillan |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
Hi, Please create documentation for the systemd-script galera_recovery The script is used when the cluster went down in an unorganized way, for example due to a power outage. Basically this tells you which node has most transactions. Please note that it does not protect you against losing transactions, if innodb_flush_log_at_trx_commit != 1, you may still have lost transactions. The only thing this helps you with it that it finds the node that has MOST transactions stored. The output looks something like this: The node where 34877824 is the highest is the right node to start. To start the node, use an editor to change grastate.dat, change safe_to_bootstrap to 1, and then bootstrap the node with galera_new_cluster. |
| Comments |
| Comment by Jan Lindström (Inactive) [ 2019-12-12 ] |
|
greenman Can you put this on some priority queue to be done. |
| Comment by Geoff Montee (Inactive) [ 2020-07-22 ] |
|
I added some basic documentation about this a while ago: https://mariadb.com/kb/en/systemd/#recovering-a-nodes-cluster-position |