Skip to content

Instantly share code, notes, and snippets.

@michaelcoburn
Created October 20, 2020 18:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michaelcoburn/479208330083a8f972a5a773f5c518c7 to your computer and use it in GitHub Desktop.
Save michaelcoburn/479208330083a8f972a5a773f5c518c7 to your computer and use it in GitHub Desktop.
How to configure PCS
The easiest method to do authentication will be to create a .my.cnf in your root user directory so run:
cd
vi .my.cnf
Give it the following contents:
[client]
user=root
password=<SET_PASSWORD>
Please use wget to download both scripts from here: http://percona.github.io/percona-consulting-scripts/
You will then chmod +x each script.
Then run the following command, it should only take a few minutes:
./pcs-collect-environment.sh
Next start screen with the screen command.
COLLECTSLAVESTATUS=1 COLLECTINNODBMUTEX=1 COLLECTVARIABLES=1 ./pcs-collect-metrics.sh . 1440
This should run for 24 hours. You can detach from screen with ctrl+a then press d.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment