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)