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.cheek...@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-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-disc...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp