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

wsrep_sst_mariabackup.sh uses --use-memory default which is 100MB resulting in prepare stage taking hours

Details

    Description

      Our manual restore process uses --use-memory=464G for our 2+TB database otherwise it takes hours for the Prepare stage.

      But recently we had a SST due to node failure which seems to use the default --use-memory=100MB which then results in the Prepare stage taking hours.
      This severely impacted our Time To Recovery.

      It should be possible to set the preferred use-memory size in a configuration file which can then be read by wsrep_sst_mariabackup.sh or by "mariadb-backup --prepare" as suggested by @Marko Mäkelä

      Attachments

        Activity

          stephanvos Stephan Vos added a comment -

          Comment from @Marko Mäkelä

          Can you please file a separate bug against wsrep_sst_mariabackup.sh so that this parameter can be specified? It is also thinkable that mariadb-backup --prepare would read the use_memory parameter from an appropriate section of a configuration file.

          stephanvos Stephan Vos added a comment - Comment from @Marko Mäkelä Can you please file a separate bug against wsrep_sst_mariabackup.sh so that this parameter can be specified? It is also thinkable that mariadb-backup --prepare would read the use_memory parameter from an appropriate section of a configuration file.
          sysprg Julius Goryavsky added a comment - Fixed, https://github.com/MariaDB/server/commit/fd9a11d8a5b820f8d08b28fb2f198edc6f196342

          People

            sysprg Julius Goryavsky
            stephanvos Stephan Vos
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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