I want to host a web site, the back end will be a PostgreSQL database server. I would like to have multiple web servers, in different data centers for redundancy. I would then round robin DNS each web server to distribute the load.
To do this, should I also have multiple databases and use some sort of replication? Or would it be better to have one database and have each web server point to it over the internet?
The idea was brought up that multiple web servers should have multiple DB servers, to eliminate single point of failure. I would really like to have a duplicate set up at each data center. I would have a web server, and a DB server at each data center. I was not sure if this was possible, so I stayed open to the idea of having only one DB server, or have all DBs at one location. But ideally, each data center would have its own.