Monthly Archives - February 2016

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

EXPLAIN FORMAT=JSON

Once again it’s time for another EXPLAIN FORMAT=JSON is cool! post. This post will discuss how EXPLAIN FORMAT=JSON allows the nested_loop command to make the JOIN operation hierarchy transparent.
The regular
EXPLAIN  command lists each table that participates in a 
JOIN  operation on a single row. This works perfectly for simple queries:

MySQL

mysql> explain select * from […]

Read more

Graphing MySQL performance with Prometheus and Grafana

 
This post explains how you can quickly start using such trending tools as Prometheus and Grafana for monitoring and graphing of MySQL and system performance.
Update, February 20, 2017: Since this blog post was published, we have released Percona Monitoring and Management (PMM), which is the easiest way to monitor MySQL and MongoDB using Grafana and […]

Read more

Monitoring MongoDB Response Time

In this blog post, we’ll discuss how using Prometheus can help with monitoring MongoDB response time. I am currently comparing the performance of different storage engines on Percona Server for MongoDB, using a slightly customized version of Tim Callaghan’s sysbench-mongodb. Since I’m interested in measuring response time for database operations, I created a very simple exporter of response […]

Read more

Percona Back to Basics: MongoDB updates

Welcome to the first in a new series of MongoDB blogs. These blogs will cover a selection of topics, including:

How-tos
New release and new features
Getting back to the basics
Solutions from the field

In this first blog, we’ll discuss MongoDB updates. You can use the update method to update documents in a collection. MongoDB updates are well-covered […]

Read more

High availability with asynchronous replication… and transparent R/W split

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.
When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ?
Description:

Three MySQL servers, […]

Read more

Percona Live featured talk with Kat Styons – Shifting the Paradigm: MongoDB and the MEAN Stack

Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special […]

Read more

MySQL connection using SSL… or not ?

MySQL connection using SSL

In this blog post, we’ll discuss how we can determine if a MySQL connection is using SSL.
Since MySQL 5.7.5 the server generates SSL certificates (see auto_generate_certs) by default if compiled with SSL, or uses mysql_ssl_rsa_setup if compiled with YaSSL.
But how can we check to see if our MySQL client connection uses SSL ?
When using an interactive client, […]

Read more

Percona Server 5.7.10-3 GA is now available

Percona Server

Percona is glad to announce the first GA release of Percona Server 5.7.10-3 on February 23, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.
Based on MySQL 5.7.10, including all the bug fixes in it, Percona Server 5.7.10-3 is the current GA release in the Percona Server 5.7 series. All […]

Read more

Percona XtraBackup 2.4.1 GA is now available

Percona XtraBackup

Percona is glad to announce the first GA release of Percona XtraBackup 2.4.1 on February 23rd 2016. Downloads are available from our download site and from apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot […]

Read more