Create germain APM Database

Contact support@germainAPM.com to get database instance creation scripts

DB Installation: MySQL Database

Use version 5.7 or higher. Follow below steps for installation

Linux:

It should show the status as runnning. Then you can connect to MySQL from command line using “mysql -u root”

Centos/RHEL:

It should show the status as running. Then you can connect to MySQL from command line using “mysql -u root” (password root)

Windows:

  • Download MySQL Installer from https://dev.mysql.com/downloads/installer/ and execute it.
  • Choose the appropriate setup type typically Developer Default to install MySQL server and choose MySQL Workbench from development tools.
  • Complete the installation wizard.

 Schema Installation: MySQL Database

 Once you have MySQL you can run the SQL scripts which will generate the required schemas and tables.

  • Extract GermainAPMService release file (to be referred to as $SERVICE_HOME)
  • Open "$SERVICE_HOME/install/databases/readme.txt"
  • Go to "$SERVICE_HOME/install/databases/mysql"
  • Edit "$SERVICE_HOME/install/databases/mysql/basic-setup.sql" Please update passwords where you see "identified by 'apm_datamart'" or "identified by 'apm_config'" accordingly
  • Execute the SQL scripts one at a time in sequence specified in "$SERVICE_HOME/install/databases/readme.txt"
    • Run basic-setup.sql – This will create 2 databases as apm_config and apm_datamart with its users as apm_config/apm_config and apm_datamart/apm_datamart
    • Run config-*.sql by selecting the apm_config database (refer screenshot on Selecting DB below)
    • Run datamart-*.sql by selecting the apm_datamart database (refer to screenshot on Selecting DB Below)

Selecting DB:

Double click "apm_config" and it will show selected by it text being bold like below:

Schema Installation: Oracle Database

Note: It is recommended to run SQL scripts from SQLDeveloper or other 3rd party SQL client tools.  With sqlplus they can fail due to blank lines in the INSERT statements.

  • Extract GermainAPMService release file (to be referred to as $SERVICE_HOME)
  • Open "$SERVICE_HOME/install/databases/readme.txt"
  • Go to "$SERVICE_HOME/install/databases/oracle"
  • Edit "$SERVICE_HOME/install/databases/oracle/basic-setup.sql" Please update passwords "xxxx" accordingly before running the script.
  • Run SQL scripts in sequence specified in "$SERVICE_HOME/install/databases/readme.txt":
    • For file basic-*.sql, run logged in as sysdba
    • For config-*.sql", run logged in as APM_CONFIG
    • For datamart-*.sql, run logged in as APM_DATAMART

Schema Installation: Other Databases

For other databases (contact germain support team, info above)