Postgres cluster
Could someone walk me through building a 3 machine postgres cluster with automatic fail over? I've searched and searched and I'm just not getting it. I currently have postgres 9.1 installed with 1 database as 9.1/main. I'd like to cluster this to provide ha and faster query times. Writes to the DB can be forced to the master only, so read-only slaves are okay (there are far more reads than writes) Can anyone help me out?
Sounds like a good project. I wish I could offer some advice, but I am not familiar with postgres. I hope someone else on this list has some ideas. I've been meaning to do more things with mysql as it seems to be the gateway dbms and since I used it for a project a few years back. On Tue, Jan 24, 2012 at 3:32 PM, Jason Couture <plaguethenet@gmail.com>wrote:
Could someone walk me through building a 3 machine postgres cluster with automatic fail over? I've searched and searched and I'm just not getting it.
I currently have postgres 9.1 installed with 1 database as 9.1/main. I'd like to cluster this to provide ha and faster query times. Writes to the DB can be forced to the master only, so read-only slaves are okay (there are far more reads than writes)
Can anyone help me out?
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
We did a few tests, for our purposes it turns out that postgres was quite a bit faster than MySQL, but its setup is quite a bit more complicated. On Wed, Jan 25, 2012 at 10:40 PM, James Gray <jamespgray@gmail.com> wrote:
Sounds like a good project. I wish I could offer some advice, but I am not familiar with postgres. I hope someone else on this list has some ideas.
I've been meaning to do more things with mysql as it seems to be the gateway dbms and since I used it for a project a few years back.
On Tue, Jan 24, 2012 at 3:32 PM, Jason Couture <plaguethenet@gmail.com> wrote:
Could someone walk me through building a 3 machine postgres cluster with automatic fail over? I've searched and searched and I'm just not getting it.
I currently have postgres 9.1 installed with 1 database as 9.1/main. I'd like to cluster this to provide ha and faster query times. Writes to the DB can be forced to the master only, so read-only slaves are okay (there are far more reads than writes)
Can anyone help me out?
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
participants (2)
-
James Gray -
Jason Couture