Test Day:2013-04-30 MariaDB

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

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 ...

• Development - Honza Horák (hhorak)
• Quality Assurance - Karel Volný (kvolny), Martin Holec (Martix)

Prerequisite for Test Day

• Installed Fedora 18 or Fedora 19 Alpha with latest updates.

Optionally, you may download a non-destructive live image for your architecture. Tips on using a live image are available at FedoraLiveCD.

Architecture	SHA256SUM
x86_64	9ceb6f18341954c98a8c5e5b2994858adc0df70df3d3a3ddd96b6b4a7ac886ea
i686	28842e78c07e0f0cfc7d82f1d9daae98238fdaa57869fc29defec54830f99f2b

• Recommended: It is better to have own working MySQL deployment (mysql-server installed and configured) with own testing data
• Optionally: Even better would be to have any application that uses locally installed MySQL database as a backend (client-side 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.

• How to backup data in MySQL/MariaDB

Data Recovery from backup

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

• How to restore data in MySQL/MariaDB

Data migration

In case you need to migrate data from one database instance to another (which can be even of another version, but keep in mind that only 5.0->5.1->5.5 upgrade paths are actually supported), you need to:

• backup data on source instance
• restore data on destination instance
• run mysql_upgrade on destination instance

No data upgrade needed if replacing the same version
When migrating between instances of the same minor version (e.g. from mysql-5.5.x to mariadb-5.5.x) we don't have to do run mysql_upgrade.

Test Cases

The following test cases focus on testing potential upgrading issues on the one hand and on functionality issues on the other hand.

Upgrading from MySQL to MariaDB and data migration

In order to test MariaDB, you can either use already installed Fedora 18, Fedora 19 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:

• Upgrading from MySQL to MariaDB in F18 using a testing repository created for the Test day
• Going back from MariaDB to MySQL in F18
• Installing MariaDB in Fedora 19

Updating perl-DBD-MySQL from testing repository
When you are using current Fedora 19 stable repository, you should install perl-DBD-MySQL package from the testing repository (available here), because the previous build (currently in Fedora 19 stable repository) included wrong dependencies. It has been fixed, but the new build has not got to stable repository yet.

Functional compatibility testing

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

• Testing akonadi package
• Testing amarok package
• Testing phpMyAdmin package
• Testing gammu package
• Testing WordPress package
• Testing ReviewBoard package
• Testing MariaDB in libreoffice-base package
• Your own application or other packages like gallery3, drupal, ...

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 testing

User	Data backup	Data restore	Upgrading in F18	Installing in F19	References
Sample User	none	pass	warn	fail
Martin Krizek	none	none	none	pass

MariaDB functionality testing

User	akonadi	amarok	phpMyAdmin	WordPress	ReviewBoard	libreoffice-base	Your own application	References
Sample User	none	pass	warn	fail	none	pass	pass