# ClickHouse

Experimental Feature

Keitaro has ClickHouse as an experimental feature. To try ClickHouse, you please contact our support.

# Why switch to ClickHouse

  • Making reports through ClickHouse is much faster.
  • ClickHouse consumes much less disk space to store data on the disk.

# Breaking changes

  • Column ip can contain IPv6 values.
  • Columns click_id and conversion_id have UUID value instead of number. That's because ClickHouse doesn't have autoincrement.
  • Column visitor_id is removed. That's because all the tables denormalized.
  • Keitaro stops writing new entries to MariaDB (MySQL).

Revert back to MariaDB (MySQL)

If you decide to move back to the old database, all the collected data will be lost.