Read-only availability of a standby server?
In the high-availabilty situation with a warm standby, is it possible (or planned) to be able to make standby readable?
This is a new feature in Oracle 11 and it is very important for a project I am working on.
Garber, Mikhail wrote:
In the high-availabilty situation with a warm standby, is it possible (or planned) to be able to make standby readable?
This is a new feature in Oracle 11 and it is very important for a project I am working on.
yeah there are plans to support this in 8.4 (and some basic groundwork
already happened in 8.3) ...
Stefan
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, 21 Nov 2007 12:20:51 -0800
"Garber, Mikhail" <mgarber@amazon.com> wrote:
In the high-availabilty situation with a warm standby, is it possible
(or planned) to be able to make standby readable? This is a new
feature in Oracle 11 and it is very important for a project I am
working on.
There was a Google Summer of Code project IIRC for that... So yes, it
has been worked on a bit but I am unaware of the status.
Joshua D. Drake
---------------------------(end of
broadcast)--------------------------- TIP 6: explain analyze is your
friend
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHRJStATb/zqfZUUQRAmxtAJ9opNJn8N7f2Fv403EqAHh419vciwCgiW4o
zvQVFrrmnYVXuhd79PpgicY=
=tyRU
-----END PGP SIGNATURE-----
On Wed, Nov 21, 2007 at 12:20:51PM -0800, Garber, Mikhail wrote:
In the high-availabilty situation with a warm standby, is it possible (or
planned) to be able to make standby readable?
Yes, but it won't happen for 8.3. It's a feature you can have today with
Slony, by the way.
A
--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke
Could you explain what hot-standby characteristic is most important?If you desire to replicate <segments of> your Write-ahead log take a look at Point In Time Recovery
http://www.postgresql.org/docs/8.1/static/backup-online.html
If you desire to use separate physical machines with ability to replicate schema changes take a look at SLONY
http://slony.info/
Anyone ?Martin--______________________________________________Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.> > -----BEGIN PGP SIGNED MESSAGE-----> Hash: SHA1> > On Wed, 21 Nov 2007 12:20:51 -0800> "Garber, Mikhail" <mgarber@amazon.com> wrote:> > > In the high-availabilty situation with a warm standby, is it possible> > (or planned) to be able to make standby readable? This is a new> > feature in Oracle 11 and it is very important for a project I am> > working on.> > > > There was a Google Summer of Code project IIRC for that... So yes, it> has been worked on a bit but I am unaware of the status.> > Joshua D. Drake> > > ---------------------------(end of> > broadcast)--------------------------- TIP 6: explain analyze is your> > friend> > > > > - -- > > === The PostgreSQL Company: Command Prompt, Inc. ===> Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240> PostgreSQL solutions since 1997 http://www.commandprompt.com/> UNIQUE NOT NULL> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate> PostgreSQL Replication: http://www.commandprompt.com/products/> > -----BEGIN PGP SIGNATURE-----> Version: GnuPG v1.4.6 (GNU/Linux)> > iD8DBQFHRJStATb/zqfZUUQRAmxtAJ9opNJn8N7f2Fv403EqAHh419vciwCgiW4o> zvQVFrrmnYVXuhd79PpgicY=> =tyRU> -----END PGP SIGNATURE-----> > ---------------------------(end of broadcast)---------------------------> TIP 1: if posting/reading through Usenet, please send an appropriate> subscribe-nomail command to majordomo@postgresql.org so that your> message can get through to the mailing list cleanly
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newways_112007
Stefan Kaltenbrunner ha scritto:
Garber, Mikhail wrote:
In the high-availabilty situation with a warm standby, is it possible (or planned) to be able to make standby readable?
This is a new feature in Oracle 11 and it is very important for a project I am working on.yeah there are plans to support this in 8.4 (and some basic groundwork
already happened in 8.3) ...
cool! do you have some links to pages?
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
On Thu, 2007-11-22 at 09:14 +0100, Ottavio Campana wrote:
Stefan Kaltenbrunner ha scritto:
Garber, Mikhail wrote:
In the high-availabilty situation with a warm standby, is it possible (or planned) to be able to make standby readable?
This is a new feature in Oracle 11 and it is very important for a project I am working on.yeah there are plans to support this in 8.4 (and some basic groundwork
already happened in 8.3) ...cool! do you have some links to pages?
This has been discussed on -hackers over the summer.
Florian Pflug has worked on a patch for this sponsored by Google Summer
of Code, mentored by myself. I hope to begin a more detailed review when
the development phase of 8.4 opens. Florian's work has been to examine
all of the issues and write preliminary code. That looks very good and
is of strong credit to him.
Having said that, the first code is not usually the last code on such a
project and I foresee much work ahead. It's not yet certain that we will
be able to make this work with both full query performance and low
overhead replication, at least in the first release.
So, its something we expect to work on actively in 2008, but won't be
available for use for roughly another year yet.
There is some overlap in functionality between this and Slony, though
there is no intention to replace all of the features of Slony. slony is
available now.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
On Wed, 2007-11-21 at 15:33 -0500, Andrew Sullivan wrote:
On Wed, Nov 21, 2007 at 12:20:51PM -0800, Garber, Mikhail wrote:
In the high-availabilty situation with a warm standby, is it possible (or
planned) to be able to make standby readable?Yes, but it won't happen for 8.3. It's a feature you can have today with
Slony, by the way.
Slony provides the _means_ for it to be a standby-read-only server, but
it _does_ not provide a way for load balancing the queries, (which is
what I really want anyway) The only way to do that is through another
app like LVS / pgpool or even coding it directly into the frontend app.