Altinity

Altinity Demo Appliance

The easiest way to get started with ClickHouse

Altinity Demo Appliance (ADA) is a set of tools packaged together to simplify your experience in integrating analytics solutions based on ClickHouse DBMS. The core of ADA is ClickHouse which is an open source column-oriented database engine. ADA comes in different distributions such as Amazon Machine Image or Docker Image.

Altinity Demo Appliance includes a simple web application allowing you to access pre-configured interated tools such as:

  • ClickHouse: open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.
  • Tabix: SQL editor, GUI and introspection tool for ClickHouse
  • Grafana: open source platform for beautiful analytics and monitoring
  • ProxySQL: high-performance MySQL proxy
  • Ontime Demo Dataset Installer: demo dataset download and installation
  • Nginx Access Logs and MySQL Slow Logs Loader Application: simple application that passes uploaded log files through a log parser and loads the data into ClickHouse in live mode.

What can you do with ADA?

Try ClickHouse with large dataset. If you're not familiar with ClickHouse the first thing you will find helpful in ADA is that it gives you a brief summary about ClickHouse itself and what it can do, followed by an interactive example where you can trigger the demo dataset installation process. This demo use case demonstrates how big amount of data can be transferred from CSV files into ClickHouse database and then used as a source of different analytic queries executed at sub-second performance.

Perform log analytics with ClickHouse. Use ADA to see how fast and easy log analytics can be using tools like: ClickHouse, Grafana and Logstash connected together. This is done by uploading a log file of a type of Nginx Access or MySQL Slow log using a simple web form.

Try simple Data Visualization / BI tools with ClickHouse. ADA includes pre-configured Tabix and Grafana tools allowing you to build data charts using your own queries to ClickHouse.

Access ClickHouse DB like MySQL using ProxySQL. The last but not least as a developer you can use MySQL Workbench or pretty much any other UI tool designed for MySQL database connecting it to ClickHouse through ProxySQL server. This gives you a way to work with ClickHouse, run SQL queries and build reports using MySQL UI tools or MySQL-aware applications.

Getting started with ADA

You can get ADA for personal use by using a Docker Image or an Amazon Machine Image.

Using ADA Docker Image

  1. Pull ADA image from docker hub:
    $ docker pull altinity/demo:v1
  2. Once it is on your local machine, you can start the container. You also need to open required ports:
    $ docker run -dit -p 3000:3000 -p 8123:8123 -p 6090:6090 -p80:80 altinity/demo:v1
  3. Go to a landing web page, i.e. http://localhost/ And you can log in to the instance using altinity/demo credentials.

Using ADA Amazon Machine Image

  1. Log into Amazon WS Console and go to EC2 service.
  2. Search for “Amazon Demo Appliance” image or Image ID: “ami-91c91be8”.
  3. Launch the instance using the AMI. Make sure to select at least 4Gb RAM to be able to install one of the demo datasets.
  4. Go to the landing web page, i.e. http://YOUR.INSTANCE.IP/ And you can log in to the instance using altinity/demo credentials.