2 ms·
I don't know about CloudFlare specifically but the usual way to create tables in clusters is to use the CREATE TABLE IF NOT EXISTS <name> ON CLUSTER <cluster>.
by hodgesrm 6y ago
I don't know about CloudFlare specifically but the usual way to create tables in clusters is to use the CREATE TABLE IF NOT EXISTS <name> ON CLUSTER <cluster>. It executes the command across all nodes. You can automate this easily. [1]
The built-in exporter is relatively new--the original PR was merged in December of last year and it still had changes coming in mid-year 2020.
Also, compatibility with clickhouse-exporter was unfortunately not a requirement, so the metric names and coverage do not fully match.
[1] https://clickhouse.tech/docs/en/sql-reference/statements/create/table/ https://clickhouse.tech/docs/en/sql-reference/statements/cre...
- pachico 6y agoYou are right, for some reason I totally forgot about it (probably because I still do it on each node since I started when that feature didn't exist). Interesting about the exporter, thanks for sharing.