Jun 5, 2020

ProxySQL 2.0 native support for Percona XtraDB Cluster (PXC) 5.7 - Vinicius Grippa

In this session, I will cover the new functionalities introduced by ProxySQL 2.X and how simple it became when we compare to ProxySQL 1.X versions when it was necessary to use an external script with the scheduler. A demonstration will show how to configure ProxySQL for PXC. Subsequently, new functionalities will be covered to explore the potential of the new version using SSL in the front end to communicate with the application and how to...

Percona XtraDB ClusterOperations

May 29, 2020

What's New in Percona XtraDB Cluster (PXC) 8.0

During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona's decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition he'll talk about the work done to integrate MySQL 8.0 features with Galera as well as how Percona is treating Kubernetes as one of its primary target platforms with this release. This webinar will provide an...

MySQLPercona XtraDB Cluster

May 29, 2020

How we ran our first 24 Hour, Virtual Percona Live Online Conference

Percona's Bronwyn Campbell, Matt Yonkovit & Valentina Lago chat about the planning and production to Percona's first 24-hour virtual conference; Percona Live Online.
They discuss the tech stack used, planning, and testing along with challenges they faced running a virtual conference remotely for 24 hours!

Percona Live Sessions

May 26, 2020

Mostly mistaken and ignored parameters while optimizing a PostgreSQL database - Percona Live 2020

Avi Vallarapu talked about Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details such a list of important PostgreSQL parameters considering the latest...

Percona Live SessionsPostgreSQLPerformance Optimization

May 26, 2020

Working With PostgreSQL As A JSON Document Store - Robert Bernier - Percona Live Online 2020

JSON, JavaScript Object Notation, is an open format and machine-readable standard facilitating data interchange between application and the persistent datastore on the modern webstack. This talk focusses on the ability of postgres to act as the authoritative datastore and when correctly designed and implemented can match any of the popular technologies in use today. In this tutorial, we will show you how to work with PostgreSQL JSON data...

Percona Live SessionsPostgreSQL

May 26, 2020

Cassandra where and how - John Schulz - Percona LIve Online 2020

You have decided you want to deploy your application using Cassandra. What flavor of Cassandra do you want to use? Do you want to do it open source or enterprise? If Enterprise, Datastax or Scylla? On-premise or in the cloud? Self-managed or Cassandra as a service?
In this talk I will discuss:
- The various Cassandra or Cassandra compatible databases including Apache Cassandra, DSE, Scylla, Azure xxx and Yugabyte.
- Self-...

Percona Live SessionsOperations

May 26, 2020

Optimize and Troubleshoot MySQL using PMM 2 - Peter Zaitsev - Percona Live Online 2020

Peter Zaitsev talked about the 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 changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are also expected to find cost-efficient means of solving these issues. In...

Percona Live SessionsMySQLPercona Monitoring and Management

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

MySQL and Clickhouse - Vadim Tkachenko - Percona Live Online 2020

In this talk I will review how to combine popular transactional and analytical databases together to get the best from both worlds. Let's talk about how to get data from MySQL to ClickHouse, different migration scenarios, and what integration solutions are available for MySQL DBA get up to speed with ClickHouse in no time.

Percona Live SessionsMySQLMigration

May 26, 2020

MongoDB 4.4 preview - Akira Kurogane - Percona Live Online 2020

MongoDB 4.4 is coming out this summer. We'll preview the changes coming up in the core MongoDB server. If we consider the last 6 major releases it's been quite a hectic ride: Pluggable storage engine API, WiredTiger, client-tunable consistency guarantees, transactions, distributed transactions.

Percona Live SessionsMongoDB