Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.0.15
-
Ubuntu 14.04
Description
Is replace insert into query using multiple database supported in galera cluster? I'm getting Deadlock message.
The query works on a single server, but doesn't work in individual node behind galera cluster.
Query and all details are posted here http://stackoverflow.com/questions/30094558/executing-mysql-replace-into-select-using-multiple-db-results-to-deadlock
I'm not quite sure if its a bug or due to cluster-level optimistic concurrency control Galera works in this way. I'm done with a workaround but not sure if that is the most optimized solution or not. If it's not an intended behavior then please look into it.