Monthly Archives - October 2016

Webinar Wednesday November 2: MongoDB Backups, All Grown Up!

MongoDB Backups

Please join us on Wednesday, November 2, 2016 at 10:00 am PDT / 1:00pm EDT (UTC-7) for the webinar MongoDB Backups, All Grown Up, featuring David Murphy, Percona’s Mongo Practice Manager. 
It has been a long road to stable and dependable backups in the MongoDB space. This webinar covers the current types of backups and their limitations when […]

Read more

Blog Series: MySQL Configuration Management

MySQL access privileges

MySQL configuration management remains a hot topic, as I’ve noticed on numerous occasions during my conversations with customers.
I thought it might be a good idea to start a blog series that goes deeper in detail into some of the different options, and what modules potentially might be used for managing your MySQL database infrastructure.
Configuration management […]

Read more

New TokuDB and PerconaFT database file management feature in Percona Server 5.6.33-79.0 and Percona Server 5.7.15-9

MariaDB ColumnStore

This blog post discusses a new TokuDB and PerconaFT database file management feature in two Percona Server releases.
By now you have hopefully read through Peter’s post and my two prior posts on the TokuDB/PerconaFT file set. If you have not, it is probably a good idea to run through them now before we get into […]

Read more

Thoughts on MySQL 8.0 Invisible Indexes

Invisible Indexes

MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer.
I wanted to share some of my first experiences and thoughts about this new feature.
Why is it good for us?
There are a couple of use cases. One of them is if you want to drop an […]

Read more

Percona Poll: What Database Technologies Are You Using?

Database Technologies

Take Percona’s poll on what database technologies you use in your environment.
Different databases get designed for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common issues. Big data and IoT applications, high availability, secure backups, security, cloud vs. on-premises deployment: each have a set […]

Read more

Percona Live Open Source Database Conference 2017: Submit Papers ASAP!

Percona Live

The Percona Live Open Source Database Conference 2017 call for papers is closing soon! Get in your submissions ASAP!
After this past sold-out Percona Live Europe in Amsterdam, we’ve decided that expansion definitely works! The diverse list of topics at the recent conference convinced us that variety is both the spice of life. It’s the […]

Read more

Monitoring OS metrics for Amazon RDS with Grafana

OS Metrics

This article describes how to visualize and monitor OS metrics for Amazon RDS instances using Grafana. We use CloudWatch as a data source, and Grafana to query CloudWatch API in real-time to get data. The setup instructions include just four quick steps (assuming you already use Grafana).
1. Create an IAM user on the AWS panel, […]

Read more

TokuDB and PerconaFT Data Files: Database File Management Part 2 of 2


This is the second installment of the blog series on TokuDB and PerconaFT data files. You can find my previous post here. In this post we will discuss some common file maintenance operations and how to safely execute these operations.

Moving TokuDB data (table/index) files to another location outside of the default MySQL datadir
TokuDB uses the […]

Read more

Announcing MyRocks in Percona Server for MySQL

MyRocks in Percona Server

Announcing MyRocks in Percona Server for MySQL.
RocksDB has been taking the world by the storm!
RocksDB counts Facebook, LinkedIn, Pinterest, Airbnb and Netflix among its users. It is the storage engine for many open source database technologies, including CockroachDB, Apache Flink, TiKV and Dgraph. It is also integrated with MySQL and MongoDB as the MyRocks and […]

Read more