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