Introducing Database Monitoring with the DBmarlin integration

DBmarlin has partnered with New Relic to make it easier to monitor the functionality and performance of your databases alongside the rest of your observability data. DBmarlin sends database performance data, including database time, top SQL statements and top wait events, to New Relic, so you can see when database slowdowns occur and what is causing them.

All New Relic users can claim a free premium copy of DBmarlin here, that can be applied to any supported database.

Benefits include:

  • See the full picture of your application health with visibility into your databases by combining the power of DBmarlin with New Relic DBmarlin monitors database performance, tracks changes and helps your databases run fast.
  • DBmarlin provides an easy-to-use and consistent way to monitor CockroachDB, DB2, MariaDB, MySQL, Oracle, PostgreSQL and SQL Server, self-hosted or in the cloud.
  • DBmarlin captures SQL statement text and wait events so you can see exactly where the time is spent executing SQL within your database.
  • DBmarlin auto-detects changes to schema objects, database parameters and execution plans so you can see their impact on performance.

How to get started:

Follow the steps below or go to this docs page for instructions.

Configure the integration in DBmarlin:

Before installing the integration you’ll need to connect DBmarlin and New Relic, it is necessary to install DBmarlin first.

Send your database performance data from DBmarlin (v2.7 and above) to New Relic to view database performance data from within a New Relic quickstart dashboard.

DBmarlin pushes data to New Relic and needs to know the connection details. These parameters may be entered using the following curl scripts on Linux. Use equivalent commands if you are on Windows. The commands assume you are on the DBmarlin server. If you are running the commands remotely, substitute http://localhost:9080 for the hostname and port (typically 9090) of your DBmarlin installation. If you have enabled authentication in Nginx then you may also need to provide -u username:password to the curl commands.


curl -X POST 'http://localhost:9080/archiver/rest/v1/parameter' -H 'Content-Type: application/json' -d '[{"name":"newrelic.url","value":"<your-newrelic-url>"}]'

curl -X POST 'http://localhost:9080/archiver/rest/v1/parameter' -H 'Content-Type: application/json' -d '[{"name":"newrelic.account","value":"<your-newrelic-account-number>"}]'

curl -X POST 'http://localhost:9080/archiver/rest/v1/parameter' -H 'Content-Type: application/json' -d '[{"name":"newrelic.apikey","value":"<your-newrelic-apikey>"}]'

curl -X POST 'http://localhost:9080/archiver/rest/v1/parameter' -H 'Content-Type: application/json' -d '[{"name":"newrelic.dbmarlin.url","value":"<your-dbmarlin-url>"}]'

curl -X POST 'http://localhost:9080/archiver/rest/v1/parameter' -H 'Content-Type: application/json' -d '[{"name":"newrelic.enable","value":"true"}]'

Don’t forget to substitute your values in the “value” fields.

  • The newrelic.url parameter should either be https://insights-collector.newrelic.com or https://insights-collector.eu01.nr-data.net if you are in Europe.
  • The newrelic.account is the account number for your New Relic account.
  • The newrelic.apikey is the API key from your New Relic account (docs here for more info).
  • The newrelic.dbmarlin.url parameter links the DBmarlin quickstart dashboard back to the DBmarlin UI. It should include the protocol, for example, http://my-dbmarlin-host:9090.

Copy the New Relic WAR file

The final step of the DBmarlin configuration is to copy the New Relic WAR file from the extras directory under the DBmarlin installation into the tomcat/webapps directory.


cp extras/newrelic##2.1.war ./tomcat/webapps/

Tomcat should automatically expand the WAR file and, if the configuration parameter newrelic.enable has to be set to true, will start pushing DBmarlin data to New Relic. You can set newrelic.enable to false if you would like to stop sending data.

Configure New Relic:

To get the pre-configured dashboard to visualize and monitor your data in New Relic:

  1. Start by visiting the Dbmarlin quickstart for New Relic.

  2. Click install now. If you are already logged in, you will continue to the New Relic platform to confirm your quickstart installation. If you are not logged in or do not have an account, follow the instructions to sign up.

  3. Once you are in the confirmation page, select an account and select Begin installation.

  4. In the Installation plan page, select Done if you have already followed the steps in the Configure the integration in DBmarlin and Copy the New Relic WAR file sections above.

  5. Select “See your data”

See data in New Relic:

Once the steps above have been completed, you should see DBmarlin data in your New Relic dashboard like this.

New Relic DBmarlin dashboard

Have questions or need support? Contact us at support@dbmarlin.com

4 Likes