v.20.3Improvement

Improve MySQL Connection Pool Sharing for External Dictionaries

Official CH changelog text
For external MySQL dictionaries, allow to mutualize MySQL connection pool to "share" them among dictionaries. This option significantly reduces the number of connections to MySQL servers. #9409 (Clément Rodriguez)
Allows external MySQL dictionaries in ClickHouse to share a mutualized MySQL connection pool.

Why it matters

This feature reduces the number of concurrent connections to MySQL servers by enabling multiple MySQL dictionaries to use a shared connection pool, improving resource efficiency and scalability.

How to use it

Enable the mutualized MySQL connection pool option in the configuration of external MySQL dictionaries to share connections among them, thereby minimizing the total number of MySQL connections.

Related resources

PreviousNext