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

No replication (Galera) using mysql8.0 jdbc driver

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.2.23
    • N/A

    Description

      We using a three node mariadb cluster for currently more than 130 Webservers.
      Between the db-nodes and the webservers is a proxysql server as a load-balancer, which
      is mainly used for high-availibility purposes for the db-cluster. Thereby only one db node
      is used for all traffic from the webserver to their corresponding databases in the cluster
      (a read/write split is not yet implemented/used).

      On a set of the webservers we are using an CMS which uses Apache/Tomcat/Java. The
      current version of this CMS is using the mysql8.0 jdbc driver and this can't be simply changed
      before initial installation.
      We can see that the writing statements didn't get replicated on the other two nodes.

      If we switching to the mariadb jdbc driver after the initial installation all data is replicated
      and everything is working fine.
      By switching back to the mysql jdbc driver we can reliable provoke the behaviour (no replication) again.

      Finally we are currently don't really know wether this is really a mysql jdbc driver specific behavior or wether we are facing some serious problems with our replication.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            stefman_87 Stefan B.
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.