EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Bug 72804 Workaround: “BINLOG statement can no longer be used to apply query events”

 | February 16, 2017 |  Posted In: MySQL

MySQL Bug 72804

In this blog post, we’ll look at a workaround for MySQL bug 72804. Recently I worked on a ticket where a customer performed a point-in-time recovery PITR using a large set of binary logs. Normally we handle this by applying the last backup, then re-applying all binary logs created since the last backup. In the middle of the […]

Read More

Percona Blog Poll Results: What Programming Languages Are You Using for Backend Development?

 | February 16, 2017 |  Posted In: Database Poll, MySQL

Programming Languages

In this blog we’ll look at the results from Percona’s blog poll on what programming languages you’re using for backend development. Late last year we started a poll on what backend programming languages are being used by the open source community. The three components of the backend – server, application, and database – are what makes […]

Read More

MariaDB at Percona Live Open Source Database Conference 2017

 | February 16, 2017 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live

MariaDB at Percona Live

In this blog, we’ll look at how we plan to represent MariaDB at Percona Live. The MariaDB Corporation is organizing a conference called M17 on the East Coast in April. Some Perconians (Peter Zaitsev, Vadim Tkachenko, Sveta Smirnova, Alex Rubin, Colin Charles) decided to submit some interesting talks for that conference. Percona also offered to […]

Read More

Group Replication: Shipped Too Early

 | February 15, 2017 |  Posted In: Group Replication, High-availability, MySQL, Percona XtraDB Cluster

Group Replication

This blog post is my overview of Group Replication technology. With Oracle clearly entering the “open source high availability solutions” arena with the release of their brand new Group Replication solution, I believe it is time to review the quality of the first GA (production ready) release. TL;DR: Having examined the technology, it is my […]

Read More

Docker Images for Percona Server for MySQL Group Replication

 | February 15, 2017 |  Posted In: Group Replication, MySQL

Group Replication

In this blog post, we’ll point to a new Docker image for Percona Server for MySQL Group Replication. Our most recent release of Percona Server for MySQL (Percona Server for MySQL 5.7.17) comes with Group Replication plugins. Unfortunately, since this technology is very new, it requires some fairly complicated steps to setup and get running. To help […]

Read More

Percona Live Open Source Database Conference 2017 Crash Courses: MySQL and MongoDB!

 | February 14, 2017 |  Posted In: MongoDB, MySQL, Percona Live

MariaDB at Percona Live

The Percona Live Open Source Database Conference 2017 will once again host crash courses on MySQL and MongoDB. Read below to get an outstanding discount on either the MySQL or MongoDB crash course (or both). The database community constantly tells us how hard it is to find someone with MySQL and MongoDB DBA skills who can help with […]

Read More

Percona Server for MongoDB 3.4 Product Bundle Release is a Valentine to the Open Source Community

 | February 14, 2017 |  Posted In: Percona Monitoring and Management, Percona Server for MongoDB, Percona Toolkit

Percona Server for MongoDB 3.4

Percona today announced a Percona Server for MongoDB 3.4 solution bundle of updated products. This release enables any organization to create a robust, secure database environment that can be adapted to changing business requirements. Percona Server for MongoDB 3.4, Percona Monitoring and Management 1.1, and Percona Toolkit 3.0 offer more features and benefits, with enhancements for both MongoDB® and […]

Read More

ClickHouse: New Open Source Columnar Database

 | February 13, 2017 |  Posted In: Benchmarks

Clickhouse

For this blog post, I’ve decided to try ClickHouse: an open source column-oriented database management system developed by Yandex (it currently powers Yandex.Metrica, the world’s second-largest web analytics platform). In my previous set of posts, I tested Apache Spark for big data analysis and used Wikipedia page statistics as a data source. I’ve used the same data as […]

Read More

Using NVMe Command Line Tools to Check NVMe Flash Health

 | February 9, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MongoDB, MySQL

NVME

In this blog post, I’ll look at the types of NVMe flash health information you can get from using the NVMe command line tools. Checking SATA-based drive health is easy. Whether it’s an SSD or older spinning drive, you can use the smartctl command to get a wealth of information about the device’s performance and health. […]

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.