[MDEV-30210] SHOW REPLICA HOSTS not working on replicas Created: 2022-12-12  Updated: 2022-12-13  Resolved: 2022-12-13

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ian Gilfillan Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

The KB page for SHOW REPLICA HOSTS - https://mariadb.com/kb/en/show-replica-hosts/ - states that "The list is displayed on any server (not just the master server)". This appears not to be correct.

MySQL docs state that "SHOW SLAVE HOSTS should be executed on a server that acts as a replication source" - https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html

 Comments   
Comment by Anel Husakovic [ 2022-12-12 ] 

connection slave;
 
show grants for current_user;
 
Grants for root@localhost
 
GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` WITH GRANT OPTION
 
GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
 
select @@global.report_host;
 
@@global.report_host
 
127.0.0.1
 
SHOW REPLICA HOSTS;
 
Server_id       Host    Port    Master_id

Comment by Ian Gilfillan [ 2022-12-13 ]

Wording just seemed to be misleading, so removed.

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