[MDEV-29105] Return some indication that there are named connections with SHOW SLAVE STATUS with Multi Source Replica Created: 2022-07-15  Updated: 2022-07-16

Status: Open
Project: MariaDB Server
Component/s: Replication
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Claudio Nanni Assignee: Unassigned
Resolution: Unresolved Votes: 3
Labels: None


 Description   

When multi source replica even with just one named connection SHOW SLAVE STATUS returns empty results:

MariaDB [(none)]> show slave status\G
Empty set (0.000 sec)
 
MariaDB [(none)]> show all slaves status\G
*************************** 1. row ***************************
               Connection_name: ext_repl
               Slave_SQL_State: Waiting for room in worker thread event queue
                Slave_IO_State: Waiting for master to send event

I think it would be useful to have an indication that the server is actually replicating on some other "channel".
Maybe also just convert SHOW SLAVE STATUS to behave as SHOW ALL SLAVES STATUS by default, in such case it will always do the right thing showing all the channels if present or the default one in all other cases.



 Comments   
Comment by Ralf Gebhardt [ 2022-07-16 ]

claudio.nanni, was

default_master_connection

set?

Generated at Thu Feb 08 10:05:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.