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.
New to ADSelfService Plus?
Related Articles
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 ...Unable to upgrade Applications Manager - MySQL Deprecation
Problem: You encounter the following error while trying to install service pack for Applications Manager v16140 and above: Reason: This error occurs because MySQL backend database has been deprecated in Applications Manager. Solution: You have to ...Failover support in Applications Manager
Failover is an alternate Application High availability (HA) mode that facilitates automatic switching to a secondary/ backup server, database, or network when the primary system breaks down, or is unavailable due to maintenance. Configuring failover ...Maintenance of Applications Manager backend database
Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers
Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Solution: To overcome this issue follow the steps given below: Execute the following query in the corresponding MySQL shell script: ALTER USER ...