maria-discuss team mailing list archive

[Chaitanya Cheekate <chaitanya.cheekate@xxxxxxxxxxxx>]

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>
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> 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@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, 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>> _______________________________________________
>> 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
>>
>


-- 
Thanks.