Percona Tech Days 2020
2020-08-05..2020-09-18
-- online --
| title | author | length |
|---|---|---|
| Database Talks and Tutorials | Matt Yankovic | 01m |
Percona runs half-day events that deliver a tight snapshot of a single database technology in a few-hour window, each session packing multiple technical talks… | ||
| The best Database Tutorials | 01m | |
Percona runs free, half-day focused sessions that target one core open‑source database per week and deliver concrete MySQL, MongoDB, or PostgreSQL updates… | ||
| Building Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL | Avi Vallarapu | 29m |
Percona Distribution bundles community Postgres (11 and 12) with tested tooling so you get point‑in‑time recovery and incremental, encrypted backups via… | ||
| Elephant by the pool: PostgreSQL connection poolers overview | Sergey Kuzmichev | 20m |
Explains why connection creation costs matter with concrete numbers: auth drops TPS from 130 to 95 and TLS to 72 while persistent connections jump throughput… | ||
| Joining Heterogeneous Databases is a reality, not a Myth | Ibrar Ahmed | 34m |
Demonstrates that PostgreSQL Foreign Data Wrappers let one actually join tables across Postgres, ClickHouse, MySQL and even MongoDB by pushing work to the… | ||
| An Introduction To pgcrypto | Robert Bernier | 26m |
Shows how to install pgcrypto on Ubuntu Bionic, add CREATE EXTENSION pgcrypto, and use OpenPGP via gpg2; demonstrates digest() for MD5/SHA‑256, password… | ||
| Migrating from MSSQL to PostgreSQL | Robert Bernier | 27m |
Real migration steps: compile and install the tds_fdw foreign data wrapper on a Linux/Postgres 9.6+ build, create foreign tables for the SQL Server… | ||
| Understanding and Optimizing commit sychronization for maximum performance | Jobin Augustine | 35m |
Explains how PostgreSQL guarantees durability via WAL and which knobs change real behavior: default 16 MB wal segment, WAL is 64‑bit LSN (effectively 16… | ||
| Enterprise Authentication for Percona Server for MongoDB - LDAP and Kerberos | Sandra Romanchenko | 22m |
Percona Server for MongoDB adds external auth using saslauthd proxy, native LDAP binding, and Kerberos keytab methods: the demo configures saslauthd, shows… | ||
| MongoDB Backups Overview | Akira Kurgane | 40m |
Six concrete options: mongodump (logical, simple, OK for small DBs but slow due to read‑amplification), stopping a secondary and copying DB files (physical… | ||
| Why Pay for MongoDB Enterprise When Open Source Has You Covered? | Barret Chambers | 21m |
Claim: get MongoDB Enterprise–class features without paying MongoDB Inc by using Percona tooling. Lists concrete replacements: Percona Server for MongoDB… | ||
| Moving MongoDB to the Cloud: Strategies and points to consider | Vinicius. Grippa | 24m |
Describes two concrete migration paths: add a replica set member on cloud using rs.add and rs.stepDown for zero downtime with initial sync, or a physical… | ||
| MongoDB Atlas vs managed community edition | Rick Vasquez | 47m |
Licensing changes since SSPL change (Oct 16 2018) force cloud providers to either license MongoDB commercially or hard‑fork the last AGPL code, so Atlas… | ||
| How Safe is Asynchronous Master-Master Setup? | Sveta Smirnova | 21m |
Claims that built-in asynchronous active-active replication is unusable for production get challenged with concrete fixes: thousands of shops use asynchronous… | ||
| MySQL Schema Review | Michael Benshoof | 28m |
Demo creates two identical tables with 4 million rows and compares INT vs BIGINT, finding about 250 MB extra for BIGINT; removing a duplicate index reclaims… | ||
| MySQL 8 Observability | Peter Zaitsev | 27m |
MySQL 8 adds concrete observability: Performance Schema with >1,000 instruments and configurable consumers, session vs global SHOW STATUS deltas… | ||
| Deep Dive Into InnoDB Page Merging and Page Splitting | Marco Tusa | 34m |
Explains how InnoDB physically stores pages, shows that page splits happen on inserts and page merges on deletes/updates, and measures ~3x more splits with… | ||
| Percona Server 8.0 features you always wanted but were afraid to ask for | Yura Sorokin, Satya Bodapati | 30m |
Percona adds SEQUENCE_TABLE() (Percona Server 8.0.20-11) as a table function that generates integer ranges, bounded by session expressions, supports shifting… | ||
| Using PMM to identify and troubleshoot problematic MySQL queries | Michael Coburn | 27m |
Uses RED: rate errors duration with PMM Query Analytics 2.9 to find which MySQL statements drive load, showing 62 distinct queries, one averaging 120 ms while… | ||
| nothing matches | ||