Can you clarify what SHOW SLAVE STATUS blocks on for you? On Sun, Aug 20, 2017 at 9:47 AM, Nils Carlson <nils.carlson@ludd.ltu.se> 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@knielsen-hq.org> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp