Collect replication slave information

Bug #1642754 reported by Sveta Smirnova
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Medium
Carlos Salguero

Bug Description

Currently pt-stalk does not collect replication slave information. Please add support for it.

Before 5.7: SHOW SLAVE STATUS

5.7+:

select * from performance_schema.replication_connection_configuration join performance_schema.replication_applier_configuration using(channel_name);
select * from replication_connection_status;
select * from replication_applier_status join replication_applier_status_by_coordinator using(channel_name);

Tags: pt-stalk pt80
Changed in percona-toolkit:
status: New → Confirmed
tags: added: pt-stalk
Changed in percona-toolkit:
importance: Undecided → Medium
assignee: nobody → Carlos Salguero (carlos-salguero)
milestone: none → 3.0.2
status: Confirmed → In Progress
Revision history for this message
Carlos Salguero (carlos-salguero) wrote :

Those queries are always returning an empty result set in my environment.
Could you provide some configuration option I must enable in order to make them work?

Thanks

Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

Do you run them on server, configured as slave?

Revision history for this message
Carlos Salguero (carlos-salguero) wrote :

Yes

tags: added: pt80
Changed in percona-toolkit:
milestone: 3.0.2 → 3.0.3
Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-718

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.