Re: [GENERAL] master/master replication with load balancer in front

2015-08-30 Thread Martín Marqués
El 24/08/15 a las 15:41, Florin Andrei escribió: > On 2015-08-23 06:56, Martín Marqués wrote: >> El 21/08/15 a las 20:45, Florin Andrei escribió: >>> >>> The single instance scheme is not very reliable. I need to build a new >>> DB backend. I'll set up Postgres 9.4. Ideally, I'd like to setup 2 >>>

Re: [GENERAL] master/master replication with load balancer in front

2015-08-24 Thread Florin Andrei
On 2015-08-22 03:05, Chris Mair wrote: a few keywords in your mail hint at the fact you're using AWS? If that's the case, you might want to look into their managed PostgreSQL hosting: it's called Amazon RDS for PostgreSQL and supports failover ("Multi AZ") and master-slave replication ("Read Re

Re: [GENERAL] master/master replication with load balancer in front

2015-08-24 Thread Florin Andrei
On 2015-08-23 06:56, Martín Marqués wrote: El 21/08/15 a las 20:45, Florin Andrei escribió: The single instance scheme is not very reliable. I need to build a new DB backend. I'll set up Postgres 9.4. Ideally, I'd like to setup 2 instances, each instance placed in a different availability zone.

Re: [GENERAL] master/master replication with load balancer in front

2015-08-23 Thread Martín Marqués
El 21/08/15 a las 20:45, Florin Andrei escribió: > > The single instance scheme is not very reliable. I need to build a new > DB backend. I'll set up Postgres 9.4. Ideally, I'd like to setup 2 > instances, each instance placed in a different availability zone. > Master/master replication. I'll put

Re: [GENERAL] master/master replication with load balancer in front

2015-08-22 Thread Chris Mair
> I see there are many different ways to build a PG cluster. What would be > the best choice in my case? Hi, a few keywords in your mail hint at the fact you're using AWS? If that's the case, you might want to look into their managed PostgreSQL hosting: it's called Amazon RDS for PostgreSQL and