← Back to team overview

maria-developers team mailing list archive

Re: [Maria-discuss] Maria db read/write configuration issues

 

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
>

Follow ups

References