by Roel Van de Paar | Apr 27, 2018 | Insight for DBAs, MySQL, Open Source
What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA?When it comes to being a software critic, a lot.In many ways, the work of a software critic is easy. We risk very little and thrive on... by Roel Van de Paar | Dec 12, 2017 | Insight for DBAs, MySQL, Percona Software
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... by Roel Van de Paar | Jan 25, 2017 | Percona Software, ProxySQL
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... by Roel Van de Paar | Jan 9, 2017 | Insight for DBAs, MySQL
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... by Roel Van de Paar | Nov 1, 2016 | MongoDB, MySQL, Percona Software
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... by Roel Van de Paar | Sep 28, 2016 | Insight for DBAs, Insight for Developers, MySQL
This blog post will look at seven bugs in MySQL 8.0.Friday afternoon is always ideal for a quick look at the early quality of MySQL 8.0! Last Friday, I did just that.If you haven’t heard the news yet, MySQL 8.0 DMR is available for download on... by Roel Van de Paar | Sep 21, 2016 | MySQL
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... by Roel Van de Paar | Jul 5, 2016 | MySQL
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... by Roel Van de Paar | Jun 3, 2016 | MySQL
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... by Roel Van de Paar | Aug 17, 2015 | Insight for DBAs, 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... by Roel Van de Paar | Aug 13, 2015 | Insight for DBAs, Insight for Developers, MySQL
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 &... by Roel Van de Paar | Aug 11, 2015 | Insight for DBAs, Insight for Developers, MySQL
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... by Roel Van de Paar | Aug 4, 2015 | Insight for DBAs, Insight for Developers, MySQL
Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode will be of interest to anyone who is or wants to work with Valgrind on a regular or semi-regular basis. Pro’s/Why Con’s... by Roel Van de Paar | Jul 31, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right.Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this episode... by Roel Van de Paar | Jul 28, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode 9. This episode will go more in-depth into reducer.sh: Reducing Testcases for Experts: multi-threaded reducer.shWe will explore how to use reducer.sh to do true multi-threaded testcase reduction – a world’s first.Topics:... by Roel Van de Paar | Jul 23, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh Advanced configurable variables & their default/vanilla reducer.sh settings FORCE_SKIPV FORCE_SPORADIC TIMEOUT_COMMAND & TIMEOUT_CHECK MULTI_THREADS MULTI_THREADS_INCREASE... by Roel Van de Paar | Jul 21, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh!In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default... by Roel Van de Paar | Jul 15, 2015 | Insight for DBAs, Insight for Developers, Percona Software
Welcome to MySQL QA Episode #6!Today we will look into analyzing and filtering our QA run. We’ll use tools like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh1. Quick re-cap and QA run setup 2. pquery-prep-red.sh 3. pquery-clean-known.sh 4.... by Roel Van de Paar | Jul 13, 2015 | Insight for DBAs, Insight for Developers, Percona Software
Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… and I’ll also trigger some actual bugs (fun guaranteed)! I’ll also introduce you to mtr_to_sql.sh and pquery-run.sh. pquery-run.sh (the... by Roel Van de Paar | Jul 8, 2015 | Insight for DBAs, Insight for Developers, Percona Software
Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & more.1. All about percona-qa 2. pquery Shell $ cd ~; bzr branch lp:percona-qa 1 $ cd ~; bzr branch lp:percona-qa 3. reducer.sh...