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 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 a
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
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
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,
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 be
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 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,
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
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
On Sun, Feb 27, 2011 at 7:17 PM, Andrew Sullivan a...@crankycanuck.ca 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
11 matches
Mail list logo