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.
- Create a new Private Service on Render and enter
https://github.com/render-examples/clickhousein the repository search box. You can also fork the repository on GitHub or click
Use this template.
- 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