8 ms·

Arch Linux: MariaDB replaces MySQL in repositories

• niggler 14y ago
  My favorite comment from the comparison page https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/ https://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/ "Timings may be different as MariaDB is in many cases faster than MySQL. "
  • signed0 14y ago
    Cached version: http://webcache.googleusercontent.com/search?q=cache:zMNULrzBDREJ:https://kb.askmonty.org/v/mariadb-versus-mysql-compatibility/+&cd=1&hl=en&ct=clnk&gl=us http://webcache.googleusercontent.com/search?q=cache:zMNULrz...
• mcrittenden 14y ago
  For any arch'ers looking to upgrade, note that "mysql_upgrade -p" can take a long time depending on how much data you have in MySQL. It took a few minutes on my laptop with only a few medium sized databases.
• koenigdavidmj 14y ago
  Slackware is doing this too.
  • stock_toaster 14y ago
    Apparently Fedora and SuSe also decided to a while ago. https://news.ycombinator.com/item?id=5147574 https://news.ycombinator.com/item?id=5147574
• shared4you 14y ago
  What a coincidence! Just today, Slackware also switched to MariaDB! [1]. Two weeks ago, it was openSUSE [2]. It's on the cards for the next Fedora release in May [3]. Wonder when will Debian (and its children) make the switch. [1]: http://www.h-online.com/open/news/item/Slackware-Linux-switches-to-MariaDB-1829261.html http://www.h-online.com/open/news/item/Slackware-Linux-switc... [2]: http://blog.mariadb.org/opensuse-12-3-released-with-mariadb-as-default/ http://blog.mariadb.org/opensuse-12-3-released-with-mariadb-... [3]: http://www.h-online.com/open/news/item/Fedora-19-MariaDB-instead-of-MySQL-but-no-Btrfs-1795146.html http://www.h-online.com/open/news/item/Fedora-19-MariaDB-ins...
  • Spittie 14y ago
    I know it's not exactly a huge distro, but Chakra did the switch almost two months ago. http://chakra-project.org/news/index.php?/archives/3-Switching-from-MySQL-to-MariaDB.html http://chakra-project.org/news/index.php?/archives/3-Switchi...
  • username111 14y ago
    Debian stable: Probably not for a while. Ubuntu and Debian testing and up maybe sooner.
  • ams6110 14y ago
    From the OpenBSD ports email list: Subject: NEW: MariaDB To: ports@openbsd.org Date: Fri, 22 Mar 2013 21:55:07 -0400 Here is a new port of MariaDB. MariaDB is a fork of MySQL maintained in the open. The development environment is so much better than what has become of MySQL AB since Oracle took over Sun. They deal with security issues in a much better manner and don't try to hide the tickets or any details regarding the issues. Bugs are fixed much quicker and tickets in general are dealt with in a much better manner. MariaDB 5.5 will replace the current MySQL 5.1 port for the next release. ...
  • Corrado 14y ago
    I would think that Debian would be especially sensitive to the Closed Source environment that Oracle is generating for MySQL. It seems like it would be an easy choice between two software stacks; one OSS and the other CSS. Granted, Stable probably won't move for at least a release cycle, but I would be disappointed if Sid didn't make the switch soon. Ubuntu, on the other hand, doesn't have the same strong OSS sensibilities and will probably tow the Oracle line, at least for a little while longer.
    • jcastro 14y ago
      > Ubuntu, on the other hand, doesn't have the same strong OSS sensibilities and will probably tow the Oracle line, at least for a little while longer. Sorry to ruin your "Ubuntu is more closed" claim (seriously why even make that up?) but Ubuntu has been discussing switching to MariaDB at for the past year -- here are the last 2 blueprints with the progress: - https://blueprints.launchpad.net/ubuntu/+spec/servercloud-q-mysql-roundtable https://blueprints.launchpad.net/ubuntu/+spec/servercloud-q-... - https://blueprints.launchpad.net/ubuntu/+spec/servercloud-r-mysql https://blueprints.launchpad.net/ubuntu/+spec/servercloud-r-... Also it's "toe the line", and we're toeing with Debian, it just happens to be the same person doing the work in Ubuntu and Debian, so doing the work in Debian and syncing to Ubuntu makes the most sense.
• eksith 14y ago
  Looking at the specs for MariaDB, I can see why our last client dropped MySQL for the front end and went with it. The XtraDB engine, basically a fork of InnoDB with patches, is actually very nice. We've had to do almost no modifications to the data structure when moving from InnoDB for some DBs (that we're not using Postgres for). Fun fact: XtraDB is also the default in Percona http://www.percona.com http://www.percona.com (No, I don't work for them). There are things you still need to carefully look into before migration if that's what you want to do. Minor things like naming is only part of it. Read. Read. Re-read the documentation : https://mariadb.org/docs https://mariadb.org/docs I've felt MairaDB is the direction MySQL should have gone after the 4.x branch. In many ways (though the technical aspects are totally different), this split is very similar to what happened with FreeBSD after the 4.x branch with the start of DragonFly. When in doubt, fork. The beauty of Open Source.
  • stock_toaster 14y ago
    XtraDB is not only the default in Percona, they originally wrote it (forked from InnoDB). http://www.mysqlperformanceblog.com/2008/12/16/announcing-percona-xtradb-storage-engine-a-drop-in-replacement-for-standard-innodb/ http://www.mysqlperformanceblog.com/2008/12/16/announcing-pe...
  • olalonde 14y ago
    Out of curiosity, why do you need to use both Postgres and MySQL/MariaDB?
    • eksith 14y ago
      Our clients usually have a lot already running on InnoDB so we always have similar setups (preferably identical except the same volume of data) to what they have on the side. Can't tell you how many problems we've caught that way and how much it simplifies things during deployment. If starting anew, it's Postgres. Our internal stuff is almost all running straight Postgres but a small part of our application stack is abstracted on top of it to provide document DB functionality.
    • harichinnan 14y ago
• xxdesmus 14y ago
  Hopefully Ubuntu makes a similar switch in the near future. Long overdue at this point.
  • monsterix 14y ago
    Totally agree. I have been feeling this gut for nearly everything open-source out there. It's time to reign-back-in! Sorely.
• mindstab 14y ago
  It's a pretty tricky business buying an open source company. You have to work with the community and existing people to maintain "master" of it. Oracle of course is not that company and so their subacquisition of mysql via Sun is now being pissed away in its entirety. If I were an investor I might have some questions. *Edit: Sun dropped $1 billion on mysql. That's a lot of money to later just "lose"
  • arkitaip 14y ago
    I think it was a very deliberate strategy by Oracle to undermine open source RDBMs by extinguishing the number one solution if it failed to attract customers to Oracle db. Their major mistake seems to be that they underestimated just how skeptical the foss community is of them - and rightly so - and how fast it can re-group and create alternatives. But you know what I really like? The fact that virtually no startups these days talk Oracle when discussing big data, which used to be the domain that Oracle truly dominated. Seriously, when did you read about Oracle (db) here on HN? It's interesting that Oracle focused so much on fighting open source RDBMs when NoSQL databases were the real threat all along.
    • FooBarWidget 14y ago
      Is the fact that almost no startups talk about or use Oracle that much of a problem for Oracle? Those startups wouldn't have generated much revenue for Oracle anyway. Those startups will forever be in search for a free solution.
      • Herbert2 14y ago
        It could be, fast forward ten years and the majority of the smartest minds in the industry will have no experience with your flagship product.
      • ams6110 14y ago
        Startups targeting enterprise or government customers might well use Oracle. It's free* to develop on, and something a lot of those sorts of clients use anyway. * Last I checked, Oracle allowed you to use Oracle RDBMS free for "prototype development" but once you were actually generating revenue from that you are supposed to buy the necessary licenses, even for continued development or support purposes.
• fjordan 14y ago
  Interesting performance comparison here between MariaDB, Percona Server, and MySQL http://vbtechsupport.com/657/2/ http://vbtechsupport.com/657/2/
• eli 14y ago
  I'm hardly a DB expert, but I would have thought Percona would make more sense to replace Oracle MySQL in the repository. True it doesn't have a few new bells, but it should be a drop-in replacement for pretty much everyone.
• antihero 14y ago
  That said, if you can, use PostgreSQL for the good of your head. Transactional schema migrations mean you can save yourself a lot of headache.
  • dcolgan 14y ago
    Is there a good reason to use MySQL when you have the choice between it and Postgres? When we had the MySQL vs Postgres discussion in college, it seemed like the only reason to use MySQL we could come up with was that it had the larger user base.
    • arjn 14y ago
      We use both in our production and staging environment. I've been using both for the last 3 years (5 years for MySql). My opinion at this time is that in 80% of cases MySQL is easier to setup, use and manage.
      • saosebastiao 14y ago
        Only if 80% of the use cases are extremely simple use cases, with no need for multiple indexes per table, complex queries, common table expressions, user defined datatypes, window functions, asynchronous queries, or a strict stance on undefined behaviors, etc. The problem I see is that simple use cases gradually become slightly-less-simple use cases. And the pain of switching is 1000x the pain of taking a few extra steps up front and using a better database.
        • rimantas 14y ago
          I doubt all the stuff you listed is used even in 1% of cases, except multiple indexes and strict stance. And MySQL supports both.
          • saosebastiao 14y ago
            All the stuff, sure. But I have yet to find a scenario that doesn't involve at least one of them.
• deleted 14y ago
  [deleted]
• acomjean 14y ago
  I went to Open Database camp a few weeks ago. There was a talk about the split... The short story: MariaDB is a fork of MySQL done by Michael "Monty" Widenius one of the mySQL founders. It seems the winds of fear are blowing against mySQL and MariaDB is getting mindshare (it is a fork so pretty close still but not going back). Although Oracle hasn't really done anything yet, and did send a rep to the conference, there seems to be some distrust. About a decade ago at a startup we had and Oracle instance running s a test, their sales people where tenacious (fought them off by asking for an ODBC driver for linux). Then startup went under. sigh.
  • arkitaip 14y ago
    My prediction is that in the next few years Oracle will give up on MySQL by either abandoning it or give it to the foss community. Because once the enthusiasts, devs and hackers lose faith in your foss project - it's done for. Just look at what happened to Open Office.
    • cincinnatus 14y ago
      But first they'll try to sue a bunch of people.
    • kryptiskt 14y ago
      I don't see them giving up the copyrights. As it is GPL, nobody else is going to go opencore with it or having a separate commercial license. Which puts a spanner in the works for MariaDB and other MySQL-based competitors (Monty did in fact complain about it a while back).
• saintx 14y ago
  The queen is dead. Long live the queen.
• HarrisonFisk 14y ago
  The interesting part about this is that MariaDB is only a drop in replacement for MySQL 5.5. MariaDB isn't porting to MySQL 5.6 (which came out last month), instead they are going to try to reimplement all of the functionality from MySQL 5.6 which will probably never finish: http://blog.mariadb.org/mariadb-10-0-and-mysql-5-6/ http://blog.mariadb.org/mariadb-10-0-and-mysql-5-6/
• deleted 14y ago
  [deleted]
• pootch 14y ago
  Considering that MySQL is in the running for worst database ever coded. I realy dont give a shit what fork ARCH LINUX chooses. Since I wouldnt use that bullshit either,
• Uchikoma 14y ago
  How easy is it to switch a production environment (millions of users, TBs of data) from MySQL to MariaDB?
• chiph 14y ago
  Is MariaDB Galeria Cluster mostly-the-same as MySQL Cluster?