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

Change mariadb-dump to use SHOW REPLICA STATUS instead of SHOW SLAVE STATUS

    XMLWordPrintable

Details

    • Hide
      Add support for MySQL 8.4 to mariadb-dump for fetching binary position
      Added MySQL 8.4 syntax "SHOW BINARY LOG STATUS' as an alias for SHOW MASTER STATUS
      Show
      Add support for MySQL 8.4 to mariadb-dump for fetching binary position Added MySQL 8.4 syntax "SHOW BINARY LOG STATUS' as an alias for SHOW MASTER STATUS

    Description

      MySQL has removed the use of MASTER and SLAVE in 8.4. mariadb-dump therefore reports a syntax error for "SHOW SLAVE STATUS" and "SHOW MASTER STATUS" when used against MySQL 8.4 for a migration.

      https://dev.mysql.com/doc/refman/8.4/en/show-master-status.html

      SHOW MASTER STATUS - deprecated
      replaced by SHOW BINARY LOG STATUS.

      SHOW SLAVE STATUS - replaced by
      SHOW REPLICA STATUS.

      The task is to change mysql-dump to work with MySQL 8.4 and also ensure that MariaDB supports the MySQL syntax.

      Changes in mysql-dump:

      • If SHOW SLAVE STATUS fails with syntax error, retry with SHOW REPLICA STATUS
      • If SHOW MASTER STATUS fails, retry with SHOW BINARY LOG STATUS

      Changes in MariaDB server:

      • Add SHOW BINARY LOG STATUS as an alias to SHOW MASTER STATUS

      Attachments

        Issue Links

          causes

          Task - A task that needs to be done. MDEV-39880 Merge MDEV-37146 into MDEV-39519

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          Task - A task that needs to be done. MDEV-37146 mariadb-dump: Replace SHOW SLAVE STATUS usage with information_schema.SLAVE_STATUS

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-18777 Rename or alias slave-related statements, options, status variables

          • Major - Major loss of function.
          • Stalled

          MIGTK-11 Loading...

          Activity

            People

              monty Michael Widenius
              manoj.vakeel Manoj
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.