[Maria-developers] Maria db read/write configuration issues
Hi We have configured maxscale in our environment using the links http://karlssonondatabases.blogspot.in/2014/02/maxscale-for-rest-of-us-part-..., 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.
Follow these below 3 links (especially 3rd link): https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Tu... https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ro... https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ge... 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@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
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@paycommerce.com> a écrit :
Follow these below 3 links (especially 3rd link):
https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Tu...
https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ro...
https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ge...
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@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-..., 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
Thanks for reply. Right now we are are checking with commands only. On Thu, Mar 9, 2017 at 5:34 PM, Guillaume Lefranc <guillaume@adishatz.net> 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 < ksubramanian@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.cheekate@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
-- Thanks.
participants (3)
-
Chaitanya Cheekate -
Guillaume Lefranc -
Karthick Subramanian