Pgpool-II Pgpool-II is a proxy software that sits between PostgreSQL servers and a PostgreSQL database client. It provides the following features: 1.Connection Pooling: Pgpool-II maintains established connections to the PostgreSQL servers, and reuses them whenever a new connection with the same properties (i.e. user name, database, protocol version, and other connection parameters if any) comes in. It reduces the connection overhead, and improves system's overall throughput. 2.Load Balancing: If a database is replicated (because running in either replication mode or master/slave mode), performing a SELECT query on any server will return the same result. Pgpool-II takes advantage of the replication feature in order to reduce the load on each PostgreSQL server. It does that by distributing SELECT queries among available servers, improving the system's overall throughput. In an ideal scenario, read performance could improve proportionally to the number of PostgreSQ
Nice content, and thanks for sharing.
ReplyDeleteDatabase Genex supports all major databases including Oracle MySQL, Percona MySQL, PostgreSQL, MongoDB, and associated platforms. We at Genex, seamlessly handle all complexities of database installation and custom-make your solutions for your specific needs. We manage your database with no data loss while also putting the best practices in place to prevent/minimize any data loss.
ReplyDeletehttps://genexdbs.com/
Postgre SQL Interview Questions and Answers
ReplyDelete