On Wed, Nov 28, 2012 at 3:12 PM, suhas.basavaraj12 <suhas.b@verse.in> wrote:
> We are planning to migrate our production databases to different
> servers.We have around 8 servers with 8 different clusters.We are planning
> t shuffle databases and make them as 7 cluster and migrate to new remote
> servers .
> We cannot use streaming replication as we are migrating different databases
> from different clusters to one single cluster . This will be resulting in
> huge downtime as data is huge .
> Need expert advice on this scenario.Can we reduce downtime in any way ..??
One time we had to do something like this (on a smaller scale), we used slony.