MariaDB

From Wikipedia, the free encyclopedia
  (Redirected from SkySQL)
Jump to navigation Jump to search
MariaDB
MariaDB Logo.png
Developer(s) MariaDB Corporation Ab, MariaDB Foundation
Initial release 22 January 2009; 9 years ago (2009-01-22)
Stable release 10.3.10 (October 4, 2018; 6 days ago (2018-10-04)[1]) [±]
Preview release 10.3.10 RC [2] (August 28, 2018; 43 days ago (2018-08-28)) [±]
Repository Edit this at Wikidata
Written in C, C++, Perl, Bash
Operating system Unix, Windows, Solaris, Linux, MacOS, BSD[3]
Available in English
Type RDBMS
License GNU General Public License (version 2), GNU Lesser General Public License (for client-libraries)[4]
Website mariadb.org, mariadb.com

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.[5] Contributors are required to share their copyright with the MariaDB Foundation.[6]

MariaDB intends to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands.[7] It includes the XtraDB storage engine for replacing InnoDB,[8] 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.[9]

Its lead developer is Michael "Monty" Widenius, one of the founders of MySQL AB and the founder of Monty Program AB. On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately $1 billion. The acquisition completed on 26 February 2008. MariaDB is named after Monty's younger daughter Maria, similar to how MySQL is named after his other daughter My.[10]

Versioning[edit]

MariaDB version numbers follow the MySQL's numbering scheme up to version 5.5. Thus, MariaDB 5.5 offers all of the MySQL 5.5 features. There exists a gap in MySQL versions between 5.1 and 5.5, while MariaDB issued 5.2 and 5.3 point releases.

Since specific new features have been developed in MariaDB, the developers decided that a major version number change was necessary.[11][12]

Version Original release date Latest version Release date Status
Old version, no longer supported: 5.1 October 29, 2009; 8 years ago (2009-10-29)[13] 5.1.67 2013-01-30[14] Stable (GA)
Old version, no longer supported: 5.2 April 10, 2010; 8 years ago (2010-04-10)[15] 5.2.14 2013-01-30[16] Stable (GA)
Old version, no longer supported: 5.3 July 26, 2011; 7 years ago (2011-07-26)[17] 5.3.12 2013-01-30[18] Stable (GA)
Older version, yet still supported: 5.5 February 25, 2012; 6 years ago (2012-02-25)[19] 5.5.61 2018-07-31[20] Stable (GA)
Older version, yet still supported: 10.0 November 12, 2012; 5 years ago (2012-11-12)[21] 10.0.36 2018-08-01[22] Stable (GA)
Older version, yet still supported: 10.1 June 30, 2014; 4 years ago (2014-06-30)[23] 10.1.36 2018-09-08[24] Stable (GA)
Older version, yet still supported: 10.2 April 18, 2016; 2 years ago (2016-04-18)[25] 10.2.18 2018-09-25[26] Stable (GA)
Current stable version: 10.3 April 16, 2017; 17 months ago (2017-04-16)[27] 10.3.10 2018-10-04[28] Stable (GA)
Legend:
Old version
Older version, still supported
Latest version
Latest preview version
Future release

Cloud deployment[edit]

MariaDB has been supported in Amazon RDS service since October 2015.[29]

MariaDB is a supported database in Microsoft Azure.[30]

Third-party software[edit]

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 replaced MySQL with MariaDB in Fedora 19, out of concerns that Oracle was making MySQL a more closed software project.[31] OpenBSD likewise in April 2013 dropped MySQL for MariaDB 5.5.[32]

MariaDB Foundation[edit]

In December 2012 Michael Widenius, David Axmark, and Allan Larsson announced the formation of a foundation that would oversee the development of MariaDB.[33][34] In April 2013 the Foundation announced that it had appointed Simon Phipps as its Secretary and interim Chief Executive Officer, Rasmus Johansson as Chairman of the Board, and Andrew Katz, Jeremy Zawodny, and Michael Widenius as Board members.[35] 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.[35] Phipps quit in 2014 on the sale of the MariaDB trademark to SkySQL. He later said: "I quit as soon as it was obvious the company was not going to allow an independent foundation."[36]

SkySQL Corporation Ab, 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. The MariaDB Foundation appointed Widenius as its CTO;[37] Simon Phipps became the MariaDB Foundation's interim chief executive.[38]

On 1 October 2014, SkySQL Corporation AB changed its name to MariaDB Corporation AB[39] to reflect its role as the main driving force behind the development of MariaDB server and the biggest support-provider for it.[40]

MariaDB is a registered trademark of MariaDB Corporation AB,[41] used under license by the MariaDB Foundation.[42]

Prominent users[edit]

MariaDB is used at ServiceNow [43], DBS Bank [44], Google[45], Mozilla[46] and the Wikimedia Foundation since 2013[47].

Several Linux and BSD distributions include MariaDB[48], like Ubuntu (from 14.04 LTS)[49]. Some default to MariaDB, such as Arch Linux[50], Manjaro[51], Debian (from Debian 9)[52], Fedora (from Fedora 19)[53][54], Red Hat Enterprise Linux (from RHEL 7 in June 2014)[55][56], CentOS (from CentOS 7)[57], Mageia (from Mageia 2)[58], openSUSE (from openSUSE 12.3 Dartmouth)[59], SUSE Linux Enterprise Server (from SLES 12)[60], OpenBSD (from 5.7)[61][62][63] and FreeBSD[64].

Support[edit]

In 2013 Google tasked one of its engineers to work at the MariaDB Foundation.[65] A group of investment companies led by Intel has invested $20 million in SkySQL.[66] The European Investment Bank has funded MariaDB with €25 million in 2017.[67]

See also[edit]

References[edit]

  1. ^ "MariaDB 10.3.10 Release Notes". mariadb.com. 2018-10-04. Retrieved 2018-10-05.
  2. ^ 10.3.10 Release Notes,Maria DB.com
  3. ^ "MariaDB 10.0.20 Stable". Retrieved 18 June 2015.
  4. ^ "MariaDB licenses".
  5. ^ "Dead database walking: MySQL's creator on why the future belongs to MariaDB - MariaDB, open source, mysql, Oracle". Computerworld. Retrieved 2013-09-11.
  6. ^ "Contributing Code". MariaDB KnowledgeBase. Retrieved 17 September 2014.
  7. ^ "MariaDB versus MySQL - Compatibility". MariaDB KnowledgeBase. Retrieved 17 September 2014.
  8. ^ "About XtraDB". MariaDB KnowledgeBase. Retrieved 17 September 2014.
  9. ^ "Aria FAQ". MariaDB KnowledgeBase. Retrieved 17 September 2014.
  10. ^ "Why is the project called MariaDB?". MariaDB KnowledgeBase. Retrieved 17 September 2014.
  11. ^ rasmus (2012-08-13). "Explanation on MariaDB 10.0 « The MariaDB Blog". Blog.mariadb.org. Retrieved 2013-04-16.
  12. ^ "What comes in between MariaDB now and MySQL 5.6? « The MariaDB Blog". Blog.mariadb.org. 2012-05-28. Retrieved 2013-04-16.
  13. ^ "MariaDB 5.1.38 Release Notes". Retrieved 2015-09-21.
  14. ^ "MariaDB 5.1.67 Release Notes". Retrieved 2015-09-21.
  15. ^ "MariaDB 5.2.0 Release Notes". Retrieved 2015-09-21.
  16. ^ "MariaDB 5.2.14 Release Notes". Retrieved 2015-09-21.
  17. ^ "MariaDB 5.3.0 Release Notes". Retrieved 2015-09-21.
  18. ^ "MariaDB 5.3.12 Release Notes". Retrieved 2015-09-21.
  19. ^ "MariaDB 5.5.20 Release Notes". Retrieved 2015-09-21.
  20. ^ "MariaDB 5.5.61 Release Notes". Retrieved 2018-07-31.
  21. ^ "MariaDB 10.0.0 Release Notes". Retrieved 2015-09-21.
  22. ^ "MariaDB 10.0.36 Release Notes". Retrieved 2018-08-01.
  23. ^ "MariaDB 10.1.0 Release Notes". Retrieved 2015-09-21.
  24. ^ "MariaDB 10.1.36 Release Notes". mariadb.com. 2018-09-26.
  25. ^ "MariaDB 10.2.0 Release Notes". Retrieved 2016-09-28.
  26. ^ "MariaDB 10.2.18 Release Notes". Retrieved 2018-08-26.
  27. ^ "MariaDB 10.3.0 Release Notes". Retrieved 2017-04-23.
  28. ^ "MariaDB 10.3.10 Release Notes". Retrieved 2018-10-05.
  29. ^ https://www.marketwatch.com/story/amazon-web-services-announces-two-new-database-services-aws-database-migration-service-and-amazon-rds-for-mariadb-2015-10-07/
  30. ^ czeumault. "Azure MariaDB Documentation - Tutorials, API Reference". docs.microsoft.com. Retrieved 2018-10-03.
  31. ^ "Features / Replace MySQL with MariaDB". Retrieved 17 September 2014.
  32. ^ Colin Charles (5 April 2013). "MariaDB now in OpenBSD ports tree". MariaDB blog. Retrieved 4 March 2017.
  33. ^ rasmus (2012-12-04). "MariaDB Foundation to Safeguard Leading Open Source Database « The MariaDB Blog". Blog.mariadb.org. Retrieved 2013-04-16.
  34. ^ "1 million euros pledged to new MariaDB Foundation - The H Open: News and Features". H-online.com. 2012-12-04. Archived from the original on 5 December 2012. Retrieved 2013-04-16.
  35. ^ a b "MariaDB Foundation on course for community governance". The H. 2013-04-18. Archived from the original on 19 April 2013.
  36. ^ Asay, Matt (22 August 2016). "Does MariaDB's latest move show how hard it is to make money with open source?". TechRepublic. Retrieved 7 February 2017.
  37. ^ "SkySQL merges with Monty Program to unite MariaDB developers". The H. 2013-04-23. Archived from the original on 25 April 2013. [...] Widenius has been appointed as its CTO by the MariaDB Foundation.
  38. ^ Clark, Jack (2013-09-12). "Google swaps out MySQL, moves to MariaDB". Data Center. The Register. Situation Publishing. Retrieved 2017-09-14. The MariaDB Foundation's interim chief executive is Simon Phipps.
  39. ^ "SkySQL to become MariaDB Corporation". mariadb.com. MariaDB Corporation. Archived from the original on 6 October 2014. Retrieved 1 October 2014.
  40. ^ Widenius, Monty. "Why SkySQL becoming MariaDB Corporation will be good for the MariaDB Foundation". MariaDB Foundation Blog. Retrieved 1 October 2014.
  41. ^ "MariaDB Trademarks". mariadb.com. Archived from the original on 2014-10-06.
  42. ^ "MariaDB Trademark". mariadb.org.
  43. ^ "How ServiceNow deploys MariaDB".
  44. ^ MariaDB (15 March 2018). "M-18 Keynote - DBS, Ng Peng Khim and Joan Tay Kim Choo". Retrieved 21 April 2018 – via YouTube.
  45. ^ "The Register 12 September 2013 Google swaps out MySQL, moves to MariaDB'".
  46. ^ "MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation". Mozilla IT. Retrieved 17 September 2014.
  47. ^ "Wikipedia Adopts MariaDB". Wikimedia Foundation. 2013-04-22.
  48. ^ "Distributions Which Include MariaDB". MariaDB Corporation.
  49. ^ "Trusty Tahr Release Notes". Ubuntu.
  50. ^ "MariaDB replaces MySQL in repositories". Arch Linux.
  51. ^ "Install Apache, MariaDB, PHP (LAMP) 2016". Manjaro.
  52. ^ "MariaDB Server Default in Debian 9". MariaDB Corporation.
  53. ^ "Features/ReplaceMySQLwithMariaDB". Fedora Project.
  54. ^ "Oracle who? Fedora & openSUSE will replace MySQL with MariaDB". ZDNet. 31 January 2013. Retrieved 17 September 2014.
  55. ^ "7.0 Release Notes : Chapter 17. Web Servers and Services". Red Hat.
  56. ^ "Red Hat ditches MySQL, switches to MariaDB". Itwire.com. Retrieved 2013-09-11.
  57. ^ "CentOS Product Specifications". CentOS.
  58. ^ "Mageia 2 Release Notes : MariaDB". Mageia.
  59. ^ "openSUSE 12.3 released with MariaDB as default". MariaDB Foundation.
  60. ^ "Release Notes : MariaDB Replaces MySQL". SUSE.
  61. ^ "MariaDB now in OpenBSD ports tree". MariaDB Foundation.
  62. ^ "mariadb-server-10.0.16v0 – multithreaded SQL database (server)". OpenBSD ports. 2015-01-30. Retrieved 2015-02-11.
  63. ^ "Switch from using MySQL to using MariaDB attempt #2". Retrieved 28 September 2014.
  64. ^ https://mariadb.com/kb/en/library/building-mariadb-on-freebsd/
  65. ^ "Google sniffs at MySQL fork MariaDB: Yum. Have an engineer". The Register.
  66. ^ Wolpe, Toby (23 October 2013). "MariaDB gets shot in the arm from Intel-led $20m SkySQL injection". ZDNet. CBS Interactive.
  67. ^ "Finland: Investment Plan for Europe - EIB supports MariaDB with financing for accelerated growth". www.eib.org. Retrieved 2017-05-15.

Further reading[edit]

External links[edit]