[arch-dev-public] [announcement draft] MariaDB replaces MySQL in repositories
With `mysql 5.5.30-7` in [extra], all packages depending on it have been rebuilt against MariaDB counterparts. MariaDB is [almost](https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/) a drop-in replacement, but not automatic one. Users may need to manually install `mariadb`, `libmariadbclient` or `mariadb-clients` and execute `mysql_uprade` in order to migrate their systems. Additionally, there is another MySQL fork available in [community], `percona-server`, which should be closer to Oracle MySQL Enterprise in exchange for new features provided by MariaDB. More background information can be found on [mailing list](https://mailman.archlinux.org/pipermail/arch-dev-public/2013-February/024478...). MySQL will be dropped from repositories in a month. Migration example # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mariadb # mysql_upgrade -p -- Bartłomiej Piotrowski http://bpiotrowski.pl/
On 24 March 2013 18:50, Bartłomiej Piotrowski <b@bpiotrowski.pl> wrote:
With `mysql 5.5.30-7` in [extra], all packages depending on it have been rebuilt against MariaDB counterparts. MariaDB is [almost](https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/) a drop-in replacement, but not automatic one. Users may need to manually install `mariadb`, `libmariadbclient` or `mariadb-clients` and execute `mysql_uprade` in order to migrate their systems. Additionally, there is another MySQL fork available in [community], `percona-server`, which should be closer to Oracle MySQL Enterprise in exchange for new features provided by MariaDB.
More background information can be found on [mailing list](https://mailman.archlinux.org/pipermail/arch-dev-public/2013-February/024478...). MySQL will be dropped from repositories in a month.
Migration example # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mariadb # mysql_upgrade -p
-- Bartłomiej Piotrowski http://bpiotrowski.pl/
Looks good to me, aside from the "systemctl start" line which should be using "mysqld" as the service name.
On 2013-03-24 18:29, Evangelos Foutras wrote:
Looks good to me, aside from the "systemctl start" line which should be using "mysqld" as the service name.
Right, sorry for such a brainless mistake. -- Bartłomiej Piotrowski http://bpiotrowski.pl/
On Sun, Mar 24, 2013 at 5:50 PM, Bartłomiej Piotrowski <b@bpiotrowski.pl> wrote:
With `mysql 5.5.30-7` in [extra], all packages depending on it have been rebuilt against MariaDB counterparts. MariaDB is [almost](https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/) a drop-in replacement, but not automatic one. Users may need to manually install `mariadb`, `libmariadbclient` or `mariadb-clients` and execute `mysql_uprade` in order to migrate their systems. Additionally, there is another MySQL fork available in [community], `percona-server`, which should be closer to Oracle MySQL Enterprise in exchange for new features provided by MariaDB.
More background information can be found on [mailing list](https://mailman.archlinux.org/pipermail/arch-dev-public/2013-February/024478...). MySQL will be dropped from repositories in a month.
Migration example # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mariadb # mysql_upgrade -p
-- Bartłomiej Piotrowski http://bpiotrowski.pl/
MariaDB is now officially our default implementation of MySQL. MariaDB is [almost](https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/) a drop in replacement, so an upgrade should be possible with minimum hassle. However, due to remaining compatibility concerns, an automatic replace is not done. It is recommended for all users to upgrade. MySQL will be dropped from the repositories to the AUR in a month. Users who want to switch will need to install `mariadb`, `libmariadbclient` or `mariadb-clients` and execute `mysql_upgrade` in order to migrate their systems. Migration example: # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mysqld # mysql_upgrade -p `percona-server` is another MySQL fork available in [community]. It should be closer to Oracle MySQL Enterprise, but is missing the new features included in MariaDB. Together with `mysql 5.5.30-7` in [extra], all packages depending on it have been rebuilt against their MariaDB counterparts. Other package maintainers should move their dependencies to the MariaDB packages. More information can be found on our [mailing list](https://mailman.archlinux.org/pipermail/arch-dev-public/2013-February/024478...).
Am 24.03.2013 17:50, schrieb Bartłomiej Piotrowski:
Migration example # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mariadb # mysql_upgrade -p
I will be affected here, so I'll better ask this time: Is it really that simple? If a PHP application uses mysql/mysqli, will it "just work" with mariadb? Any problems I may encounter?
Am 25.03.2013 10:56, schrieb Thomas Bächler:
Am 24.03.2013 17:50, schrieb Bartłomiej Piotrowski:
Migration example # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mariadb # mysql_upgrade -p
I will be affected here, so I'll better ask this time:
Is it really that simple? If a PHP application uses mysql/mysqli, will it "just work" with mariadb? Any problems I may encounter?
I did a lot of tests regarding PHP and so far everything just works fine; I switched archlinux.de to mariadb 17 days ago. Recent PHP version don't even use the mysql client libraries, but their own implementation mysqlnd. -- Pierre Schmitz, https://pierre-schmitz.com
The latest draft by Jan Alexander Steffens looks good to me. - Alexander
participants (6)
-
Alexander Rødseth
-
Bartłomiej Piotrowski
-
Evangelos Foutras
-
Jan Alexander Steffens
-
Pierre Schmitz
-
Thomas Bächler