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

how to check what causing replication full in Galera?

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.5.12, 10.5(EOL)
    • N/A
    • Galera
    • None
    • redhat

    Description

      Hi all,

      In case production incident, found replication is full by checking status variable "wsrep_flow_control_active". But we don't know what to check further.

      More than 50% chance the replication will be resumed within 15mins. However, we have several cases that replication is not resumed after 3 hours.

      In case of replication not resumed long time, re reboot the DB node to get service resume.

      Understand the problem may be caused by additonal workload transaction. But we want to check further. Anything we can check in next occurance?

      Regards,
      William Wong

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            frelist William Wong
            Votes:
            1 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.