Buy Percona ServicesBuy Now!

Minimalist Tooling for MySQL/MariaDB DBAs

 | August 14, 2019 |  Posted In: MariaDB, MySQL, Tools

In my roles as a DBA at various companies, I generally found the tooling to be quite lacking. Everything from metrics collection, alerting, backup management; they were either missing, incomplete or implemented poorly. DBA-Tools was born from a desire to build backup tools that supported my needs in smaller/non-cloud environments. As BASH is easily the […]

Read More

Impact of innodb_file_per_table Option On Crash Recovery Time

 | July 23, 2019 |  Posted In: MySQL, Open Source Databases

Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces. It provides some advantages. I will highlight some of them: You can reclaim disk space when truncating or dropping a table stored in a file-per-table tablespace. Truncating or dropping tables stored in the shared system tablespace creates free space internally […]

Read More

Percona Live Presents: Globalizing Player Accounts with MySQL at Riot Games

 | May 28, 2019 |  Posted In: Events, MySQL, Open Source Databases

During my presentation at Percona Live 2019, I’ll be talking about how Riot Games, the company behind League of Legends, migrated hundreds of millions of player accounts to unlock opportunities for us to delight players. This meant moving ten geographically distributed databases into a single global database replicated into four AWS regions. I’ll talk about […]

Read More