In this lesson we will:
- Lesson contents 1
- Lesson contents 2
- Lesson contents 3
We recommend using a free ClickHouse Cloud Account when studying this lesson
Storage Location
ClickHouse will by default store it's data and state on the local servers disk. If you wish to backup the data, this is the location to replicate:
ls -la /var/lib/clickhouse
Outputs:
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 access
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 backups
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 cores
drwxr-x--- 4 clickhouse clickhouse 4096 Nov 18 22:31 data
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 dictionaries_lib
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 flags
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 format_schemas
drwxr-x--- 4 clickhouse clickhouse 4096 Nov 18 22:31 metadata
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 metadata_dropped
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 preprocessed_configs
-rw-r----- 1 clickhouse clickhouse 57 Nov 18 22:31 status
drwxr-x--- 10 clickhouse clickhouse 4096 Nov 18 22:31 store
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 tmp
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 user_defined
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 user_files
drwxr-x--- 2 clickhouse clickhouse 4096 Nov 18 22:31 user_scripts
-rw-r----- 1 clickhouse clickhouse 36 Nov 18 22:31 uuid