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

mysqldump restore with specified databases wont set gtid

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.28
    • 10.1.28
    • Backup, Replication
    • None
    • Windows Server 2012 R2

    Description

      I have a MariaDB Master (called A) with binlog, and a MariaDB Slave (called B) to A for some specified databases.

      Now I need to create another MariaDB Slave (called C) to A for some specified databases which different replicate from B.

      I install MariaDB, and restore with backup from mysqldump with gtid and master-data flags for specified databases. (with{{ -D database -o database}})

      After complete restoration and start the slave, it says slave_io_process error, can not get latest binlog.

      I get into troubleshooting for this problem, and find there is no value in mysql.gtid_slave_pos.

      So I need to login to A and get the gtid from binlog and set it in C.

      But if I restore ALL database in C, there is value in mysql.gtid_slave_pos in C.

      Why do the specified databases restore will not execute set global gtid_slave_pos in dumpfile?

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            sujunmin Su, Jun-Ming
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.