talk-data.com

Agenda: 18:00 Welcome 18:15 How not to sell the same ticket to two different people by Jose Muñoz (ClickHouse) 19:00 Online schema changes at Scale with TiDB by Mattias Jonsson (PingCAP) 19:45 Lightning Sessions 20:15 Pizza & networking

How not to sell the same ticket to two different people by Jose Muñoz (ClickHouse) Summary: Let’s say we build an app to sell movie theater tickets using your favorite database and framework. We design a stunning interface, pack it with amazing features, and ensure every detail of accessibility is perfect. We deploy it to production, and once users start arriving, we notice some very strange things happening: some customers have purchased the same seat for the same movie at the same time, and in some showings, people are sitting on the floor because we've sold more tickets than there are seats. What could have gone wrong?

In this talk, we’ll explore how these kinds of issues can occur when we don’t use transactions, share some real-world cases, and examine techniques modern databases use to help us avoid these problems.

Bio: Jose is a software engineer with close to nine years of experience building data-centric products at companies such as Tuenti and Tinybird. He now works at ClickHouse, where he maintains the dbt connector. Passionate about community, he has helped organize events with GDG Cáceres and Databeers Madrid and tries to share what he learns by speaking at meetups and conferences.

Online schema changes at Scale with TiDB by Mattias Jonsson (PingCAP) Summary: ALTER TABLE in production databases are tricky, this talk will go through some of the challenges, as well as how the Distributed SQL database TiDB solves the issues as well as providing high speed index addition and more.

Bio: Mattias has worked as a Principal Software Engineer at PingCAP working on TiDB, since April 2021. Previously he worked with MySQL at Booking.com and before that working on MySQL server at Oracle. So more than 20 years of Database experiences, mostly in the MySQL community.

Wednesday 26th February is our next meetup. We'll be sharing what we've learned with open databases. Want to be involved? Tell us in our OpenUK Slack community! The more interactive the better!

This maintains a Hybrid event but we have separate signups now to limit no-shows at the in-person one. This is for the Online event, which will remain open until the day of. There is a separate link if you can commit to joining us in person.

6:45 pm: Log on to Teams and network 6:50 pm: Welcome, code of conduct and warmup

6:55 pm: AI and Data Governance, by Dr Aisha Naseer presenting remotely 7:15 pm: Distribute Data and Machine Learning with Bacalhau, by Sean Tracey Short break 7:40 pm: Open Source and Cloud Native Databases on Kubernetes, by Edith Puclla, including Cloud Native PG, Percona Everest, and CrunchyData 8:05 pm: Building a Graph RAG Application with TiDB, by Mattias Jonsson

Please remember to bring your I.D. if you are attending in person, as it is required to access the venue. Note the venue does not permit e-scooters or bicycles within the building. Thank you to our sponsors Avanade for providing this great space and yummy pizza!

The link for the online version of this event will be added about a week before, so please check back.

By attending this or any OpenUK event, you are adhering to our Code of Respect and OpenUK's Competition Policy. Please read ahead.

If you would like to hear more about OpenUK's other events, you can join our Newsletter. After attending, look out for an email with an invite to our burgeoning Slack community as a way to keep in touch and support each other between activities.

Wednesday 26th February for our next meetup. We'll be sharing what we've learned with open databases. Want to be involved? Tell us in our OpenUK Slack community! The more interactive the better!

This remains an interactive Hybrid event. However, after no-shows, we are splitting the meetup invites. This event's signups are closed but we welcome everyone still to sign up for the online listing of the event.

6:30 pm: Arrive on time, grab a bev, a slice and a chat. Scope out our swag table (bring pieces to contribute or trade!) 6:50 pm: Welcome, code of conduct and warmup 6:55 pm: AI and Data Governance, by Dr Aisha Naseer presenting remotely 7:15 pm: Distribute Data and Machine Learning with Bacalhau, by Sean Tracey Short break 7:40 pm: Open Source and Cloud Native Databases on Kubernetes, by Edith Puclla, including Cloud Native PG, Percona Everest, and CrunchyData 8:05 pm: Building a Graph RAG Application with TiDB, by Mattias Jonsson

8:45 pm: Clean up and leave.

Please remember to bring your I.D. if you are attending in person, as it is required to access the venue. Note the venue does not permit e-scooters or bicycles within the building. Thank you to our sponsors Avanade for providing this great space and yummy pizza!

By attending this or any OpenUK event, you are adhering to our Code of Respect and OpenUK's Competition Policy. Please read ahead.

If you would like to hear more about OpenUK's other events, you can join our Newsletter. After attending, look out for an email with an invite to our burgeoning Slack community as a way to keep in touch and support each other between activities.

Date & Time: 17 October, 2024 from 19:00 – 21:30 CEST Location: Warsaw, Poland, Golder Floor Conference Overview: Join us for an in-depth meetup where we explore how TiDB, a horizontally scalable and MySQL-compatible database, can significantly reduce the time and expense associated with application maintenance.

We’ll dive into TiDB’s unique features that make it an ideal choice for organizations looking to streamline their database operations while keeping costs in check. Attendees will learn how TiDB’s distributed architecture and automatic failover capabilities contribute to lower maintenance overhead and enhanced application performance.

Key Takeaways:

• Understand the cost-saving benefits of TiDB’s distributed database architecture.
• Learn how to leverage TiDB to minimize application downtime and maintenance efforts.
• Discover real-world use cases where TiDB has optimized maintenance costs for leading companies.

Whether you’re a DBA, DevOps professional, or developer, this meetup will provide valuable insights for optimizing your application infrastructure. Don’t miss this opportunity to gain practical knowledge and network with like-minded industry professionals.

Agenda: 18:30 – 19:00 Networking ( drinks and snacks) 19:00 – 19:15 – Welcome talk 19:15- 19:45 – Data at Scale – Intro to modern distributed database TiDB for scalability, reliability and versatility by Mattias Jonsson, Senior Database Engineer at PingCAP 19:45 – 20:15 – Cost Efficient Data Management by Nikita, Business Development Manager at PingCAP 20:15- 20:30 – Break ( drinks and snacks) 20:30 – 21:00 – Journey from HBase to TiDB to achieve increased performance 21:00 – 22:00 – Networking ( drinks and snacks)

Speakers:

Mattias Jonsson, Senior Database Engineer at PingCAP Mattias has worked with MySQL for more than 15 years. Prior to joining PingCAP, he worked for Booking.com, where he spent a significant amount of time on MySQL.

Nikita Khristenko, Business Development Manager at PingCAP Nikita is experienced Business Development Manager. Previously as Global Chief of Ai driving the adoption of AI solutions at Tencent Cloud.

Anton Lapin, Software Engineer at Bolt I’m Anton Lapin, Software Engineer at Bolt working on Customer Support Automations. Participated in development of AI Chatbot Alfred. Before joining Bolt, I got a bachelor’s degree in Computer Science and worked 3 years as a Software Engineer extensively developing web applications.

As businesses grow and data volumes increase, the demand for scalable and high-performance databases has never been more critical.

You’re invited to our upcoming meetup where we’ll explore Distributed SQL’s transformative impact on database performance.

Join us for enlightening sessions where you’ll dive into the intricacies of Distributed SQL. You’ll discover how this evolved database category solves scalability and sharding challenges often faced by traditional relational databases.

Agenda:

17:30 – 18:00 networking

18:00 – 18:40 Introduction to Distributed SQL – TiDB (Mattias Jonsson – Senior Database Engineer)

18:45 – 19:10 How Bolt built a tiered database solution with TiDB, MySQL and DM (by Andrei Fedorov)

19:15 – 19:30 BREAK

19:35 – 20:15 TiDB Demo (Daniel Van Eeden – Technical Solutions Engineer)

20:15 – 20:30 Networking

Who Should Attend:

• IT Professionals
• Database Administrators
• Developers
• Data Engineers
• Technology Enthusiasts

Join us for a co-hosted meetup by Aiven in Aiven’s HQ in Helsinki. Insightful sessions on a database technologies. Migration strategies, focusing on the transition from traditional MySQL databases to cutting-edge Distributed SQL systems. In this event, expert speakers and seasoned professionals will guide you through the intricacies of migrating your data infrastructure to meet the demands of the modern digital landscape.

Agenda:

17:30 - 18:00 Networking

18:00 - 18:40 Upgrading to TiDB from MySQL and MariaDB (Mattias Jonsson, PingCAP)

Introduction to Database Evolution:

• Understanding the shift from traditional databases to distributed SQL systems.
• Exploring the challenges faced by businesses in the age of scalability, availability, and performance.
• MySQL to Distributed SQL Migration Strategies

18:50 - 19:05 BREAK

19:05 – 19:45 TiDB Tales: A Developer’s Post-Migration Adventures in System Optimization (Maxim Dudin, Bolt)

Post-Migration System Optimization:

• Performance tuning in the Distributed SQL environment.
• Balancing data consistency, availability, and partition tolerance.
• Implementing effective monitoring and debugging techniques.
• Scaling strategies for growing workloads and user demands.

19:45 – 20:25 Second Day Ops for Kafka (Saulo Valenzuela & Lucian Dragos, Kafka Engineers at Irori)

• How can we organize key Kafka capabilities like Self Service, Disaster Recovery, Governance and Observability that scales from early stages to enterprise scale? This talk will highlight useful best practices and illustrate common pitfalls.

20:25 - 21:15 Networking

Join us for an evening of insightful discussions and networking as we dive deep into the world of database management and performance optimization. This event brings together experts in the field to share their knowledge and experiences on topics ranging from distributed SQL database fundamentals to efficient MySQL infrastructure management.

Agenda:

• 17:30 - 18:00: Networking
• 18:00 - 18:40: Introduction to TiDB (Mattias Jonsson) - Mattias Jonsson, Senior Database Engineer at PingCAP, with over 15 years of experience in MySQL, will introduce you to TiDB, a distributed SQL database.
• 18:45 - 19:10: The Paranoid TiDB Version Upgrader's Guide (Leandro Morgado) - Leandro Morgado\, Senior MySQL DBA at Bolt\, will provide insights into upgrading TiDB with a focus on availability\, performance\, and security.
• 19:15 - 19:30: Break
• 19:35 - 20:15: Automation to Run MySQL at Scale at Booking.com (Simon) - Simon\, a Senior Site Reliability Engineer at booking.com\, will share his experiences in automating MySQL at scale\, showcasing how Booking.com manages its MySQL infrastructure efficiently.
• 20:15 - 20:30: Networking

Why you should attend:

• Introduction to TiDB: Gain insights into TiDB, a distributed SQL database, and its applications. Understanding distributed databases is crucial for scalability and performance improvements.
• TiDB Version Upgrading Guide: Learn best practices for upgrading TiDB while ensuring availability, performance, and security. Discover how to navigate the complexities of version upgrades with confidence.
• Automation Strategies: Explore automation techniques for managing MySQL at scale. Understand the importance of automation in maintaining database efficiency and reliability, especially in large-scale operations. Real-World Experiences: Hear from experienced professionals who have worked with MySQL and distributed SQL databases in real-world scenarios. Their insights and practical knowledge can help you apply these concepts in your own projects.

Scalability, performance, and availability have historically been seen as separate data tables. Up to this point, the common perspective has been that a database system could have two but only some of the three characteristics. The advancement of Distributed SQL as a primary data platform has reshaped these assumptions.

Join the Data at Scale meetup to connect with industry-leading data experts and practitioners. We will explore the challenges and obstacles of scaling data while also trying to achieve optimal performance and availability.

Experts from Bolt and PingCAP will share practical experiences and best practices related to distributed SQL, data warehousing, data engineering, and data for model training.

Agenda:

17:45 – 18:30 Entry, Networking & snacks 18:30 – 19:15 Introduction to TiDB by Mattias Jonsson 19:30 – 20:15 Global overview of Bolt’s use case & exporting big data from databases to datalake 20:20 – 21:00 RonDB, a NewSQL Feature Store for AI applications by Mikael Ronström 21:00 – 21:30 Networking, snacks & drinks

*Participants will get a chance to take part in a raffle to win a prize.

Pre-registration is required here (seats are limited): https://www.aicamp.ai/event/eventdetails/W2023081009 (Venue security may not let you in if you don't pre-register at the link)

Description: Join the Data at Scale meetup where you will connect with industry-leading data experts and practitioners. We will be exploring the various challenges and obstacles that come with scaling data, as well as sharing practical experiences and best practices related to distributed SQL, data warehousing, data engineering, and data for model training (such as the kind that fuels AI models like ChatGPT).

• Attendees will get the opportunity to take part in the raffle to win grand prizes.
• Participants of the workshop will receive a Certificate of Completion (you can add to your linkedin profile)

Agenda:

• 5:00pm\~5:30pm: Checkin, food/drink and networking
• 5:30pm\~6:30pm: Tech talks
• 6:30pm\~7:30pm: Hands-on workshop and Demo
• 7:30pm: Open discussion, Lucky draw & Mixer

Tech Talk: Scaling Data Platform on Hybrid Transactional and Analytical Processing Speaker: Mattias Jonsson @PingCAP Abstract: Join us as we explore TiDB and TiDB Cloud, a fully-managed DBaaS offering of TiDB. In this tech talk session, we will discuss: - Horizontally scalable\, distributed architecture - Challenges of legacy scaling architectures - Enables fully ACID OLTP plus access to deep aggregation on real-time data - Simplifies the data ecosystem by eliminating the need for multiple niche platforms and the connecting data pipelines

Hands-on Workshop and Demo Abstract: Bring your laptop if you are eager to take part in the hands-on workshop. In this workshop session, you will learn: - Introduction to TiDB managed Cloud platform - Deploy a serverless TiDB Cluster in the Cloud - Explore TiDB Cloud console functions & features - Use SQL Smart Optimizer delivers fast query results - Leverage AI to generate SQL queries with ChatGPT

Scalability, performance, and availability have historically been seen as separate tunables. Up to this point, the common perspective has been that a database system could have two but not all three of these characteristics. The advancement of Distributed SQL as a primary data platform has reshaped these assumptions.

Join the Data at Scale meetup where you will connect with industry-leading data experts and practitioners. We will be exploring the various challenges and obstacles that come with scaling data, as well as sharing practical experiences and best practices related to distributed SQL, data warehousing, data engineering, and data for model training (such as the kind that fuels AI models like ChatGPT).

* Attendees will get the opportunity to take part in the raffle to win grand prizes. * Participants of the workshop will receive a Certificate of Completion (you can add to your linkedin profile)

Agenda (BST): * 5:00pm\~6:00pm: Checkin, food/drink and networking * 6:00pm\~6:40pm: Tech talk: scaling data platform on hybrid transactional and analytical processing * 6:40pm\~7:00pm: Break * 7:00pm\~7:30pm: Hands-on workshop and Demo * 7:30pm: Open discussion & Mixer

Scaling Data Platform on Hybrid Transactional and Analytical Processing Speaker: Mattias Jonsson, Nabil Nawaz @PingCAP Abstract: Join us as we explore TiDB and TiDB Cloud, a fully-managed DBaaS offering of TiDB. In this tech talk session, we will discuss: - Horizontally scalable\, distributed architecture - Challenges of legacy scaling architectures - Enables fully ACID OLTP plus access to deep aggregation on real-time data - Simplifies the data ecosystem by eliminating the need for multiple niche platforms and the connecting data pipelines

Hands-on Workshop and Demo Abstract: Bring your laptop if you are eager to take part in the hands-on workshop. In this workshop session, you will learn: - Introduction to TiDB managed Cloud platform - Deploy a serverless TiDB Cluster in the Cloud - Explore TiDB Cloud console functions & features - Use SQL Smart Optimizer delivers fast query results - Leverage AI to generate SQL queries with ChatGPT

Are you interested in learning more about open-source data technologies? Do you want to network with other like-minded people in a fun, relaxed environment?

Then come join us on Thursday, July, at the Aiven office in Berlin for an evening filled with great opportunities for networking and special technical talks. Read below for more details!

Before and after the talks, we’ll have food* and some time for socializing.

Note: The event starts at 6:00 PM CEST and runs until 9 PM CEST.

Program: 6.15PM - Open Doors 6.30 PM - Welcome 6.40 PM - 7.00 PM - Food & refreshments 7.00 PM - Introduction to TiDB - a distributed SQL database

Introduction to TiDB - a distributed SQL database. We will go through its architecture and how it distributes data and provides high availability. Besides its row-based storage for efficient transaction handling, it also provides optional column storage for speeding up analytics queries.

About the speaker: Mattias Jonsson - Senior Database Engineer at PingCAP. He has worked with MySQL for more than 15 years. Prior to joining PingCAP, he worked for Booking.com, where he spent a significant amount of time on MySQL.

7.30 PM - Beginners guide to balance your data across Apache Kafka partitions

Apache Kafka is a distributed system. At the heart of Apache Kafka is a set of brokers that contain topics. Topics are split into partitions. Dividing topics into smaller pieces allows us to work with data in parallel and achieve higher data throughput.

Such parallelization is the key to a performant cluster, however it comes with a price. First, reading from multiple partitions will eventually mess up the order of records, meaning that the resulting order will be different from when the data was pushed into the cluster. Another big challenge is uneven distribution of data across partitions.

Overloaded partitions present a dangerous issue for performance of all involved parties, but especially for brokers and consumers. Therefore, when building our product architecture we should carefully weigh up how many partitions we need, how to ensure proper message ordering, how to balance records across partitions, not forgetting about data load distribution over time. And do all of this while still maintaining good performance of the cluster.

If you're fresh to Apache Kafka, or looking for good practices to design your partitions and avoid common pitfalls, you'll find this session useful!

About the speaker: Olena is a Sr. Developer Advocate at Aiven. With a background in software engineering, she's led teams and developed mission-critical applications at Nokia, HERE Technologies, and AWS. Currently, she works at Aiven where she supports developers and customers in using open-source data technologies such as Apache Kafka, ClickHouse, and OpenSearch. She is also an international public speaker and regularly present at conferences around the world. She holds AWS Developer and Solutions Architect certifications, and is also a Confluent Catalyst.

8 PM - 9 PM - More food & Socialising

*Please note that this is an alcohol-free event.

Catering Pizza (vegan, vegetarian, and gluten free options will be available), soft drinks & water.

Details Scalability, performance, and availability have historically been seen as separate tables. Up to this point, the common perspective has been that a database system could have two but not all three of these characteristics. The advancement of Distributed SQL as a primary data platform has reshaped these assumptions. Join the Data at Scale meetup where you will connect with industry-leading data experts and practitioners. We will be exploring the various challenges and obstacles that come with scaling data, as well as sharing practical experiences and best practices related to distributed SQL, data warehousing, data engineering, and data for model training (such as the kind that fuels AI models like ChatGPT). Also enjoy delicious food and drinks and have the opportunity to win lucky draw prizes. Special Gift: Come and win Lego!!!

Agenda (CEST):

• * 5:00pm\~6:00pm: Networking * 6:00pm\~6:40pm: Tech talk: scaling data platform on hybrid transactional and analytical processing * 6:40pm\~7:30pm: Hands-on workshop and Demo * 7:30pm: Open discussion

Scaling Data Platform on Hybrid Transactional and Analytical Processing Speaker: Mattias Jonsson @PingCAP, senior database engineer, 15+ years on MySQL, worked for booking.com data infra Abstract: Join us as we explore TiDB and TiDB Cloud, a fully-managed DBaaS offering of TiDB. In this tech talk session, we will discuss:

• Horizontally scalable, distributed architecture
• Challenges of legacy scaling architectures
• Enables fully ACID OLTP plus access to deep aggregation on real-time data
• Simplifies the data ecosystem by eliminating the need for multiple niche platforms and the connecting data pipelines

Hands-on Workshop and Demo Abstract: Bring your laptop if you are eager to take part in the hands-on workshop. In this workshop session, you will learn:

• Introduction to TiDB managed Cloud platform
• Deploy a serverless TiDB Cluster in the Cloud
• Explore TiDB Cloud console functions & features
• Use SQL Smart Optimizer delivers fast query results
• Leverage AI to generate SQL queries with ChatGPT

Please register on the event website to gain access (seats are limited): https://www.aicamp.ai/event/eventdetails/W2023062208

Join the Data at Scale meetup where you will connect with industry-leading data experts and practitioners. We will be exploring the various challenges and obstacles that come with scaling data, as well as sharing practical experiences and best practices related to distributed SQL, data warehousing, data engineering, and data for model training (such as the kind that fuels AI models like ChatGPT).

Enjoy delicious food and drinks, receive some cool swag, and win lucky draw prizes.

Agenda:

• 5:00pm\~5:30pm: Checkin, food/drink and networking
• 5:30pm\~6:30pm: Tech talks
• 6:30pm\~7:30pm: Hands-on workshop and Demo
• 7:30pm: Open discussion, Lucky draw & Mixer

Tech Talk: Scaling Data Platform on Hybrid Transactional and Analytical Processing Speaker: Mattias Jonsson @PingCAP Abstract: Join us as we explore TiDB and TiDB Cloud, a fully-managed DBaaS offering of TiDB. In this tech talk session, we will discuss: - Horizontally scalable\, distributed architecture - Challenges of legacy scaling architectures - Enables fully ACID OLTP plus access to deep aggregation on real-time data - Simplifies the data ecosystem by eliminating the need for multiple niche platforms and the connecting data pipelines

Hands-on Workshop and Demo Abstract: Bring your laptop if you are eager to take part in the hands-on workshop. In this workshop session, you will learn: - Introduction to TiDB managed Cloud platform - Deploy a serverless TiDB Cluster in the Cloud - Explore TiDB Cloud console functions & features - Use SQL Smart Optimizer delivers fast query results - Leverage AI to generate SQL queries with ChatGPT

Participants of the workshop will receive a Certificate of Completion (you can add to your linkedin profile)