Videos from Percona
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-...
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...
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...
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