MongoDB Audit Log: Why and How

Tomislav Plavcic

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll talk about the MongoDB audit log. Percona’s development team has always invested in the open-source community a pri

2017-03-03 23:24:00  

A Look at MariaDB Subquery Cache

Federico Razzoli

The MariaDB subquery cache feature added in MariaDB 5.3 is not widely known. Let’s see what it is and how it works. What is a subquery cache? The MariaDB subquery cache optimizes the execution of correlated subqueries. Correlated subqueries

2017-03-03 02:11:59  

Using Percona Toolkit pt-mongodb-summary

Carlos Salguero

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll look at the [crayon-58bb99731cd29169686626-i/] tool in Percona Toolkit. The [crayon-58bb99731cd38110663531-i/] tool from

2017-03-02 23:08:38  

Using Percona Toolkit pt-mongodb-query-digest

Carlos Salguero

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll look at how to use the [crayon-58bb99731e9dc066412708-i/] tool in Percona Toolkit 3.0. Percona’s [crayon-58bb99731e9eb721

2017-03-01 23:21:07  

Open Source Databases on Big Machines: Disk Speed and innodb_io_capacity

Sveta Smirnova

In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results. The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I ex

2017-03-01 23:00:57  

Percona Monitoring and Management (PMM) Graphs Explained: MongoDB MMAPv1

Tim Vaillancourt

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, I hope to cover some areas to watch with Percona Monitoring and Management (PMM) when running MMAPv1. The graph examples from this ar

2017-02-28 23:28:05  

Webinar Thursday March 2, 2017: MongoDB Query Patterns

Dave Avery

Join Percona’s Senior Technical Services Engineer Adamo Tonete on Thursday, March 2, 2017, at 11:00 a.m. PST / 2:00 p.m. EST (UTC-8) as he reviews and discusses MongoDB® query patterns. Register Now MongoDB is a fast and simple-to-query schema-fr

2017-02-28 01:06:28  

MySQL Ransomware: Open Source Database Security Part 3

David Busby

This blog post examines the recent MySQL® ransomware attacks, and what open source database security best practices could have prevented them. Unless you’ve been living under a rock, you know that there has been an uptick in ransomware for

2017-02-27 22:28:12  

Percona Monitoring and Management (PMM) Graphs Explained: WiredTiger and Percona Memory Engine

Tim Vaillancourt

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog, we’ll go over some useful metrics WiredTiger outputs and how we visualize them in Percona Monitoring and Management (PMM). WiredTige

2017-02-27 17:34:25  

Installing Percona Monitoring and Management (PMM) for the First Time

Jon Tobin

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. This post is meant to walk a prospective user through the benefits of Percona Monitoring and Management (PMM), how it’s architected and the simple insta

2017-02-24 21:32:51  

Amazon AWS Service Tiers

Rick Golba

This blog post discusses the differences between the Amazon AWS service tiers. Many people want to move to an Amazon environment but are unsure what AWS service makes the most sense (EC2, RDS, Aurora). For database services, the tiering at Amazon

2016-11-11 20:33:04  

Is Your Query Cache Really Disabled?

Tibor Korocz

This blog post was motivated by an internal discussion about how to fully disable query cache in MySQL. According to the manual, we should be able to disable “Query Cache” on the fly by changing [crayon-5826fc934db02653340588-i/] to 0

2016-11-11 18:46:16  

Thoughts About Column Compression, with Optional Predefined Dictionary

Shahriyar Rzayev

This blog discusses column compression with an optional predefined dictionary. Compression, more compression with different algorithms, compress again, compress multiple times!

2016-11-10 23:05:33  

Database Daily Ops Series: GTID Replication

Wagner Bianchi

This post discusses ways of fixing broken GTID replication. This blog series is all about the daily stories we have in Managed Services, dealing with customers’ environments (mostly when we need to quickly restore a service level within the

2016-11-10 17:19:51  

Orchestrator and ProxySQL

Tibor Korocz

In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrat

2016-11-09 20:19:29  

Checking if a Slave Has Applied a Transaction from the Master

Marcelo Altmann

In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves. In summary, is a good practice to alleviate the load on the master by doing reads on slaves. It is acceptabl

2016-11-08 21:08:52  

Percona Live 2017 Call for Papers Extended Deadline: November 13th

Kortney Runyan

We’ve extended the Percona Live Open Source Database Conference 2017 call for papers deadline until November 13th! If you haven’t submitted already, please consider doing so. Speaking at Percona Live is a great way to build your personal an

2016-11-08 18:01:16  

Updating Percona XtraDB Cluster from 5.6.24-72.2 to 5.6.32-25.17

Wagner Bianchi

This blog describes how to upgrade Percona XtraDB Cluster in place from 5.6.24-72.2 to 5.6.32-25.17. This very hands-on blog is the result of some questions such as “can I perform an in-place upgrade for Percona XtraDB Cluster” coming in. We have

2016-11-07 19:35:20  

Changing the Tablespace Directory with pt-online-schema-change

Daniel Guzmán Burgos

In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’

2016-11-04 19:38:46  

Orchestrator: Moving VIPs During Failover

Tibor Korocz

In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator. In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in cas

2016-11-03 23:00:18  

中国古代文学 Global world news developer online documents developer online toolset Global E-commerce Global world images