MySQL monitoring by New Relic

Support: Full-Stack Observability (FSO) Infrastructure
#1

i am seeking for help to monitory mysql db and apache server in ubuntu 18.04 by newrelic.

I am not able to install and configure mysql on ubuntu 18.04 for newrelic, can someone please help me
#2

Hello, @siddharth: What help do you need? Have you installed the MySQL monitoring integration?

#3

i am not able to install and configure mysql on ubuntu 18.04 for newrelic, can someone please help me

#4

What have you tried? What problem are you having? Do you get an error? What does it say?

#5

nstances:

  • name: mysql-server
    command: status
    arguments:
    hostname: localhost
    port: 3306
    username: newrelic
    password: newrelic123

    extended_metrics: 1
extended_innodb_metrics: 1
extended_myisam_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: write-replica

#6

this is my conf file

#7

curl -s https://download.newrelic.com/infrastructure_agent/gpg/newrelic-infra.gpg | sudo apt-key add
echo “license_key: [redacted]” | sudo tee -a /etc/newrelic-infra.yml
printf “deb [arch=amd64] https://download.newrelic.com/infrastructure_agent/linux/apt bionic main” | sudo tee -a /etc/apt/sources.list.d/newrelic-infra.list &&
sudo apt-get update
sudo apt-get install newrelic-infra -y

++++++++++
after logiin in mysql
CREATE USER ‘newrelic’@‘localhost’ IDENTIFIED BY ‘newrelic123’;
GRANT REPLICATION CLIENT ON . TO ‘newrelic’@‘localhost’ ;
cd /etc/newrelic-infra/integrations.d
sudo cp mysql-config.yml.sample mysql-config.yml

And below is my fileinstances:

  • name: mysql-server
    command: status
    arguments:
    hostname: localhost
    port: 3306
    username: newrelic
    password: newrelic123

    extended_metrics: 1
extended_innodb_metrics: 1
extended_myisam_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: write-replica

i have not found any error message. i am still not able to see mysql in portal

#8

Hey @siddharth, I think it would be best to collect some Verbose logs from the agent to check for errors. What you want to search for there is stderr= and anything that includes mysql. If you find anything and want to share here please do, or you can DM me directly if you don’t want those logs public :slight_smile: