May 26, 2020

Dynamic Tracking for Finding MariaDB (and MySQL) Performance Problems on Linux - Percona Live 2020

Valeriy Kravchuk talked about while troubleshooting MariaDB server performance problems it is important to find out where the time is spent in the mysqld process, on-CPU and off-CPU. The process of investigation should have as small influence as possible on the server we try to troubleshoot.

Performance_schema introduced in MySQL 5.5 (and inherited from MySQL 5.6 by MariaDB) is supposed to provide detailed enough instrumentation...

Percona Live SessionsMariaDBMySQL


May 26, 2020

Expert MariaDB: Utilise MariaDB Server Effectively - Colin Charles - Percona Live Online 2020

Let's take a simple Oracle-backed application, and migrate it to MariaDB Server 10.4. While we are at it, let's learn about how to use system versioned tables, Galera 4, the MyRocks storage engine, Flashback to rollback tables/databases to an older snapshot, and also use the built-in thread pool. This and more is possible in 3 hours, as MariaDBServer 10.4 has been out for some time now (June 2019) and it has many new features, some of...

Percona Live SessionsMariaDBOperations


May 25, 2020

Profiling MySQL and MariaDB Hash Join Implementations- Jim Tommaney - Percona Live Online 2020

Hash Joins are a foundational join technology, now available in MySQL!

  • No index maintenance overhead.Can be orders of magnitude faster.Available for ad-hoc workloads and ETL.
  • Great complement to index join operations.

However, the underlying implementation is fundamentally different and introduces additional tweaks to optimize performance.
This presentation will give you the tools to learn when to...

Percona Live SessionsMariaDBMySQLOperations


May 22, 2020

MariaDB 10.4 and the Competition - Kaj Arno - Percona Live Online 2020

There are many good databases out there. Picking the right database for your project is never easy. There are technical criteria, business criteria, perhaps even ethical criteria. In this keynote, MariaDB Foundation CEO Kaj Arnö will present his – obviously completely impartial – view of the process.

Should you pick a database in the cloud or on-premise? Should you pick a relational database or a NoSQL database? Should you pick...

Percona Live SessionsMariaDB


Mar 17, 2020

MySQL 8 vs MariaDB 10.4

At the moment MySQL 8 and MariaDB 10.4 are the latest versions of the corresponding database management systems. Each of these DBMS has a unique set of features. For example, specific MariaDB features might be unavailable in MySQL, and vice versa. In this presentation, we’ll cover these new features and provide recommendations regarding which will work best on which DBMS.

MariaDBMySQL


Jun 19, 2019

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

Sveta Smirnova (Percona) delivers the talk, "Billion Goods in Few Categories: How Histograms Save a Life?", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

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...

Percona Live SessionsMariaDBMySQL


Jun 18, 2019

MySQL Group Replication: The Magic Explained v2

Frédéric Descamps (Oracle) delivers the talk, "MySQL Group Replication: The Magic Explained v2", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

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...

Percona Live SessionsMariaDBMySQL


Jun 18, 2019

From Scheduled Downtime to Self-Healing in Less Than a Year

Karoly Nagy (Salesforce) delivers the talk, "From Scheduled Downtime to Self-Healing in Less Than a Year", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Infrastructure automation is not easy, especially for stateful services like MySQL (or any other database for that matter). It goes way beyond the capabilities of Ansible, Chef, SaltStack or other similar tools. In this session I'm going...

Percona Live SessionsContainers and AutomationMariaDBMySQL


Jun 18, 2019

Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup

Iwo Panowicz (Percona), Juan Pablo Arruti (Percona) deliver the talk, "Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

There are few ways to take a backup. One of the most used tools is Percona Xtrabackup, MariaBackup, and MySQL Enterprise Backup.

In this talk, the audience will have an in-deep overview of:
-...

Percona Live SessionsMariaDBPercona XtraBackup


Jun 18, 2019

Percona XtraDB Cluster 8.0 (PXC-8.0)

Krunal Bauskar (Percona) delivers the talk, "Percona XtraDB Cluster 8.0 (PXC-8.0)", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

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....

...

Percona Live SessionsMariaDBMySQLPercona XtraDB Cluster


Pages