How to install ClickHouse on Ubuntu — Quick start guide

How to install ClickHouse on Ubuntu — Quick start guide


How to install ClickHouse? ClickHouse is a column-store
database developed by Yandex for processing
analytical queries. It is an optimal digital
analytics tool as it was particularly developed
to resolve Yandex.Metrika tasks. The process of ClickHouse can
be divided into three stages: Purchase of a server working
with Ubuntu OS 14/04 and later. ClickHouse installation. ClickHouse setup. This is not so complicated as it may seem’s. Purchase of a server Go to DigitalOcean (digitalocean.com),
open the server purchasing page and select Create Droplets then specify the required
characteristics of a server. Then the process of purchasing a server will begin and you will get login data by e-mail. Once you get access to a server, you can
continue with ClickHouse installation ClickHouse installation To install ClickHouse, you need to connect
to a server using a SSH client. SSH client is a program allowing to
manage a server via the command line. Any application and even Google
Chrome extension can fit. Launch the SSH client. To connect to a server, specify the
server’s IP address, your login, then set password
after an authentication. After that follow instructions
prepared by our team. To do that, copy commands
from Google Docs sequentially & insert them
in the SSH client console: Specify the repository from which
ClickHouse will be downloaded. Then launch the installation process
(it usually takes several minutes). Launch ClickHouse. There you have it, installation is completed! To ensure it was successful,
launch the console client. Then execute a test query. If everything is correct, it will
return 1 (one) as an answer. Exit the client and switch
to the final stage: ClickHouse setup. After a server setup we
need to execute three steps to ensure further secure
and comfortable work. Right after installation ClickHouse
is closed for connection. You need to provide necessary
IP addresses with access to it. Working with ClickHouse is
much more convenient via the graphic client called
Tabix – switch it on. You need to create an account to
use when accessing ClickHouse. Just do this: Open a server access settings,
that are stored in the config file. Then specify IP addresses allowed
to connect to ClickHouse. Or simply delete listen host so that the
connection from any address is allowed. After that the
tag will upload data to Tabix Save changes. Now when a server is addressed,
Tabix is being downloaded. The only thing left is
to create an account. By default, ClickHouse is creating a user
with the login default and with no password. To set a password, do this: Generate a password by inserting
it in the corresponding command As a result we get
a coded password. Save it. Then edit the users file where we specify the
generated password for the user default. Save changes. Now you can type in login and
password to access ClickHouse. ClickHouse is now available for work. To upload marketing data to ClickHouse you
can use ready connectors made by Renta.