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

Change database and table used for Mariabackup's history

Details

    Attachments

      Issue Links

        relates to

        Task - A task that needs to be done. MDEV-14746 mariabackup doesn't read [mariabackup] option group in configuration file

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. MDEV-18347 mariabackup doesn't read all server option groups from configuration files

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. MDEV-18405 Add Mariabackup option to set gtid_slave_pos to original server's gtid_current_pos during prepare

        • Major - Major loss of function.
        • Stalled

        Bug - A problem which impairs or prevents the functions of the product. MDEV-18917 Don't create xtrabackup_binlog_pos_innodb with Mariabackup

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. MDEV-18931 Rename Mariabackup's xtrabackup_* files to mariadb_backup_*

        • Critical - Crashes, loss of data, severe memory leak.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. MDEV-18985 Remove support for XtraDB's changed page bitmap from Mariabackup in 10.2+

        • Major - Major loss of function.
        • Closed

        Task - A task that needs to be done. MDEV-19264 Better support MariaDB GTID for Mariabackup's --slave-info option

        • Major - Major loss of function.
        • Closed

        New Feature - A new feature of the product, which has yet to be developed. MDEV-20552 Remove innobackupex mode from Mariabackup

        • Major - Major loss of function.
        • Stalled

        Bug - A problem which impairs or prevents the functions of the product. MDEV-20556 Remove references to "xtrabackup" and "innobackupex" executables in mariabackup option descriptions

        • Major - Major loss of function.
        • Closed
        is part of

        DOCSCOLLAB-291 Loading...

        Activity

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik added a comment -

          is this table only used by mariabackup itself for incremental backups? Does it have any other usages, other tools that use it, perhaps?

          serg Sergei Golubchik added a comment - is this table only used by mariabackup itself for incremental backups? Does it have any other usages, other tools that use it, perhaps?
          GeoffMontee Geoff Montee (Inactive) added a comment -

          I am not aware of any tools other than Percona XtraBackup and mariabackup that use the table.

          According to the Percona XtraBackup documentation, the table is primarily intended for maintaining a history of backups for informational purposes:

          Percona XtraBackup supports storing the backups history on the server. This feature was implemented in Percona XtraBackup 2.2. Storing backup history on the server was implemented to provide users with additional information about backups that are being taken. Backup history information will be stored in the PERCONA_SCHEMA.XTRABACKUP_HISTORY table.

          https://www.percona.com/doc/percona-xtrabackup/LATEST/xtrabackup_bin/backup.history.html

          GeoffMontee Geoff Montee (Inactive) added a comment - I am not aware of any tools other than Percona XtraBackup and mariabackup that use the table. According to the Percona XtraBackup documentation, the table is primarily intended for maintaining a history of backups for informational purposes: Percona XtraBackup supports storing the backups history on the server. This feature was implemented in Percona XtraBackup 2.2. Storing backup history on the server was implemented to provide users with additional information about backups that are being taken. Backup history information will be stored in the PERCONA_SCHEMA.XTRABACKUP_HISTORY table. https://www.percona.com/doc/percona-xtrabackup/LATEST/xtrabackup_bin/backup.history.html
          ralf.gebhardt Ralf Gebhardt added a comment -

          But it is not only to log a history, XtraBackup can also use this history to for incremental backups

          ralf.gebhardt Ralf Gebhardt added a comment - But it is not only to log a history, XtraBackup can also use this history to for incremental backups
          serg Sergei Golubchik added a comment - - edited

          okay, if there aren't any tools that would break because of this change, then yet, let's do it.
          What should be the new name? mysql.mariabackup_history ?

          serg Sergei Golubchik added a comment - - edited okay, if there aren't any tools that would break because of this change, then yet, let's do it. What should be the new name? mysql.mariabackup_history ?
          bar Alexander Barkov added a comment -

          Hello serg,

          Can you please review this patch:

          https://github.com/MariaDB/server/commit/24d3f2cb8037f40dfce4b6da7ca243c838aa9800

          ?

          Thanks!

          bar Alexander Barkov added a comment - Hello serg , Can you please review this patch: https://github.com/MariaDB/server/commit/24d3f2cb8037f40dfce4b6da7ca243c838aa9800 ? Thanks!
          serg Sergei Golubchik added a comment -

          24d3f2cb8037f40dfce4b6da7ca243c838aa9800 is ok to push

          serg Sergei Golubchik added a comment - 24d3f2cb8037f40dfce4b6da7ca243c838aa9800 is ok to push
          serg Sergei Golubchik added a comment -

          The primary name is mariadb-backup, but it'd be inconvenient to have a dash in the identifier (table name), it'd always need to be quoted. So mariabackup_history or maria_backup_history. And I think between those two either is fine.

          serg Sergei Golubchik added a comment - The primary name is mariadb-backup, but it'd be inconvenient to have a dash in the identifier (table name), it'd always need to be quoted. So mariabackup_history or maria_backup_history . And I think between those two either is fine.
          bar Alexander Barkov added a comment -

          Let's go with mariadb_backup_history. It's closest possible to the program name, just using an underscore instead of a dash.

          bar Alexander Barkov added a comment - Let's go with mariadb_backup_history . It's closest possible to the program name, just using an underscore instead of a dash.

          People

            bar Alexander Barkov
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            9 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.