展开查看详情
1 .Monitor RDS using PMM
Mykola Marzhan
Version: 27.02.18
2 .Mykola Marzhan
Release Engineer, Percona
AWS Certified Solutions
Architect - Professional
I have been developing
monitoring systems since 2004.
3 .CHAPTER 1: WHAT RDS IS?
AMAZON RELATIONAL DATABASE SERVICE
4 .CHAPTER 2: WHAT PMM IS?
5 .PERCONA MONITORING AND MANAGEMENT
FREE, OPEN SOURCE DATABASE
MONITORING PLATFORM FOR
MYSQL AND MONGODB
6 .PERCONA MONITORING AND MANAGEMENT
ON-PREMISES SOLUTION
(NOT A SAAS)
7 .PERCONA MONITORING AND MANAGEMENT
➤ Provides metric information
for database/os performance optimization
➤ Displays current queries and statistics
for query optimization
8 .PERCONA MONITORING AND MANAGEMENT
HTTPS://PMMDEMO.PERCONA.COM/
9 .CHAPTER 3: HOW TO RUN TOGETHER?
+ =
RDS PMM PERFORMANCE
10 .AMAZON RELATIONAL DATABASE SERVICE
ENABLE
PERFORMANCE_SCHEMA
(TO COLLECT QUERY ANALYTICS DATA)
11 .AMAZON RELATIONAL DATABASE SERVICE
ENABLE
ENHANCED MONITORING
(TO COLLECT OS LEVEL METRICS)
12 .AMAZON RDS RECOMMENDATIONS
➤ Don’t use T2 instances for RDS
they don’t have enough resources to handle replication and
performance_schema load
➤ Use Elastic IP for PMM instance
to preserve Public IP between reboots
➤ Create separate DB user
to provide only needed, read-only rights for PMM
➤ Create separate IAM User/Role
to provide only needed, read-only rights for PMM
13 .DATABASE USER PERMISSIONS
GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD
ON *.* TO '<DB_USER>'@'%'
IDENTIFIED BY '<DB_PASSWORD>'
WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, UPDATE, DELETE, DROP
ON performance_schema.* TO '<DB_USER>'@'%';
14 .IAM PERMISSIONS
{
"Version": "2012-10-17",
"Statement": [{
"Sid": "Stmt1508404837003",
"Effect": "Allow",
"Action": [
"rds:DescribeDBInstances",
"cloudwatch:GetMetricStatistics",
"cloudwatch:ListMetrics"
],
"Resource": ["*"]
},
{
"Sid": "Stmt1508410723001",
"Effect": "Allow",
"Action": [
"logs:DescribeLogStreams",
"logs:GetLogEvents",
"logs:FilterLogEvents"
],
"Resource": ["arn:aws:logs:*:*:log-group:RDSOSMetrics:*"]
}
]
}
15 .AMAZON RELATIONAL DATABASE SERVICE
➤ Create Parameter
group
➤ Apply Parameter
group to RDS instance
➤ Enable enhanced
monitoring
➤ Create separate IAM
User/Role
➤ Create separate DB
user
LIVE DEMO ➤
➤
Start PMM instance
Assign Elastic IP
➤ Update PMM
16 . Mykola Marzhan
mykola.marzhan@percona.com
热门城市
