Videos from Percona
Jan 27, 2021
Using PMM to Identify and Troubleshoot Problematic MySQL Queries
Join us as Michael Coburn, Percona Product Manager, discusses two methods to identify and troubleshoot problematic MySQL queries using the RED Method and PMM Query Analytics. He will also highlight specific Dashboards in PMM that visualize the rate, errors, and duration of MySQL events that may be impacting the stability and performance of your database instance.
MySQLPercona Monitoring and Management
Nov 11, 2020
Google Cloud Platform: MySQL at Scale with Reliable HA
Google Cloud Platform (GCP), with it’s CloudSQL offering, has become a leading platform for database-as-a-service workload deployments for many organizations. Scale and High Availability have surfaced as primary goals for many of these deployments. Unfortunately, the attainment of these objectives has been challenging. Often, the answer has been to simply add more CloudSQL databases. Many, however, have found a better solution in Percona’s...
CloudMySQLHigh Availability
Nov 3, 2020
Analytical Queries in MySQL - PLO October 2020
Analytical Queries in MySQL - PLO October 2020
MySQL
Nov 3, 2020
MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020
The ARM ecosystem is quickly evolving as a cost-effective alternative to run High-Performance Computing (HPC) software. It continues to grow with some major cloud players hosting ARM-based cloud servers. MySQL too joined the ecosystem with 8.x. MariaDB already has made its presence. But besides the mainline server, a lot of tools are yet to get ported to ARM.
In this talk, we will explore what all aspects of the MySQL ecosystem...
MySQL
Nov 3, 2020
How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE
It's very challenging to support high availability and consistency in cross data center deployment. TiDB is a distributed HTAP database that speaks MySQL protocols.
This talk will introduce how TiDB solves the problem by some unique designs based on Raft, and how those designs make TiDB run fast and cheap in these scenarios. Jay Lee is a TiKV maintainer, a distributed system expert, and the author of open source projects grpc-rs...
MySQL
Nov 3, 2020
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020
MySQL and PostgreSQL are the goto SQL databases for a huge number of services. But what if your service generates billions or even trillions of records? This talk helps listeners decide when applications work better with a SQL data warehouse.
PostgreSQLMySQL
Nov 3, 2020
Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020
Kunlun Distributed Database Cluster is a distributed DBMS that aims to combine the best of both MySQL and PostgreSQL to meet the challenges of an ever-growing amount of data to manage and provide users with a highly performant, highly available, highly scalable and fault-tolerant, easy to use and manage database system that requires minimal human maintenance.
Kunlun Distributed Database Cluster enables users to define table...
PostgreSQLMySQL
Nov 3, 2020
Boosting MySQL Performance - Jose Luis Martinez - Percona Live ONLINE 2020
Discover the basic tips and tricks on how to build your MySQL schemas so you don't get caught up in early performance problems.
Learn how to select your tables data types and what performance implications they have. Review how indexing works, as well as basic indexing tips and tricks. A healthy schema is one of the first steps to having a performant database.
MySQLPerformance Optimization
Nov 3, 2020
Best Practice in Design and Implementing MySQL Geographic Distributed, High Availability Solutions - PLO October 2020
Nowadays implementing different grades of business continuity for the data layer storage is a common requirement.
When designing architectures that include MySQL as a data layer, we have different options to cover the required target. Nevertheless we still see a lot of confusion when in the need to properly cover concepts such as HighAvailability and Disaster Recovery. Confusion that often leads to improper architecture design...
MySQLHigh Availability
Nov 3, 2020
DBdeployer, the Community Edition - Giuseppe Maxia - Percona Live ONLINE 2020
DBdeployer, an OpenSource tool that allows easy deployment of many MySQL/Percona servers in the same host, has passed two years of development. Its latest additions have aimed at improving ease of use for both beginners and experts.
This talk will show how to start with dbdeployer with an empty box, and quickly populate it with recent and less recent server versions, all at the command line.
MySQLOperations