From: Kevin Grittner <kgrittn@ymail.com>
To: Jim Nasby <jim@nasby.net>
Cc: bsreejithin <bsreejithin@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: How clustering for scale out works in PostgreSQL
Date: Thu, 12 Sep 2013 11:46:20 -0700 (PDT)
Message-ID: <1379011580.85901.YahooMailNeo@web162901.mail.bf1.yahoo.com> (raw)
In-Reply-To: <5231DB62.4080507@nasby.net>
References: <1377778443804-5768917.post@n5.nabble.com>
<521F61B9.1000709@archonet.com>
<521F63DD.3050301@commandprompt.com>
<1377792804612-5768951.post@n5.nabble.com>
<1377960241.19370.YahooMailNeo@web162901.mail.bf1.yahoo.com>
<5231DB62.4080507@nasby.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Jim Nasby <jim@nasby.net> wrote:
> If you setup some form of replication it's very easy to move to
> larger servers as you grow. I'm sure that when Kevin moved their
> database it was a complete non-event.
Yeah, replication was turned on for the new server in addition to
the old one. When everything was ready the web application
configuration was updates so that it started using the new server
for new requests and disconnected from the old server as requests
completed. Zero down time. No user-visible impact, other than
things ran a little faster because of the better hardware.
One generation of old hardware is kept in replication for running
ad hoc queries and to provide availability in case the new one
crashes.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, jim@nasby.net, bsreejithin@gmail.com
Subject: Re: How clustering for scale out works in PostgreSQL
In-Reply-To: <1379011580.85901.YahooMailNeo@web162901.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox