From Fedora Project Wiki

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 9: Line 9:
| fedora_mailing_list = test
| fedora_mailing_list = test
}}
}}
{{admon/warning | In construction | The Test Day page is yet in construction. It will be ready for the Test Day - when this message is removed :) .}}


{{admon/note | 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 [http://bugzilla.redhat.com 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 [[QA/Test_Days|current schedule]] and see if a similar but more recent Test Day is planned or has already happened.}}
{{admon/note | 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 [http://bugzilla.redhat.com 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 [[QA/Test_Days|current schedule]] and see if a similar but more recent Test Day is planned or has already happened.}}
Line 20: Line 22:
The following cast of characters will be available testing, workarounds, bug fixes, and general discussion ...
The following cast of characters will be available testing, workarounds, bug fixes, and general discussion ...
* Development - [[User:hhorak|Honza Horák]] (hhorak)
* Development - [[User:hhorak|Honza Horák]] (hhorak)
* Quality Assurance - [http://admin.fedoraproject.org/accounts/user/view/kvolny Karel Volný] (kvolny), [[User:Martix|Martin Holec]] (Martix)
* Quality Assurance - [[User:Martix|Martin Holec]] (Martix), [http://admin.fedoraproject.org/accounts/user/view/kvolny Karel Volný] (kvolny)


== Prerequisite for Test Day ==  
== Prerequisite for Test Day ==  


* Installed [http://fedoraproject.org/en/get-fedora Fedora 18] or [http://fedoraproject.org/get-prerelease Fedora 19 Alpha] with latest updates.
* Installed [http://fedoraproject.org/en/get-fedora Fedora 18] or [http://fedoraproject.org/get-prerelease 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]].
* 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)  
! Architecture !! SHA256SUM
|-
| [http://fedorapeople.org/groups/qa/testday-20130430-x86_64.iso x86_64] || 9ceb6f18341954c98a8c5e5b2994858adc0df70df3d3a3ddd96b6b4a7ac886ea
|-
| [http://fedorapeople.org/groups/qa/testday-20130430-i686.iso 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)  


{{admon/important|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.}}
{{admon/important|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.}}
Line 50: Line 43:


* [[QA:How_to_restore_data_in_MySQL_or_MariaDB|How to restore data in MySQL/MariaDB]]
* [[QA:How_to_restore_data_in_MySQL_or_MariaDB|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:
* [[QA:Testcase_MySQL_MariaDB_Backup_data|backup data on source instance]]
* [[QA:How_to_restore_data_in_MySQL_or_MariaDB|restore data on destination instance]]
* run <code>mysql_upgrade</code> on destination instance
{{admon/note|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 ==
== Test Cases ==


The following test cases focus on testing potential upgrading issues on the one hand and on functionality issues on the other hand.
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 ===
=== 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:
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:


* [[QA:Testcase_Upgrading_from_MySQL_to_MariaDB_in_f18|Upgrading from MySQL to MariaDB in F18]] using a testing repository created for the Test day
* [[QA:Testcase_Upgrading_from_MySQL_to_MariaDB_in_f18|Upgrading from MySQL to MariaDB in F18]] using a testing repository created for the Test day
* [[QA:Testcase_Going_back_from_MariaDB_to_MySQL_in_f18|Going back from MariaDB to MySQL in F18]]
* [[QA:Testcase_Installing_MariaDB_in_f19|Installing MariaDB in Fedora 19]]
* [[QA:Testcase_Installing_MariaDB_in_f19|Installing MariaDB in Fedora 19]]
{{admon/warning|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 ([https://admin.fedoraproject.org/updates/FEDORA-2013-6896/perl-DBD-MySQL-4.023-2.fc19 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 ===
=== Functional compatibility testing ===
Line 84: Line 64:
* [[QA:Testcase_MySQL_or_MariaDB_in_gammu|Testing gammu package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_gammu|Testing gammu package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_WordPress|Testing WordPress package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_WordPress|Testing WordPress package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_drupal7|Testing drupal7 package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_phpBB|Testing phpBB package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_gallery|Testing gallery package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_ReviewBoard|Testing ReviewBoard package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_ReviewBoard|Testing ReviewBoard package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_libreoffice-base|Testing MariaDB in libreoffice-base package]]
* [[QA:Testcase_MySQL_or_MariaDB_in_libreoffice-base|Testing MariaDB in libreoffice-base package]]
* Your own application or other packages like gallery3, drupal, ...
* Your own application...


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.
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.
Line 94: Line 77:
If you have problems with any of the tests, report a bug to [https://bugzilla.redhat.com Red Hat Bugzilla] usually for the component [https://bugzilla.redhat.com/enter_bug.cgi?product=Fedora&version=18&component=mariadb 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 [[Template:result|result template]] to enter your result, as shown in the example result line.
If you have problems with any of the tests, report a bug to [https://bugzilla.redhat.com Red Hat Bugzilla] usually for the component [https://bugzilla.redhat.com/enter_bug.cgi?product=Fedora&version=18&component=mariadb 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 [[Template:result|result template]] to enter your result, as shown in the example result line.


=== MariaDB upgrade testing ===
=== MariaDB upgrade ===
{|
! User
! [[QA:Testcase_MySQL_MariaDB_Backup_data|Data backup]]
! [[QA:How_to_restore_data_in_MySQL_or_MariaDB|Data restore]]
! [[QA:Testcase_Upgrading_from_MySQL_to_MariaDB_in_f18|Upgrading in F18]]
! [[QA:Testcase_Installing_MariaDB_in_f19|Installing in F19]]
! References
|-
| [[User:SampleUser|Sample User]]
| {{result|none}}
| {{result|pass}}
| {{result|warn}} <ref>Test pass, but also encountered {{bz|54321}}</ref>
| {{result|fail}} <ref>{{bz|12345}}</ref>
| <references/>
|-
| [[User:mkrizek|Martin Krizek]]
| {{result|none}}
| {{result|none}}
| {{result|none}}
| {{result|pass}}
| <references/>
|-
|}
 
=== MariaDB functionality testing ===
{|
{|
! User
! User
! [[QA:Testcase_MySQL_or_MariaDB_in_akonadi|akonadi]]
! [[QA:Testcase_MySQL_Backup_data|Backup data]]
! [[QA:Testcase_MySQL_or_MariaDB_in_amarok|amarok]]
! [[QA:Testcase_MySQL_MariaDB_upgrade|Upgrade the packages]]
! [[QA:Testcase_MySQL_or_MariaDB_in_phpMyAdmin|phpMyAdmin]]
! [[QA:Testcase_MySQL_Migrate_data|Data Migration]]
! [[QA:Testcase_MySQL_or_MariaDB_in_WordPress|WordPress]]
! [[QA:Testcase_MySQL_Migrate_data|Data Migration]]
! [[QA:Testcase_MySQL_or_MariaDB_in_ReviewBoard|ReviewBoard]]
! [[QA:Testcase_MySQL_or_MariaDB_in_libreoffice-base|libreoffice-base]]
! Your own application
! References
! References
|-
|-
Line 136: Line 91:
| {{result|warn}} <ref>Test pass, but also encountered {{bz|54321}}</ref>
| {{result|warn}} <ref>Test pass, but also encountered {{bz|54321}}</ref>
| {{result|fail}} <ref>{{bz|12345}}</ref>
| {{result|fail}} <ref>{{bz|12345}}</ref>
| {{result|none}}
| {{result|pass}}
| {{result|pass}}
| <references/>
| <references/>
|-
|-
|}
|}


[[Category:Fedora 19 Test Days|m]]
[[Category:Test Days]]
[[Category:QA Templates]]
Please note that all contributions to Fedora Project Wiki are considered to be released under the Attribution-Share Alike 4.0 International (see Fedora Project Wiki:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To edit this page, please solve the following task below and enter the answer in the box (more info):

Cancel Editing help (opens in new window)