| Author |
Message |
LegionSB
Joined: 29 Jan 2012
Posts: 1
|
| Posted: Sun Jan 29, 2012 6:34 pm Post subject: Postgres and NodeBalancer - possible? |
|
|
I have no experience with Postgres or NodeBalancer, and I was wondering if what I'm picturing in my head is possible, or if I have a fundamental misunderstanding of any of the technologies involved.
Here's what I imagine: two servers running Postgres. Both are "masters" - can receive write and read queries. Each one replicates the write queries they receive to the other server.
Our apps point their DB address to NodeBalancer, which directs the traffic to one of the two servers. If one happens to go down, NodeBalancer will only direct traffic to the remaining one.
Is this a right-headed understanding of the possibilities of Postgres and NB, or am I wrong in thinking this setup is possible? |
|
| Back to top |
|
Azathoth
Joined: 07 Dec 2009
Posts: 263
|
| Posted: Sun Jan 29, 2012 6:58 pm Post subject: |
|
|
| pgpool-II |
|
| Back to top |
|
obs
Joined: 07 Mar 2010
Posts: 1403
Location: Earth
|
| Posted: Mon Jan 30, 2012 6:00 am Post subject: |
|
|
| Node balancers can only balance external traffic so they won't fit into your plan. |
|
| Back to top |
|
caker
Joined: 15 Apr 2003
Posts: 2907
Location: Galloway, NJ
|
| Posted: Mon Jan 30, 2012 10:54 am Post subject: |
|
|
NodeBalancers listen on IPv6 too, and local IPv6 traffic doesn't count against the transfer pool.
-Chris |
|
| Back to top |
|
mnordhoff
Joined: 03 May 2008
Posts: 451
|
| Posted: Mon Jan 30, 2012 2:42 pm Post subject: |
|
|
| Although NodeBalancers are always accessible to the public, aren't they? And you might not want *that* for your private db servers... |
|
| Back to top |
|
| |
