maria-discuss team mailing list archive

[Markus Mäkelä <markus.makela@xxxxxxxxxxx>]

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 
> <guillaume@xxxxxxxxxxxx <mailto:guillaume@xxxxxxxxxxxx>> 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
>     <ksubramanian@xxxxxxxxxxxxxxx
>     <mailto:ksubramanian@xxxxxxxxxxxxxxx>> 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/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/Routers/ReadWriteSplit.md>
>
>         https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Getting-Started/Configuration-Guide.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@xxxxxxxxxxxx
>         <mailto:chaitanya.cheekate@xxxxxxxxxxxx>> 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
>             <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
>             <https://launchpad.net/%7Emaria-discuss>
>             Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>             <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>             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@xxxxxxxxxxxxxxxxxxx
>         <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>         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@xxxxxxxxxxxxxxxxxxx
> 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