New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Arch Linux replaces MySQL with MariaDB by default
Just got this message from the arch announce mailing list:
Bartłomiej Piotrowski wrote:
MariaDB is now officially our default implementation of MySQL. MariaDB is
[almost][1] 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][2].
[1]: https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/
[2]: https://mailman.archlinux.org/pipermail/arch-dev-
public/2013-February/024478.html
URL: https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/
_______________________________________________
arch-announce mailing list
[email protected]
https://mailman.archlinux.org/mailman/listinfo/arch-announce
Does anybody successfully run MariaDB as a MySQL replacement? I do have experience with the Percona MySQL builds, but not with MariaDB...
Comments
Dang it, like I said, MariaDB is getting tons of love lately
it is much more refined and better supported as of late.
@Raymii, it usually goes smoothly if you don't use the listed incompatible options
well it seems Wikipedia is moving to MariaDB
source: http://www.zdnet.com/wikipedia-moving-from-mysql-to-mariadb-7000008912/
With the Debian versions MariaDB 5.5 uses more memory than MySql & Percona, to be used with caution on a low end box.
I wonder about performance improvements over plain mysql
@djvdorp One of my databases i migrated went from 800qps on mysql to 900qps on mariadb with a lot fewer slow queries. Doesn't mean much i know but there's definitely improvements.
You can tweak the settings to work with the system resources: http://petermoulding.com/tune_mysql_and_mariadb_through_their_.ini_configuration_file
been using MariaDB mysql as default out of the box installs for Centmin Mod http://centminmod.com/ for over 21 months now http://centminmod.com/mysql.html. 1000s of Centmin Mod users are using MariaDB without problems - some vBulletin clients even using it for clustered multi-server setups.
MariaDB 5.2.x branch while i am testing MariaDB 5.5/10.x and Oracle MySQL 5.6.x
Outside of Centmin Mod, I've been using MariaDB for 2+ yrs now without problems for standalone and WHM/Cpanel server setups
MariaDB proud user here.
Arch linux has defaults?
...yes?
systemd, mariadb, bunch of others
I always thought it was the lazy distro. The "here you do it" installer that makes the user do every insignificant thing... :P
I am hating to see the name Oracle in LEMP stack setup. Does MariaDB installation show the name "Oracle" by any chance?
Another happy MariaDB user here. Nice to see Arch make this move Hope Ubuntu (and CentOS) follow soon!
MariaDB has NEVER been a good thing for me... ever.
MySQL or Percona seems to work just fine.
How about sharing why it didn't work good for you?
I think I saw once in MariaDB's installation document, but not sure :P
Oh nooo...