#sfmysql #CreditKarma was such a great host for our Meetup!

#sfmysql ClickHouse is young - CloudFlare has opensourced GO driver, Grafana plugin, Kafka -> ClickHouse

#sfmysql CloudFlare now has 33 nodes, 8M+/sec insertions...

#sfmysql CloudFlare uses Grafana to look at the data!

#sfmysql ClickHouse primary key is more like a sorting key..

#sfmysql ClickHouse basically does materialized views which makes me think of a couple of MySQL DBAs

#sfmysql ClickHouse at CloudFlare does 1mill records /second

#sfmysql CloudFlare wrote a go converter from Kafka to ClickHouse

#sfmysql tried Kafka + a number of technologies..

#sfmysql CloudFlare needed multidimensional analytics, as hoc, scale, roll-ups/aggregations etc

#sfmysql resultsets must fit into memory.

#sfmysql ClickHouse is limited by SQL. Can do joins & you must define join order

#sfmysql ClickHouse & ProxySQL are working together to incorporate it into MySQL

#sfmysql ClickHouse has resources incl GUI tool, docs more companies are using - Carto, CloudFlare, Percona and Yandex who wrote it

#sfmysql ClickHouse cons limited tools, custom SQL, somewhat young

#sfmysql ClickHouse is OLAP not OLTP, key-value, not a doc store & no editing of data

#sfmysql ClickHouse can work on 1 server with more CPUs or distributed.. AND it has replicas, cross DC!

#sfmysql Finally a Meetup with @VadimTk talking about ClickHouse analytic open source

Sadly missing #PerconaLive2017 and sad to hear no eomen in the C level panel...