WAL to RAW devices ?
От | Alex Vinogradovs |
---|---|
Тема | WAL to RAW devices ? |
Дата | |
Msg-id | 1188600416.6082.44.camel@localhost обсуждение исходный текст |
Ответ на | Re: URGENT: Whole DB down ("no space left on device") (Jeff Davis <pgsql@j-davis.com>) |
Ответы |
Re: WAL to RAW devices ?
Re: WAL to RAW devices ? Re: WAL to RAW devices ? |
Список | pgsql-general |
Hi guys, 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 ? Thanks! Best regards, Alex Vinogradovs
В списке pgsql-general по дате отправления: