[Maria-discuss] 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.
Hi, It's also possible that the reads are going to the master because prepared statements are being used. The current version of MaxScale does not yet support read scaling of prepared statements. Markus On 09/03/17 14:12, Chaitanya Cheekate wrote:
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 <mailto: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 <mailto: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/Tutorials/MySQL-Replication-Read-Write-Splitting-Tutorial.md>
https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ro... <https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md>
https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Ge... <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 <mailto: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-... <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 <https://launchpad.net/%7Emaria-discuss> Post to : maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> More help : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> Post to : maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> More help : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
-- 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
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
participants (4)
-
Chaitanya Cheekate -
Guillaume Lefranc -
Karthick Subramanian -
Markus Mäkelä