Constant WAL replay

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: pgsql-hackers(at)postgresql(dot)org, eg(at)cybertec(dot)at
Subject: Constant WAL replay
Date: 2005-04-24 06:10:34
Message-ID: 426B385A.1060103@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

We have toyed around with PostgreSQL's WAL structure and we are
wondering whether it is (theoretically) possible to replay WAL records
coming from a remote host while a system is working in read only mode.

The idea: We are looking for a way to implement a synchronous
single-master / multiple slaves systems.
Meanwhile we are able to serialize / deserialize WAL records and send
them to a group communication system which transports those records to
the slave database.
This is not hard to do. The problem is: How can we replay data on the
slave while the slave is answering read-only SQL-statements?

As far as I understand the code we can either recover the system or
answer SQL statements. Which kind of modifications are necessary to
replay and answer at the same time? (assuming that locks and
transactional information are available on the slave).

Input is very much appreciated.

Best regards,

Hans

--
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/664/393 39 74
www.cybertec.at, www.postgresql.at

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-24 06:28:16 Re: Constant WAL replay
Previous Message Tom Lane 2005-04-24 05:52:16 Re: Wierd performance issue with 8.1cvs

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-04-24 06:28:16 Re: Constant WAL replay
Previous Message Bruce Momjian 2005-04-24 03:51:04 Re: VACUUM VERBOSE FSM info