EmergencyEMERGENCY? Get 24/7 Help Now!

Upgrading to Percona Server for MongoDB 3.4 from Previous Versions

 | March 15, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

MMAPv1

This post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we will walk through upgrading to Percona Server for MongoDB 3.4 from a previous MongoDB version. We will highlight the important details to guarantee the successful completion of this task in your environment. MongoDB 3.4 was just released, and […]

Read More

How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It

 | March 15, 2017 |  Posted In: InnoDB, Insight for DBAs, Percona XtraBackup, Quality Assurance

InnoDB

In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping the table. You can also see an earlier blog post about restoring a single table from a full backup here: How to recover a single InnoDB table from a full backup. The idea behind the actions […]

Read More

How to Change MongoDB Storage Engines Without Downtime

 | March 7, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

MongoDB Storage Engines

This blog is another in the series for the Percona Server for MongoDB 3.4 bundle release. Today’s blog post is about how to migrate between Percona Server for MongoDB storage engines without downtime. Today, the default storage engine for MongoDB is WiredTiger. In previous versions (before 3.2), it was MMAPv1. Percona Server for MongoDB features […]

Read More

Quest for Better Replication in MySQL: Galera vs. Group Replication

 | February 24, 2017 |  Posted In: Group Replication, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

Group Replication

UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed term “synchronous” (which the use of is inaccurate and misleading) to “virtually synchronous.” This term is more accurate and already used by both […]

Read More

Using NVMe Command Line Tools to Check NVMe Flash Health

 | February 9, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MongoDB, MySQL

NVME

In this blog post, I’ll look at the types of NVMe flash health information you can get from using the NVMe command line tools. Checking SATA-based drive health is easy. Whether it’s an SSD or older spinning drive, you can use the smartctl command to get a wealth of information about the device’s performance and health. […]

Read More

MySQL super_read_only Bugs

and  | February 8, 2017 |  Posted In: Insight for DBAs, MySQL, Replication

super_read_only

This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances. Background In MySQL 5.7.5 and onward introduced the gtid_executed table in the MySQL database to store every GTID. This allows slave instances to use the GTID feature regardless whether the binlog option is set or not. Here […]

Read More

WAN Synchronous Clusters: Dealing with Latency Using Concurrency

 | February 1, 2017 |  Posted In: Group Replication, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

WAN Latency

In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN deployments is having the primary site in one data center, and stand-by backup site in […]

Read More