Percona Live Online 2020
2020-10-20..2020-10-21
-- online --
| title | author | length |
|---|---|---|
| The Cloud is Inevitable | Sugu Sougoumarane | 28m |
Argument: CPU clocks stall while software and datasets grow so databases must be distributed; the concrete solution is Vitess with three solved problems… | ||
| Organizing for your Ethical Principles | Liz Fong Jones, Emily Gorcenski | 30m |
Examples include Theranos producing bad test kits, Volkswagen cheating emissions tests, Cambridge Analytica running micro‑targeted propaganda, LaLiga’s app… | ||
| The Technological Response to a Global Pandemic | Karen Ambrose | 29m |
The Francis Crick Institute repurposes labs into a COVID 19 diagnostic centre and within two weeks fields a high-throughput RT‑PCR pipeline integrated with HSL… | ||
| Why Public Database as a Service is Prime for Open Source Distribution | Peter Zaitsev | 17m |
Database-as-a-service wins on convenience but creates vendor lock-in, higher incidents and surprise costs; the talk claims a premium rose from ~30% to parity… | ||
| The Democratization of Databases | Bruce Momjian | 32m |
Argues that open source acts like a democratic meritocracy and produces software as good or better than proprietary stacks, with PostgreSQL improving in all… | ||
| The State of the Dolphin | Frederic Descamps | 29m |
Latest MySQL 8.0 release claims concrete changes: Document Store and InnoDB Cluster and an InnoDB ReplicaSet implementation, with MySQL Router and MySQL Shell… | ||
| A Look at the Elephant's Trunk PostgreSQL 13 | Magnus Hagander | 30m |
PostgreSQL 13 lists concrete, deployable changes: drop database with force actually disconnects clients, autovacuum now triggers on inserts and can run index… | ||
| The State of MongoDB, Its Open Source Community, and Where Percona Is Going With It | Kimberly Wilkins | 37m |
MongoDB claims continued growth (DB-Engines #5, ~35–50M downloads last year, ~1% global DB market) and new 4.x features: refinable shard keys, compound hashed… | ||
| pg_stat_monitor: A cool extension for better monitoring using PMM | Ibrar Ahmed, Nurlan Moldomurov | 25m |
pg_stat_monitor claims to replace pg_stat_statements by providing pre-calculated aggregates and bucketed timing histograms so aggregates and latency… | ||
| Achieving PCI Compliance With Percona Server for MongoDB, or Getting as Close as Possible | Travis Frutas, Brian Walters | 32m |
Describes a concrete checklist to get Percona Server for MongoDB toward PCI: enable envelope encryption for at‑rest data (master key external, supports… | ||
| Sharding: DIY or Out of the Box Solution? | Art van Scheppingen | 28m |
Describes concrete outcomes: a DIY sharding reuses existing ProxySQL rules, adds per-shard connections and ProxySQL per-shard connections, shards by uid with… | ||
| Using MongoDB with Kafka - Use Cases and Best Practices | Antonios Giannopoulos | 30m |
Covers concrete patterns: MongoDB as Sink (consume Kafka topics into collections) and as Source (change streams → Kafka), uses spring kafka in TransferWise’s… | ||
| DBdeployer, the Community Edition | Giuseppe Maxia | 22m |
dbdeployer is a Go command line tool shipped as a single binary per OS that initializes an environment, downloads MySQL/Percona tarballs, and deploys isolated… | ||
| MySQL 8.0 Document Store - Discovery of a new world | Frederic Descamps | 31m |
Claim: MySQL 8.0 Document Store lets applications treat JSON collections like a schemaless document DB while still using SQL when needed. It ships with X… | ||
| Security and Traceability on Distributed Database Systems | Julien Riou | 33m |
OVHcloud faces obfuscated client IPs when using load balancers in front of PostgreSQL clusters so pg_hba.conf and logs lose source identity. The solution… | ||
| Boosting MySQL Performance | Jose Luis Martinez | 59m |
Shows concrete MySQL specifics: exact storage sizes for INT family storage bytes, when VARCHAR temporary to MEMORY conversion inflates RAM, blob/text limits… | ||
| PostgreSQL WAL and Commit Synchronization, Optimization Opportunities | Jobin Augustine | 31m |
Explains what each WAL record actually does, how WAL moves from shared 16 MB WAL buffer to OS and disk, and which OS IO behavior matters; shows small code… | ||
| Between Toothpicks and Steel: Scaling for Real People | Kyle J Davis | 29m |
Compares a real bridge (George Washington Bridge with 103 million vehicles per year and 105,986 cables and a second deck added in 1959) to minimalist crossings… | ||
| Best Practice in Design and Implementing MySQL Geographic Distributed, High Availability Solutions | Marco Tusa | 32m |
Claims concrete tradeoffs and concrete setups: evaluation of PXC/Galera and group replication versus async primary/secondary, measured latency effects at 400… | ||
| Soar Higher With MariaDB SkySQL - The Ultimate MariaDB Cloud | Manjot Singh, Tim Yim | 26m |
SkySQL claims a full MariaDB Platform DBaaS that runs on Kubernetes control plane with a ServiceNow portal, Prometheus/Grafana monitoring and MaxScale for… | ||
| SELinux Fun With MySQL and Friends | Matthias Crauwels | 27m |
Moves MySQL data to /data/mysql fails to start until file contexts are set with semanage fcontext and applied with restorecon; changing MySQL to listen on port… | ||
| Panel: Running Databases in Containers | 01h 06m | |
Shows concrete wins and concrete failures: people run MySQL/Vitus and TiDB in Docker on Kubernetes using Kubernetes operators to automate failover, but… | ||
| Serverless Databases: The Good, the Bad, and the Ugly | Renato Losio | 25m |
Defines serverless relational databases by four requirements and shows how AWS Aurora Serverless meets them while imposing hard limits: MySQL 5.6/5.7… | ||
| Advanced Optimization and Troubleshooting MySQL Using PMM2 | Peter Zaitsev | 29m |
Demonstrates PMM2’s actionable features: ClickHouse-backed query analytics surfaces a specific case where an UPDATE query spends 99% time on lock and lets… | ||
| What If We Could Use Machine Learning Models as Tables? | Jorge Torres | 21m |
Claims that machine learning models behave like database tables and shows it running for MySQL and Postgres by exposing ai tables via federated storage… | ||
| Mastering Open Source Data Governance | Elisha Chitsenga | 20m |
Defines governance as planning plus execution of policies and gives a concrete life‑cycle checklist… | ||
| Revision Control for Structured Data | Gavin Mendel Gleason | 27m |
Claim: a database built for distributed revision control of structured data solves collaboration gaps that Git or central DBs leave. Implementation explores… | ||
| Engineering Data Reliably Using SLO Theory | Emily Gorcenski | 28m |
Argues that applying SLO theory to data platforms yields measurable wins: define 99.5% freshness over 30 working days (a 90 minutes error budget), then add… | ||
| How Does Geo-Replication Work in TiDB? | Jay Lee | 28m |
TiDB uses Raft-based replication with PD as the metadata router and regions (default region size 96MB) split across TiKV instances; regions default to three… | ||
| The "411" on PMM | Brandon Fleisher, Steve Hoffman | 28m |
Percona says PMM is an on‑premises open source monitoring and management app that actually monitors databases, alerts where configured, runs on‑demand security… | ||
| The State of ProxySQL, 2020 Edition | René Cannaò | 27m |
Overview of actual changes and demos: precise feature list, not fluffy promises. ProxySQL 2.0 adds LDAP authentication, client TLS, AWS Aurora host group… | ||
| Power Hour, Managing Databases at Scale – Bala Kuchibhotla | Bala Kuchibhotla | 16m |
Nutanix Era presents a one-click database service that provisions Oracle Postgres MySQL MariaDB and SQL Server in minutes instead of weeks, offers a time… | ||
| Availability and Performance Tradeoffs in Global Database Deployments | Kevin Jernigan | 27m |
Explains concrete tradeoffs: use logical replication when you need table-level filtering, zero-downtime schema rollout or bi‑directional conflict handling at… | ||
| Building Data Lake with MariaDB ColumnStore | Sasha Vaniachine | 18m |
Claims that MariaDB ColumnStore plus S3 storage cuts storage costs and delivers substantial compression while accelerating wide scans and aggregations by… | ||
| From Containers to Kubernetes Operators | Philipp Krenn | 49m |
Docker images land around 750 MB and move to trimmed CentOS7/UBI bases (~600 MB) to reduce false positives; images are immutable and no latest tag is allowed… | ||
| SQL Row Store vs Data Warehouse: Which Is Right for Your Application? | Robert Hodges | 30m |
Compares MySQL row store and ClickHouse column store using MySQL and ClickHouse examples and concrete numbers. MySQL handles millions‑per‑second tiny… | ||
| Databases on Kubernetes | Rick Vasquez | 34m |
Says Percona builds Kubernetes operators using only kubernetes primitives and claims full lifecycle automation: automated provisioning, seamless major and… | ||
| Introducing Kunlun Distributed Database Cluster | David Zhao Wei | 40m |
Kunlun claims a working distributed DBMS that wires PostgreSQL computing nodes to MySQL storage shards, implements two-phase commit for multi-shard… | ||
| Vitess Online Schema Migration Automation | Shlomi Noach | 27m |
Vitess claims to let you issue one ALTER TABLE and automate per-shard online DDL by writing a request into topology and having vttablet schedule gh-ost or… | ||
| DIY DBaaS with Percona Kubernetes Operators | Vadim Tkachenko | 27m |
Provides automated DBaaS primitives: Percona XtraDB Cluster Operator and Percona Server for MongoDB Operator deployable via kubectl, Helm or a CLI, runnable on… | ||
| MariaDB 10.5 Tutorial - New Features for Troubleshooting | Valerii Kravchuk | 57m |
MariaDB 10.5 actually adds measurable troubleshooting tooling: ~270 new instrumentation points in Performance Schema, parity with many MySQL 5.7 tables plus a… | ||
| Full Observability for Application Monitoring | Markus Strauss | 24m |
APMs stop where database visibility begins so the session claims 70% of performance problems trace back to the database and argues for instrumenting queries… | ||
| MySQL Ecosystem on ARM | Krunal Bauskar | 30m |
States that MySQL 8.x on ARM and MariaDB on ARM are working and production-ready in many cases, while dozens of ecosystem pieces remain unported or… | ||
| Power Hour, Managing Databases at Scale – Peter Zaitsev | Peter Zaitsev | 18m |
Three vendors give concrete stances: embrace open source to avoid vendor lock in, limit database sprawl to a controlled set, and invest in automation for… | ||
| How to Protect the SQL Engine From Running Out of Memory | Huaiyu Xu, Song Gao | 21m |
Claim: TiDB prevents SQL engine OOMs by measuring and capping per-query memory with a mem tracker tree and a chain of OOM actions. Implemented actions include… | ||
| Managing Databases at Scale - AWS | Sirish Chandrasekaran | 19m |
Recommendation: offload routine ops to a managed service and apply the concrete controls shown here. Claim: using Amazon RDS cuts undifferentiated heavy… | ||
| Analytical Queries in MySQL | Øystein Grøvlen | 27m |
Benchmarks use TPC‑H queries and compare MySQL 5.7, MySQL 8.0, MariaDB and PostgreSQL on the same data; tpch query 21 runs ~90% faster in 8.0 after optimizer… | ||
| NoSQL Endgame | Werner Keil, Thodoris Bais | 32m |
Compares actual Java frameworks—Spring Data, Micronaut Data, Jakarta NoSQL—against MongoDB and Neo4j with live demos: repository and template code, queries… | ||
| In and Out of the Weeds With MongoDB 4.4 Hedged Reads | Kimberly Wilkins | 23m |
Hedged Reads in MongoDB 4.4 claims to cut tail latency by sending reads to multiple replicas and returning the fastest result; mongos picks eligible… | ||
| How Can Databases Capitalize on Computational Storage? | Tong Zhang, JB Baker | 28m |
ScaleFlux CSD 2000 drives run compression and other compute in-drive so MySQL and Postgres see about 2x throughput versus NVMe with host compression while… | ||
| How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster | Sveta Smirnova | 31m |
Percona XtraDB Cluster enforces 100% synchronized for DML but DDL is non‑transactional so schema changes must replicate fully before next access and can take… | ||
| Percona Enterprise Platform | Brandon Fleisher | 02m |
Percona announces a new product called Percona Enterprise Platform claiming a truly open source DBaaS alternative that avoids vendor lock‑in, provides a single… | ||
| PostgreSQL Core Distribution 13 | Rick Golba | 02m |
Claims that PostgreSQL 13 cuts resource use: parallel VACUUM reduces bloat and speeds cleanup, B-Tree deduplication shrinks index storage, and partition-wise… | ||
| SQLancer: Finding Logic Bugs in Database Management Systems | Manuel Rigger | 06m |
An automated SQL fuzzer called SQLancer generates large numbers of random SQL workloads using grammar-aware mutations and runs them against real DBMS binaries… | ||
| Testing Cloud - Native Databases with Chaos Engineering | Qiang Zhou | 06m |
Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel + Turn on the 🔔
📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about… | ||
| nothing matches | ||