Thread: 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
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.
Attachment
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
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 note
Everything 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. Connect now!
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 note
Everything 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. Connect now!
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.