Vagrantfile.pxc_playground.rb

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

# Assumes a box from https://github.com/jayjanssen/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='team1-'
iprange='192.168.60'
if_adapter='vboxnet4'


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' => 'eu-west-1',
		'security_groups' => ['default','pxc', 'haproxy'],
		'haproxy_primary' => true,
		'pxc_bootstrap_node' => true
	},
	prefix + 'pxc2' => {
		'local_vm_ip' => iprange + '.3',
		'aws_region' => 'eu-west-1',
		'security_groups' => ['default','pxc', 'haproxy'],
		'pxc_bootstrap_node' => false
	},
	prefix + 'pxc3' => {
		'local_vm_ip' => iprange + '.4',
		'aws_region' => 'eu-west-1',
		'security_groups' => ['default','pxc', 'haproxy'],
		'pxc_bootstrap_node' => false
	}
}

# 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 = "perconajayj/centos-x86_64"
	config.ssh.username = "root"

	# 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

			# 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"					=> pxc_nodes.map{|k,v| "#{k}"}.join(','),
					"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"                  => pxc_nodes.map{|k,v| "#{k}"}.join(','),
					"datadir_dev" 						=> "dm-2",
					"percona_server_version"			=> mysql_version,
					'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"
			}

			# 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( name, node_config, 512) { |vb, override|
				provision_puppet( override, "pxc_playground.pp" ) {|puppet|
					puppet.facter = {"datadir_dev" => "dm-2"}
				}
			}
	
			provider_aws( "PXC #{name}", node_config, 't2.small', node_params['aws_region'], node_params['security_groups'], hostmanager_aws_ips) { |aws, override|
				aws.block_device_mapping = [
					{
						'DeviceName' => "/dev/sdb",
						'VirtualName' => "ephemeral0"
					}
				]
				provision_puppet( override, "pxc_playground.pp" ) {|puppet|
					puppet.facter = {"datadir_dev" => "xvdb"}
				}

			}

		end
	}
end