Hi, I'm thinking about setting up a cluster architecture for a web app. I was thinking about running an "everything replicated on all boxes" arch.
That is, I run a couple of nodes, each with a web/app server + pgpool + PostgreSQL. pgpool set to replicate write transactions to all nodes, but run read queries in the local node. This way, read-only queries do not have network overhead, yet they are load-balanced. I can have a simple high-availability setup (just shut off nodes). Is this a terrible idea? Thoughts? Alex _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
