4 ms·
No, we haven't. You are absolutely right that this would probably mitigate the deadlocks. However, (1) the deadlocks/WSREP was a problem annoying us, while the
by _rami_ 9y ago
No, we haven't. You are absolutely right that this would probably mitigate the deadlocks. However,
(1) the deadlocks/WSREP was a problem annoying us, while the query performance was a problem leading to real customer complaints,
(2) as I see it right now, we would have needed to take complicated steps to ensure that all application nodes always connect to the same database node; just a hardcoded priority would probably not be enough,
(3) a mechanism for (2) would likely make us loose more of the advantages of Galera, e.g. short failover downtimes
- shlomi-noach 9y agoSince you already use HAProxy you should get that almost for free. Your app would talk to the databased by communicating through HAProxy, which would direct traffic to the single-writer; HAProxy's health tests would detect who the single-writer is, and would adapt in the event of failover.