(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 ...") |
No edit summary |
||
Line 1: | Line 1: | ||
{{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> | ||
# 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
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
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
Going back to backed-up data if something gets wrong
In case something gets wrong, you can get back to backed-up data.
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'