Building a High-Availability PostgreSQL Cluster at ARIN

Through a long and intense period of research, implementation, and testing, ARIN completed the migration from Oracle to PostgreSQL late last year. Learn more at:
…

Through a long and intense period of research, implementation, and testing, ARIN completed the migration from Oracle to PostgreSQL late last year. Learn more at: http://teamarin.net/2014/04/01/building-high-availability-postgresql-cluster-arin/

Transcript

2.
What is ARIN?
•Regional Internet registry for
Canada, US, and parts of the
Caribbean
•Distributes IPv4 & IPv6 addresses and
Autonomous System Numbers (Internet
number resources) in the region
•Provides authoritative WHOIS services
for number resources in the region
2

9.
About Pacemaker
• Developed / maintained by Red Hat and Novell
• Scalable – Anywhere from a two-node to a 16-
node setup
• Scriptable – Resource scripts can be written in
any language
– Monitoring – Watches out for service state changes
– Fencing – Disables a box and switches roles when
failures occur
• Shareable database between nodes about
status of services / nodes
9