Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Sun Mar 17, 2013 8:23 pm 
Offline

Joined: Sun Mar 17, 2013 7:25 pm
Posts: 1
Hi folks,

Part of the high availability / data protection and business continuity planning I'm thinking of setting up my hot standby postgres server in another datacenter.
My current setup is 2 load balanced App servers talking to the master in the same datacenter in Atlanta (other app servers in a different DC will come soon and loadbalancing/failover will be done through DNS). But for the database streaming replication I was thinking of the following setup after having done some reading on Postgres clustering techniques:

1) Postgres 9.1 streaming replication from master to slave(s).
2) pgpool-II on app servers for connection pooling and distribution of R/W queries across Postgres servers.
3) repmgr to manage Postgres manual failover (as much as I like 99.99% uptime I prefer manual automation of this task unless someone can convince me that repmgr automation works flawlessly - dont have time for PoC :) ).
4) Cross datacenter streaming replication ???

Questions:
1) Having Atlanta as primary DB site, does anyone have any experience with replication from Atlanta to another DC or some other cross datacenter configuration?
latency between Atlanta and Newark seems best at 23ms/avg with 11 hops.
2) DB size will be growing to a few GB in the first year (less than 10GB) and will grow exponentially when I add more clients in year 2+ (forecasting 300G+). Anythinig I need to be aware of in terms of cross datacenter replication for failover/promoting slave to master and switching back when master comes back.
3) Any other suggestions for Postgres high availability/business continuity planning?

thank you!

Edmond


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group