Tag

Database Connectivity

1 views collected around this technical thread.

JD Cloud Developers
JD Cloud Developers
Jun 28, 2023 · Backend Development

How testOnBorrow Guarantees Reliable DB Connections in Apache Commons DBCP

This article examines the testOnBorrow mechanism in Apache Commons DBCP, detailing how validation occurs at each layer—from the commons‑pool framework through the DBCP implementation down to the MySQL driver—to ensure robust and high‑availability database connections.

Apache Commons DBCPConnection PoolDatabase Connectivity
0 likes · 7 min read
How testOnBorrow Guarantees Reliable DB Connections in Apache Commons DBCP
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 4, 2020 · Databases

Effect of Floating IP (SIP) Switch on MySQL Connections and the Importance of TCP Keepalive

The article describes an experiment that shows when a floating IP (SIP) moves between MySQL servers, existing client connections experience long delays until TCP keepalive detects the failure, highlighting the need to configure shorter keepalive intervals for high‑availability database deployments.

Database ConnectivityFloating IPMySQL
0 likes · 4 min read
Effect of Floating IP (SIP) Switch on MySQL Connections and the Importance of TCP Keepalive