🦄

Craig R Webster craigw

🦄

craigw / gist:150617

Created July 20, 2009 19:22

sudo chmod go-wrx /etc/ha.d/authkeys

craigw / gist:150618

Created July 20, 2009 19:22

	auth 2
	2 sha1 your-password-here

craigw / gist:150620

Created July 20, 2009 19:22

craigw / gist:150621

Created July 20, 2009 19:22

db-01.vm.xeriom.net 193.219.108.243

craigw / gist:150622

Created July 20, 2009 19:22

sudo /etc/init.d/heartbeat start

craigw / gist:150623

Created July 20, 2009 19:22

	heartbeat[7734]: 2008/07/07_17:19:34 info: Initial resource acquisition complete (T_RESOURCES(us))
	IPaddr[7739]: 2008/07/07_17:19:37 INFO: Running OK
	heartbeat[7745]: 2008/07/07_17:19:37 info: Local Resource acquisition completed.

craigw / gist:150624

Created July 20, 2009 19:22

	# On both boxes
	sudo iptables -I INPUT 3 -p tcp --dport mysql -s 193.214.108.10 -d 193.214.108.243 -j ACCEPT

craigw / gist:150625

Created July 20, 2009 19:22

	# on both boxes
	mysql -u root -p
	Enter password: [enter the MySQL root password you chose earlier]
	mysql> grant all, replication_client on my_application.* to 'some_user'@'193.214.108.10' identified by 'some_other_password';
	mysql> \q

craigw / gist:150626

Created July 20, 2009 19:22

	mysql -u some_user -p -h 193.214.108.243 my_application
	mysql> show slave status \G
	************************* 1. row *************************
	Slave_IO_State: Waiting for master to send event
	Master_Host: 193.219.108.242
	[unimportant lines snipped]

craigw / gist:150627

Created July 20, 2009 19:22