[ MySQL ] Percona server

  • Percona server mysql
  • PMM ( Percona monitor and management )
    • install PMM client
yum install pmm-client
  • configure MySQL to be appropriate with PMM

add some parameters ( varied based on version )

  • configure PMM client
pmm-admin config ...

pmm-admin add mysql:metrics ...
  • verify if it is working
pmm-admin list

How to remove 

step 1)

pmm-admin purge

step 2) remove instance

pmm-admin rm

How to update PMM

  1. remove docker and download the new one

NOTE on DB : 

  • master / slave for online
  • backup
  • sponsor / data science ( dump data from GA every day . different login )
  • DR : Disaster recovery

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s