Nov 3, 2020

From Containers to Kubernetes Operators - Philipp Krenn - Percona Live ONLINE 2020

Containers are the new ZIP format to distribute software" is a fitting description of today's development world. However, it is not always that easy and this talk highlights the development of a container strategy for datastores over time:
Docker images: A new distribution model.
Docker Compose: Local demos and a little more.
Helm Chart: Going from demo to production.
Kubernetes Operator: Full control with upgrades,...

Containers and Automation


Nov 3, 2020

MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020

The ARM ecosystem is quickly evolving as a cost-effective alternative to run High-Performance Computing (HPC) software. It continues to grow with some major cloud players hosting ARM-based cloud servers. MySQL too joined the ecosystem with 8.x. MariaDB already has made its presence. But besides the mainline server, a lot of tools are yet to get ported to ARM.

In this talk, we will explore what all aspects of the MySQL ecosystem...

MySQL


Nov 3, 2020

How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE

It's very challenging to support high availability and consistency in cross data center deployment. TiDB is a distributed HTAP database that speaks MySQL protocols.

This talk will introduce how TiDB solves the problem by some unique designs based on Raft, and how those designs make TiDB run fast and cheap in these scenarios. Jay Lee is a TiKV maintainer, a distributed system expert, and the author of open source projects grpc-rs...

MySQL


Nov 3, 2020

SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020

MySQL and PostgreSQL are the goto SQL databases for a huge number of services. But what if your service generates billions or even trillions of records? This talk helps listeners decide when applications work better with a SQL data warehouse.

PostgreSQLMySQL


Nov 3, 2020

Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020

Kunlun Distributed Database Cluster is a distributed DBMS that aims to combine the best of both MySQL and PostgreSQL to meet the challenges of an ever-growing amount of data to manage and provide users with a highly performant, highly available, highly scalable and fault-tolerant, easy to use and manage database system that requires minimal human maintenance.

Kunlun Distributed Database Cluster enables users to define table...

PostgreSQLMySQL


Nov 3, 2020

How to Protect the SQL Engine from Running Out of Memory - PLO October 2020

How to Protect the SQL Engine from Running Out of Memory

Open Source Database


Nov 3, 2020

pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020

pg_stat_monitor is a statistics collection tool authored by Percona and contributed to the community. It is based on pg_stat_statements, an existing PostgreSQL contrib module. The major shortcoming in pg_stat_statements is that it accumulates all the queries and their statistics but does not provide aggregated statistics nor histogram information. In this case, a user needs to calculate the aggregate, which is quite expensive....

PostgreSQLPercona Monitoring and Management


Nov 3, 2020

PostgreSQL WAL and Commit Synchronization, Optimization Opportunities - Jobin Augustine - PLO October 2020

PostgreSQL uses different types of WAL records for recording activities happening on the database. A deeper understanding of what they are, how they are synchronized, what the optimization opportunities are, etc., can lead to a better-tuned system.

This talk also discusses the different sets of PostgreSQL parameters and their impact on WAL and optimization considerations for a high-performance database.

PostgreSQL


Nov 3, 2020

MariaDB 10.5 New Features for Troubleshooting - PLO October 2020

MariaDB 10.5 New Features for Troubleshooting - PLO October 2020

MariaDB


Nov 3, 2020

Boosting MySQL Performance - Jose Luis Martinez - Percona Live ONLINE 2020

Discover the basic tips and tricks on how to build your MySQL schemas so you don't get caught up in early performance problems.

Learn how to select your tables data types and what performance implications they have. Review how indexing works, as well as basic indexing tips and tricks. A healthy schema is one of the first steps to having a performant database.

MySQLPerformance Optimization


Pages