pmm for aws
play

PMM for AWS Daniel Guzman Burgos Percona Agenda What is - PowerPoint PPT Presentation

Mar 11, 2023 •123 likes •586 views

PMM for AWS Daniel Guzman Burgos Percona Agenda What is different? What is additional? What is not there? 2 What is Different? Doing alternative things What is Different? Adding/Removing instances procedure Access

  1. PMM for AWS Daniel Guzman Burgos Percona

  2. Agenda • What is different? • What is additional? • What is not there? 2

  3. What is Different? Doing alternative things

  4. What is Different? ● Adding/Removing instances procedure ● Access requirements ● Configuration Requirements 4

  5. Adding/Removing instances No need to use the pmm-admin (From the pmm-client package) 5

  6. Adding/Removing instances Though you could use pmm-admin (more on that in a bit) 6

  7. Adding/Removing instances Use an IAM user account 7

  8. Access Requirements Details on what is an IAM users are out of scope. But not hard to find: https://docs.aws.amazon.co m/IAM/latest/UserGuide/intro duction.html 8

  9. Access Requirements IAM policy is part of the scope, though Details: https://www.percona.com/doc/pe rcona-monitoring-and-managem ent/amazon-rds.html#pmm-ama zon-rds-iam-user-policy 9

  10. Access Requirements Once 1. IAM user is created 2. Policy is in place 3. And credentials are created…. We can continue adding instances to PMM! 1 0

  11. Adding/Removing instances 1 1

  12. Adding/Removing instances 1 2

  13. Adding/Removing instances What about PostgreSQL ? 1 3

  14. Adding/Removing instances PostgreSQL RDS instance can be added as a remote DB instance: 1 4

  15. Adding/Removing instances Only credentials access are required 1 5

  16. Adding/Removing instances But also available on the remote instances dashboard 1 6

  17. Adding/Removing instances the postgres_exporter will immediately kick in 1 7

  18. Adding/Removing instances 1 8

  19. Adding/Removing instances 1 9

  20. Adding/Removing instances 2 0

  21. Adding/Removing instances The “Amazon RDS / Aurora MySQL Metrics” dashboard is going to be deprecated on PMM 2 2 1

  22. Adding/Removing instances PMM 2?? Whaat? Currently on Alpha: https://www.percona.com/blog/2019/05/03/percona-monitoring-and-manage ment-pmm-2-0-0-alpha2-is-now-available/ 2 2

  23. Adding/Removing instances PMM 2?? Whaat? But coming as Beta TOMORROW May 30th!!! 2 3

  24. Adding/Removing instances Why is the “Amazon RDS / Aurora MySQL Metrics” dashboard is going to be deprecated on PMM 2 ? 2 4

  25. Adding/Removing instances Because it was an intermediate solution. It was Grafana’s CloudWatch data source-based 2 5

  26. Adding/Removing instances It was kind of tricky to set it up. 2 6

  27. Adding/Removing instances And data was not persisted on Prometheus 2 7

  28. Adding/Removing instances All that was fixed when rds_exporter were introduced 2 8

  29. Configuration requirements ● Performance Schema enabled for QAN 2 9

  30. Configuration requirements ● Performance Schema enabled for QAN ● Enable Enhanced Monitoring for the RDS instance 3 0

  31. Configuration requirements ● Performance Schema enabled for QAN ● Enable Enhanced monitoring for the RDS instance ● If you want to use the legacy “Amazon RDS/ Aurora MySQL Metrics” dashboard: Create the .aws/credentials file 3 1

  32. Configuration requirements Docker steps: ● docker exec -ti pmm-server bash ● mkdir /usr/share/grafana/.aws ● vi /usr/share/grafana/.aws/credentials [default] aws_access_key_id=YOURACCESSKEY aws_secret_access_key=YOURSECRETKEY 3 2

  33. Adding an RDS instance from the command line Know that pmm-admin can still be used to add RDS instances to PMM... ...But it is not recommended 3 3

  34. Adding an RDS instance from the command line ● EC2 instance - yum -y install pmm-client ● pmm-admin config ● pmm-admin add mysql:metrics --server-host=SOMETHING-REMOTE ● Caveat is that you lose the rds_exporter - which means you don't have Host level metrics ● Caution - if you install linux:metrics (pmm-admin add mysql) you will get local ec2 compute metrics which is weird and won't make sense 3 4

  35. QAN ● Available through the Performance Schema. ● No slow log ● Currently not available for PostgreSQL (sorry) 3 5

  36. QAN How you manage to get Query Digest-like info from the Performance Schema? 3 6

  37. QAN How you manage to get Query Digest-like info from the Performance Schema? The performance_schema.events_statements_summary_by_digest table got your back More on that can be found at https://www.percona.com/blog/2015/10/13/mysql-query-digest-with-performance-schema/ 3 7

  38. QAN 3 8

  39. What is Additional? Things custom made for AWS

  40. What is Additional? ● RDS/Aurora own dashboards ● RDS_EXPORTER 4 0

  41. RDS/Aurora dashboards 4 1

  42. RDS/Aurora dashboards 4 2

  43. rds_exporter ● Collect metrics from CloudWatch AND store it in Prometheus ● Advanced metrics available if Enhanced Monitoring is enabled ● Saves money (credits are used once) ● Allows for standard dashboards utilization https://www.percona.com/doc/percona-monitoring-and-management/section.exporter.rds.html 4 3

  44. What is not There? What isn’t available

  45. What is not There? • Anything that is not exposed by CloudWatch • Anything that Aurora removed from regular InnoDB (like the change buffer, for example) • Anything that is not featured for PostgreSQL, like QAN 4 5

  46. Rate My Session 46

Recommend

More recommend