High Availability Setup
От | Nathan Barnett |
---|---|
Тема | High Availability Setup |
Дата | |
Msg-id | 71975481CD04D4118E57004033A2596E0DF913@ip205.82.136.216.in-addr.arpa обсуждение исходный текст |
Список | pgsql-general |
I am currently using PostgreSQL v.7.0.2 and Enhydra for a project that will ultimately require 25M transactions per day. This will be hosted on a Sun 420R server maxed out with CPU's running off of Sun's high end storage cluster. My question is whether anyone has installed PostgreSQL in a solution requiring this much scalability and if so, what sort of set up have you used to handle this much load? The environment does not require absolute uptime. The company that will be implementing this currently has downtime of roughly 48 hours per year. They currently run MySQL to perform 50K transactions per day on a single box running Linux. I chose PostgreSQL because there will be large queries running intermittently with many INSERT's and smaller queries and I was concerned with the locking functionality of MySQL. Any comments as to anyone's experience on this would greatly appreciated. -------------- Nathan Barnett
В списке pgsql-general по дате отправления: