EmergencyEMERGENCY? Get 24/7 Help Now!

MongoDB 3.4 Views

 | January 13, 2017 |  Posted In: Insight for DBAs, MongoDB

MariaDB ColumnStore

This blog post covers MongoDB 3.4 views, one of the more recent MongoDB features. Views are often used in relational databases to achieve both data security and a high level of abstraction, making it easier to retrieve data. Unlike regular tables, views neither have a physical schema nor use disk space. They execute a pre-specified […]

Read More

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More

CVE-2016-6225: Percona Xtrabackup Encryption IV Not Being Set Properly

and  | January 12, 2017 |  Posted In: MySQL, Security

CVE-2016-6225

If you are using Percona XtraBackup with xbcrypt to create encrypted backups, and are using versions older than 2.3.6 or 2.4.5, we advise that you upgrade Percona XtraBackup. Note: this does not affect encryption of encrypted InnoDB tables. CVE-2016-6225 Percona XtraBackup versions older than 2.3.6 or 2.4.5 suffered an issue of not properly setting the Initialization Vector (IV) for […]

Read More

The Percona Online Store: Get Database Help Now with Support and Health Audit Services

 | January 12, 2017 |  Posted In: MongoDB, MySQL, Percona Support

Percona Online Store

We are proud to announce the new Percona online store! Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly. With Percona, you can meet today’s workloads, […]

Read More

How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server

 | January 11, 2017 |  Posted In: Hardware and Storage, MySQL, Percona Server, Percona Software, Percona Toolkit, Percona XtraBackup

Replace MySQL with Percona Server

In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server. In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos replacing the MySQL package with MariaDB (for example, […]

Read More

Webinar Thursday, January 12: Percona Software News and Roadmap Update for Q1 2017

 | January 10, 2017 |  Posted In: MongoDB, MySQL, Percona Managed Services, Percona Monitoring and Management, Percona Monitoring Plugins, Percona Server, Percona Software, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars

Please join Percona CEO Peter Zaitsev for a webinar on Thursday, January 12, 2017 at 11 am PST/ 2 pm EST (UTC-8) for a discussion on the Percona Software News and Roadmap Update for Q1 2017. In this webinar, Peter will discuss what’s new in Percona open source software. This will include Percona Server for […]

Read More

MongoDB PIT Backups: Part 2

 | January 9, 2017 |  Posted In: Cloud and NoSQL, High-availability, MongoDB, open source databases, Solutions Engineering

MongoDB PIT Backups

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, we’ll look at the scale-out use case. When sharding, we have exactly […]

Read More

MySQL 8.0.1: The Next Development Milestone

 | January 9, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Quality Assurance

MySQL 8.0.1

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 own MySQL 8.0 early bugs review). There is plenty of excitement about the new features. As […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.