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-71.tar.gz; cd mysqlcluster-71/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 note that RPM installations at this point is less tested than tarball (tgz) installs. Please let us know of any issues on feedback@severalnines.com

Known issue: Any other mysql port than 3306 does not work currently.

Version and Platform

Cluster version: We recommend MySQL Cluster 7.1 for general purpose. MySQL Cluster 7.1 has lot of new cool features (e.g multithreading, online add node). More information here.
There are prebuilt binaries for both versions, but the source releases are made more frequently.
  • MySQL Cluster 7.1 is GA.
  • MySQL Cluster 7.2 is GA. Recommended. Fast joins, 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 Operating System must be homogenous across all computers in the replication cluster.
    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

    PortNumber This is the port the management server listens on. 1186 is the default port.
    Config directory
    1. This is where the config.ini and my.cnf files will be stored.
    OS User
    1. root - enter 'root' if you have root credentials
    2. ubuntu, fedora, cloud users: if you use 'sudo' to execute system commands, then specify the username you wish to use here (e.g, ec2-user, ubuntu).
    3. This user must exist on all servers and cannot be 'mysql'.
    MySQL Server port This is the port the mysql server listens on. 3306 is the default port.
    MySQL Server password (root) The MySQL password (for the root account). Default is 'password'.
    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.

    Server Requirements: Read our recommendations before you continue!