Add support for --check-slave-lag for more than one server for pt-archiver

Bug #1452911 reported by Sveta Smirnova
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Medium
Frank Cizmich

Bug Description

Currently pt-archiver supports option --check-slave-lag for single slave only. Add ability to specify more than one server this way.

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

Version 2.2.14

Changed in percona-toolkit:
status: New → Confirmed
Revision history for this message
Michael Wang (xw73) wrote :

I would request to implement the same solution as pt-online-schema-change with
--recursion-method dsn=D=<schame>,t=<table> to make it uniform across the tools.

Thanks.

Changed in percona-toolkit:
status: Confirmed → Fix Committed
milestone: none → 2.2.15
assignee: nobody → Frank Cizmich (frank-cizmich)
importance: Undecided → Medium
Revision history for this message
Frank Cizmich (frank-cizmich) wrote :

Implemented ability to specify multiple slaves by being able to specify --check-slave-lag multiple times.
If --progress is defined, when pausing a report for each lagging slave is given every "--check-interval" seconds.

Note: The proposed --recursion-method approach was more involved to implement, but might be considered later on.

Revision history for this message
Frank Cizmich (frank-cizmich) wrote :

command line example for two slaves:

pt-archiver --no-delete --where '1=1' --source h=oltp_server,D=test,t=tbl --dest h=olap_server --check-slave-lag h=slave1 --check-slave-lag h=slave2 --limit 1000 --commit-each

Revision history for this message
Dave Gregg (dgregg) wrote :

Slave Lag now works well for multiple Slaves.....but

No matter what - row-by-row or BULK
you have records left and not copied over........look at bug Bug #1096274
I put comments in there as that bug is more specific I believe.

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-683

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.