ManageEngine Applications Manager High Availability setup with dual database (MySQL).
Apart from the Failover setup, which uses a single database and dual Application Server, we also support a failover with dual database and Application Server. Failover support requires you to configure Applications Manager Secondary (Standby server) and keep monitoring the Applications Manager Primary server.
In case of failure in the Primary server, the Standby server automatically starts monitoring the network. The transition is so quick and smooth that the end user does not feel the impact of the failure of the Primary server or the subsequent taking over by Standby. In parallel, the Standby server also triggers an email alert about the Primary's failure.
Once the Primary server is restored back to operation, the Standby server automatically goes back to standby mode. We use MySql’s built-in replication feature to sync the data from the primary to secondary database.
For steps to set up the failover with dual database, please refer this PDF.
How to view data under Session & Performance tab in MySQL monitor?
Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell: show databases; If the output does not contain the SYS database, then install the SYS database suitable for the ...
Maintenance of Applications Manager
Applications Manager with MySQL database Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission. If using command prompt, navigate to <Applications Manager Home> directory and execute ...
Connecting to Applications Manager's bundled database
How can I connect to Applications Manager's back-end database? Note: Take a backup of the AppManager directory before modifying anything in the database. Check am.dbserver.type value in <Applications Manager Home>\conf\AMServer.properties file to ...
Error message while performing database backup of Applications Manager
While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables. pg_dump: WARNING: out of shared ...
How can I fine tune Applications Manager Java & MySQL/ PgSQL?
Here is how: 1.) Windows: a.) Open the wrapper.conf file from AppManagerHome\working\conf directory using WordPad (Run as Administrator) and change the Java memory values as below # Initial Java Heap Size (in MB) ...