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
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
>
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.
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
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
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,
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
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
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
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
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
11 matches
Mail list logo