pmm2_client

Ansible role: pmm2_client

Ansible role that installs and configures Percona Monitoring and Management client version 2. Currently only mysql client service supported. For mysql, persistence of configuration variables is only supported for version > 8.0. Otherwise, you should add options manually into your server configuration file as described in documentation.

Requirements

Ansible 2.5.0 or higher.

Role Variables

Name	Default Value	Description
`pmm2_client_server_user`	admin	PMM server user name
`pmm2_client_server_password`	admin	PMM server user password
`pmm2_client_server_host`	localhost	PMM server host
`pmm2_client_server_port`	443	PMM server port
`pmm2_client_node_address`		Node address (autodetected by pmm-admin if not defined)
`pmm2_client_node_type`		Node type, one of: generic, container (default to generic by pmm-admin if not defined)
`pmm2_client_node_name`		Node name (autodetected by pmm-admin if not defined)
`pmm2_client_disable_log`	false	Disable logging to prevent littering system log file
`pmm2_client_enabled_services`	[]	List of services to configure. Currently only "mysql" is supported.
`pmm2_client_mysql_login_user`	root	Mysql instance login user.
`pmm2_client_mysql_login_password`	root	Mysql instance user password.
`pmm2_client_mysql_login_host`	localhost	Mysql instance host.
`pmm2_client_mysql_login_port`	3306	Mysql instance port.
`pmm2_client_mysql_enable_tls`	false	Mysql enable TLS connection to mysql database.
`pmm2_client_mysql_create_user`	true	Mysql create PMM user in mysql instance.
`pmm2_client_mysql_user`	pmm	Mysql user name for PMM user.
`pmm2_client_mysql_password`	pmm	Mysql password for PMM user.
`pmm2_client_mysql_host`	%	Mysql allowed hosts for PMM user.
`pmm2_client_mysql_privileges`	.:SELECT,PROCESS,SUPER,REPLICATION CLIENT,RELOAD	Mysql privileges defined for PMM user.
`pmm2_client_mysql_query_source`	perfschema	Mysql the query source. Currently only "perfschema" is supported
`pmm2_client_mysql_enable_query_response_time`	true	Enable query response time metrics for mysql
`pmm2_client_mysql_disable_tablestats`	false	Disables tablestats collection when the default limit is reached (mysql)
`pmm2_client_mysql_disable_tablestats_limit`	1000	Number of tables for which tablestats collection is disabled. 0 means no limit. (mysql)
`pmm2_client_mysql_enable_user_statistics`	true	Enable user statistics for mysql

Example Playbook

An example playbook that installs and conigures pmm-client with mysql service:

- hosts: mysql-servers
  vars:
    pmm2_client_server_host: instance-pmm-server
    pmm2_client_server_user: admin
    pmm2_client_server_password: admin
    pmm2_client_enabled_services:
      - mysql
    pmm2_client_mysql_login_host: instance-mysql
    pmm2_client_mysql_login_user: root
    pmm2_client_mysql_login_password: root
  roles:
     - harloprillar.pmm2_client

License

MIT

About

Percona Monitoring and Management 2 client for Debian based and Red Hat based distributions

role database monitoring percona pmm2

Install

ansible-galaxy install harloprillar/ansible-pmm2-client

GitHub repository

2 stars

3 forks

0 open issues

License

Unknown

Downloads

122

Owner

harloprillar