# zqpool

**Repository Path**: osdba/zqpool

## Basic Information

- **Project Name**: zqpool
- **Description**: ZQPool是中启乘数科技发布的PostgreSQL数据的开源连接池软件。主要解决流行的连接池软件pgbouncer的如下两个缺点：
1. 解决jdbc程序使用pgbouncer连接池无法减少数据库上连接数的问题；
2.  pgbouncer不能利用到CPU的多核，当对高并发的情况下，处理能力超过了单核的能力时，性能就再也上不去了。
- **Primary Language**: Go
- **License**: MulanPubL-2.0
- **Default Branch**: master
- **Homepage**: https://gitee.com/csudata/zqpool
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 18
- **Created**: 2023-10-24
- **Last Updated**: 2023-10-24

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# zqpool

#### Description

ZQPool is an open source connection pool software for PostgreSQL released by CSUDATA.COM. It mainly solves the following two shortcomings of the popular connection pool software pgbouncer:

1. Solve the problem that the JDBC program cannot reduce the number of connections on the database by using pgbouncer;
2. Pgbouncer cannot use the multi-core of CPU. When the processing capacity exceeds the capacity of single core in the case of high concurrency, the performance is pool.


#### Software Architecture

The application connects to zqpool, which connects to the PostgreSQL database.

#### Installation

The installation step is as follows:
1. Copy zqpool1 0.x86_64.xz to a directory
2. Decompression: tar -xf zqpool1.0.x86_64.xz
3. After decompression, there are two files zqpool.conf and zqpool, where zqpool.conf is a configuration file, which is configured accordingly.
4. Then start zqpool.


#### Instructions


Configure zqpool Conf file, each configuration item is described as follows:

* listen_port = 5436     ： set the listening port of zqpool
* listen_addr = *        : set the listening IP of zqpool, when set to "*", which means listening on all local IP addresses
* default_pool_size = 10 :   sets the total number of connections to the backend database
* max_client_conn = 3000 ： the total number of applications allowed to connect to zqpool

* db.1.user=u01            ： user name of the first database
* db.1.dbname=postgres     ： the first database name
* db.1.ipport=172.22.224.10:5432  ： ip address and port of the first database
* db.1.passwd=u01                 :  the password of the first database

Configure file is zqpool.conf, each configuration item is described as follows

* listen_port = 5436     ：set the listening port of zqpool
* listen_addr = *        : set the listening IP of zqpool, when set to "*", which means listening on all local IP addresses
* mgr_port = 9380        : set management port of zqpool
* mgr_addr = *           : 

every pool setup is：

* pool.1.fe_max_conns = 3000
* pool.1.fe_user=u01
* pool.1.fe_passwd=u02
* pool.1.fe_dbname=mydb
* pool.1.be_user=u01
* pool.1.be_passwd=u01
* pool.1.be_dbname=postgres
* pool.1.be_conns = 10
* pool.1.be_ipport=172.22.224.10:5432,172.22.224.10:5411
* pool.1.be_conn_life_time=60  # specify the life_time of backend connection

pool.1 represents the first pool, and there can also be pool.2, pool.3 and etc.  pool.1.be_ipport can be a list of  multiple ip address ports that  separated by commas.


start zqpool:

```
[codetest@pgdev zqpool]$ ./zqpool
2022/05/24 09:12:30 server.go:2188: Starting server on :5436 ...
```

in another terminal windows，use psql connect to zqpool：

```
[codetest@pgdev zqpool]$ /usr/pgsql-10/bin/psql -h 172.22.224.10 -p 5436 -Uu01 -d postgres
Password for user u01:
psql (10.20, server 10.5)
Type "help" for help.


postgres=> \d
         List of relations
 Schema |  Name  | Type  |  Owner
--------+--------+-------+----------
 public | test01 | table | postgres
(1 row)

postgres=> select * from test01;
 id | t
----+---
(0 rows)

postgres=> insert into test01 values(1, '111'),(2,'222'),(3,'333');
INSERT 0 3
postgres=> select * from test01;
 id |  t
----+-----
  1 | 111
  2 | 222
  3 | 333
(3 rows)
```

#### Contribution

1.  Fork the repository
2.  Create Feat_xxx branch
3.  Commit your code
4.  Create Pull Request


#### Gitee Feature

1.  You can use Readme\_XXX.md to support different languages, such as Readme\_en.md, Readme\_zh.md
2.  Gitee blog [blog.gitee.com](https://blog.gitee.com)
3.  Explore open source project [https://gitee.com/explore](https://gitee.com/explore)
4.  The most valuable open source project [GVP](https://gitee.com/gvp)
5.  The manual of Gitee [https://gitee.com/help](https://gitee.com/help)
6.  The most popular members  [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)