How to install Sys Database on Maria DB Server?
Issue:
Solution:
- Download the MariaDB-sys from the GitHub using this link
- Extract the downloaded zip.
- Based on your MariaDB version open the corresponding file [ sys_56.sql, sys_57.sql, sys_10.sql ]
- Change all the relative path entries to static path entries as mentioned below.
Example: - Relative path: SOURCE ./before_setup.sql
- Actual path: SOURCE D:/mariadb-sys-master/before_setup.sql
- You need to change all the entries in that file.
- Open a terminal/prompt where your file has been located.
- Execute the following command to install sys DB
Example: The file name is based on your Maria DB server version.mysql -u root -p < ./sys_10.sql - Login into Maria DB server and check sys DB will be installed
- Poll the monitor for a couple of times in the Applications Manager to view required data.
Note:
Check whether performance_schema is enabled or not to view session and performance tab data.
New to ADSelfService Plus?
Related Articles
Migrate from Standalone APM server to Plugin server
Please note that these steps can be followed only if your OpManager version is 127104 or above. Migration Steps from Standalone Server To Plug-In Server: In the standalone server, go to AppManager\bin directory and run BackupConfig.bat\.sh file to ...Issues while installing or starting Applications Manager with Microsoft SQL Server backend database
Problem: Unable to install or start Applications Manager using Microsoft SQL Server database as backend. Solution: Follow the below troubleshooting steps to resolve the issue: 1. On the Microsoft SQL server host, go to Start -> All Programs -> ...How is Backup Age calculated for MS SQL DB monitor?
Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...How do I migrate the MS SQL DB used by Applications Manager to another MS SQL server?
Follow the steps given below to migrate MS SQL database of Applications Manager to another MS SQL server: 1. Shutdown Applications Manager completely before the database migration. a. Stop Applications Manager service. b. Shutdown Applications ...How can I update the server IP in the database?
Follow these steps to update the server IP in the database: 1) Execute <AppManager_Home>\bin\troubleshooting\UpdateIP.bat file with the old and new hostname as arguments. For example, updateIp.bat [mysql port] [previous IpAddress] [new ...