Install & configure NRDOT for MySQL monitoring with Ansible

Prerequisites

• A New Relic account with a valid license key.
• A New Relic account ID.
• MySQL 5.7 or later.
• Ansible Core 2.13 or 2.14, Python 3.10, and the ansible.windows and ansible.utils collections.
• A Linux collector host running Debian/Ubuntu or RHEL/CentOS.
• For self-hosted MySQL: administrative access to your MySQL server (the root account or equivalent), using password-based authentication.
• For MySQL or Aurora on AWS RDS: network connectivity from the collector host to the RDS endpoint, and the RDS master username and password.
• Network connectivity to New Relic OTLP endpoint for your region.

For detailed requirements, refer to Compatibility and prerequisites.

Install the role

$
ansible-galaxy install newrelic.newrelic_install

Make sure the required collections are also installed:

$
ansible-galaxy collection install ansible.windows ansible.utils

Configure the playbook

- name: Install New Relic NRDOT for MySQL
  hosts: all
  roles:
    - role: newrelic.newrelic_install
  vars:
    targets:
      - mysql-otel
  environment:
    NEW_RELIC_API_KEY: <API key>
    NEW_RELIC_ACCOUNT_ID: <Account ID>
    NEW_RELIC_REGION: <Region>
    NR_CLI_MYSQL_CONFIG_PRESET: <1 Basic, 2 Advanced, default 1>
    NR_CLI_MYSQL_INSTANCES_FILE: <path to the instances YAML file on the target host>
    NR_CLI_MYSQL_SECRETS_FILE: <path to the secrets file (KEY=VALUE per instance) on the target host>

$
mysql -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';"

- name: Install New Relic NRDOT for MySQL on RDS
  hosts: all
  roles:
    - role: newrelic.newrelic_install
  vars:
    targets:
      - mysql-otel-rds
  environment:
    NEW_RELIC_API_KEY: <API key>
    NEW_RELIC_ACCOUNT_ID: <Account ID>
    NEW_RELIC_REGION: <Region>
    NR_CLI_MYSQL_CONFIG_PRESET: <1 Basic, 2 Advanced, default 1>
    NR_CLI_MYSQL_INSTANCES_FILE: <path to the instances YAML file on the target host, using RDS endpoints as host>
    NR_CLI_MYSQL_SECRETS_FILE: <path to the secrets file (KEY=VALUE per instance) on the target host>

Run the playbook

$
ansible-playbook -i <inventory_file> <playbook_file>.yml

Find and use your data

Once your data is being collected, you can access comprehensive MySQL database monitoring through the New Relic UI.

To find your MySQL database entity in New Relic:

1. Go to one.newrelic.com > All capabilities > Databases.
2. From the Entity type dropdown, select MySQL instance, then click Apply.
3. Select your MySQL database from the list of entities.