Let me begin by deferring to The Big Brains, but I am not sure there's enough in this to really advise you from The Implementation Guys. That's me. I/O for any database is an issue, and when I hear any db talking to a SAN, I get a bit leery. Couple that with replication, HA and failover?
If you could explain a bit more about what you're trying to accomplish, what expected performance should be, how that SAN is actually utilized, and such, I might be able to provide some experience on the issue.
Dear All,
We have following environment for database clustering at production environment:
1. Postgres is running on RedHat 6 enterprise edition for primary and failover server
2. SAN disk is available
Now I need help on following
1. What should be clustering software used for Redhat clustering ? Can Veritas Clustering Software (VCS) clustering be used for clustering REDHAT OS?
2. How the SAN disk can be used to store the data centrally? Can this be used as QUORAM disk?
3. Is there any service for Postgres Database service clustering?
Please help me in providing details.
Regards
Shyamkant