EmergencyEMERGENCY? Get 24/7 Help Now!

Business Continuity and MySQL Backups

 | December 2, 2016 |  Posted In: MySQL

MySQL Backups

This blog post discusses the business continuity plan around MySQL backups, and how organizations should think about them. During the years I’ve worked in IT, I’ve learned that backups sometimes are a conceptual subject in organizations. Many companies have them, but don’t document the associated business continuation plan for them. I experienced this the hard way many […]

Read More

Make MySQL 8.0 Better Through Better Benchmarking

 | December 2, 2016 |  Posted In: Benchmarks, MySQL

MySQL 8.0

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Read More

Managing Replication with Percona XtraDB Cluster

 | December 1, 2016 |  Posted In: GTID, High-availability, Percona XtraDB Cluster, Replication

Managing Replication

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read More

Database Daily Ops Series: GTID Replication and Binary Logs Purge

 | December 1, 2016 |  Posted In: GTID, MySQL, Percona Managed Services

GTID replication

This blog continues the ongoing series on daily operations and GTID replication. In this blog, I’m going to investigate why the error below has been appearing in a special environment I’ve been working with on the last few days:

The error provides the right message, and explains what is going on. But sometimes, it can be a […]

Read More

Galera Cache (gcache) is finally recoverable on restart

 | November 30, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

Gcache

This post describes how to recover Galera Cache (or gcache) on restart. Recently Codership introduced (with Galera 3.19) a very important and long awaited feature. Now users can recover Galera cache on restart. Need If you gracefully shutdown cluster nodes one after another, with some lag time between nodes, then the last node to shutdown holds […]

Read More

Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7

 | November 30, 2016 |  Posted In: MySQL

InnoBD Buffer Pool Pre-Load Feature

In this blog post, I’ll discuss how to use the InnoDB buffer pool pre-load feature in MySQL 5.7 Starting MySQL 5.6, you can configure MySQL to save the contents of your InnoDB buffer pool and load it on startup. Starting in MySQL 5.7, this is the default behavior. Without any special effort, MySQL saves and […]

Read More

Percona XtraBackup 2.4.5 is now available

 | November 29, 2016 |  Posted In: MySQL

Percona XtraBackup 2.4.5

Percona announces the GA release of Percona XtraBackup 2.4.5 on November 29th, 2016. You can download it 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 tolerate long periods of downtime. Offered […]

Read More

Percona XtraBackup 2.3.6 is now available

 | November 29, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona XtraBackup 2.4.5

Percona announces the release of Percona XtraBackup 2.3.6 on November 29, 2016. Downloads are available from our download site or Percona Software 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 tolerate long periods of downtime. Offered free as an open […]

Read More

Percona Server 5.7.16-10 is now available

 | November 28, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

percona server 5.7.16-10

Percona announces the GA release of Percona Server 5.7.16-10 on November 28, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.16, including all the bug fixes in it, Percona Server 5.7.16-10 is the current GA release in the Percona Server 5.7 series. Percona’s provides completely open-source and free […]

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.