If your application uses transactions, e.g. Java/Hibernate, Python connector... it will route to master by default.

-GL

Le jeu. 9 mars 2017 à 18:43, Karthick Subramanian <ksubramanian@paycommerce.com> a écrit :

Follow these below 3 links (especially 3rd link):

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Tutorials/MySQL-Replication-Read-Write-Splitting-Tutorial.md

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Getting-Started/Configuration-Guide.md

there is some weightby clause that you can use to control the read write split. Above 3 links will provide some idea on what you need to achieve, 

On Thu, Mar 9, 2017 at 3:36 PM, Chaitanya Cheekate <chaitanya.cheekate@vidyayug.com> wrote:

Hi 

We have configured maxscale in our environment using the links http://karlssonondatabases.blogspot.in/2014/02/maxscale-for-rest-of-us-part-1.html, 2, 3 . We have two slaves and one master and the replication between them is working well. But after configuring read/write split the select queries are being executed in master itself, not routing to the slaves. Please find the attached documents of maxscale configuration, maxscale commands maxscale log and. Please help with maxscale read/write split.

Attached documentsdetails

1. maxsconf.txt from the location /etc/maxscale.cnf

2. maxscale-commands.txt, coomands like maxadmin -pmariadb list servers, maxadmin -pmariadb list services, maxadmin -pmariadb show service "Splitter Service", 

3. maxscale-log.txt from /var/log/maxscale

Thanks

Chaitu

--

Thanks.

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp