I am using Mariadb Enterprise 10.6.Having 1 Master Node,2 Slave Nodes and 1 Maxscale Node. While testing found that MDB Enterprise 10.6 is having performance issues(taking more time to execute) than Single Node MDB Columnstore.
Current Maxscale Config-
[maxscale]
threads = auto
admin_host = 0.0.0.0
admin_secure_gui = false
Router type used - readwritesplit
Listener type used - readwritesplit.
Installation is performed as per offical doc-
https://mariadb.com/docs/deploy/topologies/columnstore-object-storage/enterprise-server-10-6/
Query>
how to improve the performance of MDB Enterprise cluster using Maxscale?
Is there any improvement required in maxscale conf file?
Without maxscale the performance is better on Single Node.
Ref link-I found one Maxscale config. MaxScale with multicluster setup