Steven Livingstone-Perez stevenlivz

Hey! I saw this has been indexed by the search engines. It is a first draft of a post I ended up publishing on my blog at: Scaling PostgreSQL With Pgpool and PgBouncer

Thanks for stopping by!

PostgreSQL and Pgpool Architecture

	# install haproxy
	yum install -y haproxy

	# config haproxy for rabbitmq
	cat > /etc/haproxy/haproxy.cfg << "EOF"
	global
	log 127.0.0.1 local0 notice

	maxconn 10000
	user haproxy

	#!/usr/bin/env bash

	# Kill an Erlang process by node name
	#
	# e.g.: kill-erlang-node kred

	# Check usage
	if [ -z "$1" ]; then
	echo "Usage: `basename $0` NODE_NAME"
	exit 1

	# Documentation for HAProxy
	# http://code.google.com/p/haproxy-docs/w/list
	# http://haproxy.1wt.eu/download/1.2/doc/architecture.txt

	# NOTES:
	# open files limits need to be > 256000, use ulimit -n to set (on most POSIX systems)

	global
	log 127.0.0.1 local0
	log 127.0.0.1 local1 notice

	Strophe.addConnectionPlugin('receipts', {
	_conn: null,
	_msgQueue: {},
	_retries: {},
	_resendCount: 10,
	_resendTime: 9000,

	init: function(conn) {
	this._conn = conn;
	Strophe.addNamespace('RECEIPTS', 'urn:xmpp:receipts');

	# to undo a git push
	git push -f origin HEAD^:master

	# to get to previous commit (preserves working tree)
	git reset --soft HEAD

	# to get back to previous commit (you'll lose working tree)
	git reset --hard HEAD^