Tips and Tricks with MariaDB ColumnStore

Make the most of your ColumnStore columnar analytics engine!
Deep dive into best practices for columnar engines in general, what are the best use cases for columnar, and tips and trick for both ColumnStore and other analytics engines.

MongoDB HA, What Can Go Wrong?

Redundancy and high availability are the basis for all production deployments. With MongoDB this can be achieved by deploying a replica set. In this talk, we'll explore how MongoDB replication works and what the components are of a replica set.

Billion Goods in Few Categories: How Histograms Save a Life?

We store data with an intention to use it: search, retrieve, group, sort... To do it effectively, the MySQL Optimizer uses index statistics when it compiles the query execution plan. This approach works excellently unless your data distribution is not even.

Getting Started with PostgreSQL

PostgreSQL is undoubtedly the second most popular open source RDBMS and it is within the top five most popular DB engines as per Why not take a rest from your favorite database server for a while, start learning some more about it, and aim for another logo on your resume?

Opensource Column Store Databases: MariaDB ColumnStore vs. ClickHouse

Running an analytical (OLAP) workload on top of MySQL can be slow and painful. A specifically designed storage format ("Column Store") can significantly improve analytical queries' performance. There are a number of opensource column store databases around.

Percona XtraDB Cluster 8.0 (PXC-8.0)

Percona XtraDB Cluster 8.0 (PXC-8.0) is the latest addition to PXC family.

Starting MySQL/PS-8.0 upstream has done a lot of significant changes including atomic DDL, replication channel, locking algorithm changes, security/ encryption, etc....

MySQL Group Replication: The Magic Explained v2

During this talk, I explain how Group Replication replication works.

This is a theoretical talk in which I explain in details what replication is and how it works.
I discuss what certification is and how it's done. What is XCOM and GCS?

Immutable Database Infrastructure with Percona XtraDB Cluster

In this session, we will discuss how we build Immutable infrastructure for databases.
Yahoo! JAPAN is the largest web portal in Japan. We have about 90 million unique browser accesses per month.

A Deep Dive Into PostgreSQL Indexing

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers.

Kafka on Kubernetes: Does It Really Have To Be "The Hard Way"?

When it comes to choosing a distributed streaming platform for real-time data pipelines, everyone knows the answer: Apache Kafka! And when it comes to deploying applications at scale without needing to integrate different pieces of infrastructure yourself, the answer nowadays is increasingly Kubernetes.


Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863