PostgreSQL on Solaris PGCon 2007
[Pages:40]PostgreSQL on Solaris PGCon 2007
Josh Berkus, Jim Gates, Zdenek Kotala, Robert Lor Sun Microsystems
1
Agenda
? Sun Cluster ? ZFS ? Zones ? Dtrace ? Service Management Facility (SMF)
PGCon 2007
2
Hightly Available HA-PostgreSQL on Sun Cluster
PGCon 2007
3
1. Sun Cluster
? Loosely coupled heterogeneous nodes
> Max. 64 nodes
? Provides single client view of network services or applications
> databases, web services, file services.
? Highly available and scalable applications ? Capacity for modular growth ? Low entry price compared to traditional hardware
fault-tolerant systems.
PGCon 2007
4
2. Sun Cluster Continued
? Continuously monitors health of member nodes, networks and storage
? Monitors applications and their dependent system resources, and fails over or restarts applications in case of failures.
? Fault-tolerant hardware systems come at a higher cost because of specialized hardware.
PGCon 2007
5
3. Sun Cluster Goals
? Reduce system downtime due to software or hardware failure
? Ensure availability of data and applications, regardless of the kind of failure that would normally take down a single server system
? Increase application throughput by enabling services to scale to additional processors by adding nodes to the cluster
? Perform maintenance without shutting down the entire cluster
PGCon 2007
6
4. Failover and Scalability
? A single cluster can support both failover and scalable applications.
? Failover
> Cluster automatically relocates an application from a failed primary node or zone to a designated secondary node or zone.
> Clients might see a brief interruption in service and might need to reconnect after the failover has finished.
PGCon 2007
7
5. Failover and Scalability
? Scalability
> Leverages the multiple nodes in a cluster to concurrently run an application, thus providing increased performance.
> Each node in the cluster can provide data and process client requests.
? HA-PostgreSQL is a failover application
PGCon 2007
8
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- psql role does not exist
- postgresql on solaris pgcon 2007
- postgresql sql syntax and use
- postgresql sql syntax and use pearson
- the pci compliant database pgcon
- how postgresql tuning can profit from 20 years oracle tuning
- skytools3 postgresql trigger based replication
- postgresql tuning for oracle dbas
- install postgresql postgis for qgis by lex berman
- back end development
Related searches
- microsoft office 2007 download office 2007 microsoft
- install microsoft office 2007 on windows 10
- install word 2007 on windows 10
- postgresql if not exist
- postgresql execute sql script
- postgresql execute format
- postgresql list users
- postgresql execute using
- postgresql execute query
- postgresql show all users
- postgresql database does not exist
- postgresql execute into