Percona Tools
by Mark Nielsen
Copyright 2022
- Links
- Percona PMM for Mongodb
- Our shard
- Percona Backups
- Percona Toolkit
Links
- https://www.percona.com/blog/2019/07/23/pmm-for-mongodb-start-guide/
- https://www.percona.com/software/mongodb/percona-backup-for-mongodb
- https://www.percona.com/doc/percona-toolkit/LATEST/pt-mongodb-query-digest.html
- https://www.percona.com/doc/percona-toolkit/LATEST/pt-mongodb-summary.html
Percona PMM
We will run PMM against our shard.
Our shard
This is just a copycat of a previous article.
Percona Backups
This is a highly desired backup soluton for replica sets or shards to take a consistent
snapshot. Its made aas easy as possible. With our sharded environment we shall take a backup
and then restore it.
Percona ToolKit
There are only two toosl I see, and one of them I use.
Although there may be other tools, and I have written them before,
pt-mongodb-query-digest is a highly valueable tool. Summary is nice also.
pt-mongodb-query-digest
At the time of this writing, digest does not support ssl. That seems to be on schedule
for a feature.
We will create two scenarios where we lock tables and we create horrible queries. To
do the horrible queries we will have to put some data in a few tables. To make it
horrible we will not use indexes.
pt-mongodb-summary
A useful. We will generate a sample output of our sharded environment.