QA:Testcase Upgrading from MySQL to MariaDB in f18

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
(Created page with "For upgrade from MySQL to MariaDB that are of the same minor version (e.g. from mysql-5.5.x to mariadb-5.5.x) we don't have to do upgrade data. However, before upgrading from ...")
 
 
Line 1: Line 1:
For upgrade from MySQL to MariaDB that are of the same minor version (e.g. from mysql-5.5.x to mariadb-5.5.x) we don't have to do upgrade data. However, before upgrading from MySQL to MariaDB, we recommend to
+
{{admon/note|No data upgrade needed if replacing the same version|When replacing MySQL with MariaDB that are of the same minor version (e.g. from mysql-5.5.x to mariadb-5.5.x) we don't have to do upgrade data.}}
[[QA:Testcase_MySQL_MariaDB_Backup_data|backup important data]] for the case something gets wrong.
+
 
 +
{{admon/important|Data backup|Before upgrading from MySQL to MariaDB, we recommend to [[QA:Testcase_MySQL_MariaDB_Backup_data|backup important data]] for the case something gets wrong.}}
  
 
== Testing Yum repository for Fedora 18 ==
 
== Testing Yum repository for Fedora 18 ==
Line 8: Line 9:
  
 
<pre>
 
<pre>
rootshell> wget -o /etc/yum.repos.d/mariadb-testday.repo \
+
# wget -o /etc/yum.repos.d/mariadb-testday.repo http://hhorak.fedorapeople.org/mariadb-testday/mariadb-testday.repo
http://hhorak.fedorapeople.org/mariadb-testday/mariadb-testday.repo
+
</pre>
 +
 
 +
{{admon/important | Testing repository disabled by default | This testing repository is disabled by default, which means it won't be used unless explicitly enabled by --enablerepo Yum argument.}}
 +
 
 +
== Proceeding the upgrade (replace MySQL packages by MariaDB packages) ==
 +
 
 +
Except <code>--enablerepo=mariadb-testday</code> we also use <code>--disablerepo=*</code> in order to not update other packages during test. You can let this argument out if you want update all packages.
 +
 
 +
The replacement of already installed MySQL packages with MariaDB alternative will be proceeded as follows:
 +
 
 +
<pre>
 +
yum update --disablerepo=* --enablerepo=mariadb-testday
 +
</pre>
 +
 
 +
For installing MariaDB server package use:
 +
 
 +
<pre>
 +
yum install --disablerepo=* --enablerepo=mariadb-testday mariadb-server
 
</pre>
 
</pre>
  
Line 17: Line 35:
  
 
* [[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]]
 +
 +
 +
== Expected results ==
 +
 +
Now you should have installed only MariaDB packages, while all MySQL packages should have been removed. You can check that using:
 +
 +
<code>
 +
$ rpm -qa | grep -e '^mysql' -e '^mariadb'
 +
</code>

Latest revision as of 07:53, 22 April 2013

Note.png
No data upgrade needed if replacing the same version
When replacing MySQL with MariaDB that are of the same minor version (e.g. from mysql-5.5.x to mariadb-5.5.x) we don't have to do upgrade data.
Important.png
Data backup
Before upgrading from MySQL to MariaDB, we recommend to backup important data for the case something gets wrong.

Contents

[edit] Testing Yum repository for Fedora 18

We've prepared a testing Yum repository with RPMs for Fedora 18, which correspond with packages that are being prepared for Fedora 19. The repository is located in http://hhorak.fedorapeople.org/mariadb-testday/mariadb-testday.repo and to use it, just copy it to /etc/yum.repos.d/.

# wget -o /etc/yum.repos.d/mariadb-testday.repo http://hhorak.fedorapeople.org/mariadb-testday/mariadb-testday.repo
Important.png
Testing repository disabled by default
This testing repository is disabled by default, which means it won't be used unless explicitly enabled by --enablerepo Yum argument.

[edit] Proceeding the upgrade (replace MySQL packages by MariaDB packages)

Except --enablerepo=mariadb-testday we also use --disablerepo=* in order to not update other packages during test. You can let this argument out if you want update all packages.

The replacement of already installed MySQL packages with MariaDB alternative will be proceeded as follows:

yum update --disablerepo=* --enablerepo=mariadb-testday

For installing MariaDB server package use:

yum install --disablerepo=* --enablerepo=mariadb-testday mariadb-server

[edit] Going back to backed-up data if something gets wrong

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


[edit] Expected results

Now you should have installed only MariaDB packages, while all MySQL packages should have been removed. You can check that using:

$ rpm -qa | grep -e '^mysql' -e '^mariadb'