Re: [Maria-developers] [Maria-discuss] Maria db read/write configuration issues

[Karthick Subramanian]

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] Query ambiguity

[Karthick Subramanian]

I think the OP needs to try a lot of googling and stackoverflow etc first
and break the heads first and then post it here if it's really required.
IMHO, if people start asking the SQL problems (mainly most of the sql
issues are knowledge gap related) here, then I think the quality of this
forum will be compromised.

On Thu, May 17, 2018, 6:36 AM Pantelis Theodosiou 
wrote:

> What Rhys said, please post queries as text, not as images.
>
> The issue is likely due to the way you structured your query. You have put
> a derived table in a random place (in the SELECT list).
>
> Please try to read about CTEs. It will help you design those complex
> queries better and make them more readable and easy to edit:
> https://mariadb.com/kb/en/library/with/
>
> Best regards
>
> Pantelis Theodosiou
>
> On Thu, May 17, 2018 at 11:23 AM,  wrote:
>
>> You're not making a lot of sense here. Please explain the "ambiguity".
>> That's a fairly complex query so you should include as text.
>>
>>
>>
>> "Does not work" <- In the image. It helps if you include error message.
>>
>>
>>
>> *From:* Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=
>> swisscom@lists.launchpad.net] *On Behalf Of *Dev C
>> *Sent:* 17 May 2018 06:41
>> *To:* maria-disc...@lists.launchpad.net; Maria Developers <
>> maria-developers@lists.launchpad.net>
>> *Subject:* [Maria-discuss] Query ambiguity
>>
>>
>>
>> Hello
>>
>>
>>
>> I have query ambiguity as attached. Please help me on how to solve that.
>>
>>
>>
>>
>> ___
>> 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