How to install Sys Database on Maria DB Server?

How to install Sys Database on Maria DB Server?

Issue:
Solution:
  1. Download the MariaDB-sys from the GitHub using this link
  2. Extract the downloaded zip.
  3. Based on your MariaDB version open the corresponding file [ sys_56.sql, sys_57.sql, sys_10.sql ]
  4. Change all the relative path entries to static path entries as mentioned below.
    Example: 
    1. Relative path: SOURCE ./before_setup.sql
    2. Actual path: SOURCE D:/mariadb-sys-master/before_setup.sql
    3. You need to change all the entries in that file.
  5. Open a terminal/prompt where your file has been located.
  6. 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
  7. Login into Maria DB server and check sys DB will be installed
  8. 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

                    • 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 ...
                    • 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 ...
                    • Troubleshoot - RUM Agent silent installation

                      RUM Agent silent installation can fail on various factors based on your environment, troubleshoot with the help of error message shown while running the script. Below are the list of the error messages thrown from the script and its troubleshooting ...
                    • 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 -> ...
                    • Steps to configure AWS RDS database as Applications Manager's back-end

                      Browse through the following topics to configure AWS RDS as a database backend in Applications Manager: Note: Make sure to verify the DB permissions required to run Applications Manager. Learn more Steps to configure AWS RDS - PostgreSQL database The ...