Planet MariaDB Server
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…
Percona Live Presents: The First Ever TiDB Track
The PingCAP team has always been a strong supporter of Percona and the wider open source database community. As the people who work day in and day out on TiDB,…
Slack
Just a simple post here to give support to the slack community channels. If you have not joined some of these… this is a great way to communicate with the…
Percona Live Presents: The MySQL Query Optimizer Explained Through Optimizer Trace
During my presentation at Percona Live 2019 I will show how using Optimizer Trace can give insight into the inner workings of the MySQL Query Optimizer. Through the presentation, the audience…
Percona Live Presents: Vitess – Running Sharded MySQL on Kubernetes
The topic I’m presenting addresses a growing and unfulfilled need: the ability to run stateful workloads in Kubernetes. Running stateless applications is now considered a solved problem. However, it’s currently…