EmergencyEMERGENCY? Get 24/7 Help Now!

Better Than Linear Scaling

 | April 22, 2017 |  Posted In: Hardware and Storage, High-availability, Insight for DBAs, Insight for Developers, MySQL

Scalability

In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system scalable if it is capable of increasing its total output under […]

Read More

How to Setup and Troubleshoot Percona PAM with LDAP for External Authentication

 | April 21, 2017 |  Posted In: Insight for DBAs, MySQL, Security

Percona Server for MySQL 5.7.18-15

In this blog, we’ll look at how to setup and troubleshoot the Percona PAM authentication plugin. We occasionally get requests from our support clients on how to get Percona Server for MySQL to authenticate with an external authentication service via LDAP or Active Directory. However, we normally do not have access to client’s infrastructure to […]

Read More

The mysqlpump Utility

 | April 17, 2017 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

mysqlpump

In this blog, we’ll look at the mysqlpump utility. mysqlpump is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump a database or a set of databases to a file and […]

Read More

Correct Index Choices for Equality + LIKE Query Optimization

 | April 11, 2017 |  Posted In: Insight for DBAs, MySQL

Query Optimization

As part of our support services, we do a lot of query optimization. This is where most performance gains come from. Here’s an example of the work we do. Some days ago a customer arrived with the following table:

And a query that looked like this:

The table had an index t_msg that wasn’t […]

Read More

Non-Deterministic Order for SELECT with LIMIT

 | April 7, 2017 |  Posted In: Insight for DBAs, MySQL

Non-Deterministic Order

In this blog, we’ll look at how queries in systems with parallel processing can return rows in a non-deterministic order (and how to fix it). Short story: Do not rely on the order of your rows if your query does not use ORDER BY. Even with ORDER BY, rows with the same values can be sorted differently. To fix this […]

Read More

Dealing with MySQL Error Code 1215: “Cannot add foreign key constraint”

 | April 6, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

MySQL error code 1215

In this blog, we’ll look at how to resolve MySQL error code 1215: “Cannot add foreign key constraint”. Our Support customers often come to us with things like “My database deployment fails with error 1215”, “Am trying to create a foreign key and can’t get it working” or “Why am I unable to create a […]

Read More

New MariaDB Dashboard in Percona Monitoring and Management Metrics Monitor

 | April 3, 2017 |  Posted In: Events and Announcements, InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Monitoring and Management, Percona Server, Percona Software, PMM

MariaDB

In honor of the upcoming MariaDB M17 conference in New York City on April 11-12, we have enhanced Percona Monitoring and Management (PMM) Metrics Monitor with a new MariaDB Dashboard and multiple new graphs! The Percona Monitoring and Management MariaDB Dashboard builds on the efforts of the MariaDB development team to instrument the Aria Storage Engine Status Variables related […]

Read More

Performance Evaluation of SST Data Transfer: With Encryption (Part 2)

 | March 30, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

SST Data Transfer

In this blog post, we’ll look at the performance of SST data transfer using encryption. In my previous post, we reviewed SST data transfer in an unsecured environment. Now let’s take a closer look at a setup with encrypted network connections between the donor and joiner nodes. The base setup is the same as the previous […]

Read More