Configurator for MySQL Cluster - version 4.2.0

  • General Settings
  • Configure Storage
  • Configure Directories
  • Review Config
  • Complete

For 'localhost' installation, please use the Cluster Sandbox.

Check out the movie how install MySQL Cluster.

General Cluster Setttings

  • Follow the documentation on the last page of this Configurator (and print that page as it contains important information for reference)
  • Installation: tar xvfz mysqlcluster-73.tar.gz; cd mysqlcluster-73/cluster/scripts/install; ./deploy.sh 2>&1 |tee cc.log
  • Configuration parameters are tuned for most use cases, but further tuning may be needed (also we are continously improving the defaults used in this Configurator).
  • Contact feedback@severalnines.com if you have any problems or if something is missing, or in any case we would love to hear from you.

In the next pages you will be able to select a few properties of your installation.
Please let us know of any issues on support.severalnines.com.

Version and Platform

Cluster version: We recommend MySQL Cluster 7.3 for general purpose.
  • MySQL Cluster 7.3 is GA. Recommended. Fast joins, better connection management, foreign keys, and a lot more.
Platform Platform must be homogenous across all computers in the cluster.
Infrastructure: The scripts will be generated in a way that is suitable for the selected provider.
  • Amazon EC2 - you will be able to specify the keypair so that you can ssh without passwords.
  • OpenShift/Amazon EC2 - RPM install is not possible - there are many conflicts with packages already installed on the OpenShift platform.
  • On-premise/Rackspace - you will be able to automatically generate shared ssh keys for passwordless ssh.
  • Operating System Very important to select the version matching your OS! Operating System must be homogenous across all computers in the replication cluster.
    • Fedora 16 does not work yet due to dependency problems with php-mysql.
    • Debian 6.0.4 has been reported to cause problems
    Do you use RPMs to install MySQL Cluster? The Deployment Package will automatically download the necessary RPMs/TARs.
     

    Cluster - number of nodes and replication

    Number of management servers Two management servers are recommended in a HA setup.
    Number of Data Nodes:
    1. You should have at least two computers (for two data nodes).
    2. A minimal HA setup consists of four computers: 2 computers for data nodes and two computers for mysqlds and management servers.
    Number of APIs (sql nodes, slapds): You should have at least two mysql servers for a HA setup. Hint: You can co-locate management servers and SQL Nodes (mysql servers)!
    Replication role:
    1. None - the cluster will not replicate to another cluster
    2. Master - the cluster will act as the replication master (one or more mysqlds will produce binary logs)
    3. Slave - the cluster will act as a slave/backup cluster
     

    Ports and User

    OS User
    • root - enter 'root' if you have root credentials
    • if you use 'sudo' to execute system commands, then specify the username you wish to use here (e.g, ec2-user, ubuntu, bob, alice).
    PortNumber This is the port the management server listens on. 1186 is the default port.
    Firewall: Open port 1186
    ServerPort This is the port the Data Nodes listens on. 2200 is the default port.
    Firewall: Open port 2200
    MySQL Server port This is the port the mysql server listens on. 3306 is the default port.

    Firewall: Open port 3306
    SSH PortNumber This is the port the ssh operates on. Default is port 22.
    Firewall: Open 22.
    Firewall (iptables) By default, iptables will be disabled by the deployment scripts.
    enable: You need to MANUALLY setup the firewall ports on all nodes.
    MySQL Server password (root) The MySQL password (for the root account). Default is 'password'.
    Use only alpha-numeric characters in the password string.
    CMON DB password (cmon user) Monitoring agents will store their data in a MySQL database, aka, the CMON DB.
    Default MySQL password for the CMON DB is 'cmon'. It is used by the monitoring agents.
    Use only alpha-numeric characters in the password string.

    Server Requirements: Read our recommendations before you continue!