Quantcast

cascade replication and multiple primary_conninfo

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

cascade replication and multiple primary_conninfo

e-blokos
Hi,
 
just wondering if PG 9.2 can accept
multiple primary_conninfo on slaves standby servers.
 
if I understood we can now replicate from slave to slave, tha'ts great,
but with only one primary_conninfo so one upstream server,
is it not a point of failure in case of the slave upstream down ?
 
sorry for my ignorance, but is a db like pg can work like bittorrent,
take bits wherever it's possible so set multiple primary_conninfo, "secondary_conninfo" etc... ?
 
Thanks
 
Franck Madovsky
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: cascade replication and multiple primary_conninfo

John R Pierce
On 05/17/12 4:17 PM, E-Blokos wrote:
> sorry for my ignorance, but is a db like pg can work like bittorrent,
> take bits wherever it's possible so set multiple primary_conninfo,
> "secondary_conninfo" etc... ?

torrents work because the torrent itself is static and constant.

databases are dynamic, and changes are supposed to be atomic.    trying
to do N-way mesh replication while maintaining atomicity of changes
would be a nightmare.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...