[MDEV-19902] No replication (Galera) using mysql8.0 jdbc driver Created: 2019-06-28  Updated: 2021-12-23  Resolved: 2021-12-23

Status: Closed
Project: MariaDB Server
Component/s: Galera, mariabackup, Storage Engine - MyISAM
Affects Version/s: 10.2.23
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Stefan B. Assignee: Jan Lindström (Inactive)
Resolution: Incomplete Votes: 0
Labels: Debian, Galera, JDBC, MariaDB, MySQL8, ProxySQL
Environment:
  • 3 MariaDB Nodes
    --> KVM virtualized
    --> running on Debian Stretch
    --> Version 10.2.23
    --> Replication with Galera Cluster
  • ProxySQL as LoadBalancer (mainly for HA)
  • Clients
    --> Debian Stretch
    --> Apache/Tomcat8.5/Java8
    --> mysql8.0 JDBC driver

Attachments: File my.cnf    

 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.


Generated at Thu Feb 08 08:55:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.