Search Postgresql Archives

Re: PostgreSQL Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2021-02-16 09:28, Raul Giucich wrote:
> This article will help you
> https://wiki.postgresql.org/wiki/Multimaster
> <https://wiki.postgresql.org/wiki/Multimaster>. 
> 
> El mar., 16 feb. 2021 10:56, Mutuku Ndeti <jnmutuku@xxxxxxxxx
> <mailto:jnmutuku@xxxxxxxxx>> escribió:
> 
>     Hi,
> 
>     Need some advice here. I have an application using PostgreSQL. I
>     need to install it on 2 servers for redundancy purposes and have 2
>     databases. I need the DBs to replicate to each other, in real-time.
>     Writes can be done on both DBs. 
> 
>     Please let me know if this is a feasible setup and the best way to
>     proceed. 
> 

Hi,

While I have no experience with replication on pgsql, in general
multi-master database replication is much more complex and often require
a pretty rigid setup. The graphs on that page seems to tell the same
story for pgsql.

Are you sure you really need multi-master replication as opposed to
having a single active master in a replicated set? If properly
configured, cluster software can automatically fail over the active
master, which provides very good redundancy and is much simpler from a
technological standpoint.

Regards,

--
Thomas





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux