MySQL Database

Feature

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

Deployment

Use version 5.7 or higher.

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 (password 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

You can then download https://www.mysql.com/products/workbench/ to connect to MySQL.

Configuration

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)