Skip to main content
Skip table of contents

MySQL Database Setup


Germain supports MySQL as its datastore, providing users with a reliable and scalable solution for managing their data. In particular, MySQL Cluster is a powerful option that addresses the challenges of modern web, cloud, and communications services. MySQL Cluster offers the following benefits:

  1. Scalability: MySQL Cluster allows you to scale your database horizontally by distributing the data across multiple nodes. This enables you to handle increasing data volumes and user traffic while maintaining high performance.

  2. High Availability: With MySQL Cluster, your data is automatically replicated across multiple nodes, ensuring that it remains available even in the event of node failures. This high availability feature minimizes downtime and provides continuous access to your data.

  3. Performance: MySQL Cluster is designed for high-performance applications. It leverages in-memory storage and parallel processing to deliver fast response times, making it suitable for demanding workloads and real-time applications.

  4. Fault Tolerance: MySQL Cluster provides built-in fault tolerance mechanisms to protect your data. It can automatically detect and recover from node failures, ensuring data integrity and minimizing the impact on your applications.

  5. Flexibility: MySQL Cluster supports a wide range of data types and indexing options, allowing you to model and query your data in a way that suits your application requirements. It also supports SQL, making it compatible with existing applications and tools.

By choosing MySQL Cluster as the datastore for Germain, you can leverage its capabilities to handle large amounts of data, deliver high availability, ensure performance, and achieve fault tolerance. This enables you to build robust and scalable applications that meet the needs of your business.


Use version 5.7 or higher.


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


  • sudo yum update

  • sudo yum install wget

  • 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  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 to connect to MySQL.


 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)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.