search

codership / mysql-wsrep

wsrep API patch for MySQL server
Other
65 stars 34 forks source link

Duplicate INSERTS in galera cluster #360

Open kevinnivek opened 5 years ago

kevinnivek commented 5 years ago

Hello,

I am using the following on CentOS 7 : 

galera-3-25.3.26-2.el7.x86_64
mysql-wsrep-libs-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-common-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-libs-compat-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-devel-5.7-5.7.21-25.14.el7.x86_64
mysql-wsrep-client-5.7-5.7.21-25.14.el7.x86_64

This is a high availability environment with a load balancer in front of 2 servers and an arbitrator.

I am noticing under certain conditions (yet to be discovered), duplicate INSERTS are happening into the table when a user submits a POST request (to ultimately insert into the database).

I have ruled out the application level that is submitting the INSERT and am curious if anyone can help me to diagnose the issue further.

When the duplicate happened, in this most recent scenario, the date/timestamps are identical : 

row id : 152309 - 2019-09-12 16:44:26
row id : 152315 - 2019-09-12 16:44:26

Any ideas?