EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live Europe 2017 Sneak Peek Schedule Up Now! See Available Sessions!

 | August 3, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live

Percona Live Europe 2017

We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel. The theme of Percona Live Europe 2017 is Championing Open Source Databases, with sessions on MySQL, MariaDB, MongoDB and […]

Read More

What is MySQL Partitioning?

 | July 27, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 101

MySQL Partitioning

In this blog, we’ll quickly look at MySQL partitioning. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables, but still get treated as a single table by the SQL layer. When partitioning, it’s a good idea to find a natural partition key. You want […]

Read More

Multi-Threaded Slave Statistics

 | July 19, 2017 |  Posted In: Insight for DBAs, MySQL, Replication

Multi-Threaded Slave Statistics

In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file. MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it you need to modify the slave_parallel_workers variable to a value greater than 1. Recently, a […]

Read More

Percona Monitoring and Management 1.2.0 is Now Available

 | July 14, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management (PMM)

Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM Server 1.2.0 introduced the following changes: Updated Components Consul 0.8.5 Grafana 4.3.2 Orchestrator 2.1.5 Prometheus 1.7.1 New Features PMM-737: New graphs in System Overview dashboard: Memory Advanced Details Saturation Metrics PMM-1090: Added ESXi support […]

Read More

Gh-ost benchmark against pt-online-schema-change performance

 | July 12, 2017 |  Posted In: Benchmarks, Insight for DBAs, MySQL

gh-ost-benchmark

In this blog post, I will run a gh-ost benchmark against the performance of pt-online-schema-change. When gh-ost came out, I was very excited. As MySQL ROW replication became commonplace, you could use it to track changes instead of triggers. This practice is cleaner and safer compared to Percona Toolkit’s pt-online-schema-change. Since gh-ost doesn’t need triggers, I assumed it would […]

Read More

Webinar Wednesday July 12, 2017: MongoDB Index Types – How, When and Where Should They Be Used?

 | July 11, 2017 |  Posted In: Insight for DBAs, MongoDB, Technical Webinars

MongoDB Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents MongoDB Index Types: How, When and Where Should They Be Used? on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MongoDB has 12 index types. Do you know how each works, or when you should use each […]

Read More

Differences in PREPARE Statement Error Handling with Binary and Text Protocol (Percona XtraDB Cluster / Galera)

 | July 5, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

PREPARE Statement

In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire […]

Read More