Vagrantfile.pxc_playground.rb

# -*- mode: ruby -*-
# vi: set ft=ruby :

# Assumes a box from https://github.com/grypyrg/packer-percona

# This sets up 3 nodes with a common PXC
# it also installs haproxy

# HOW TO USE
# You have to bring the machines up prior to provisioning. so run it in 2 steps:
#
# # vagrant up --no-provision --parallel
# # vagrant provision --parallel

prefix='cluster-'
iprange='192.168.56'
if_adapter='vboxnet0'

enable_repo_percona_testing=true

require File.dirname(__FILE__) + '/lib/vagrant-common.rb'

mysql_version = "56"

# Node names and ips (for local VMs)
# (Amazon) aws_region is where to bring up the node
# (Amazon) Security groups are 'default' (23 open) and 'pxc' (3306, 4567-4568,4444 open) for each respective region
# (Amazon) HAproxy also needs the 'haproxy' security group (3307-3309, 8080, 8000) for each respective region
# Don't worry about amazon config if you are not using that provider.
pxc_nodes = {
	prefix + 'pxc1' => {
		'local_vm_ip' => iprange + '.2',
		'aws_region' => 'us-east-1',
		'security_groups' => ['default','pxc', 'haproxy'],
		'haproxy_disabled' => 'false',
		'maxscale_disabled' => 'false',
		'haproxy_primary' => true,
		'pxc_bootstrap_node' => true,
		'server_id'	=> '1'
	},
	prefix + 'pxc2' => {
		'local_vm_ip' => iprange + '.3',
		'aws_region' => 'us-east-1',
		'security_groups' => ['default','pxc', 'haproxy'],
		'pxc_bootstrap_node' => false,
		'haproxy_disabled' => 'true',
		'maxscale_disabled' => 'true',
		'server_id'	=> '2'
	},
	prefix + 'pxc3' => {
		'local_vm_ip' => iprange + '.4',
		'aws_region' => 'us-east-1',
		'security_groups' => ['default','pxc', 'haproxy'],
		'pxc_bootstrap_node' => false,
		'haproxy_disabled' => 'true',
		'maxscale_disabled' => 'true',
		'server_id'	=> '3'
	}
}


# make a comma separated serverlist, which can be reused in puppet
serverlist=pxc_nodes.map{|k,v| "#{k}"}.join(',')

# should we use the public or private ips when using AWS
hostmanager_aws_ips='private'

# Support for cloud.percona.com through the percona-agent
# please ensure to fill in the correct api key
percona_agent_enabled=false
percona_agent_api_key='----'

Vagrant.configure("2") do |config|
	config.vm.box = "grypyrg/centos-x86_64"
	config.ssh.username = "vagrant"

	# it's disabled by default, it's done during the provision phase
	config.hostmanager.enabled = false
	config.hostmanager.include_offline = true

	# Create all three nodes identically except for name and ip
	pxc_nodes.each_pair { |name, node_params|
		config.vm.define name do |node_config|
			node_config.vm.hostname = name
			node_config.vm.network :private_network, ip: node_params['local_vm_ip'], adaptor: if_adapter

			# this is to test haproxy PROXY support in PXC
			if name == prefix + 'pxc1'
				node_config.vm.network :private_network, ip: '172.0.0.1'
			end

			ssh_port = "882" + node_params["server_id"]
			haproxy_port = "888" + node_params["server_id"]

			node_config.vm.network "forwarded_port", guest: 22, host: ssh_port, auto_correct: false
			node_config.vm.network "forwarded_port", guest: 8080, host: haproxy_port, auto_correct: false

			# custom port forwarding
			node_config.vm.network "forwarded_port", guest: 8080, host: 8080, auto_correct: true	

			# Provisioners
			node_config.vm.provision :hostmanager

			provision_puppet( node_config, "pxc_playground.pp" ) { |puppet|
				puppet.facter = {
					'vagrant_hostname'				=> name,
					"percona_server_version"			=> mysql_version,
					"haproxy_servers"				=> serverlist,
					"haproxy_disabled"				=> node_params['haproxy_disabled'],
					"maxscale_disabled"				=> node_params['maxscale_disabled'],
					"haproxy_servers_primary"			=> pxc_nodes.select{|k,v| ! v.select{|k2,v2| k2=="haproxy_primary" && v2==true}.empty? }.map{|k3,v3| "#{k3}"}.join(','),
					"maxscale_servers"				=> serverlist,
					"cluster_servers"				=> serverlist,
					"datadir_dev" 					=> "dm-2",
					'datadir_fs'					=> "xfs",
					'percona_agent_enabled'				=> percona_agent_enabled,
					'percona_agent_api_key'				=> percona_agent_api_key,
					'innodb_buffer_pool_size' 			=> '128M',
					'innodb_log_file_size'				=> '64M',
					'innodb_flush_log_at_trx_commit'		=> '0',
					'pxc_bootstrap_node'				=> node_params['pxc_bootstrap_node'],
					'extra_mysqld_config'				=> 
						'wsrep_cluster_address=gcomm://' + pxc_nodes.map{|k,v| "#{k}"}.join(',') + "\n" +
						"wsrep_sst_receive_address=" + name + "\n" +
						"wsrep_node_address=" + name + "\n" +
						"log_slave_updates\n" +
						"server_id=" + node_params['server_id'] + "\n" +
						"log_bin" + "\n"
				}
			}

			# Disable these options
			# 'wsrep_provider_options=ist.recv_addr="' + name + "\"\n" +
			# 'wsrep_sst_receive_address=' + name + "\n" +
			# 'wsrep_node_address=' + name + "\n" +

			# Providers
			provider_virtualbox( nil, node_config, 256) { |vb, override|
				provision_puppet( override, "pxc_playground.pp" ) {|puppet|
					puppet.facter = {"datadir_dev" => "dm-2"}
				}
			}
	
			provider_aws( "PXC #{name}", node_config, 'm3.medium', node_params['aws_region'], node_params['security_groups'], hostmanager_aws_ips) { |aws, override|
				aws.block_device_mapping = [
					{
						'DeviceName' => "/dev/xvdf",
						'VirtualName' => "ephemeral0"
					}
				]
				provision_puppet( override, "pxc_playground.pp" ) {|puppet|
					puppet.facter = {"datadir_dev" => "xvdf"}
				}

			}

		end
	}

end