EmergencyEMERGENCY? Get 24/7 Help 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

ProxySQL Admin Configuration

and  | January 25, 2017 |  Posted In: Percona Software, Percona XtraDB Cluster, ProxySQL

ProxySQL Admin

ProxySQL Admin (proxysql-admin) is a powerful tool for configuring Percona XtraDB Cluster nodes into ProxySQL. The proxysql-admin tool comes with the ProxySQL package from Percona apt/yum repositories. ProxySQL 1.3.2-1 is now available from the Percona repositories. This release is based on ProxySQL v1.3.2a and introduces the following new changes: proxysql-admin_v1.3.2a.md. Installing on Red Hat or CentOS […]

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.1

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

Percona Monitoring and Management (PMM) Information Script

 | November 1, 2016 |  Posted In: InnoDB, MongoDB, MySQL, Percona Monitoring and Management, Percona XtraDB Cluster

Percona Monitoring and Management

This blog post discusses an information script for the Percona Monitoring and Management (PMM) tool. In recent news, we announced the fresh-of-the-press Percona Monitoring and Management (or PMM for short) platform. Given the interaction of the different components that together make up PMM, I developed a script that helps provide you information about the status of your PMM installation. You can use this script yourself, or one of our […]

Read More

Regular Expressions Tutorial

 | September 21, 2016 |  Posted In: MySQL

regular expressions

This blog post highlights a video on how to use regular expressions. It’s been a while since I did the MySQL QA and Bash Training Series. The 13 episodes were quite enjoyable to make, and a lot of people watched the video’s and provided great feedback. In today’s new video, I’d like to briefly go over regular expressions. The session will cover […]

Read More

MySQL 8.0

 | July 5, 2016 |  Posted In: MySQL

MySQL 8.0.1

If you haven’t heard the news yet, MySQL 8.0 is apparently the next release of the world-famous database server. Obviously abandoning plans to name the next release 5.8, Percona Server’s upstream provider relabelled all 5.8-related bugs to 8.0 as follows: Reported version value updated to reflect release name change from 5.8 to 8.0 What will MySQL […]

Read More

MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

 | June 3, 2016 |  Posted In: MySQL

binary logs make MySQL 5.7 slower

Researching a performance issue, we came to a startling discovery: MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings. Test server MySQL versions used: i7, 8 threads, SSD, Centos 7.2.1511 mysql-5.6.30-linux-glibc2.5-x86_64 mysql-5.7.12-linux-glibc2.5-x86_64 mysqld –options: --no-defaults --log-bin=mysql-bin --server-id=2 Run details: Sysbench version 0.5, 4 threads, socket file connection […]

Read More

MySQL is crashing: a support engineer’s point of view

and  | August 17, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server for MySQL, Percona Software

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – […]

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