From Fedora Project Wiki

Revision as of 08:27, 29 April 2013 by Kvolny (talk | contribs)

Fedora Test Days
Replace MySQL with MariaDB feature page

Date 2013-04-30
Time all day

Website QA/Fedora_19_test_days
IRC #fedora-test-day (webirc)
Mailing list test


In construction
The Test Day page is yet in construction. It will be ready for the Test Day - when this message is removed :) .
Can't make the date?
If you come to this page before or after the test day is completed, your testing is still valuable, and you can use the information on this page to test, file any bugs you find at Bugzilla, and add your results to the results section. If this page is more than a month old when you arrive here, please check the current schedule and see if a similar but more recent Test Day is planned or has already happened.

What to test?

Today's instalment of Fedora Test Day will focus on the F19 feature Replacing MySQL by MariaDB. The test cases will focus on functional compatibility, upgrading issues and data migration.

Who's available

The following cast of characters will be available testing, workarounds, bug fixes, and general discussion ...

Prerequisite for Test Day

  • Installed Fedora 18 or Fedora 19 Alpha with latest updates.
  • Recommended: Working MySQL deployment (mysql-server installed and configured) with testing data
  • Optionally: Any application that uses locally installed MySQL database as a backend (client may be on a different system)
Data backup
Make sure you have properly backed-up all data you could theoretically lost during the test. It doesn't usually happen, but you know the Murphy's law.

Backup data before testing

In case you are going to test MariaDB on a system with non-empty MySQL data, you should backup your data before.

Data Recovery from backup

In case something gets wrong, you can get back to backed-up data.

Test Cases

Provide a list of test areas or test cases that you'd like contributors to execute. For other examples, see Category:Test_Cases.

Upgrading from MySQL to MariaDB and data migration

In order to test MariaDB, you can either use already installed Fedora 18 or use Live CD images or properly installed version of upcoming Fedora 19. Depending on which way you choose you can perform one of the following test cases:

Functional compatibility testing

After you have successfully installed MariaDB on your system, you can test functionality using the following test cases:

The most relevant test would be using MariaDB on an application with real data. Therefore if you have any type of application that uses MySQL as a back-end, we'd like to encourage you to test this application with a copy of real data together with MariaDB database.

Test Results

If you have problems with any of the tests, report a bug to Red Hat Bugzilla usually for the component mariadb. If you are unsure about exactly how to file the report or what other information to include, just ask on IRC and we will help you. Once you have completed the tests, add your results to the Results table below, following the example results from the first line as a template. The first column should be your name with a link to your User page in the Wiki if you have one. For each test case, use the result template to enter your result, as shown in the example result line.

MariaDB upgrade

User Backup data Upgrade the packages Data Migration Data Migration References
Sample User
none
Pass pass
Warning warn
[1]
Fail fail
[2]
  1. Test pass, but also encountered RHBZ #54321
  2. RHBZ #12345