Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-03-02 Thread Craig Ringer
On 03/03/11 09:01, Jasmin Dizdarevic wrote: > hehe... > andrew, I appriciate pg and it's free open source features - maybe I've > chosen a wrong formulation. > in my eyes such a feature is getting more important nowadays. Why? Shared disk means shared point of failure, and poor redundancy against

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-03-02 Thread Jasmin Dizdarevic
hehe... andrew, I appriciate pg and it's free open source features - maybe I've chosen a wrong formulation. in my eyes such a feature is getting more important nowadays. Postgresql-R and -XC are interesting ideas. thanks everybody for the comments regards, jasmin 2011/2/28 Andrew Sullivan >

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Robert Treat
On Sun, Feb 27, 2011 at 7:17 PM, Andrew Sullivan wrote: > On Mon, Feb 28, 2011 at 12:13:32AM +0100, Jasmin Dizdarevic wrote: >> My idea was the one, that john described: DML and DDL are done on the small >> box and reporting on the "big mama" with streaming replication and hot >> stand-by enabled.

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread John R Pierce
On 02/27/11 4:07 PM, Andrew Sullivan wrote: Multi-master transactional ACID-type databases with multiple masters is very hard. indeed. Oracle RAC works by having a distributed cache and locking manager replicating over a fast bus like infininet. oracle fundamentally uses a transaction re

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Andrew Sullivan
On Mon, Feb 28, 2011 at 12:13:32AM +0100, Jasmin Dizdarevic wrote: > My idea was the one, that john described: DML and DDL are done on the small > box and reporting on the "big mama" with streaming replication and hot > stand-by enabled. the only problem is that we use temp tables for reporting > p

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Andrew Sullivan
On Mon, Feb 28, 2011 at 12:13:32AM +0100, Jasmin Dizdarevic wrote: > Thank you for your detailed information about HA and LB. First of all it's a > pitty that there is no built-in feature for LB+HA (both of them, > simultaneous). I think it's a pity that I'm not paid a million dollars a year, too,

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Jasmin Dizdarevic
Thank you for your detailed information about HA and LB. First of all it's a pitty that there is no built-in feature for LB+HA (both of them, simultaneous). In my eyes, the pgpool2/3-solution has to much disadvantages and restrictions. My idea was the one, that john described: DML and DDL are done

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Andrew Sullivan
On Sun, Feb 27, 2011 at 12:10:36PM -0800, John R Pierce wrote: > are made to the master server, but reads are done to either. note you > do NOT want to use block level replication like drbd for this as the > drbd slave can not be actively mounted, nor could the slave instance of > postgres b

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread John R Pierce
On 02/27/11 4:48 AM, Jasmin Dizdarevic wrote: I have to build a load balanced pg-cluster and I wanted... master-master doesn't work real well with databases, especially ones like postgres that are optimized for a high level of concurrency and transactional integrity. on proper hardware, po

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Andrew Sullivan
On Sun, Feb 27, 2011 at 01:48:24PM +0100, Jasmin Dizdarevic wrote: > A drbd disk in dual primary mode with ocfs2-filesystem. > > Will there be any conflicts if using the shared volume as PGDATA directory? Yes. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (p

[GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Jasmin Dizdarevic
Hi, I have to build a load balanced pg-cluster and I wanted to ask you, if this configuration would work: A drbd disk in dual primary mode with ocfs2-filesystem. Will there be any conflicts if using the shared volume as PGDATA directory? R+W is a required feature for this cluster. Thank you Ja