maria-discuss team mailing list archive

[Pavel Ivanov <pivanof@xxxxxxxxxx>]

Can you clarify what SHOW SLAVE STATUS blocks on for you?

On Sun, Aug 20, 2017 at 9:47 AM, Nils Carlson <nils.carlson@xxxxxxxxxxx> wrote:
> Hi Pavel and Kristian,
>
> On 08/10/2017 10:58 PM, Pavel Ivanov wrote:
>>
>> Note also that you don't want to set rpl_semi_sync_master_enabled='ON'
>> on all your slaves, it should be set only on the master. With the
>> setting your slaves' SQL threads will hang waiting for semi-sync ack
>> as well, and they will hang forever if
>> rpl_semi_sync_master_wait_no_slave is set to ON too.
>>
> Thank you.
>
>> On Wed, Aug 9, 2017 at 2:30 AM, Kristian Nielsen
>> <knielsen@xxxxxxxxxxxxxxx> wrote:
>>>
>>> Hope this helps,
>
>
> And thank you for all this!
>
> I have updated the resource-agent based on this and run some light testing.
> I will try to write automated tests soon.
>
> I was also wondering about one thing, the block SHOW SLAVE STATUS command.
> Is there any way to ensure this doesn't block? Maybe this is something to
> suggest to the development mailing list?
>
> Thanks again.
>
> Cheers,
> Nils
>
>
>>>
>>>   - Kristian.
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~maria-discuss
>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>
>