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/Tu...

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ro...

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ge...

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-..., 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

Hi, It's also possible that the reads are going to the master because prepared statements are being used. The current version of MaxScale does not yet support read scaling of prepared statements. Markus On 09/03/17 14:12, Chaitanya Cheekate wrote:

Thanks for reply. Right now we are are checking with commands only.

On Thu, Mar 9, 2017 at 5:34 PM, Guillaume Lefranc mailto:guillaume@adishatz.net> wrote:

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 mailto:ksubramanian@paycommerce.com> a écrit :

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

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Tu... https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Tu...

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ro... https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ro...

https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ge... https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ge...

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 mailto: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-... http://karlssonondatabases.blogspot.in/2014/02/maxscale-for-rest-of-us-part-..., 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 https://launchpad.net/%7Emaria-discuss Post to : maria-discuss@lists.launchpad.net mailto:maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss https://launchpad.net/%7Emaria-discuss More help : https://help.launchpad.net/ListHelp https://help.launchpad.net/ListHelp

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

-- 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

-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela