via MySQL Client

Overview

You can connect to and execute queries on your Hydrolix cluster using a MySQL client. The Clickhouse MySQL interface provides support for the MySQL protocol and dialect.

Connecting to a Hydrolix cluster

By default, Hydrolix clusters listen on port 9004 for MySQL TCP connections.

If you have a MySQL client installed, you can test connecting to your Hydrolix cluster using the following command:

mysql --protocol tcp -h $HDX_HOST -P 9004 -u $USERNAME --password=$PASSWORD

Tunables

You can use the following tunables to enable/disable query forwarding, modify which port accepts MySQL queries, and to enable/disable TLS.

Name	Description	Type	Default
`disable_traefik_mysql_port`	When set to `true`, the load balancer won't forward queries to Traefik on the default Clickhouse MySQL interface port `9004`.	boolean	`false`
`mysql_port`	The port to serve the Clickhouse MySQL interface on if applicable.	integer	`9004`
`mysql_port_disable_tls`	When `true`, Traefik won't use Transport Layer Security (TLS) configuration on MySQL TCP route. Using TLS is currently not supported.	boolean	`true`

See the Hydrolix Tunables page to read more about tunables and how to use them.

Compatible query tools

The following Business Intelligence tools are tested with the Clickhouse MySQL interface:

Limitations

The MySQL query interface may not support all MySQL language features. The interface is a proxy that converts SQL queries using the MySQL dialect into equivalent ClickHouse queries. A particular query may require dialect features (for example, MySQL-specific functions or settings) that aren't implemented in Clickhouse.
TLS isn't supported