MySQL Bugs: #76828: Expose slave details via PS on a master

Bug #76828	Expose slave details via PS on a master
Submitted:	24 Apr 2015 14:11	Modified:	12 May 2015 9:59
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S4 (Feature request)
Version:	5.7.7	OS:	Any
Assigned to:	Marc ALFF	CPU Architecture:	Any
Tags:	connection attributes, performance_schema, replication

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
It would be nice if I could join the output of "show slave hosts" with for example the connection attributes for the connection from the session_connect_attrs table. 

How to repeat:
Try to find the data from 'show slave hosts' in a P_S table.

Suggested fix:
Add performance_schema.master_slave_hosts with the same info as 'show slave hosts'.

It would be nice to also have a PROCESSLIST_ID to make it easy to join it with session_connect_attrs

Hello Daniël,

Thank you for the feature request!

Thanks,
Umesh