Percona Community Live 2022
2022-06-21..2022-06-23
-- online --
| title | author | length |
|---|---|---|
| Percona Community Live Conference - Day 3 - Open Source Databases Conference | Maksim Gramin, Denys Kondratenko, Sergey Pronin, Colin Charles | 11h 21m |
Day 3 bundles practical demos and hard numbers: a PMM Helm chart for Kubernetes (deployable, PVC-aware, disables UI updates) and a PMM API that registers… | ||
| Percona Community Live Conference - Day 2 - Open Source Databases Conference | Sidney Chen, Sri Sakthivel M.D., Gabriel Ciciliani, Yunus Shaikh | 01h 57m |
Shows how a real core‑banking app reaches 1000 TPS on TiDB: missing indexes fixed a full table scan, enabling index_merge cuts a 50M‑row scan to 8ms, NUMA… | ||
| Percona Community Live Conference - Day 1 - Open Source Databases Conference | Ravikumar Buragapu, Lenz Grimmer, Keao Yang, Anton Bystrov, Bruce Momjian | 11h 43m |
Claims that VictoriaMetrics stores huge time series cheaply and with far lower CPU than Prometheus, demonstrated by a 12‑hour test that ingests 344 billion… | ||
| Database Resiliency | Ravikumar Buragapu | 47m |
Explains concrete tradeoffs of the CAP theorem (favor consistency or availability under partition), compares specific topologies — master‑slave for read… | ||
| Flexible Indexing With Postgres | Bruce Momjian | 01h 00m |
Covers which Postgres index to pick and why: expression indexes on lower(name) let function-based WHERE clauses use an index; partial indexes shrink index size… | ||
| I Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest | Charly Batista | 56m |
Demonstrates recovering a dropped table from a PostgreSQL physical base backup plus WAL archives using pgBackRest for automated point-in-time recovery; creates… | ||
| Emulate Block Device Incidents With IO Scheduler | Keao Yang | 50m |
Describes a Linux IO scheduler called IOEM kernel module that emulates block-device latency and IOPS per device and per process, letting teams reproduce a real… | ||
| The 10 Deadly PostgreSQL Sins | Matt Yonkovit | 01h 00m |
Ten recurring production mistakes and concrete fixes: using the wrong tool (eg pg_repack can block busy DDL), confusing pooling vs load‑balancing (use… | ||
| How to Build Percona Server 8 on Raspberry Pi 4 | Wayne Leutwyler | 55m |
Like👍 Comment💬 Share🔗 Subscribe✅ and tap the 🔔 to be the first to see new videos on #OpenSource #Databases & more! https://percona.tv/subscribe
We will… | ||
| Making Databases as Easy as Legos: No code, No problem! | Farokh Shahabi | 54m |
Argues that no-code must stop treating spreadsheets as databases and instead creates a database automatically from a visual form, so business users build UI… | ||
| Liquibase Data: Version Control and Collaboration for the Database | Robert Reeves | 01h 00m |
Liquibase Data claims to version both schema and row data using a git-style workflow and 15 years of Liquibase history behind it. The demo runs on Docker… | ||
| The Future of MyDumper | David Ducos | 01h 00m |
MyDumper now supports streaming with full compression so restores can start while a backup is still running, and the stream implementation reliably pushes… | ||
| Percona Database Distributions - An Overview | Lenz Grimmer | 15m |
Percona maintains enterprise database distributions for MongoDB, MySQL and PostgreSQL that bundle tested tools like Percona Server for MySQL, Percona XtraDB… | ||
| ProxySQL 2021 Dev Submit | Javier Jaramago Fernández | 41m |
ProxySQL adds a built-in Prometheus exporter exposing 180+ metrics and Grafana templates, switches to per-thread counters for zero-overhead scraping, and… | ||
| Data Wrangling With MongoDB | Jean Joseph | 40m |
Walks through a 70% demo that actually builds and runs Python scripts to convert CSV to JSON and insert into MongoDB, including using the csv module, datetime… | ||
| Using PMM Alerting in Production | Francisco Bordenave | 25m |
PMM connects to Percona Platform to run advisors checks and now ships a technical‑preview integrated alerting system using YAML templates and notification… | ||
| Let's Talk About MySQL Query Tuning | Gabriel Ciciliani | 55m |
Sets long_query_time and watches the slow_queries counter, aiming for aim for ~1 slow query/sec; captures logs to file/table or TCP dump and groups… | ||
| PostgreSQL and Artificial intelligence | Ibrar Ahmed | 01h 00m |
Shows a working proof of concept that trains a tiny neural network inside PostgreSQL using plpython and PL/Tcl style tensors, generating a random dataset… | ||
| Optimization Techniques in MySQL | Yunus Shaikh | 56m |
MySQL 8 removes the query cache and relies on performance_schema plus Percona PMM for query analytics and top‑time digests, with pt‑query‑digest as an… | ||
| Production with ProxySQL and Orchestrator | Alawi Assaggaf | 55m |
Three concrete setups using ProxySQL and Orchestrator show how to decouple apps and run MySQL rolling changes: a central cluster with 1 master + 3 promotable… | ||
| The Low Hanging Fruits of MySQL | Kedar Vaijanapurkar | 47m |
Tune InnoDB buffer pool to 75–80% memory, split it with buffer_pool_instances to avoid mutex contention, and use O_DIRECT with large innodb_log_file_size (even… | ||
| Database Reliability Engineering for MySQL | Matthias Crauwels | 46m |
Describes a concrete MySQL reliability stack: Orchestrator with Raft (requires three nodes) automates primary failover, uses holistic detection and an… | ||
| How do We Keep Metrics for a Long Time in VictoriaMetrics | Anton Bystrov | 01h 00m |
Comparison shows VictoriaMetrics storing long‑term metrics with far lower resource cost: a 12‑hour test on a 2‑CPU, 7.7 GB RAM, 25 GB disk bench ingests 344… | ||
| The Journey to Achieve 1000x TPS for a Real-World Core Banking Application on TiDB | Sidney Chen | 36m |
A real deployment on ARM64 TiDB starts at QPS 1 and reaches 1,200 after systematic fixes: fix three slow queries with a composite index and enable index-merge… | ||
| Overview of Different ALTER Algorithms and Its Locking Scenarios in MySQL | Sri Sakthivel M.D. | 36m |
Demo uses Percona server 8.7.28 and sysbench against a ~4,000,000‑row InnoDB table to run ALTER with algorithms COPY, INPLACE and INSTANT under locks shared… | ||
| The Lost Art of Database Design | Matt Yonkovit | 51m |
Argues that poor schema design is the top recurring problem and that small choices cascade into big costs: a user table keyed by email balloons storage and… | ||
| Database as Code. Not only migrations | Maksim Gramin | 08m |
Migrations are only the start: a proposed set of four rules requires all database changes scripted and automated, version control as single source… | ||
| PMM on Kubernetes | Denys Kondratenko | 01h 00m |
Shows how to run Percona Monitoring and Management (PMM) inside Kubernetes using the published Helm chart and a statefulset with PVC for persisted metrics… | ||
| Cross-Cloud Migrations With Databases on Kubernetes | Sergey Pronin | 01h 00m |
Percona Operators for MySQL, PostgreSQL and MongoDB enable cross‑cloud moves by automating real primitives: MySQL uses asynchronous replication between Percona… | ||
| Physical Backups with Percona Backup for MongoDB | Sergey Pronin | 39m |
Percona Backup for MongoDB adds PSMDB based physical backups using backupCursor and backupCursorExtend to capture file lists, oplog end timestamps, and… | ||
| The Open-Source Distributed Graph Database: Nebula Graph | Wey Gu | 01h 00m |
Nebula Graph claims linear scalability across hundreds of billions of vertices and trillions of edges with many-second latency under high-concurrency OLTP… | ||
| PostgreSQL Query Performance Insights | Hamid Quddus Akhtar | |
Understanding query performance patterns are essentially the foundation for query performance tuning. It, in many ways, dictates how a #database cluster… | ||
| PostgreSQL Replication Conflicts: Avoiding Pitfalls | Hamid Quddus Akhtar | 51m |
Experiencing replication conflicts is not too unfamiliar a sight. Whether one experiences replication lag, slots, locks, snapshots, tablespace issues, or other… | ||
| Common Possible Preventative Measures to Avoid Locking Issue in PostgreSQL | Naveed Shaikh | 37m |
Main concrete rules: before PostgreSQL 11 adding a column with a DEFAULT rewrites the whole table and can block reads and writes for hours so avoid defaults on… | ||
| The Road Towards an Open Database Performance Ranking | Daniel Seybold | 47m |
An open database performance ranking built with benchANT publishes reproducible results for nine popular databases across three cloud providers, three VM sizes… | ||
| nothing matches | ||