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

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)