by Pablo Padua | Jan 10, 2017 | Insight for DBAs, MySQL
In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7. Up to version 5.7, MySQL had a limitation that made it impossible to directly exchange partitions between partitioned tables. Now and then, we...
by Jon Tobin | Jan 9, 2017 | Cloud, Insight for DBAs, MongoDB, Open Source
This blog post is the second in a series covering MongoDB PIT backups. You can find the first part here. Sharding Makes Everything Fun(ner) The first blog post in this series looked at MongoDB backups in a simple single-replica set environment. In this post,...
by Roel Van de Paar | Jan 9, 2017 | Insight for DBAs, MySQL
This post discusses the next MySQL development milestone: MySQL 8.0.1. From the outset, MySQL 8.0 has received plenty of attention. Both this blog (see the MySQL 8.0 search) and other sites around the Internet have covered it. Early reviews seem positive (including my...
by Rick Golba | Jan 6, 2017 | Insight for DBAs, MongoDB, MySQL
This post discusses archiving MySQL and MongoDB data and determining what, when and how to archive data. Many people store infrequently used data. This data is taking up storage space and might make your database slower than it could be. Archiving data can be a huge...
by Anastasia Raspopina | Jan 6, 2017 | Benchmarks, MySQL, Open Source, Percona Live, PostgreSQL
This blog compares how PostgreSQL and MySQL handle millions of queries per second. Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer “yes.” However, assertions aren’t enough for...
by David Murphy | Jan 5, 2017 | MongoDB, Security
In this blog post, we’ll look at some of the concerns recently seen around MongoDB ransomware and security issues. Security blogs and magazines have recently been aflutter with the news that a hacker is stealing data from MongoDB instantiations and demanding...
by Tim Vaillancourt | Jan 4, 2017 | MongoDB
In this blog post, we will discuss some of the Sharding improvements in the recent MongoDB 3.4 GA release. Sharding? Let’s go over what MongoDB Sharding “is” at a simplified, high level. The concept of “sharding” exists to allow MongoDB...
by Daniel Guzmán Burgos | Jan 3, 2017 | Insight for DBAs, MySQL
This post discusses enabling and disabling jemalloc on Percona Server for MySQL. The benefits of jemalloc versus glibc for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) you have less memory fragmentation, and...
