Skip to content

Instantly share code, notes, and snippets.

@nownabe
Last active August 29, 2015 14:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nownabe/ad27584f7d9b03c0a73c to your computer and use it in GitHub Desktop.
Save nownabe/ad27584f7d9b03c0a73c to your computer and use it in GitHub Desktop.
Percona ExtraDB Cluster
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
## Example options
## http://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.0.11
wsrep_slave_threads=2
wsrep_sst_method=rsync
binlog_format=ROW
## Important variables for galera
## http://www.olindata.com/blog/2013/12/important-variables-configuring-galera-percona-xtradb-cluster-56
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
bind-address=192.168.0.31
wsrep_cluster_name=galeraex
wsrep_node_name=galera-w1
skip-name-resolve
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
# -*- mode: ruby -*-
# vi: set ft=ruby :
VAGRANTFILE_API_VERSION = "2"
Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
config.vm.box = "cent65"
config.vm.network "public_network", ip: "192.168.0.31", bridge: "Qualcomm Atheros AR8161/8165 PCI-E Gigabit Ethernet Controller (NDIS 6.20)"
config.vm.provider "virtualbox" do |vb|
vb.customize ["modifyvm", :id, "--memory", "1024"]
end
config.vm.provision "shell", inline: <<-EOS
sudo rpm -ivh http://repo.percona.com/testing/centos/6/os/noarch/percona-release-0.1-1.noarch.rpm
sudo yum install -y Percona-XtraDB-Cluster-56
EOS
config.vm.provision "file", source: "my.cnf", destination: "~/my.cnf"
config.vm.provision "shell", inline: "sudo cp /home/vagrant/my.cnf /etc/my.cnf"
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment