Running PMM in Production at Tessi Valentin Traen, Jonathan Gourdon, - - PowerPoint PPT Presentation

▶
running pmm in production at tessi
SMART_READER_LITE
LIVE PREVIEW

Running PMM in Production at Tessi Valentin Traen, Jonathan Gourdon, - - PowerPoint PPT Presentation

Feb 16, 2023 558 likes •915 views

Running PMM in Production at Tessi Valentin Traen, Jonathan Gourdon, Michael Coburn Tessi, Percona Whats New in PMM2? New performance and usability query improvements. New query analytics for PostgreSQL. New labeling with

slide-1
SLIDE 1

Running PMM in Production at Tessi

Valentin Traen, Jonathan Gourdon, Michael Coburn Tessi, Percona

slide-2
SLIDE 2

What’s New in PMM2?

  • New performance and usability query improvements.
  • New query analytics for PostgreSQL.
  • New labeling with Leverage Standard (system-generated) and Custom tags.
  • New administrative API.
  • New service-level dashboards.
  • Enhanced security protocols to ensure data is safe.
2
slide-3
SLIDE 3

Why You Should Upgrade to PMM2

  • Still (and always) free and open source.
  • A single pane of glass.
  • An enhanced version of our award-winning database monitoring tool.
  • Keeps your revenue engine up and running.
  • Spend less time managing complex environments.
  • Speed up development.
  • Improve the quality of your releases and applications.
  • Enterprise-ready.
3
slide-4
SLIDE 4

4

ABOUT THE PRESENTATION

ABOUT TESSI CUSTOMIZATION AUTOMATED DEPLOYMENT REASON TO MIGRATE TO PMM

slide-5
SLIDE 5

TESSI

01 /

5

slide-6
SLIDE 6

6

Tessi, Business Process Services

slide-7
SLIDE 7

MIGRATE TO PMM

02 /

7

slide-8
SLIDE 8

PROCESS

8

MIGRATE TO PMM

Improve MySQL monitoring 6 Months project 3 Members Production Ready

300+ Instances POC Acceptance test Customization Deployment Automated Deployment

slide-9
SLIDE 9

9

MIGRATE TO PMM

Symptom Oriented Don’t know how application works / Hard to debug Focuses on availability & response time Does not expose Application-level metrics WHAT WE HAD

REASON TO MIGRATE TO PMM

slide-10
SLIDE 10

10

MIGRATE TO PMM

Combine Server & Application metrics Capacity Planning / Find under & over resource utilization Detect Both Hardware & Software Potential Problems Database Queries monitoring WHAT WE WANT

REASON TO MIGRATE TO PMM

slide-11
SLIDE 11

11

MIGRATE TO PMM

PROMETHEUS GRAFANA OPEN SOURCE STACK MULTIPLE DATABASES TECHNOLOGIES HIGHLY CUSTOMIZABLE NOT CLOUD BASED EASY TO SETUP OBSERVABILITY COMBINE SERVERS & DB METRICS DETECT SATURATION / ERRORS SPEEDS UP TROUBLESHOOTING & QAN WHAT WE GOT

slide-12
SLIDE 12

LIMITATIONS

12

MIGRATE TO PMM

Single Docker Container Scalabily & Flexibility Requires an Agent

slide-13
SLIDE 13

CUSTOMIZATION

03 /

13

slide-14
SLIDE 14

CUSTOMIZATION OF HOME DASHBOARD : ALL YOU NEED TO KNOW ON YOUR SCREEN

14

PMM

Dashboard id : 10583

Features :

  • MySQL Instance

state

  • Global SWAP/RAM

usage

  • QAN enabled

instances

  • Number of

instances/clusters

  • MySQL versions
  • Disk usage
slide-15
SLIDE 15

USE VARIABLES TO GROUP YOUR INSTANCES

15

PMM

  • Grouping by

database name

  • Custom metric
slide-16
SLIDE 16

DON’T FORGET TO PERSONNALIZE YOUR QUERIES-MYSQLD.YML

16

PMM

mysql_custom_metric_get_schema_name: query: "SELECT SCHEMA_NAME,0 AS VALUE FROM information_schema.SCHEMATA;" metrics:

  • SCHEMA_NAME:

usage: "LABEL" description: "The name of the MySQL schema"

  • VALUE:

usage: "GAUGE" description: "Fixed value"

valentinmysql (repository : MYSQL_PMM-Custom-YAML)

slide-17
SLIDE 17

THE COMMUNITY IS NECESSARY

17

PMM

Status Dot by btplc

slide-18
SLIDE 18

GROUP REPLICATION DASHBOARD

18

PMM

Dashboard id : 10006

Features :

  • Node state
  • Node role
  • Automatic cluster

enrolment

  • MySQL Router server

name

slide-19
SLIDE 19

TAG : A POWERFUL FEATURE

19

PMM

slide-20
SLIDE 20

CHECK YOUR RAM USAGE ADJUST YOUR SERVER RESOURCES

20

PMM

Dashboard id : 10654

Based on https://www.abhinavbit.com/p/mysql-memory-calculator.html
slide-21
SLIDE 21

CHECK YOUR RAM USAGE ADJUST YOUR SERVER RESOURCES

21

PMM

Dashboard id : 10654

slide-22
SLIDE 22

LET YOUR DBA CHANGE THE CONFIGURATION OF YOUR INSTANCE …

22

PMM

slide-23
SLIDE 23

LET YOUR DBA CHANGE THE CONFIGURATION OF YOUR INSTANCE …

23

PMM

slide-24
SLIDE 24

AUTOMATION

04 /

24

slide-25
SLIDE 25

25

AWX

DYNAMIC INVENTORY

ANSIBLE

PULL CUSTOMIZATION FROM GIT GIT PROJECT DEPLOYMENT

AUTOMATION

PMM Server MySQL Servers

slide-26
SLIDE 26

26

RELEASE IRM TEST DEPLOY OPERATE

CONTINUOUS INTEGRATION & DEPLOYMENT

AUTOMATION

Include PMM to our CI/CD workflow

slide-27
SLIDE 27

27

  • name: Search Host in PMM API

uri: url: "https://{{ pmm_server_url }}/{{ pmm_qan_api.instances }}" method: GET status_code: 200 body_format: json return_content: yes register: instances_list

  • name: Search Host in Json Response

set_fact: server_instances: "{{ instances_list.json | json_query(query) }}" vars: query: "[?Name=='{{ ansible_hostname }}'].Name" QAN INTEGRATION EXAMPLE

AUTOMATION

slide-28
SLIDE 28

BEST PRACTICES

28

AUTOMATION

CREATE ATOMIC ROLES NAME ALL TASKS, NAME IT RIGHT ! DO NOT EDIT CONFIGURATION FILES, MANAGE THEM THROUGH TEMPLATES IDEMPOTENCY CREATE TESTING LIFECYLCE & STAGE ENVIRONMENTS

slide-29
SLIDE 29

29

  • Readme.md for each role
  • Should include:
  • Name
  • Description
  • Dependencies
  • Variables
  • Examples
  • Author
  • Automate Build & Deploy Docs
  • Based on Readme.md
  • Using GITLAB Pipelines

CREATE DOCUMENTATION FOR EACH ROLE

AUTOMATION

slide-30
SLIDE 30

WHAT’S NEXT ?

05 /

30

slide-31
SLIDE 31

WHAT’S NEXT ?

31

PMM

Upgrade to PMM 2.0 Explore PMM Plugins Improve Alert Manager

slide-32
SLIDE 32

Follow Us

slide-33
SLIDE 33

Rate My Session

33
slide-34
SLIDE 34

We’re Hiring!

34

Percona’s open source database experts are true superheroes, improving database performance for customers across the globe. Our staff live in nearly 30 different countries around the world, and most work remotely from home. Discover what it means to have a Percona career with the smartest people in the database performance industries, solving the most challenging problems our customers come across.