Setting up MySQL Monitoring With New Relic Infrastructure Pro

• New Relic Infrastructure: Flexible, dynamic monitoring of your entire infrastructure, from services running in the cloud or on dedicated hosts, to containers running in orchestrated environments.
• New Relic Alerts: A flexible, centralized notification system that unlocks the operational potential of New Relic. Alerts is a single tool to manage alert policies and alert conditions for all of your New Relic data.
• New Relic Logs: A fast, scalable log management platform that allows you to connect your log data with the rest of your telemetry data.
• New Relic Insights: Allows you to query and chart your New Relic data. Insights is a software analytics resource for gathering and visualizing data about your software, and understanding what that data says about your business.

New Relic infrastructure agent install

# Create a configuration file and add your license key 
 echo "license_key: xxxxxxxxxxxxxxxxxxxxxx" | sudo tee -a /etc/newrelic-infra.yml && 
 # Create the agent’s yum repository 
 sudo curl -o /etc/yum.repos.d/newrelic-infra.repo https://download.newrelic.com/infrastructure_agent/linux/yum/el/7/x86_64/newrelic-infra.repo && 
 # Update your yum cache 
 sudo yum -q makecache -y --disablerepo='*' --enablerepo='newrelic-infra' && 
 # Run the installation script 
 sudo yum install newrelic-infra -y

license_key: 1db211983ab4871600faef016f5235066f208fd5 
 display_name: mysql-qa-usw-a-1
 verbose: 0
 custom_attributes:
  env: QA
  app: MySQL
  team: Pythian

sudo yum -q makecache -y --disablerepo='*' --enablerepo='newrelic-infra'
 sudo yum install nri-mysql

mysql> CREATE USER 'newrelic'@'localhost' IDENTIFIED BY 'YOUR_SELECTED_PASSWORD';
 
 mysql> GRANT REPLICATION CLIENT ON *.* TO 'newrelic'@'localhost' WITH MAX_USER_CONNECTIONS 5

# Change the directory to the integration's folder.
 cd /etc/newrelic-infra/integrations.d
 # Copy the sample configuration file:
 sudo cp mysql-config.yml.sample mysql-config.yml
 # Edit the file mysql-config.yml as shown below substituting the hostname, user, password:
 vi /etc/newrelic-infra/integrations.d/mysql-config.yml

integration_name: com.newrelic.mysql
 instances:
  - name: mysql-server
  command: status
  arguments:
   hostname: localhost
   port: 3306
   username: newrelic
   password: xxxxxxxxxxx
   extended_metrics: 1
   extended_innodb_metrics : 1
   # New users should leave this property as `true`, to identify the
   # monitored entities as `remote`. Setting this property to `false` (the
   # default value) is deprecated and will be removed soon, disallowing
   # entities that are identified as `local`.
   # Please check the documentation to get more information about local
   # versus remote entities:
   # https://github.com/newrelic/infra-integrations-sdk/blob/master/docs/entity-definition.md
   remote_monitoring: true
  labels:
   env: production
   role: Master

systemctl restart newrelic-infra.service