Peter Zaitsev

Columnnar data stores have enabled new workloads and improved performance and storage efficiency for others. They have added storage options to existing database engines and spawned whole new projects.

What happens when databases don’t just store data—but help analyze it intelligently? This talk explores emerging trends in AI-powered database intelligence, from schema optimization and real-time query tuning to transforming unstructured content using techniques like sentiment analysis and entity recognition.

2024 has been a transformative year for open source, with rapid innovation and pivotal industry changes. This talk will delve into the major developments across the open source landscape, particularly within the open source database industry.

In the era of distributed systems, many modern databases are designed to scale horizontally from the ground up. Yet, some of the most widely used databases, like MySQL and PostgreSQL, remain single-node by design, relying on third-party sharding solutions like Citus or Vitess for distribution.

Open source software is fun to work on, but building a real business is tough. We’ve all read about commercial open source companies that switched to proprietary models or flat went out of business.

Running PostgreSQL on Kubernetes is becoming increasingly popular, offering various methods for implementation. This talk will examine different operators that facilitate running PostgreSQL on Kubernetes. We'll also take a look at Neon PostgreSQL, specifically designed for cloud-native...

Running PostgreSQL on Kubernetes is becoming increasingly popular, offering various methods for implementation. This talk will examine different operators that facilitate running PostgreSQL on Kubernetes.

In this talk, we'll explore the emergent landscape of vector search in databases, a paradigm shift in information retrieval. Vector search, traditionally the domain of specialized systems, is now being integrated into mainstream databases and search engines like Lucene, Elasticsearch, Solr, PostgreSQL, MySQL, MongoDB, and Manticore.

If you look at data store as just another service, the things Application cares about is successfully establishing connection and getting results to the queries promptly and with correct results. In this presentation, we will explore this seemingly simple aspect of working with MySQL in details.

If you look at data store as just another service, the things Application cares about is successfully establishing connection and getting results to the queries promptly and with correct results. In this presentation, we will explore this seemingly simple aspect of working with PostgreSQL in details.

MySQL 8 and MariaDB 10.10 are the latest Major versions for MySQL and MariaDB. While MariaDB started by being slightly different MySQL variant, now it has grown into very much different database platforms which grows more different from every release.

"If you look at data store as just another service, the things Application cares about is successfully establishing connection and getting results to the queries promptly and with correct results.

Optimizing MySQL performance, troubleshooting MySQL problems, and managing backups are the most critical and challenging tasks for MySQL DBAs in their daily routine. The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and...

It has been an exciting year in the open source database industry, with more choice, more cloud, and key changes in the industry. We will dive into the key developments over 2022, including the most important opensource database software releases in general, the significance of cloud-native...

MySQL 8 and MariaDB 10.6 are the latest Major versions for MySQL and MariaDB. While MariaDB started by being slightly different MySQL variant, now it has grown into very much different database platforms which grows more different from every release.

For years CPU choice for MySQL was pretty boring - just chose what Intel Made CPU you want. In recent years the situation changed with AMD producing very competitive Server grade CPUs and ARM going from being the leading CPU manufacturers for low-power gadgets to being inside some of the highest performance server chips.

Optimizing MariaDB performance and troubleshooting MariaDB problems are two of the most critical and challenging tasks for DBA’s. The databases powering your applications need to be able to handle heavy traffic loads while remaining responsive and stable so that you can deliver an excellent user experience.

The presentation will be focused on dealing with an unexpected high traffic event as it is happening. We will address the impact a traffic spike can have on your database – from poor query response time to replication lag issues – and provide actionable tips and tricks.

A broken MariaDB means broken Application, so maintaining insights in MariaDB operational performance is critical. Thankfully MariaDB offers a lot in terms of observability to resolve problems quickly and get great insights into opportunities for optimization.

If you're tasked with optimizing PostgreSQL performance, chances are you're relying on pg stat statements extension to capture information about query performance. While this extension provides a lot of great insights, PostgreSQL allows to go even further!

MySQL 8 and MariaDB 10.4 are the latest Major versions for MySQL and MariaDB. While MariaDB started by being slightly different MySQL variant, now it has grown into very much different database platforms which grows more different from every release.

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA's. The databases powering your applications need to be able to handle heavy traffic loads while remaining responsive and stable so that you can deliver an excellent...

MySQL Replication is powerful and has added a lot of advanced features through the years. In this presentation we will look into replication technology in MySQL 8 and variants focusing on advanced features, what do they mean, when to use them and when not, Including When should you use STATEMENT, ROW or MIXED binary log format ?