Planet MariaDB Server
How to Build a Percona Server “Stack” on a Raspberry Pi 3+
The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the…
MySQL Optimizer: Naughty Aberrations on Queries Combining WHERE, ORDER BY and LIMIT
Sometimes, the MySQL Optimizer chooses a wrong plan, and a query that should execute in less than 0.1 second ends-up running for 12 minutes!This is not a new problem: bugs…
My experience talking at JConf Colombia
Sharing my experience presenting Vaadin at JConf Colombia 2019.
Impact of innodb_file_per_table Option On Crash Recovery Time
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…
The Concept of Materialized Views in MongoDB Sharded Clusters
In one of my past blogs I explained the contribution of MongoDB® views in organization security. In this blog, I will take it one step further and I will try…
Dynimize Quickstart Tutorial
Duration: 10 min Level: Beginner This tutorial will show you how to install Dynimize. We’ll then use it to optimize a live MySQL process that’s been running the Sysbench…
MySQL How do you restore tablespace
MySQL How do you restore tablespace? This is not new information but I have not covered it much so addressing it now for those that need it. If you lose…
MySQL Binlogs:: How to recover
So I realized I had not made a post about this after this situation that recently came up. Here is the scenario: A backup was taken at midnight, they used…
Tame Kubernetes with These Open-Source Tools
Kubernetes’ popularity as the most-preferred open-source container-orchestration system has skyrocketed in the recent past. The overall container market is expected to cross USD 2.7 billion by 2020 with a CAGR…
MySQL Group Replication
So MySQL’s group replication came out with MySQL 5.7. Now that is has been out a little while people are starting to ask more about it. https://dev.mysql.com/doc/refman/8.0/en/group-replication.html https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-single-primary-mode.html Below is…
Max_connections 214 4.15.0-46-generic #49-Ubuntu
So the issue of max_connections dropping from the value set in your my.cnf file down to 214 has been around for a little while on Ubuntu. As an example, it was…
Percona Live Presents: Globalizing Player Accounts with MySQL at Riot Games
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…
Percona Live Presents: Gonymizer, A Tool to Anonymize Sensitive PostgreSQL Data Tables for Use in QA and Testing
SmithRX is a next generation pharmacy benefit platform that is using the latest technology to radically reshape the prescription benefit management industry. To move quickly, we require the ability to…
Percona Live Presents: An Open-Source, Cloud Native Database
During our presentation at Percona Live 2019 Intel and its software partners will introduce the audience to the work we’re doing to enable an open-source framework, we call Cloud Native…
Percona Live Presents: The State of Databases in 2019
At this year’s Percona Live I am talking about The State of Databases in 2019. As a Software Engineer in the thick of the Database landscape, there are two problems…