Comments - Mariabackup Overview
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Why would database need a restart? I can't find a compelling reason. Server is unaware about mariabackup, it can not detect its presence even.
As for upgrade information, mariabackup should match the version of the mysqld, ideally 100% . I hope it is automated by DEB and RPMs.
Well, I've just tried it. Installing mariabackup on a galera cluster to switch from rsync to mariabackup for non-blocking SST. (Ubuntu , MariaDB 10.2.18) node1 running mariadb node2 running mariadb node3 running mariadb Galera working fine.
Then stop node2 and node3
Install mariadb on all 3 nodes, while node1 is running. (Incl changing my.cnf and the required wsrep_sst_method/ ..._auth on all 3 nodes) Try to start node2, and see SST fail miserably. Node1 is unable to read swrep_sst_auth and sst_method is still set to rsync. It doesn't help changing wsrep_sst_method online on node1, SST still fails.
Restart of node1, makes it aware of mariabackup sst settings and SST succeeds.
That's why I claim it requires restart,but I'd love to hear where I might assume wrong or forget an important detail ;) ?
I am wrong. It WILL work also with Galera, aithout restarting any online databases.
My error was that I overlooked the simple task of setting *both* wsrep_auth AND wsrep_method on the DONOR (And on JOINER I guess, in config file(s))
So: DONOR-MYSQL> SET GLOBAL WSREP_AUTH="username:password" DONOR-MYSQL> SET GLOBAL WSREP_METHOD="maribackup"
Start mariadb on the JOINER node that needs SST running non-blocking. It works fine.
My bad!
I'm talking in terms of general backup, you're talking about Galera, nodes, SST , which I do not know at all. Sorry.