Monitor RDS using PMM

您是否关心如何监控您的AWS环境?跟踪Amazon RDS部署中发生的事情对于确保关键应用程序和服务的数据库性能和可用性至关重要。
您是否知道,Percona监控和管理(PMM)附带了对RDS MySQL和Amazon Aurora的开箱即用支持?是的!
Percona监控和管理(PMM)是一个免费的开源平台,用于管理和监控MySQL、Mariadb和MongoDB的内部和云端性能。
在本课程中,我们将讨论:
-如何使用EC2实例针对RDS MySQL和Aurora配置PMM(度量和查询)
-如何根据CloudWatch度量配置PMM
-如何设置AWS的配置参数以获得最大的PMM可见性

展开查看详情

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