Buy Percona ServicesBuy Now!

Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate

 | December 12, 2017 |  Posted In: MySQL, MySQL 8.0, Percona Server for MySQL, Quality Assurance

MySQL 8.0.3 Release Candidate

Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC. On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate. I tested the MySQL 8.0.3 Release Candidate branch with selected Percona bugfixes applied and built […]

Read More

autoxtrabackup v1.5.0: A Tool for Automatic Backups

 | November 27, 2017 |  Posted In: Backups, Percona XtraBackup, Quality Assurance

autoxtrabackup

There is a new version of the autoxtrabackup tool. In this post, I’ll provide some of the highlights available this time around. autoxtrabackup is a tool created by PerconLabs. We’ve now put out the 1.5.0 version, and you can test it further. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and […]

Read More

How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It

 | March 15, 2017 |  Posted In: InnoDB, Insight for DBAs, Percona XtraBackup, Quality Assurance

InnoDB

In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping the table. You can also see an earlier blog post about restoring a single table from a full backup here: How to recover a single InnoDB table from a full backup. The idea behind the actions […]

Read More

Improving TokuDB Hot Backup Usage with the autotokubackup Command Line Tool

 | March 6, 2017 |  Posted In: Percona Server for MySQL, Quality Assurance, TokuDB

autotokubackup

In this blog post, we’ll look at how the command line tool autotokubackup can make TokuDB hot backups easier. I would like to share an experimental tool named autotokubackup, for TokuBackup. This tool is aimed at helping simplify the life of TokuDB system administrators. autotokubackup is written in the Python language. General information: If you need more information […]

Read More

MySQL 8.0.1: The Next Development Milestone

 | January 9, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Quality Assurance

MySQL 8.0 innodb_dedicated_server

This post discusses the next MySQL development milestone: MySQL 8.0.1. From the outset, MySQL 8.0 has received plenty of attention. Both this blog (see the MySQL 8.0 search) and other sites around the Internet have covered it. Early reviews seem positive (including my own MySQL 8.0 early bugs review). There is plenty of excitement about the new features. As […]

Read More

Thoughts About Column Compression, with Optional Predefined Dictionary

 | November 10, 2016 |  Posted In: InnoDB, Quality Assurance

column compression

This blog discusses column compression with an optional predefined dictionary. Compression, more compression with different algorithms, compress again, compress multiple times! 🙂 Compression is a hot topic in our lives. In general, testing new things is great if the processes are well-described and easy to follow. Let’s try to think like a QA engineer: the first […]

Read More

MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)

 | August 13, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL Quality Assurance

Welcome to the final – but most important – episode in the MySQL QA Series. In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide. Episode 13: A Better Approach to all MySQL Regression, Stress & Feature Testing: Random Coverage Testing & SQL Interleaving 1. pquery Review 2. Random […]

Read More

MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash

 | August 11, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

My server is crashing… Now what? This special episode in the MySQL QA Series is for customers or users experiencing a crash. A crash? Cheat sheet: https://goo.gl/rrmB9i Sever install & crash. Note this is as a demonstration: do not action this on a production server! sudo yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm sudo yum install -y Percona-Server-client-56 Percona-Server-server-56 sudo service […]

Read More