• 0
Sign in to follow this  
John

How can I monitor 2 database systems on the same server?

Question

  • 0

Both the MySQL and PostgreSQL monitoring configurations require dbname to be set, yet the values for dbname need to be different.

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Both the MySQL and PostgreSQL monitoring configurations require dbname to be set, yet the values for dbname need to be different.

Share this post


Link to post
Share on other sites
  • 0

If youd like to be able to support 2 distinct databases on the same host, its possible to create custom properties (which could be applied at the portal, group, or host level to the desired hosts) called: jdbc.mysql.dbname and jdbc.postgres.dbnamen

nThen clone your existing postgres and mysql datasources and do the following to the clones: add && hasproperty(jdbc.mysql.dbname) or && hasproperty (jdbc.postgres.dbname) to the Applies to field and replace the DBNAME tokens with jdbc.mysql.dbname or jdbc.postgres.dbnamen

nThis will associate the cloned datasources only with hosts that have the proper custom properties and ensure make those cloned datasources use the new tokens. Let us know if you need help with this.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this