Clickhouse indexer

[MakarovSg]

Is there any way to run clickhouse version of indexer? I see some artifacts, but there is nothing in docs/envs.

[dungeon-master-666]

Hello,

There's an index worker executable that inserts to clickhouse. Follow these steps to deploy it:

• Run clickhouse instance
• Run TON node on the machine where index worker will be be deployed
• Build target ton-index-clickhouse of ton-index-worker
• Increase number of open files ulimit -n 65536 and run ./ton-index-clickhouse --db /var/ton-work/db --host CH_IP --port CH_PORT --user USER --password PASSWORD --dbname DB_NAME --from START_SEQNO. You can see full list of parameters here. The worker will create the necessary database and tables itself.

Note that the DB schema might change in future. We don't provide migrations for clickhouse, so you will need to reindex data in that case.