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

▶
pmm for aws
SMART_READER_LITE
LIVE PREVIEW

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

Mar 11, 2023 123 likes •588 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

slide-1
SLIDE 1

PMM for AWS

Daniel Guzman Burgos Percona

slide-2
SLIDE 2

2

Agenda

  • What is different?
  • What is additional?
  • What is not there?
slide-3
SLIDE 3

What is Different?

Doing alternative things

slide-4
SLIDE 4
  • Adding/Removing instances procedure
  • Access requirements
  • Configuration Requirements

4

What is Different?

slide-5
SLIDE 5

5

Adding/Removing instances

No need to use the pmm-admin (From the pmm-client package)

slide-6
SLIDE 6

6

Adding/Removing instances

Though you could use pmm-admin (more on that in a bit)

slide-7
SLIDE 7

7

Adding/Removing instances

Use an IAM user account

slide-8
SLIDE 8

8

Access Requirements

Details on what is an IAM users are

  • ut of scope.

But not hard to find: https://docs.aws.amazon.co m/IAM/latest/UserGuide/intro duction.html

slide-9
SLIDE 9

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

slide-10
SLIDE 10

1

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!

slide-11
SLIDE 11

1 1

Adding/Removing instances

slide-12
SLIDE 12

1 2

Adding/Removing instances

slide-13
SLIDE 13

1 3

Adding/Removing instances

What about PostgreSQL ?

slide-14
SLIDE 14

1 4

Adding/Removing instances

PostgreSQL RDS instance can be added as a remote DB instance:

slide-15
SLIDE 15

1 5

Adding/Removing instances

Only credentials access are required

slide-16
SLIDE 16

1 6

Adding/Removing instances

But also available on the remote instances dashboard

slide-17
SLIDE 17

1 7

Adding/Removing instances

the postgres_exporter will immediately kick in

slide-18
SLIDE 18

1 8

Adding/Removing instances

slide-19
SLIDE 19

1 9

Adding/Removing instances

slide-20
SLIDE 20

2

Adding/Removing instances

slide-21
SLIDE 21

2 1

Adding/Removing instances

The “Amazon RDS / Aurora MySQL Metrics” dashboard is going to be deprecated on PMM 2

slide-22
SLIDE 22

2 2

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/

slide-23
SLIDE 23

2 3

Adding/Removing instances

PMM 2?? Whaat? But coming as Beta TOMORROW May 30th!!!

slide-24
SLIDE 24

2 4

Adding/Removing instances

Why is the “Amazon RDS / Aurora MySQL Metrics” dashboard is going to be deprecated on PMM 2 ?

slide-25
SLIDE 25

2 5

Adding/Removing instances

Because it was an intermediate solution. It was Grafana’s CloudWatch data source-based

slide-26
SLIDE 26

2 6

Adding/Removing instances

It was kind of tricky to set it up.

slide-27
SLIDE 27

2 7

Adding/Removing instances

And data was not persisted on Prometheus

slide-28
SLIDE 28

2 8

Adding/Removing instances

All that was fixed when rds_exporter were introduced

slide-29
SLIDE 29

2 9

Configuration requirements

  • Performance Schema enabled for QAN
slide-30
SLIDE 30

3

Configuration requirements

  • Performance Schema enabled for QAN
  • Enable Enhanced Monitoring for the RDS instance
slide-31
SLIDE 31

3 1

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

slide-32
SLIDE 32

3 2

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

slide-33
SLIDE 33

3 3

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

slide-34
SLIDE 34

3 4

  • 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

Adding an RDS instance from the command line

slide-35
SLIDE 35

3 5

  • Available through the Performance Schema.
  • No slow log
  • Currently not available for PostgreSQL (sorry)

QAN

slide-36
SLIDE 36

3 6

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

slide-37
SLIDE 37

3 7

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

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/

slide-38
SLIDE 38

3 8

QAN

slide-39
SLIDE 39

What is Additional?

Things custom made for AWS

slide-40
SLIDE 40

4

What is Additional?

  • RDS/Aurora own dashboards
  • RDS_EXPORTER
slide-41
SLIDE 41

4 1

RDS/Aurora dashboards

slide-42
SLIDE 42

4 2

RDS/Aurora dashboards

slide-43
SLIDE 43

4 3

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

slide-44
SLIDE 44

What is not There?

What isn’t available

slide-45
SLIDE 45

4 5

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

slide-46
SLIDE 46

46

Rate My Session