Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, March 2, 2016    Sveta Smirnova

In order to fix an issue, you must first understand it. The easiest way to understand and fix an issue is to repeat its occurrence, make assumptions, create some possible workarounds, then try to test them. Ideally this process occurs on the application development machine, then the fix is pushed live to the production environment.

In the database world, however, this process can fail – often because you need a real production environment with production-level data in your test environment to repeat the issue. Sometimes it isn’t feasible to create a test server with the same performance level and load as a production server.

In this webinar – the first in a series of "MySQL Troubleshooting” webinars – I will demonstrate how to create a test environment that imitates your production server sufficiently to perform valid tests.

We will discuss what to do if:

  • A production database is too large to be copied
  • A production database contains sensitive data
  • Your production server performs much better than one you can use for tests
  • You don't have a separate server to run tests

We will focus on what must be copied and which data or options can be modified without risking an invalid test.

After this webinar, you will be able create a test environment to troubleshoot your database without fear of missing key issues!

About the Author

Sveta Smirnova

Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.