← Back to team overview

maria-developers team mailing list archive

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

 

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

Follow ups

References