MariaDB: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
Jepafi (talk | contribs)
17 edits
No edit summary
Jepafi (talk | contribs)
17 edits
Line 42: Line 42:
===Clients===
===Clients===


* [[JPDB Admin for MariaDB]] — a administration application for MariaDB and MySQL, with free version and trial version, developed for Windows and Linux.
* [http://www.jpdbadmin.com JPDB Admin for MariaDB] — a administration application for MariaDB and MySQL, with free version and trial version, developed for Windows and Linux.
* [[DBEdit]] — a free administration application for MariaDB and other databases.
* [[DBEdit]] — a free administration application for MariaDB and other databases.
* [[Navicat]] — a series of proprietary database management applications for [[Windows]], [[Mac OS X]], and [[Linux]].
* [[Navicat]] — a series of proprietary database management applications for [[Windows]], [[Mac OS X]], and [[Linux]].

Revision as of 16:11, 18 July 2013

MariaDB
Developer(s)Monty Program Ab, MariaDB Foundation
Initial release22 January 2009 (2009-01-22)
Repository
Written inC, C++, Perl, Bash
Operating systemCross-platform (Unix, Windows, Solaris, Linux, MacOS, BSD).[1]
Available inEnglish
TypeRDBMS
LicenseGNU General Public License (version 2), GNU Lesser General Public License (for client-libraries)
Websitemariadb.org

MariaDB is a community-developed fork of the MySQL relational database management system, the impetus being the community maintenance of its free status under the GNU GPL. As a fork of a leading open source software system, it is notable for being led by its original developers and triggered by concerns over direction by an acquiring commercial company Oracle.[2] Contributors are required to share their copyright with Monty Program AB.[3]

The intent is also to maintain high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.[4] It includes the XtraDB storage engine as a replacement for InnoDB,[5] as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL.[6]

Its lead developer is Michael "Monty" Widenius, the founder of MySQL and Monty Program AB. He had previously sold his company, MySQL AB, to Sun Microsystems for 1 billion USD. MariaDB is named after Monty's younger daughter, Maria.[7]

Versioning

MariaDB version numbers, until 5.5, followed MySQL's numbers. Thus, if one uses MariaDB 5.5 one knows that all features from MySQL 5.5 are available.

Notably, there exists a gap in MySQL versions between 5.1 and 5.5 while MariaDB issued point releases for 5.2 and 5.3.

After 5.5, MariaDB developers decided to start a branch numbered as 10. This change has been made to make clearer that MariaDB will not import all features from MySQL 5.6 in 10.0 (they may or may not be ported in future versions). In some cases the reason is that some of that features seem not to be stable enough for MariaDB standards. As new specific features have been developed, they think that the major version number was necessary.[8][9]

Third-party software

MariaDB's API and protocol are compatible with those used by MySQL, plus some features to support native non-blocking operations and progress reporting. This means that all connectors, libraries and applications which work with MySQL should also work on MariaDB - whether or not they support its native features. On this basis, Fedora developers plan to replace MySQL with MariaDB in Fedora 19, out of fears that Oracle is making MySQL a more closed software project.[10]

Here is a list of tools that are known to work properly with MariaDB:

Clients

  • JPDB Admin for MariaDB — a administration application for MariaDB and MySQL, with free version and trial version, developed for Windows and Linux.
  • DBEdit — a free administration application for MariaDB and other databases.
  • Navicat — a series of proprietary database management applications for Windows, Mac OS X, and Linux.
  • HeidiSQL — a free and open source client for MySQL on Windows. It supports MariaDB specific features like Virtual Columns, and is included with the Windows MSI package of MariaDB beginning with the 5.2.7 release.[11][12]
  • phpMyAdmin — a web-based database management application for MySQL

Applications

The following applications officially support MariaDB:[13]

MariaDB Foundation

In December 2012, Michael Widenius, David Axmark, and Allan Larsson announced the creation of a foundation that would oversee the development of MariaDB.[14][15] In April 2013, the Foundation announced that it had appointed Simon Phipps as its Secretary and interim Chief Executive Officer, Rasmus Johansson as Chair of the Board, and Andrew Katz, Jeremy Zawodny, and Michael Widenius as Board members.[16] Noting that it wished to create a governance model similar to that used by the Eclipse Foundation, the Board appointed the Eclipse Foundation's Executive Director Mike Milinkovich as an advisor to lead the transition.[16]

SkySQL, a company formed by ex-MySQL executives and investors after Oracle bought MySQL, announced in April 2013 that they were merging their company with Monty Program Ab, and joining the MariaDB Foundation. SkySQL's CEO Patrik Sallner would lead the new merged company, and Widenius was appointed as its CTO by the MariaDB Foundation.[17]

Prominent users

See also

Books

  • MariaDB Crash Course, Ben Forta, Addison Wesley, 2011, ISBN 0-321-79994-1

References

  1. ^ MariaDB 5.5.28a Stable, Downloads Source, Binaries, and Packages
  2. ^ http://www.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_mariadb/
  3. ^ Contributing Code, AskMonty Knowledgebase
  4. ^ MariaDB versus MySQL - Compatibility, AskMonty KnowledgeBase
  5. ^ About XtraDB, AskMonty KnowledgeBase
  6. ^ Aria FAQ, AskMonty KnowledgeBase
  7. ^ Why is the project called MariaDB?, AskMonty KnowledgeBase
  8. ^ by rasmus (2012-08-13). "Explanation on MariaDB 10.0 « The MariaDB Blog". Blog.mariadb.org. Retrieved 2013-04-16.
  9. ^ "What comes in between MariaDB now and MySQL 5.6? « The MariaDB Blog". Blog.mariadb.org. 2012-05-28. Retrieved 2013-04-16.
  10. ^ Features / Replace MySQL with MariaDB, 2013-01-21
  11. ^ "MariaDB 5.2.7 shipped with HeidiSQL". Heidisql.com. Retrieved 2013-04-16.
  12. ^ MariaDB 5.2.7 released!, Monty Program Group Blog
  13. ^ "Works With MariaDB - AskMonty KnowledgeBase". Kb.askmonty.org. Retrieved 2013-04-16.
  14. ^ by rasmus (2012-12-04). "MariaDB Foundation to Safeguard Leading Open Source Database « The MariaDB Blog". Blog.mariadb.org. Retrieved 2013-04-16.
  15. ^ "1 million euros pledged to new MariaDB Foundation - The H Open: News and Features". H-online.com. 2012-12-04. Retrieved 2013-04-16.
  16. ^ a b "MariaDB Foundation on course for community governance". The H. 2013-04-18.
  17. ^ "SkySQL merges with Monty Program to unite MariaDB developers". The H. 2013-04-23.
  18. ^ https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ Arch Linux News - 25 March 2013 MariaDB replaces MySQL in repositories
  19. ^ "The Chakra Project - Get". Chakra-linux.org. Retrieved 2013-04-16.
  20. ^ Oracle who? Fedora & openSUSE will replace MySQL with MariaDB, 2013-02-1.
  21. ^ MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation, 2013-17-1.
  22. ^ openSUSE Dumps MySQL Makes MariaDB Default Database, 2013-02-1.
  23. ^ http://www.itwire.com/business-it-news/open-source/60292-red-hat-ditches-mysql-switches-to-mariadb
  24. ^ "Slackware News - 23 March 2013 ''Slackware switching to the MariaDB database''". Slackware.com. Retrieved 2013-04-16.
  25. ^ "Wikipedia Adopts MariaDB". Wikimedia Foundation. 2013-04-22.
  26. ^ "SaltOS sees gains with subqueries in MariaDB". MariaDB Foundation.
  27. ^ "Web of Trust (WOT) trusts the MariaDB upgrade". MariaDB Foundation.

External links

Wikibooks has a book on the topic of: MariaDB
Retrieved from "https://en.wikipedia.org/w/index.php?title=MariaDB&oldid=564806863"