cascade replication and multiple primary_conninfo
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
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