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

May 26, 2020

Diagnosing memory utilization, leaks and stalls in production - Marcos Albe - Percona Live 2020

Finding out what parts of our code are consuming (or leaking!) memory can be a challenge if we don't have the right tools. Until not so long ago most of us relied on Valgrind/Massif to find out, but this had a huge impact on performance and was not really practical for production systems. Gladly this has been slowly changing as more systems get upgraded to Linux releases with 4.x Kernels, where it's easy to set up tools like eBPF and perf...

Percona Live SessionsPerformance Optimization

May 26, 2020

Scaling financial audit logs at TransferWise with MongoDB - Pedro Albuquerque - Percona Live 2020

TransferWise is a global technology company that is building the best way to move money around the world and 6M users are transferring more than $5 billion every month with us. All transfers within TransferWise are processed by strict state machine rules handled by "Transfer Service". The state machine has a lot of different states like "New", "Money Received", "Converted", "Transferred", and the Transfer object itself contains the most...

Percona Live SessionsMongoDBOperations