ClickHouse is a column-oriented OLAP database system that allows generating analytical reports in real-time using SQL queries. Clickhouse strives to maximize hardware efficiency and is capable of processing typical analytical queries two to three orders of magnitude faster than traditional row-oriented systems. It also supports multi-master asynchronous replication where all nodes are equal, which prevents single points of failure. You can run your own ClickHouse instance as a private service on Render backed by SSD disks which have automatic snapshots.
Click the button below to install ClickHouse on Render.
Pick Docker for the Environment.
Be sure to choose the Standard plan or higher. ClickHouse may exhaust memory limits on starter plans.
masterbranch uses the latest stable version of ClickHouse. You can choose a different branch if you’d like to use a specific ClickHouse version.
Under Advanced, add a disk with the following values:
10 GBFeel free to change this to suit your needs.
You’re all set! Save your private service, and your ClickHouse instance should be up in a few minutes.
You should be able to connect to your ClickHouse instance using
host:port values displayed in the dashboard like
9009 is internal and used for replication). Consult ClickHouse documentation on interfaces for more details.
|Native interface for driver libraries and |
|MySQL wire protocol|
You can also use the shell in your dashboard to connect to your database.
$ clickhouse-client --host clickhouse-xyz