Hi, Dimitri Fontaine wrote:
If slave nodes were able to accept connection and redirect them to master, the client wouldn't need to care about connecting to master or slave, just to connect to a live node.
I've thought about that as well, but think about it this way: to protect against N failing nodes, you need to forward *every* request through N living nodes, before actually hitting the node which processes the query. To me, that sounds like an awful lot of traffic within the cluster, which can easily be avoided with automatic client failover.
(Why are you stating, that only slaves need to redirect? What is happening in case of a master failure?)
So the proposal for Automatic Client Failover becomes much more simpler.
I'm arguing it's the other way around: taking down a node of the cluster becomes much simpler with ACF, because clients automatically reconnect to another node themselves. The servers don't need to care.
Regards Markus Wanner -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
