PostgreSQL Replication/Clustering solution
От | guillermo schulman |
---|---|
Тема | PostgreSQL Replication/Clustering solution |
Дата | |
Msg-id | F141uLBYuk4ZojADXR200002578@hotmail.com обсуждение исходный текст |
Список | pgsql-admin |
Hi you all. I'm asked to do a report about Replication/Clustering for PostgreSQL. I need to report about what kind of tools does exist and compare them, and finally propose a solution to implement in the company's database. I have a poor idea about replication/clustering issues (and about writing english, you can see it), so I'd be glad to be helped by you. Here is a brief description of our model: There are a lot of "component servers" (CS) that provide the frontend services. These CS hosted in diferent servers work with databases hosted in the unique main "database server". We are adding periodically more CS because the growing number of users. Adding these CS solves succesfully the scalability problem in this point of view, but the database is becoming over-required due this situation. So, I need to look for solution on database to solve the following problems: - scalability as the 1st priority. - reliability as the second priority (system failure, disaster avoiding, etc). - performance as a future problem to solve (phisically distributed CS with local/remote access). So, which kind of solution, orientated on Replication/Clustering, are available for ProspectSql? And which are the "pros and cons" for each one for our priorities to solve? Thanks, and sorry for my english. _________________________________________________________________
В списке pgsql-admin по дате отправления: