Description

Installs Codership's MySQL Galera Cluster (http://www.codership.com/) or MariaDB Galera Cluster (https://mariadb.com/kb/en/galera/).

Galera Cluster provides synchronous multi-master replication for MySQL (replication plugin).

No master failover scripting (automatic failover and recovery)
No slave lag
Read and write to any node
Write scalabilty
WAN Clustering

This cookbook enables you to install a Galera cluster from scratch. At minimum you would probaly only need to change a few attributes like

['mysql']['vendor'] = "mariadb"
['mysql']['root_password'] = "password"
['mysql']['tunable']['buffer_pool_size'] = "256M"

Howto: Chef, MySQL Galera and ClusterControl http://support.severalnines.com/entries/21453521-opscode-s-chef-mysql-galera-and-clustercontrol

Requirements

Platform

Debian, Ubuntu
CentOS, Red Hat, Fedora

Tested on:

Ubuntu 12.04 w/ Chef-server 10.16.2 and Galera Cluster v2.2
Ubuntu 11.10/12.04 w/ Chef-solo 0.10.8/0.10.10 and Galera Cluster v2.1

Attributes

node['mysql']['install_dir'] = "/usr/local"
node['mysql']['root_password'] = "password"
node['mysql']['base_dir'] = "/usr/local"
node['mysql']['data_dir'] = "/var/lib/mysql"
node['mysql']['run_dir'] = "/var/run/mysqld"
node['mysql']['pid_file'] = /var/lib/mysql/mysqld.pid"
node['mysql']['socket'] = /var/run/mysqld/mysqld.sock"
node['mysql']['port'] = 3306
node['mysql']['tmp_dir'] = "/tmp"
node['mysql']['tunable']['buffer_pool_size'] = "256M"
node['mysql']['tunable']['flush_log_at_trx_commit'] = 2
node['mysql']['tunable']['file_per_table'] = 1
node['mysql']['tunable']['doublewrite'] = 0
node['mysql']['tunable']['log_file_size'] = "512M"
node['mysql']['tunable']['log_files_in_group'] = 2
node['mysql']['tunable']['buffer_pool_instances'] = 1
node['mysql']['tunable']['max_dirty_pages_pct'] = 75
node['mysql']['tunable']['thread_concurrency'] = 0
node['mysql']['tunable']['concurrency_tickets'] = 5000
node['mysql']['tunable']['thread_sleep_delay'] = 10000
node['mysql']['tunable']['lock_wait_timeout'] = 50
node['mysql']['tunable']['io_capacity'] = 200
node['mysql']['tunable']['read_io_threads'] = 4
node['mysql']['tunable']['write_io_threads'] = 4
node['mysql']['tunable']['file_format'] = "barracuda"
node['mysql']['tunable']['flush_method'] = "O_DIRECT"
node['wsrep']['cluster_name'] = "my_galera_cluster"
node['wsrep']['slave_threads'] = 1
node['wsrep']['certify_nonPK'] = 1
node['wsrep']['max_ws_rows'] = 131072
node['wsrep']['max_ws_size'] = 1073741824
node['wsrep']['retry_autocommit'] = 1

and more in attributes/default.rb

Usage

On MySQL Galera Nodes,

	include_recipe "galera:server"

Example cc_galera role:

	name "cc_galera"
	description "MySQL Galera Node"
	run_list "recipe[galera::server]"

Data Bags

sql_galera_cluster / config.json

	{
	  "id": "config",
	  "mysql_wsrep_tarball_x86_64": "mysql-5.5.29_wsrep_23.7.3-linux-x86_64.tar.gz",
	  "mysql_wsrep_tarball_i686": "mysql-5.5.29_wsrep_23.7.3-linux-i686.tar.gz",
	  "galera_package_i386": {
	  	"deb": "galera-23.2.4-i386.deb",
	  	"rpm": "galera-23.2.4-1.rhel5.i386.rpm"},
	  "galera_package_x86_64": {
	  	"deb": "galera-23.2.4-amd64.deb",
	  	"rpm": "galera-23.2.4-1.rhel5.x86_64.rpm"
	  },
	  "mysql_wsrep_source": "https://launchpad.net/codership-mysql/5.5/5.5.29-23.7.3/+download",
	  "galera_source": "https://launchpad.net/galera/2.x/23.2.4/+download",
	  "sst_method": "rsync",
	  "init_node": "192.168.122.12",
	  "galera_nodes": [
	     "192.168.122.12",
	     "192.168.122.14",
	     "192.168.122.16"
	    ],
	   "secure": "yes",
	   "update_wsrep_urls": "yes"
	}

galera_nodes These are the IP addresses where you have MySQL Galera nodes running and a random host in this list will be used as the cluster URL for a galera node if the galera recipe is "reloaded".
sst_method State Snapshot Transfer method, 'mysqldump', 'rsync', 'rsync_wan' or 'xtrabackup' (if installed).

Change History

TODO:

Allow the installation of MySQL OR MariaDB
Reconfigure the deployment to search for nodes to add to the cluster (removing the need to manually specify galera nodes)
Off load the installation and repo management to other cookbooks if possible (https://github.com/opscode-cookbooks/mysql and https://github.com/joerocklin/chef-mariadb)
v0.4 - Vagrant host only fix, attribute names match opscode mysql recipe, update to MySQL version 5.5.29-23.7.3 and Galera 2.4.2
v0.3 - Add init_node which specifies the intital donor node.
v0.2 - Use wsrep_urls with mysqld_safe
v0.1 - Initial recipe based upon MySQL Galera 5.5.23

License and Author

Cookbook Maintainer - Trent "Rockstar04" Petersen (trent.petersen@convergint.com)

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Original License

Alex Yu (<alex@severalnines.com>)