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

Copyright 2013 Convergint Technologies LLC

Cookbook Maintainer - Trent "Rockstar04" Petersen ([email protected])

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 (<[email protected]>)

Copyright (c) 2012 Severalnines AB.

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.