Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Puppet Ruby Shell
branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
manifests
modules/pxc_talk
README.md
Vagrantfile
download_rpms.sh

README.md

NOTES

Setup the environment

Requirements

Installation

host> git clone https://github.com/martinarrieta/vagrant-xtradb-cluster-talk
host> cd vagrant-xtradb-cluster-talk
host> sh download_rpms.sh
host> vagrant up

If you have any problem with this initial setup, please open a new issue on this URL: https://github.com/martinarrieta/vagrant-xtradb-cluster-talk/issues

During the talk

Node1

Connect to node1

host> vagrant ssh node1

Become root

node1> sudo -s 

Create the default my.cnf file:

node1> cat /opt/notes/my.cnf-00 > /etc/my.cnf

Add the default wsrep option to the my.cnf file

node1> cat /opt/notes/my.cnf-01 >> /etc/my.cnf

Start the cluster

node1> /etc/init.d/mysql start --wsrep_cluster_address=gcomm://
# if you have 5.5.31-23.7.5 or newer 
node1> /etc/init.d/mysql bootstrap-pxc

Create the MySQL user to make the SST.

node1> mysql -u root -e "GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sst'@'localhost' IDENTIFIED BY 'secret'"

Node2

Connect to node2

host> vagrant ssh node2

Become root

node2> sudo -s 

Create the default my.cnf file:

node2> cat /opt/notes/my.cnf-00 > /etc/my.cnf

Add the default wsrep option to the my.cnf file

node2> cat /opt/notes/my.cnf-01 >> /etc/my.cnf

Node3

Connect to node3

host> vagrant ssh node3

Become root

node3> sudo -s 

Create the default my.cnf file:

node3> cat /opt/notes/my.cnf-00 > /etc/my.cnf

Add the default wsrep option to the my.cnf file

node3> cat /opt/notes/my.cnf-01 >> /etc/my.cnf
Something went wrong with that request. Please try again.