Sample Header Ad - 728x90

How Maxscale deals with "Select for update transactions"

0 votes
1 answer
579 views
We are facing intermitent deadlock issues that doesnt got reflected in the maxscale log nor the mariadb log. Only in the applications triying to do sql transactions in the database. We use mostly readwritesplit with 2 nodes (yes, i know, bad design) and we dont know exactly how maxscale deals with the select for update queries. 1. to the slave, because is a read query (select) 2. to the master, because is a write query (update) Maxscale version 2.1.16, MariaDB 2.1.29 Thanks!
Asked by PsySkeletor (11 rep)
Feb 6, 2019, 12:15 PM
Last activity: Feb 6, 2019, 01:53 PM