v.1.1.54289New Feature

External Dictionaries Loading from MySQL via Filesystem Socket

Official CH changelog text
External dictionaries can be loaded from MySQL by specifying a socket in the filesystem.
Allows loading external dictionaries from MySQL by specifying a filesystem socket instead of a TCP connection.

Why it matters

This feature was created to enable ClickHouse to connect to MySQL instances using Unix domain sockets (filesystem sockets) for external dictionaries, which can improve security and performance by avoiding TCP overhead and allowing socket file permissions control.

How to use it

When defining an external dictionary source of type MySQL, specify the socket parameter with the path to the MySQL Unix socket file instead of the usual host and port parameters.
PreviousNext