Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36677

wsrep_sst_rsync broken if innodb_log_group_home_dir is different than datadir

    XMLWordPrintable

Details

    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
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            TM Tomas Merta
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.