v.1.1.54289New Feature

External Dictionaries Loading from MySQL with SSL Support

Official CH changelog text
External dictionaries can be loaded from MySQL over SSL (ssl_cert, ssl_key, ssl_ca parameters).
Support for loading external dictionaries from MySQL databases using SSL connections, enabling secure data retrieval via parameters ssl_cert, ssl_key, and ssl_ca.

Why it matters

This feature was created to enhance the security of external dictionary loading by allowing encrypted SSL connections to MySQL sources. It solves the problem of insecure data transmission when connecting to MySQL databases for dictionaries, thus providing confidentiality and integrity for sensitive data. For users, it provides a way to safely integrate MySQL-based dictionaries into ClickHouse without risking data leaks or man-in-the-middle attacks.

How to use it

To use this feature, specify the SSL-related parameters in the external dictionary configuration YAML or XML such as ssl_cert (path to client certificate), ssl_key (path to client private key), and ssl_ca (path to the CA certificate) along with the existing MySQL connection parameters. Upon establishing a connection, ClickHouse will use these SSL certificates to connect securely to the MySQL server and then load the external dictionary data.
PreviousNext