asked on

how to turn on transaction_replay and master_failure_mode=fail_on_write in maxscale

hi,

I am reading

https://mariadb.com/kb/en/mariadb-maxscale-23-readwritesplit/#transaction_replay
https://mariadb.com/kb/en/mariadb-maxscale-23-readwritesplit/#master_reconnection
https://jira.mariadb.org/browse/MXS-2139

how to turn on transaction_replay and master_failure_mode=fail_on_write in maxscale so that when DML transaction is executing, failover is started, the executing transaction is not interrupted?

when I add this:

[readwriteservice]
transaction_replay=true
master_failure_mode=fail_on_write

maxscale can't start up any more and remove it can !

this is the error:

ob for maxscale.service failed because the control process exited with error code. See "systemctl status maxscale.service" and "journalctl -xe" for details

Open in new window

the log said:

Unknown module type for object 'readwriteservice':

Kenza Cohen

Hi there,
Sorry about the late reply you may find the following handy :)

https://maxscale.readthedocs.io/en/stable/Documentation/Tutorials/MaxScale-Tutorial/

marrowyung

ASKER

I see this:

https://maxscale.readthedocs.io/en/stable/Documentation/Routers/ReadConnRoute/

https://maxscale.readthedocs.io/en/stable/Documentation/Routers/ReadWriteSplit/

but never have one is about DML transaction level failover, please suggest which part is it?

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.