Tag

ConnectionPool

0 views collected around this technical thread.

37 Interactive Technology Team
37 Interactive Technology Team
Mar 18, 2024 · Databases

Handling MySQL Read‑Only Errors During Master‑Slave Switch in Go: Extending the Driver and Using rejectReadOnly

When a MySQL master‑slave switch makes the old master read-only, Go connection pools keep reusing stale connections and cause prolonged write errors, but by extending the driver to return driver.ErrBadConn on error 1290 or using the DSN flag rejectReadOnly=true, the bad connections are discarded and the error disappears almost instantly.

ConnectionPoolDatabaseSwitchDriverExtension
0 likes · 14 min read
Handling MySQL Read‑Only Errors During Master‑Slave Switch in Go: Extending the Driver and Using rejectReadOnly
DeWu Technology
DeWu Technology
Dec 25, 2023 · Databases

Jedis Connection Pool: Principles, Configuration, and Troubleshooting

Jedis uses Apache Commons’ GenericObjectPool to manage Redis connections, with Spring‑Data‑Redis creating a JedisConnectionFactory that holds a configurable pool where borrowObject and returnObject handle idle queues, eviction and validation settings (testOnBorrow, testWhileIdle, etc.) can be tuned, and JMX metrics aid troubleshooting.

ConnectionPoolGenericObjectPoolJava
0 likes · 10 min read
Jedis Connection Pool: Principles, Configuration, and Troubleshooting
High Availability Architecture
High Availability Architecture
Nov 29, 2021 · Databases

Analysis of DBCP Connection‑Pool Bug Causing Database Connection Saturation and Recommended Mitigations

The article investigates a DBCP 1.4 connection‑pool bug that allows the pool to exceed its configured limits, explains how removeAbandoned and socketTimeout interact to produce excess MySQL connections, reproduces the issue with a multithreaded test, and proposes configuration changes to avoid it.

AbandonedConnectionPoolDBCP
0 likes · 10 min read
Analysis of DBCP Connection‑Pool Bug Causing Database Connection Saturation and Recommended Mitigations
vivo Internet Technology
vivo Internet Technology
Jun 9, 2021 · Mobile Development

HTTP Connection Reuse Optimization in OkHttp:原理与实践

The article explains how reusing HTTP connections with OkHttp—by leveraging persistent HTTP/1.1, multiplexed HTTP/2, and pre‑established sockets—dramatically cuts latency, details the underlying ConnectInterceptor and ConnectionPool implementation, and recommends enlarging the pool and adjusting keep‑alive settings to suit multi‑domain, high‑concurrency apps.

ConnectionPoolHTTP connection reuseHTTP/2
0 likes · 15 min read
HTTP Connection Reuse Optimization in OkHttp:原理与实践