Size: a a a

ClickHouse не тормозит

2016 November 18

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Which is actually not so difficult but hard to explain
источник

RK

Roman Kolchin in ClickHouse не тормозит
Viktor Tarnavskiy
Which is actually not so difficult but hard to explain
you mean how many nodes apply the same block?
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
I mean what the guarantees when you insert data
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
For example you have replica set of 3
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Your data is replicated to 3 nodes
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
And you insert data to one node
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Should it be 'at least 2' or 'one' is enough?
источник

RK

Roman Kolchin in ClickHouse не тормозит
Viktor Tarnavskiy
For example you have replica set of 3
single OK after insert is not enough? ah yes
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
OK is enough, question is what this OK means =)
источник

RK

Roman Kolchin in ClickHouse не тормозит
Viktor Tarnavskiy
Should it be 'at least 2' or 'one' is enough?
i guess it should be derived from replica factor
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Nope, that's different
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
replica factor is how many times your data is copied
источник

E

Etki in ClickHouse не тормозит
we had a conversation like this here
источник

E

Etki in ClickHouse не тормозит
we're about to break hell loose
источник

RK

Roman Kolchin in ClickHouse не тормозит
Viktor Tarnavskiy
replica factor is how many times your data is copied
i know. and replica factor is a basic factor of durability
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
Generally there are 2 options: async replication and sync replication
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
async is default in clickhouse, and it says 'insert in one is OK'
источник

RK

Roman Kolchin in ClickHouse не тормозит
so if snapshot is saved by 'replica factor' nodes this insert is really ok
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
sync replication usually is really slow
источник

VT

Viktor Tarnavskiy in ClickHouse не тормозит
It's not. It's OK in terms of guarantees but slowdown is like 10 times easily
источник