Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2206

Replication of mysql schema - Replication stops when a user is altered

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.2.2
    • Icebox
    • ?
    • None
    • 2 UM, 2 PM system with local query

    Description

      Reported by a customer

      2 UM, 2 PM system with local query. Replication stops when a user is altered from UM1. A simple grant to a user on UM1 will stop replication to the other servers with these errors:

      Slave_IO_Running: Yes
      Slave_SQL_Running: No
      Last_Error: Error 'Can't find any matching row in the user table' on query. Default database: ''. Query: 'grant select on test.dairy_comm_pred to ro_dairy'

      First, this user, along with others, are intentionally not on the other servers of UM2, PM1 and PM2 as they do not need to access anything from there. Second, the rsync command for replication also excludes the mysql dir, so shouldn't this also be skipped over when replicating?

      rsync -vopgr -e ssh --exclude=mysql/ --exclude=test/ --exclude=infinidb_vtable/ --exclude=infinidb_querystats/ --exclude=calpontsys/ --include=/ --include=/* --exclude=* $INSTALLDIR/mysql/db/ $USERNAME@$SERVER:$INSTALLDIR/mysql/db/

      I believe this could be set as a variable in Replicate_Ignore_DB=mysql

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            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.