Re: [Maria-developers] [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.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
Re: [Maria-developers] [Maria-discuss] Maria db read/write configuration issues
Thanks for reply. Right now we are are checking with commands only. On Thu, Mar 9, 2017 at 5:34 PM, Guillaume Lefranc 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 < > 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-disc...@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-disc...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> > -- Thanks. ___ 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
Re: [Maria-developers] [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 < 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-disc...@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-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