$ tar -ztvf pmm-client-1.17.4.tar.gzdrwxrwxr-x ec2-user/docker 0 2020-07-08 14:04 pmm-client-1.17.4/-rw-rw-r-- ec2-user/docker 1816536 2020-07-08 14:03 pmm-client-1.17.4/pmm-client-38b8313.tar.gz-rw-rw-r-- ec2-user/docker 1145679 2020-07-08 14:03 pmm-client-1.17.4/postgres_exporter-3017fce.tar.gz-rw-rw-r-- ec2-user/docker 2361627 2020-07-08 14:03 pmm-client-1.17.4/proxysql_exporter-bbd1471.tar.gz-rw-rw-r-- ec2-user/docker 2405889 2020-07-08 14:03 pmm-client-1.17.4/qan-agent-9399e1f.tar.gz-rw-rw-r-- ec2-user/docker 1327002 2020-07-08 14:03 pmm-client-1.17.4/mysqld_exporter-491e5e4.tar.gz-rw-rw-r-- ec2-user/docker 76448822 2020-07-08 14:04 pmm-client-1.17.4/percona-toolkit-a4db86e0.tar.gz-rw-rw-r-- ec2-user/docker 1296480 2020-07-08 14:03 pmm-client-1.17.4/mongodb_exporter-9fd6f88.tar.gz-rw-rw-r-- ec2-user/docker 1470353 2020-07-08 14:03 pmm-client-1.17.4/node_exporter-fe47433.tar.gz-rw-rw-r-- ec2-user/docker 8106798 2020-07-08 14:03 pmm-client-1.17.4/pid-watchdog-2a86cf7.tar.gz
tar -C $GOPATH/src/github.com/percona -zxf mongodb_exporter-9fd6f88.tar.gztar -C $GOPATH/src/github.com/percona -zxf mysqld_exporter-491e5e4.tar.gztar -C $GOPATH/src/github.com/percona -zxf node_exporter-fe47433.tar.gztar -C $GOPATH/src/github.com/percona -zxf percona-toolkit-a4db86e0.tar.gztar -C $GOPATH/src/github.com/percona -zxf pid-watchdog-2a86cf7.tar.gztar -C $GOPATH/src/github.com/percona -zxf pmm-client-38b8313.tar.gztar -C $GOPATH/src/github.com/percona -zxf postgres_exporter-3017fce.tar.gztar -C $GOPATH/src/github.com/percona -zxf proxysql_exporter-bbd1471.tar.gztar -C $GOPATH/src/github.com/percona -zxf qan-agent-9399e1f.tar.gz
Using Percona Toolkit pt-mongodb-summary
pushd $GOPATH/src/github.com/perconamv mongodb_exporter-9fd6f88 mongodb_exportermv postgres_exporter-3017fce postgres_exportermv proxysql_exporter-bbd1471 proxysql_exportermv node_exporter-fe47433 node_exportermv pmm-client-38b8313 pmm-clientmv mysqld_exporter-491e5e4 mysqld_exportermv percona-toolkit-a4db86e0 percona-toolkitmv pid-watchdog-2a86cf7 pid-watchdogmv qan-agent-9399e1f qan-agent
pushd $GOPATH/src/github.com/percona/node_exportermake buildmv node_exporter $GOPATH/bincd $GOPATH/src/github.com/percona/postgres_exportermake buildmv postgres_exporter $GOPATH/bincd $GOPATH/src/github.com/percona/percona-toolkitperl Makefile.PLmakego get -u github.com/golang/dep/cmd/dep../../../../bin/dep ensure -vgo build ./src/go/pt-mongodb-summarycp pt-mongodb-summary $GOPATH/bincp bin/pt-mysql-summary $GOPATH/bincp bin/pt-summary $GOPATH/binpopd
Foreign key-related issues are prevalent when dealing with DDL changes in MySQL using the Percona toolkit. We need to do pre-checks not only on the DB end before executing the alter, but we also need to make sure the tool that we are using is up-to-date to avoid hitting the bug to cause an issue.
2ff7e9595c
Comments