Pgpool - Middleware between PostgreSQL Client and Server

  •        564

pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It supports connection pooling, Using the replication function enables creating a realtime backup on 2 or more physical disks, so that the service can continue without stopping servers in case of a disk failure, Load balance the queries, It can execute queries in parallel to multiple servers.

http://www.pgpool.net

Tags
Implementation
License
Platform

   




Related Projects

DBBalancer - Middleware btw Database client and server


DBBalancer is some sort of middleware that would sit in between of database clients and a server. Currently the only server supported is Postgres, but the architecture is open to embrace more servers in a future. It's a connection pool, a load balancer and a database replicator.

Libzdb - Connection Pool Library in C


Libzdb is a small, fast and easy to use Database Connection Pool Library. It is thread safe and connects to database like MySQL, PostgreSQL, SQLLite and Oracle.

SQL Relay - Database Connection Pool library with API available in all programming languages


SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, and all major databases. It has APIs for C, C++, ODBC, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, Java, TCL and Erlang, drop-in replacement libraries for MySQL and PostgreSQL clients.

pgpool-II - Pgpool - a connection pooling/replication server for PostgreSQL


Pgpool - a connection pooling/replication server for PostgreSQL



c3p0 - JDBC3 Connection and Statement Pooling


c3p0 is an easy-to-use library for making traditional JDBC drivers "enterprise-ready" by augmenting them with functionality defined by the jdbc3 spec and the optional extensions to jdbc2. It provides (DriverManager-based) JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.

DBCP - Java Database Connection Pooling library


Creating a new connection for each user can be time consuming (often requiring multiple seconds of clock time), in order to perform a database transaction that might take milliseconds. Opening a connection per user can be unfeasible in a publicly-hosted Internet application where the number of simultaneous users can be very large. Accordingly, developers often wish to share a "pool" of open connections between all of the application's current users.

Vibur DBCP - A concurrent and dynamic JDBC connection pool.


Vibur DBCP is a concurrent, fast and fully-featured JDBC connection pool based on Java dynamic proxies. It supports a fairness parameter, statement caching, SQL queries logging, and Hibernate integration, among other features.

Proxool - Java connection pool


Proxool is a Java connection pool. It transparently adds connection pooling to your existing JDBC driver. The performance of database connections could be monitored. It's easy to configure using the JDBC API, XML, or Java property files. It complies with the J2SE standards.

DBPool - Java Database Connection Pooling


A Java-based database connection pooling utility, supporting Time-based expiry, Statement caching, Connection validation, and easy configuration using a pool manager.

HikariCP - A high-performance JDBC connection pool


Fast, simple, reliable. HikariCP is a "zero-overhead" production ready JDBC connection pool. At roughly 90Kb, the library is very light.

db_connection - Database connection behaviour


Database connection behaviour and database connection pool designed for handling transaction, prepare/execute, cursors and client process describe/encode/decode.Four pool implementations are provided: DBConnection.Connection (default/single connection), DBConnection.Poolboy (poolboy pool), DBConnection.Sojourn (sbroker pool) and DBConnection.Ownership (ownership pool).

Barman - Backup and Recovery manager for PostgreSQL


Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers . It allows your organisation to perform remote backups of multiple servers in business critical environments and to help DBAs during the recovery phase. Its features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups.

djorm-ext-pool - DB-API2 connection pool for Django (for postgresql, mysql and sqlite)


DB-API2 connection pool for Django (for postgresql, mysql and sqlite)

pgproxy - PostgreSQL proxy server.


pgproxy is a postgresql proxy server, through a pipe redirect connection, which allows you to filter the requested sql statement. In the future it will support multi-database backup, adapt to distributed databases and other schemes except the analyze sql statement.Start or shut down the proxy server.

sm-postgresql - SM Postgresql Extension Set (postgresql, pgpool, pgbouncer, slony, extensions)


SM Postgresql Extension Set (postgresql, pgpool, pgbouncer, slony, extensions)

r2d2 - A generic connection pool for Rust


A generic connection pool for Rust.Opening a new database connection every time one is needed is both inefficient and can lead to resource exhaustion under high traffic conditions. A connection pool maintains a set of open connections to a database, handing them out for repeated use.

puppet-pgpool - puppet module for postgresql pgpool


puppet module for postgresql pgpool

pgbouncer-ng - Simple connection pool for postgresql, written in python.


Simple connection pool for postgresql, written in python.