Upgrade to Pro — share decks privately, control downloads, hide ads and more …

ClickHouse walks into a Cloud...

Avatar for Matteo Bianchi Matteo Bianchi
August 21, 2024
10

ClickHouse walks into a Cloud...

This talk explores the deployment of ClickHouse, the open-source columnar database / OLAP DBMS, using cloud-native methodologies.
The session includes a fast demo showcasing how to deploy ClickHouse both locally with Docker-compose and in a Kubernetes cluster with the Altinity operator.

You will learn how easy it is to self-host ClickHouse in the Cloud then we are going to perform operations on the database such as creating tables, inserting data, and running aggregated queries.

By the end of the talk, you will gain practical knowledge on setting up and managing ClickHouse in both local and cloud environments, enabling its usage in your cloud-native stack.

Avatar for Matteo Bianchi

Matteo Bianchi

August 21, 2024
Tweet

Transcript

  1. Agenda This is what you can expect from this presentation!

    01 Intro 02 Some (not boring) slides 03 A demo?!
  2. Hey there, I'm your Speaker, Matteo Bianchi! > Developer Advocate

    (open to work) Startup CTO Freelance DevOps / Platform coach Cloud Native Consultant Lead DevOps & SRE Software Engineer @mbianchide v
  3. Today, we will learn to: 01 02 Deploy ClickHouse on

    a k8s cluster with the Altinity Operator 03 Run commands to test ClickHouse! Deploy ClickHouse locally with docker-compose
  4. What is Cloud Native? Cloud native technologies empower organizations to

    build and run scalable applications in modern, dynamic environments such as public, private, and hybrid clouds. Containers, service meshes, microservices, immutable infrastructure, and declarative APIs exemplify this approach. These techniques enable loosely coupled systems that are resilient, manageable, and observable. Combined with robust automation, they allow engineers to make high-impact changes frequently and predictably with minimal toil. TLDR; Born to be Cloud
  5. Why Cloud native Clickhouse? Optimized resource usage and overall density

    of your ClickHouse installation - here for more A scalable and self-healing ClickHouse experience ready to be configured Minimal downtime plus ease in handling day-2 operations
  6. A Cluster!? What do we need to deploy CLICKHOUSE ON

    Kubernetes? Volumes? Configs! Operator…? !!! !!! CLICKHOUSE
  7. SECTION 2: DEMO TIME!! Please, never put cola near your

    laptop. Or mine. Also, have you noticed every Click-House reference so far?
  8. Enjoy your Cloud native Clickhouse! An OLAP DBMS - with

    some transactional capabilities - like consistent read/writes and update/delete mutations… Now you are ready to enjoy a Real Time Analytics, Business Intelligence, AI & Observability data store on k8s! … Plus amazing data compression capabilities which in the cloud world saves you a ton of money.
  9. Big thanks to: YOU! For attending my presentation Note: I’m

    not endorsed by, nor affiliated with ClickHouse Inc.
  10. Stay databased! Feel free to leave a a GitHub star.

    Sources: ClickHouse Documentation ClickHouse Meetup presentation @mbianchide v
  11. Pop Art features designs with bold black outlines, giving it

    a cartoon-like look. Bold Outlines Pop Art uses bright and vivid colors. Bright Colors Features that Pop:
  12. Pop Art often features speech, thought bubbles, and action words,

    like in a comic. Words and Speech Pop Art often features repeated shapes such as triangles and patterns like lines and dots. Repeated Patterns Features that Pop:
  13. Did you know ...that one of the most famous artworks

    of all time is an image of a banana?
  14. Grab some colored pencils and a piece of paper, and

    try writing your name in Pop Art style! !!! !!! !!! !!!
  15. Add topic here Lorem ipsum dolor sit amet, consectetur adipiscing

    elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
  16. Use these design resources in your Canva Presentation. This presentation

    template uses the following free fonts: Titles: Bangers Headers: Oswald Bold Body Copy: Oswald Regular You can find these fonts online too. Happy designing! Don't forget to delete this page before presenting. Resource Page
  17. Click on the "Google Slides" button below this presentation preview.

    Make sure to sign in to your Google account. Click on "Make a copy." Start editing your presentation. Alternative: Click on the "Share" button on the top right corner in Canva and click on "More" at the bottom of the menu. Enter "Google Drive" in the search bar and click on the GDrive icon to add this design as a Google slide in your GDrive. Google Slides Click on the "PowerPoint" button below this presentation preview. Start editing your presentation. Alternative: From Canva template file, Click on the "Share" button on the top right corner in Canva and click on "More" at the bottom of the menu. Enter "PowerPoint" in the search bar and click on the PowerPoint icon to download. PowerPoint Click on the "Canva" button under this presentation preview. Start editing your presentation. You need to sign in to your Canva account. Canva How to use this Presentation