Size: a a a

ClickHouse не тормозит

2016 November 18

VT

Viktor Tarnavskiy in ClickHouse не тормозит
┌─table─┬─new_part_name──────────────────────┬─type────────┐
│ hits  │ 20161113_20161118_131116_158637_19 │ MERGE_PARTS │
└───────┴────────────────────────────────────┴─────────────┘
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
and there is different columns you can check
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
We use the same process for money data actually
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
But we have 'golden source' for that
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
And for that 'golden source' (also in ClickHouse) we use synchronious replication
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
It is possible but it's not documented for now
источник

RK

Roman Kolchin in ClickHouse не тормозит
golden source or persistent cache for hot data + blocked inserts + replication queue = great durability for highload analytics
источник

RK

Roman Kolchin in ClickHouse не тормозит
even for money data :)
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
yep
источник

RK

Roman Kolchin in ClickHouse не тормозит
Viktor Tarnavskiy
And for that 'golden source' (also in ClickHouse) we use synchronious replication
what is performance impact from this feature?
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
you have to wait while your data is transferred to at least one more node
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
i have no numbers for our case now
источник

E

Etki in ClickHouse не тормозит
are there any plans to add 'x replicas replied ok' requests/responses, like persistent storages?
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Should be like x2
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
We'll have 'guarantee that at least n/2 + 1 replicas replied ok'
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
I believe it should be enougn
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
And that's just a settings parameter so easy to use
источник

E

Etki in ClickHouse не тормозит
that would be cool to satisfy those who want guarantees about stored data
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Yeah
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
We already have that actually
источник