ClickHouse in Avito: live gatherings with Alexey Milovidov

Hello, Habr! On April 9, from 17:00 to 20:00, our engineers will gather for cozy gatherings with the chief developer of ClickHouse Alexei Milovidy. We will talk about how we use the database management system in Avito, what difficulties we face, and ask Alexey questions about the present and future of ClickHouse.


For obvious reasons, we are not holding events at the office right now, so we invite everyone to watch the live broadcast of the meeting. Format: three micro-reports and a large Q&A session where viewers can ask their questions.



TL; DR: register on the Taipad and we will send a link reminding you of the broadcast.

Reports


We will start with three Avito reports to immerse viewers and Alexei in the context of the conversation. Our engineers will tell how their teams use ClickHouse. For everything about everything - 20 minutes, and move on to the question and answer session.


Vladimir Kolobaev, lead system administrator


image


  ClickHouse.  β€”   .  6  20   SSD.    12 . , .   , ,   , .

β€”  , 150   4 . ,   -  , . .



, senior backend engineer


image


,   .

β€”   ,   .          SSD. , , . ,   .

β€” , . β€” , β€”   ,  .   ad hoc ,  Materialized View.

β€” ,  ,     -  ClickHouse.



, middle engineer big data


image


   Realtime AB.  ClickHouse.  Cron- β€”  18.7. 3β€”4 .

Materialized View.   ,  .  ClickHouse lazy_load, - .

     XML , . ,   .



Q&A  


 β€” , ClickHouse  .   .



.    


  .   , β€” - Sale Success β€” β€” .   β€” Golang-   Integros. , , ClickHouse.


:


  • . ,  Collapsing MT .
  •   .
  • . N select .
  •  . distributed   .
  • WAL. Rollback  alter .
  • . .
  • . ,   , .
  • Kafka engine.   .
  • Kill query.    .
  • Driver GoLang. ,   issues.
  • . lazy_load  .

image


,    .    .




  9   17:00. ,   β€”       .  .


,  !


All Articles