Is it mandatory for the database to be installed on the same server on which the application is inst

Description

OpsHub Integration Manager supports 4 types of databases: HSQL, MYSQL, MSSQL, ORACLE, PostgreSQL. Among these, HSQL is the in-built database provided with OpsHub Integration Manager. However, you can use one of the other external databases like MYSQL, MSSQL, ORACLE, or PostgreSQL. So in such case, is it necessary to install the OpsHub Integration Manager on the same machine where the database is hosted?

Solution

It is not mandatory to have the database on the same machine where OpsHub Integration Manager is installed. They can reside on different machines as long as database pre-requisites and hardware pre-requisites are fulfilled for them. The machine on which OpsHub Integration Manager is installed should be able to access the machine on which the database has been placed. It is better to have strong connectivity to the database machine to ensure smooth performance of OpsHub Integration Manager.

Note: Installation of OpsHub Integration Manager with HSQL database will automatically create the database on the same machine, as HSQL is the default embedded database of OpsHub Integration Manager.