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

Mariadb cluster built in Galera mode, data in database mysql is out of sync

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2.18
    • N/A
    • Galera
    • None
    • Ubuntu18.04、Kubernetes、mariadb for openstack

    Description

      In the openstack environment of containerized deployment managed by Kubernetes, mariadb is used to manage the database. Now I am performing an openstack upgrade operation. I backed up the data in the mysql database in one environment and imported it into the database in the other environment. The replicas of the database service is 3 . AfterI executed the import command, I found that the data in the mysql library will only be written to one of the pods, and this pod may not be the master of the cluster. The mysql user table in the other two pods is empty, what's more restarting the service will not synchronize data with the pods that have data.

      Attachments

        Activity

          People

            janlindstrom Jan Lindström
            hanchl hanchl
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.