Unable to change the value of wsrep_sst_method on user-provided hosts

[Vinogradoww]

Hello,

By default, in the node configuration (/etc/mysql/wsrep/conf.d/99.galera.cnf), wsrep_sst_method = mariabackup. Because of this, some queries on large tables are slow.

When creating a cluster, I add to the Custom DB engine configuration:

[mysqld]
wsrep_sst_method = rsync

After that, in the /etc/mysql/wsrep/conf.d was created file 00.galera.cnf, containing my custom configuration. However 99.galera.conf still contains wsrep_sst_method = mariabackup.

I checked on the server:

MariaDB [(none)]> SHOW VARIABLES LIKE '%wsrep_sst_method%';
+------------------+-------------+
| Variable_name    | Value       |
+------------------+-------------+
| wsrep_sst_method | mariabackup |
+------------------+-------------+

How do I correctly change wsrep_sst_method with Galera Manager?

---

Note I can change this parameter manually, however, if server restarts, configuration returns to default

Galera Manager 1.7.5, node DB engine mariadb:10.5

[ayurchen]

Hi, thanks for report. It was our conscious decision to control certain variables and not allow the users to change them.

mariabackup is positioned as THE backup tool for MariaDB and it makes much faster SST for big databases than rsync. What makes you believe that wsrep_sst_method=mariabackup makes some queries slow?