MySQL Test Framework (MTR) provides unit test suite for MySQL. Tests in the framework are written by MySQL Server developers and contributors and run to ensure build is working correctly.

I found this is not the only thing which can be done with MTR. I regularly use it in my Support job to help customers and verify bug reports.

With MySQL Test Framework I can:

• Create complicated environment in single step and re-use it later
• Test same scenario on dozens of MySQL/Percona/MariaDB server versions with single command
• Test concurrent scenarios
• Test errors and return codes
• Work with results, external commands, stored routines

Everything with single script which can be reused on any machine any time with any MySQL/Percona/MariaDB Server version.

In this session I will show my way of working with MySQL Test Framework and I hope you will love it as I do!