Skip to content
This repository has been archived by the owner on Feb 20, 2019. It is now read-only.

Add hint about Galera cluster transactions to avoid deadlocks #2490

Closed
PVince81 opened this issue Jun 17, 2016 · 4 comments · Fixed by #3216
Closed

Add hint about Galera cluster transactions to avoid deadlocks #2490

PVince81 opened this issue Jun 17, 2016 · 4 comments · Fixed by #3216
Assignees

Comments

@PVince81
Copy link
Contributor

@felixboehm
Copy link
Contributor

There is also a loadbalancer from mariaDB called maxScale, I recommend to use this as it provides read / write splitting.
https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-readwrite-splitting-with-galera-cluster/

@felixboehm
Copy link
Contributor

A good point in docs to mention this and warn might be here: https://doc.owncloud.com/server/9.0/admin_manual/installation/deployment_recommendations.html#id2

@PVince81 PVince81 modified the milestones: 9.1, 9.1.1 Jul 21, 2016
@carlaschroder carlaschroder self-assigned this Aug 31, 2016
@PVince81 PVince81 modified the milestones: 9.1.2, 9.1.1 Sep 21, 2016
@PVince81 PVince81 modified the milestones: 9.1.3, 9.1.2 Oct 20, 2016
@carlaschroder carlaschroder removed their assignment Nov 29, 2016
@settermjd settermjd modified the milestones: 9.1.3, Documentation Backlog Dec 20, 2016
@tomneedham
Copy link
Contributor

https://mariadb.com/kb/en/mariadb-enterprise/consistent-critical-read-filter/ should be configured when using macscale using the exampke configuration:

[CCRFilter]
type=filter
module=ccrfilter
time=5

@tomneedham
Copy link
Contributor

transaction_persistent = 1 in ProxySQL as well

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants