MySQL monitoring by New Relic

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

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

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

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

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

this is my conf file

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

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: