I've got a bunch of PosgreSQL servers connected to external storage,
where a single server needs to be serving as WO database dealing with
INSERTs only, and bunch of other guys need to obtain a copy of that
data for RO serving, without taking resources on WO server.
The idea is to have say 2 raw devices which would be used as 2 WAL
segments (round-robin). RO servers will go after the one that's not used
at a given time with something like xlogdump utility and produce INSERT
statements to be then executed locally. After that import is done, a
command will be issued to the WO server to switch to the other segment
so that the cycle can repeat.
The objective of that replication model is to ensure that SELECT
queries won't ever affect the performance of the WO server,
which may experience uneven loads.
Is that possible with the 8.2.4 or 8.3 capabilities, or maybe with
minor modifications ?
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2007-08-31 23:21:18|
|Subject: Re: WAL to RAW devices ? |
|Previous:||From: Anton Melser||Date: 2007-08-31 22:32:39|
|Subject: Re: URGENT: Whole DB down ("no space left on device")|