EmergencyEMERGENCY? Get 24/7 Help Now!

Sixth Annual Percona Live Open Source Database Conference 2017 Call for Speakers Now Open

 | September 22, 2016 |  Posted In: MySQL

The Call for Speakers for Percona Live Open Source Database Conference 2017 is open and accepting proposals through Oct. 31, 2016. The Percona Live Open Source Database Conference 2017 is the premier event for the diverse and active open source community, as well as businesses that develop and use open source software. Topics for the […]

Read More

How X Plugin Works Under the Hood

 | September 16, 2016 |  Posted In: Insight for DBAs, MySQL

X Plugin

In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still […]

Read More

Consul, ProxySQL and MySQL HA

 | September 16, 2016 |  Posted In: MySQL

ProxySQL

When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load Balancing?” “Should I be deploying this proxy tool on my application servers or on a […]

Read More

pmp-check-pt-table-checksum Percona Monitoring Plugin

 | September 14, 2016 |  Posted In: MySQL

pmp-check-pt-table-checksum

Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost. pmp-check-pt-table-checksum alerts you when the pt-table-checksum tool from Percona Toolkit finds data drifts on a replication slave. pmp-checksum-pt-table-checksum monitors data differences on the slave from […]

Read More

Percona Monitoring and Management (PMM) is now available

 | September 13, 2016 |  Posted In: MongoDB, MySQL, Percona Monitoring and Management

Percona Monitoring and Management

Percona announces the availability of Percona Monitoring and Management (PMM), an open source software database monitoring and management tool. Completely open source and free to download and use, Percona Monitoring and Management provides point-in-time visibility and historical trending of database performance that enables DBAs and application developers to optimize the performance of their MySQL and […]

Read More

Is Your Database Affected by CVE-2016-6662?

 | September 12, 2016 |  Posted In: MySQL, Security

CVE-2016-6662

In this blog post, I will discuss the CVE-2016-6662 vulnerability, how to tell if it affects you, and how to prevent the vulnerability from affecting you if you have an older version of MySQL. I’ll also list which MySQL versions include the vulnerability fixes. As we announced in a previous post, there are certain scenarios in […]

Read More

Percona Live Europe featured talk with Ronald Bradford — Securing your MySQL/MariaDB data

 | September 12, 2016 |  Posted In: MySQL, Percona Live

Percona Live Europe featured talk

Welcome to another Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live Europe […]

Read More

Basic Housekeeping for MySQL Indexes

 | September 9, 2016 |  Posted In: Insight for DBAs, MySQL

MySQL Indexes

In this blog post, we’ll look at some of the basic housekeeping steps for MySQL indexes. We all know that indexes can be the difference between a high-performance database and a bad/slow/painful query ride. It’s a critical part that needs deserves some housekeeping once in a while. So, what should you check? In no particular order, […]

Read More

MySQL Replication Troubleshooting: Q & A

 | September 8, 2016 |  Posted In: MySQL, Technical Webinars

Solving Database Performance Issues

In this blog, I will provide answers to the Q & A for the MySQL Replication Troubleshooting webinar. First, I want to thank everybody for attending the August 25 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the […]

Read More

Percona’s widely read Percona Data 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.