haproxy needs to be configured to avoid deadlock with mysql galera cluster
Bug #1387685 reported by
Tom Howley
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
tripleo |
Invalid
|
High
|
Nicholas Randon |
Bug Description
When the overcloud controller is deployed in HA mode and mysql galera cluster is being used, we have a potential deadlock issue when two mysql instances are writing at the same time. One issue is that mysql galera does not support SELECT...FOR UPDATE calls as it has no concept of cross-node locking.
I'm not aware if this issue has changed. If not, the workaround is configure haproxy to effectively use mysql in active-passive mode, which can be achieved by configuring all but one mysql instances as 'backup' nodes.
Changed in tripleo: | |
assignee: | nobody → Nicholas Randon (nicholas-randon) |
Changed in tripleo: | |
assignee: | Nicholas Randon (nicholas-randon) → Alexis Lee (alexisl) |
Changed in tripleo: | |
status: | In Progress → Invalid |
To post a comment you must log in.
Fix proposed to branch: master /review. openstack. org/132048
Review: https:/