5 ms·
Proposed Fedora 19 Feature: Replace MySQL with MariaDB
- rohshall 14y agoKudos to Fedora for making such a bold move. Oracle's commitment to MySQL is questionable. So, even though MariaDB does not have MySQL's 'brand' recognition, it's completely backward compatible with MySQL (at least till now). And I think most people can just switch to MariaDB without any issues.
- whalesalad 14y agoI run mariadb on my Mac instead of MySQL. It's been fine as a transparent replacement thus far on my contracting gigs.
- jacques_chester 14y agoSpeaking of drop in replacements, I've been very happy with Percona Server. The improved monitoring is worth it alone.
- thejosh 14y agoAgreed - Percona Community Edition is pretty dang good.
- jacques_chester 14y agoI poked around a bit before picking it. The monitoring is what sold me -- I don't do anything like enough traffic for the performance stuff to affect me. I looked at MariaDB, Percona and Drizzle. MariaDB is very close to stock MySQL, Percona is stock + lots of performance patches and monitoring. Drizzle was still in the middle of proving Fredrick Brooks right about second systems.
- jmspring 14y agoUnderstanding the drop-in aspect, I'm curious if you compared those same three against Postgres? I'm contemplating which DB to move to for a project. I know Mysql and Postgres pretty well.
- jacques_chester 14y agoI greatly prefer PostgreSQL. But it's for a Wordpress installation.
- whalesalad 14y agoI believe the next version of WP is supposed to move away from a MySQL requirement by way of finishing their database abstraction. If I wasn't half asleep, on cold meds, and typing from my phone I'd validate that and share a link. I'm pretty sure it's in their near future though. Something in regards to PDO is ringing a bell.
- jacques_chester 14y agoPlugins and themes assume MySQL. Not all of them go through the Wordpress interface to the database.
- thejosh 14y agoThey aren't plugins/themes you want to be using than...
- LeonidasXIV 14y agoThe same could be said about blog engines that rely exclusively on using MySQL.
- whalesalad 14y agoPostgres is hard to beat right now in terms of the community behind it and the rate of innovation. Everyone is using it in exciting new ways. Hstore is awesome. Postgis is awesome. Async indexing. Heroku Postgres. The list goes on and on. That being said, most of the big projects that I've worked on in my lifetime were on MySQL and it fared very well. Mariadb and Percona are both solid. At some point all of the MySQL variants are still MySQL though... Which means a lot of its inherent flaws are still there. At the end of the day it's not tremendously hard to switch from one to the other. See the recent posts from the Lanyrd dev team on migrating to Postgres.
- peapicker 14y agoDoes MariaDB still use the InnoDB engine for real work?
- dschiptsov 14y agoThat's good move. OSS software should be written only by passionate engineers for self-realization, not by [outsourced] corporate drones for salary and position.
- darklajid 14y agoMy apologies. I'm starting to feel like Oracle's becoming to the 33 years old me what Microsoft was to this zeal... - erm - open-source enthusiast 10 years ago. Even recognizing this similarity and although I know that it is childish and stupid, I cannot help to wear a fat smile when Oracle hits the news in a bad way, recently. And in moments like this I'm proud of the fact that my native language 'invented' Schadenfreude. They just (subjectively) messed up so much. OpenOffice, Java failures, MySQL - the only news in a long time about that company that weren't about messing up software involved Larry buying a private island..
- rlpb 14y agoThis has also been considered in Ubuntu: "MySQL's future in Debian and Ubuntu" https://lists.ubuntu.com/archives/ubuntu-server/2012-February/006073.html https://lists.ubuntu.com/archives/ubuntu-server/2012-Februar... and an intermediate conclusion: https://lists.ubuntu.com/archives/ubuntu-server/2012-February/006129.html https://lists.ubuntu.com/archives/ubuntu-server/2012-Februar... Also see "Oracle Makes More Moves To Kill Open Source MySQL": http://techcrunch.com/2012/08/18/oracle-makes-more-moves-to-kill-open-source-mysql/ http://techcrunch.com/2012/08/18/oracle-makes-more-moves-to-...
- rmk2 14y agoA similar proposition has been put forward on the openSUSE development mailing list: http://lists.opensuse.org/opensuse-factory/2013-01/msg00298.html http://lists.opensuse.org/opensuse-factory/2013-01/msg00298....
- jiggy2011 14y agoSo , since it seems that MariaDB is the new "real" mysql is there any good reason now to do this? On a more practical note, if I have production servers running mysql should I in theory at least be able to just drop in MariaDB as a replacement with the same config files?