Forum Discussion

Mike_Aracic's avatar
Mike_Aracic
Icon for Employee rankEmployee
14 years ago

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

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 way the clones of the datasources will associate with the hosts, and the datasources will use the application-specific custom substitution tags. Let me know if you need more information.

2 Replies

Sort By
Replies have been turned off for this discussion
  • John's avatar
    John
    14 years ago

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

  • Mike_Aracic's avatar
    Mike_Aracic
    Icon for Employee rankEmployee
    14 years ago

    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.