How to set up a three-node cluster in EC2 enviroment¶

This manual assumes you are running m1.xlarge instances with Red Hat Enterprise Linux 7 64-bit.

• node1: 10.93.46.58
• node2: 10.93.46.59
• node3: 10.93.46.60

To set up Percona XtraDB Cluster:

1. Remove Percona XtraDB Cluster and Percona Server packages for older versions:

   • Percona XtraDB Cluster 5.6, 5.7
   • Percona Server 5.6, 5.7

2. Install Percona XtraDB Cluster as described in Installing Percona XtraDB Cluster on Red Hat Enterprise Linux and CentOS.

3. Create data directories:

   $ mkdir -p /mnt/data
   $ mysql_install_db --datadir=/mnt/data --user=mysql
   

4. Stop the firewall service:

   $ service iptables stop
   

   Note

   Alternatively, you can keep the firewall running, but open ports 3306, 4444, 4567, 4568. For example to open port 4567 on 192.168.0.1:

   iptables -A INPUT -i eth0 -p tcp -m tcp --source 192.168.0.1/24 --dport 4567 -j ACCEPT
   

5. Create /etc/my.cnf files:

   Contents of the configuration file on the first node:

   [mysqld]
   datadir=/mnt/data
   user=mysql
   
   binlog_format=ROW
   
   wsrep_provider=/usr/lib64/libgalera_smm.so
   wsrep_cluster_address=gcomm://10.93.46.58,10.93.46.59,10.93.46.60
   
   wsrep_slave_threads=2
   wsrep_cluster_name=trimethylxanthine
   wsrep_sst_method=xtrabackup-v2
   wsrep_node_name=node1
   
   innodb_autoinc_lock_mode=2
   

   For the second and third nodes change the following lines:

   wsrep_node_name=node2
   
   wsrep_node_name=node3
   

6. Start and bootstrap Percona XtraDB Cluster on the first node:

   [root@pxc1 ~]# systemctl start mysql@bootstrap.service
   

   You should see the following output:

   2014-01-30 11:52:35 23280 [Note] /usr/sbin/mysqld: ready for connections.
   Version: '...'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release ..., Revision ..., wsrep_version
   

7. Start the second and third nodes:

   $ sudo systemctl start mysql
   

   The output should be similar to the following:

   ... [Note] WSREP: Flow-control interval: [28, 28]
   ... [Note] WSREP: Restored state OPEN -> JOINED (2)
   ... [Note] WSREP: Member 2 (percona1) synced with group.
   ... [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2)
   ... [Note] WSREP: New cluster view: global state: 4827a206-876b-11e3-911c-3e6a77d54953:2, view# 7: Primary, number of nodes: 3, my index: 2, protocol version 2
   ... [Note] WSREP: SST complete, seqno: 2
   ... [Note] Plugin 'FEDERATED' is disabled.
   ... [Note] InnoDB: The InnoDB memory heap is disabled
   ... [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
   ... [Note] InnoDB: Compressed tables use zlib 1.2.3
   ... [Note] InnoDB: Using Linux native AIO
   ... [Note] InnoDB: Not using CPU crc32 instructions
   ... [Note] InnoDB: Initializing buffer pool, size = 128.0M
   ... [Note] InnoDB: Completed initialization of buffer pool
   ... [Note] InnoDB: Highest supported file format is Barracuda.
   ... [Note] InnoDB: 128 rollback segment(s) are active.
   ... [Note] InnoDB: Waiting for purge to start
   ... [Note] InnoDB:  Percona XtraDB (http://www.percona.com) ... started; log sequence number 1626341
   ... [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
   ... [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
   ... [Note] Server hostname (bind-address): '*'; port: 3306
   ... [Note] IPv6 is available.
   ... [Note]   - '::' resolves to '::';
   ... [Note] Server socket created on IP: '::'.
   ... [Note] Event Scheduler: Loaded 0 events
   ... [Note] /usr/sbin/mysqld: ready for connections.
   Version: '...'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release ..., Revision ..., wsrep_version
   ... [Note] WSREP: inited wsrep sidno 1
   ... [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
   ... [Note] WSREP: REPL Protocols: 5 (3, 1)
   ... [Note] WSREP: Assign initial position for certification: 2, protocol version: 3
   ... [Note] WSREP: Service thread queue flushed.
   ... [Note] WSREP: Synchronized with group, ready for connections
   

   When all nodes are in SYNCED state, your cluster is ready.

8. You can try connecting to MySQL on any node and create a database:

   $ mysql -uroot
   > CREATE DATABASE hello_tom;
   

The new database will be propagated to all nodes.