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