MySQL schema

Feature

MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime, etc

Configure

DB Installation: MySQL Database

Use version 5.7 or higher. Follow below steps for installation

Linux:

• sudo apt update

• sudo apt install mysql-server

• sudo systemctl status mysql

• If a specific version needs to be installed download .deb package from https://downloads.mysql.com/archives/community/

• Then run – dpkg -i <package_name>

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

Centos/RHEL:

• sudo yum update

• sudo yum install wget

• wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

• sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

• sudo yum install mysql-server

• sudo systemctl start mysqld

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 Germain Service 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: