MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime, etc
DB Installation: MySQL Database
Use version 5.7 or higher. Follow below steps for installation
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”
sudo yum update
sudo yum install wget
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)
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)
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)
Double click "apm_config" and it will show selected by it text being bold like below: