# 连接池中间件配置示例（PgBouncer）
# 安装PgBouncer
yum install pgbouncer

# 配置PgBouncer
# 编辑pgbouncer.ini
[databases]
fgedudb = host=192.168.1.10 port=5432 dbname=fgedudb

[pgbouncer]
listen_addr = 0.0.0.0
listen_port = 6432
auth_type = md5
auth_file = /etc/pgbouncer/userlist.txt
pool_mode = transaction
max_client_conn = 1000
default_pool_size = 20风哥提示：

# 创建用户列表文件
echo “”fgedu” “Fgedu123!”” > /etc/pgbouncer/userlist.txt

# 启动PgBouncer
systemctl start pgbouncer
systemctl enable pgbouncer

# 缓存中间件配置示例（Redis）
# 安装Redis
yum install redis

# 配置Redis
# 编辑redis.conf
bind 0.0.0.0
port 6379
requirepass Redis123!
maxmemory 2gb
maxmemory-policy allkeys-lru

# 启动Redis
systemctl start redis
systemctl enable redis

# 案例1：使用PgBouncer管理数据库连接
# 1. 安装PgBouncer
yum install pgbouncer

# 2. 配置PgBouncer
# 编辑pgbouncer.ini
[databases]
fgedudb = host=192.168.1.10 port=5432 dbname=fgedudb

[pgbouncer]
listen_addr = 0.0.0.0
listen_port = 6432
auth_type = md5
auth_file = /etc/pgbouncer/userlist.txt
pool_mode = transaction
max_client_conn = 1000
default_pool_size = 20

# 3. 创建用户列表文件
echo “”fgedu” “Fgedu123!”” > /etc/pgbouncer/userlist.txt

# 4. 启动PgBouncer
systemctl start pgbouncer
systemctl enable pgbouncer

# 5. 测试连接
gsql -h 192.168.1.10 -p 6432 -U fgedu -d fgedudb

# 输出：
# gsql ((openGauss 3.0.0 build 02c14696) compiled at 2024-01-01 00:00:00)
# Non-SSL connection (SSL connection is recommended when requiring high-security)
# Type “help” for help.
#
# fgedudb=>

# 6. 查看连接池状态
psql -h 192.168.1.10 -p 6432 -U fgedu -d pgbouncer

# 执行以下命令查看状态学习交流加群风哥QQ113257174
SHOW POOLS;

# 输出：
# database | cl_active | cl_waiting | sv_active | sv_idle | sv_used | sv_tested | sv_login | maxwait | maxwait_us | pool_mode
# ————+———–+————+———–+———+———+———–+———-+———+————+———–
# fgedudb | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | transaction
# (1 row)

# 案例2：使用Redis作为缓存
# 1. 安装Redis
yum install redis

# 2. 配置Redis
# 编辑redis.conf
bind 0.0.0.0
port 6379
requirepass Redis123!
maxmemory 2gb
maxmemory-policy allkeys-lru

# 3. 启动Redis
systemctl start redis
systemctl enable redis

# 4. 测试Redis
redis-cli -h 192.168.1.10 -p 6379 -a Redis123!

# 执行以下命令测试
SET fgedu:test “Hello, Redis!”
GET fgedu:test

# 输出：
# OK
# “Hello, Redis!”

# 5. 在应用程序中使用Redis
# Java代码示例更多视频教程www.fgedu.net.cn
// 导入Redis客户端库
import redis.clients.jedis.Jedis;

// 连接Redis
Jedis jedis = new Jedis(“192.168.1.10”, 6379);
jedis.auth(“Redis123!”);

// 存储数据
jedis.set(“fgedu:user:1”, “{\”id\”:1,\”name\”:\”fgedu\”,\”age\”:30}”);

// 读取数据
String user = jedis.get(“fgedu:user:1”);
System.out.println(user);

// 关闭连接
jedis.close();