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 Coverage Testing
3. SQL Interleaving
4. The past & the future
Presented by Roel Van de Paar. Full-screen viewing @ 720p resolution recommended
Interested in the full MySQL QA Full Series?
All, please note we have moved percona-qa to GitHub:
https://github.com/Percona-QA/percona-qa
To clone it, use:
$ sudo yum install git
$ cd ~
$ git clone https://github.com/Percona-QA/percona-qa.git
reducer.sh was also put directly into this repository (and it is maintained there), so *no* need anymore to separately fetch lp:randgen.
One of my colleagues made a good comment that this testing does not cover certain bug classes like replication and query correctness (and likely others). Query correctness testing however has been fully integrated into the pquery framework over the last 1.5 years. As for replication, extensive master/slave setup & use would be a good future extension. We also added a quality SQL generator which expands the testing SQL further.