Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.4.5
Description
We use Galera cluster with different log and data dir due to ZFS backend optimalization. Current 11.4.5 has still broken RSYNC SST. Some fixes were made in MDEV-35387, as I reported earlier, but SST only work with method mariabackup. We use rsync, because rsync in our scenario is about 5x faster than mariabackup (500Gb data in 6000 DBs).
Problematic part start in wsrep_sst_rsync on line 178, There are hardly defined
ar_log_dir="$DATA_DIR" |
ib_log_dir="$DATA_DIR" |
ib_home_dir="$DATA_DIR" |
ib_undo_dir="$DATA_DIR" |
but in previous version of script after these line were code with detection of innodb_log_group_home_dir properly modifying these vars. If I change ib_log_dir for proper path, rsync SST is working. Without modification rsync SST finish successfully, but ib_logfile0 is not copied and MariaDB crash on start with
[ERROR] InnoDB: File /var/lib/mysql/logs/ib_logfile0 was not found |
Our config:
innodb_log_group_home_dir=/var/lib/mysql/logs |
aria_log_dir_path=/var/lib/mysql/logs |
datadir=/var/lib/mysql/data |