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


May 26, 2020

Enhancing MySQL Security at LinkedIn- Karthik Appigatla - Percona Live Online 2020

In this talk, we will discuss how security is enhanced for MySQL at LinkedIn. The following areas will be covered:

1- A brief overview of MySQL at LinkedIn
2- MySQL Access Management- Privileged User Access Control- Fine-grained Access Control- Access to application owners
3- SSL- Applications to Databases- Replication
4- Audit Framework- Audit Plugin- Syslog to Kafka- Query Analyzer
5- How applications get...

Percona Live SessionsMySQLSecurity


May 26, 2020

Comparison of Kubernetes Operators for MySQL - Mykola Marzhan - Percona Live Online 2020

Running databases in Kubernetes attracts a lot of attention today. Orсhestration of MySQL on Kubernetes is no way a straightforward process. There are several good MySQL based solutions in the open-source world, made by Oracle, Presslabs, and Percona. Having a common base, they differ in self-healing capabilities, consistency guarantees, storage capabilities, monitoring, proxying and backup / restore support, etc. So, let’s make a fair...

Percona Live SessionsContainers and AutomationMySQL


Pages