From: Scott Marlowe <scott.marlowe@gmail.com>
To: Kiswono Prayogo <kiswono@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Best Replication Tool
Date: Sun, 7 Feb 2010 20:32:46 -0700
Message-ID: <dcc563d11002071932r136b9d3eyc004fd0452ef24c4@mail.gmail.com> (raw)
In-Reply-To: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com>
References: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com>
On Sun, Feb 7, 2010 at 8:22 PM, Kiswono Prayogo <kiswono@gmail.com> wrote:
> Hi, i'm really new to postgresql replication, was there any
> replication tool for postgresql that can do real-time replication from
> 1 database to ~3-10 database (on the other machines) with little
> overhead for load balancing purpose?
Well, you're not telling us how much traffic you're looking at or how
powerful your servers will be. Where I work we have two large master
servers (lots of SAS drives on power hardware RAID controllers with
battery backed cache) which are our master and slave-master, so to
speak, then we currently have two, but may have more, slaves synced
off of the slave-master machine. We use slony. It works well enough,
but there are some issues with large numbers of db objects (lots of
tables / indexes / schemas) that we've run into with it that are
making me pull some hair out, and I haven't had time to troubleshoot
them.
Overall though, it's a quite capable system, and once it's setup and
running it's fast and stable.
There's also londiste, bucardo, and a few others worth looking at.
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, kiswono@gmail.com
Subject: Re: Best Replication Tool
In-Reply-To: <dcc563d11002071932r136b9d3eyc004fd0452ef24c4@mail.gmail.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