sfmysql's profile picture. A forum for users and aficionados of MySQL to get together and talk about their favorite open source database!

SF MySQL Meetup

@sfmysql

A forum for users and aficionados of MySQL to get together and talk about their favorite open source database!

SF MySQL Meetup 님이 재게시함

Presentations from yesterday's Meetup are here altinity.com/sfmeetup2017 @VadimTk @vavrusam @kodiakdata @Cloudflare @Percona @sfmysql


#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...


Loading...

Something went wrong.


Something went wrong.