Category Archives: Learning

This week we discuss MySQL and Geographical Information Systems (GIS). Ear candy is how MVCC in InnoDB relates to undo logging and how you can write better queries based on this information. At the Movies is a demo of GIS.
MySQL and MariaDB geographic … Continue reading →

This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.
News
MySQL Community Awards 2014: the Winners
MariaDB 10
MariaDB 10.0.1 fe… Continue reading →

This week, we interviewed longtime community member and Percona principal support engineer Justin Swanhart about Flexviews, a tool for Materialized Views in MySQL. Ear Candy is about the EXPLAIN analyzer, and At the Movies is about “Advanced MySQL Repl… Continue reading →

This week, we sat down with Luis Villa about non-software licenses. Ear Candy is and At the Movies is Sheeri talking about Percona Replication Manager at the Boston MySQL User Group a few years ago.
Non-software Licenses
Luis Villa’s Wikipedia page.
Ba… Continue reading →

This week we talk about replication features in MariaDB 10. Ear Candy is a gotcha about PIVOT tables in MariaDB, and At the Movies is about the viability of transactions.
Percona Live
DB Hangops – every other Wednesay at noon Pacific time
Upcoming MySQ… Continue reading →

This week, we talk about the awesome ways to use MariaDB’s CONNECT storage engine that go above and beyond merely connecting to remote tables.
MariaDB CONNECT Engine
Episode 174, where we talked about setting up the CONNECT storage engine and some simp… Continue reading →

This week we discuss MariaDB’s CONNECT storage engine. Ear Candy is inconsistent behavior with dates, NULLs and collations. At the Movies is a talk about the history and future of MySQL and its variants.
Sheeri:
The 2014 MySQL Community Awards are open… Continue reading →

This week we discuss more tools in the Percona Toolkit – pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTI… Continue reading →

This week we discuss administering Percona Replication Manager. Ear Candy is about repository packages from MariaDB and Oracle, and At the Movies presents a Riak engineer talking about “convergent replicated data types” – data structures that tolerate … Continue reading →