enable causal reads

[cYuSeDfZfb cYuSeDfZfb]

Hi!

Running maxscale 23.02.1 on ubuntu, with:

[Read-Write-Service]
type=service
router=readwritesplit
servers=galera1,galera2,galera3
user=maxscale
password=very_secret
causal_reads = global
causal_reads_timeout = 15

After restarting maxscale, it seems causal reads are still running as default:

galera1:~# maxctrl show service  Read-Write-Service | grep caus
│                     │     "causal_reads": "false",                                │
│                     │     "causal_reads_timeout": "10000ms",                      │

We also configured the three galera mariadb (10.6.12) backend servers with session_track_system_variables=last_gtid

Can anyone explain what is going wrong here..?

Thanks!

[cYuSeDfZfb cYuSeDfZfb]

Ah wait, answering my own question here:

warning: Overwriting configuration section 'Read-Write-Service' from main file '/etc/maxscale.cnf' with contents from runtime file '/var/lib/maxscale/maxscale.cnf.d/Read-Write-Service.cnf'. To prevent this warning message, manually move the runtime changes to the main file.

Many apologies!

[Markus Mäkelä]

Hi,

By default, changes done via maxctrl and through the REST-API are persisted in configuration files located in /var/lib/maxscale/maxscale.cnf.d/. This way if you configure MaxScale using only the GUI or via maxctrl, your changes aren't lost when you restart MaxScale.

You can disable the loading of these generated files using load_persisted_configs=false  and you can disable the generation of them with persist_runtime_changes=false.

Markus

--
You received this message because you are subscribed to the Google Groups "MaxScale" group.
To unsubscribe from this group and stop receiving emails from it, send an email to maxscale+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/b6364229-6690-4ee3-8771-96cdffa25f90n%40googlegroups.com.

-- 
Markus Mäkelä, Senior Software Engineer
MariaDB Corporation

[cYuSeDfZfb cYuSeDfZfb]

Thank you Markus, I will do that!

> To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/41effbf0-c251-a441-0e12-64b6b6b3c891%40mariadb.com.