Locked
Discussion interactions are currently paused.
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.
Mike_Aracic
OP14 years agoIf 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.
John
·14 years agoBoth the MySQL and PostgreSQL monitoring configurations require dbname to be set, yet the values for dbname need to be different.