MariaDB
| المطوّر | MariaDB plc, MariaDB Foundation |
|---|---|
| الإطلاق المبدئي | 29 أكتوبر 2009[1] |
| الإصدار المستقر | 10.1.22 |
| المستودع | github |
| مكتوب بلغة | C, C++, Perl, Bash |
| نظام التشغيل | Linux, Windows, macOS[2] |
| متاح في | English |
| النوع | RDBMS |
| الرخصة | GPLv2, LGPLv2.1 (client libraries)[3] |
| الموقع الإلكتروني | mariadb mariadb |
ماريا دي بي إنگليزية: MariaDB هي قاعدة بيانات تعتمد على تطوير المجتمع، اشتقت وتفرعت عن قاعدة بيانات ماي إس كيو إل. والدافع لهذا التفرع هو المحافظة عليها حرة وتحت ترخيص رخصة جنو العمومية في مواجهة الشكوك التي تدور حول ترخيصها عند مالكها الجديد شركة أوراكل. ويطلب من المساهمين مشاركة حقوقهم مع شركة Monty Program Ab.[4] المطور الأساسي هو مايكل "مونتي" ويدنيوس، مؤسس ماي إس كيو إل وMonty Program Ab، والذي قام سابقاً ببيع شركة تطوير ماي إس كيو إل لشركة صن ميكروسيستمز مقابل واحد مليار دولار. والتي آلت إلى ملكية شركة أوراكل لاحقاً.
MariaDB is intended to maintain high compatibility with MySQL, with exact matching with MySQL APIs and commands, allowing it in many cases to function as a drop-in replacement for MySQL. However, new features are diverging.[5] It includes new storage engines like Aria, ColumnStore, and MyRocks.
MariaDB itself is open source software. The MariaDB company makes its profits from developing proprietary products related to MariaDB.[6] In 2023, the MariaDB company had an initial public offering.[6] In 2024, all MariaDB company shares were bought by K1 Investment Management, a private equity fund, who appointed a new CEO.[7]
Its CTO is Michael "Monty" Widenius, one of the founders of MySQL AB and the founder of Monty Program AB. MariaDB is named after Widenius' younger daughter, Maria. (MySQL is named after his other daughter, My.)[8] Its logo consists of a sea lion, that Monty Widenius chose while he was snorkeling with his daughter in the Galápagos Islands.[9]
MariaDB Server
Licensing
The MariaDB Foundation mentions that "MariaDB Server will remain Free and Open Source Software licensed under GPLv2, independent of any commercial entities."[10]
الإصدارات
تبعت ماريا دي بي أرقام إصدارات ماي إس كيو إل حتى الإصدار رقم 5.5، وجميع الميزات في MySQL 5.5 تتوفر في إصدار ماريا دي بي 5.5.
بعد الإصدار 5.5 قرر مطوروا ماريا دي بي البدء بسلسلة أرقام إصدارات 10. وهذا التغيير للتوضيح بان ماريا دي بي لن يستورد كامل ميزات ماي إس كيو إل 5.6 (لأن بعضها لا يبدو أن مستقراً بما يكفي حسب معايير ماريا دي بي) أو يعيد تطويعها. ولكن تم تطوير ميزات جديدة محددة، لذلك أعتقدوا أن تغيير رقم الإصدار الرئيسي كان ضروريا.[11][12]
| Version | Original release date | Latest version | Release date | Status | End of Life[13] |
|---|---|---|---|---|---|
| 5.1 LTS | 29 أكتوبر 2009[14] | 5.1.67 | 2013-01-30[15] | Stable (GA) | Feb 2015 |
| 5.2 LTS | 10 أبريل 2010[16] | 5.2.14 | 2013-01-30[17] | Stable (GA) | Nov 2015 |
| 5.3 LTS | 26 يوليو 2011[18] | 5.3.12 | 2013-01-30[19] | Stable (GA) | Mar 2017 |
| 5.5 LTS | 25 فبراير 2012[20] | 5.5.68 | 2020-05-12[21] | Stable (GA) | Apr 2020 |
| 10.0 LTS | 12 نوفمبر 2012[22] | 10.0.38 | 2019-01-31[23] | Stable (GA) | Mar 2019 |
| 10.1 LTS | 30 يونيو 2014[24] | 10.1.48 | 2020-11-04[25] | Stable (GA) | Oct 2020 |
| 10.2 LTS | 18 أبريل 2016[26] | 10.2.44 | 2022-05-20[27] | Stable (GA) | May 2022 |
| 10.3 LTS | 16 أبريل 2017[28] | 10.3.39 | 2023-05-10[29] | Stable (GA) | May 2023 |
| 10.4 LTS | 9 نوفمبر 2018[30] | 10.4.34 | 2024-05-16[31] | Stable (GA) | Jun 2024 |
| 10.5 LTS | 3 ديسمبر 2019[32] | 10.5.29 | 2025-05-06[33] | Stable (GA) | Jun 2025 |
| 10.6 LTS | 26 أبريل 2021[34] | 10.6.24 | 2025-11-06[35] | Stable (GA) | Jul 2026 |
| 10.7 | 17 سبتمبر 2021[36] | 10.7.8 | 2023-02-06[29] | Stable (GA) | Feb 2023 |
| 10.8 | 22 ديسمبر 2021[37] | 10.8.8 | 2023-05-10[29] | Stable (GA) | May 2023 |
| 10.9 | 23 مارس 2022[38] | 10.9.8 | 2023-08-14[39] | Stable (GA) | Aug 2023 |
| 10.10 | 23 يونيو 2022[40] | 10.10.7 | 2023-11-13[39] | Stable (GA) | Nov 2023 |
| 10.11 LTS | 26 سبتمبر 2022[41] | 10.11.15 | 2025-11-06[42] | Stable (GA) | Feb 2028 |
| 11.0 | 27 ديسمبر 2022[43] | 11.0.6 | 2024-05-16[44] | Stable (GA) | Jun 2024 |
| 11.1 | 27 مارس 2023[43] | 11.1.6 | 2024-08-08[45] | Stable (GA) | Aug 2024 |
| 11.2 | 20 يونيو 2023[46] | 11.2.6 | 2024-11-01[47] | Stable (GA) | Nov 2024 |
| 11.4 LTS | 24 ديسمبر 2023[48] | 11.4.9 | 2025-11-06[49] | Stable (GA) | May 2029 |
| 11.8 LTS | 18 ديسمبر 2024[50] | 11.8.5 | 2025-11-14[51] | Stable (GA) | June 2028 |
| 12.0 | 7 أغسطس 2025[52] | 12.0.2 | 2025-08-07[53] | Stable (GA) | Q4 2025 |
| 12.1 | 7 أغسطس 2025[54] | 12.1.1 | 2025-08-07[55] | Release Candidate (RC) | Q1 2026 |
المفتاح: نسخة قديمة نسخة أقدم، ولكنها مازالت مصانة أحدث نسخة آخر نسخة بروفة | |||||
برمجيات طرف ثالث
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.[56] OpenBSD likewise in April 2013 dropped MySQL for MariaDB 5.5.[57]
However, for recent MySQL features, MariaDB either has no equivalent yet (like geographic function) or deliberately chose not to be 100% compatible (like GTID, JSON).[58] The MariaDB wiki claims that starting with MariaDB 10, upgrading from MySQL 8 is possible in most cases.[59]
مستخدمون بارزون
MariaDB is used at ServiceNow,[60] DBS Bank,[61] Google,[62] Mozilla,[63] and, since 2013, the Wikimedia Foundation.[64]
Several Linux distributions and BSD operating systems include MariaDB.[65] Some default to MariaDB, such as Arch Linux,[66] Manjaro,[67] Debian (from Debian 9),[68] Fedora (from Fedora 19),[69][70] Red Hat Enterprise Linux (from RHEL 7 in June 2014),[71][72] CentOS (from CentOS 7),[73] Mageia (from Mageia 2),[74] openSUSE (from openSUSE 12.3 Dartmouth),[75] SUSE Linux Enterprise Server (from SLES 12),[76] Slackware Linux (from Slackware 14.1)[77] and OpenBSD (from 5.7).[78][79][80]
أبرز المستخدمين
- مؤسسة ويكيميديا [81][82]
- فيدورا
- آرش لينكس
- دبيان ابتداء من إصدارة 9 ستريتش
- شركة موزيلا
- ريدهات ابتداء من RHEL 7
- غوغل [83]
مؤسسة ماريا دي بي
في ديسمبر 2012 أعلن مايكل ويدينوس، David Axmark، وAllan Larsson عن تأسيس مؤسسة MariaDB للإشراف على تطوير MariaDB.[84][85]
الدعم
إن شركة جوجل ترسل مهندسين لمؤسسة ماريا دي بي [86]، وقد استثمرت مجموعة من الشركات العالمية الكبرى فيها وبقيادتهم إنتل ب 20 مليون دولار. [87] أما البنك الأوربي للاستثمار فقد دفع 25 مليون يورو في 2017 [88]
انظر أيضاً
الهامش
- ^ "MariaDB 5.1.38 Release Notes". MariaDB KnowledgeBase. Retrieved 2019-01-14.
- ^ ""Download MariaDB"". Archived from the original on 23 January 2019. Retrieved 2019-01-16.
- ^ "MariaDB License". MariaDB KnowledgeBase. Archived from the original on 5 October 2019. Retrieved 1 November 2019.
- ^ Contributing Code, AskMonty Knowledgebase
- ^ "MariaDB versus MySQL - Compatibility". MariaDB KnowledgeBase. Archived from the original on 16 September 2020. Retrieved 17 September 2014.
- ^ أ ب "Private equity firm completes MariaDB buyout" (in الإنجليزية). Archived from the original on 16 May 2025. Retrieved 2025-07-26.
- ^ Acquisition
- ^ "Why is the project called MariaDB?". MariaDB KnowledgeBase. Archived from the original on 16 September 2020. Retrieved 17 September 2014.
- ^ Arnö, Kaj (2019-02-08). "The Story of our Sea Lion". MariaDB.org. Retrieved 2025-02-18.
- ^ "About MariaDB Server". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2022-02-23.
- ^ Explanation on MariaDB 10.0 - MariaDB.org
- ^ What comes in between MariaDB now and MySQL 5.6? - MariaDB.org
- ^ "Maintenance Policy". Archived from the original on 29 July 2019. Retrieved 2019-08-08.
- ^ "MariaDB 5.1.38 Release Notes". Archived from the original on 27 February 2016. Retrieved 2015-09-21.
- ^ "MariaDB 5.1.67 Release Notes". Archived from the original on 27 February 2016. Retrieved 2015-09-21.
- ^ "MariaDB 5.2.0 Release Notes". Archived from the original on 27 February 2016. Retrieved 2015-09-21.
- ^ "MariaDB 5.2.14 Release Notes". Archived from the original on 27 February 2016. Retrieved 2015-09-21.
- ^ "MariaDB 5.3.0 Release Notes". Archived from the original on 27 February 2016. Retrieved 2015-09-21.
- ^ "MariaDB 5.3.12 Release Notes". Archived from the original on 23 September 2015. Retrieved 2015-09-21.
- ^ "MariaDB 5.5.20 Release Notes". Archived from the original on 27 January 2016. Retrieved 2015-09-21.
- ^ "MariaDB 10.4.13, 10.3.23, 10.2.32, 10.1.45 and 5.5.68 now available". mariadb.org. 2020-05-13. Archived from the original on 16 May 2020. Retrieved 13 May 2020.
- ^ "MariaDB 10.0.0 Release Notes". Archived from the original on 27 January 2016. Retrieved 2015-09-21.
- ^ "MariaDB 10.0.38, MariaDB Connector/J 2.4.0 and MariaDB Connector/Node.js 2.0.3 now available". February 2019. Archived from the original on 27 March 2019. Retrieved 2019-02-01.
- ^ "MariaDB 10.1.0 Release Notes". Archived from the original on 5 January 2016. Retrieved 2015-09-21.
- ^ "MariaDB 10.5.7, 10.4.16, 10.3.26, 10.2.35 and 10.1.48 now available". mariadb.org. 4 November 2020. Archived from the original on 4 November 2020. Retrieved 2020-11-04.
- ^ "MariaDB 10.2.0 Release Notes". Archived from the original on 16 June 2016. Retrieved 2016-09-28.
- ^ "MariaDB 10.9.1, 10.8.3, 10.7.4, 10.6.8, 10.5.16, 10.4.25, 10.3.35 and 10.2.44 now available". mariadb.org. 21 May 2022. Archived from the original on 25 May 2022. Retrieved 2022-05-23.
- ^ "MariaDB 10.3.0 Release Notes". Archived from the original on 24 April 2017. Retrieved 2017-04-23.
- ^ أ ب ت "MariaDB 10.11.3, 10.10.4, 10.9.6, 10.8.8, 10.6.13, 10.5.20, 10.4.29 and 10.3.39 now available". mariadb.org. 10 May 2023. Archived from the original on 10 May 2023. Retrieved 2023-03-20.
- ^ "MariaDB 10.4.0 Release Notes". Archived from the original on 17 February 2019. Retrieved 2018-11-15.
- ^ "MariaDB 10.4.34 Release Notes". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2024-05-17.
- ^ "MariaDB 10.5.0 Release Notes". Archived from the original on 8 August 2019. Retrieved 2019-08-08.
- ^ "MariaDB 10.5.29 Release Notes". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2025-02-05.
- ^ "MariaDB 10.6.0 now available". 26 April 2021. Archived from the original on 26 April 2021. Retrieved 2021-04-26.
- ^ "MariaDB 10.6.24 Release Notes". mariadb.com (in الإنجليزية الأمريكية). 2025-11-06. Retrieved 2025-11-07.
- ^ "10.7.0 Comes As Preview Releases". 17 September 2021. Archived from the original on 9 November 2021. Retrieved 2021-09-17.
- ^ "MariaDB 10.8.0 preview releases now available". 22 December 2021. Archived from the original on 14 February 2022. Retrieved 2022-02-14.
- ^ "MariaDB 10.9.0 preview releases now available". 23 March 2022. Archived from the original on 24 March 2022. Retrieved 2022-05-23.
- ^ أ ب "MariaDB 11.1.3, 11.0.4, 10.11.6, 10.10.7, 10.6.16, 10.5.23, 10.4.32 now available". mariadb.org. 14 Nov 2023. Archived from the original on 27 November 2023. Retrieved 2023-11-21.
- ^ "MariaDB 10.10.0 preview releases now available". 23 June 2022. Archived from the original on 23 June 2022. Retrieved 2022-06-23.
- ^ "MariaDB 10.10.0 preview release now available". 26 September 2022. Archived from the original on 7 December 2022. Retrieved 2022-09-26.
- ^ "MariaDB 10.11.15 Release Notes". mariadb.com (in الإنجليزية الأمريكية). Retrieved 2025-11-06.
- ^ أ ب "MariaDB 11.0 – new optimizer, new major version series". 27 December 2022. Archived from the original on 27 December 2022. Retrieved 2022-12-27.
- ^ "MariaDB 11.0.6 Release Notes". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2024-05-17.
- ^ "MariaDB 11.1.6 Release Notes". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2024-08-22.
- ^ Gilfillan, Ian (2023-06-26). "MariaDB 11.2.0 preview release available". MariaDB.org (in الإنجليزية الأمريكية). Archived from the original on 26 June 2023. Retrieved 2024-08-22.
- ^ "MariaDB 11.2.6 Release Notes". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2024-11-15.
- ^ Gilfillan, Ian (2023-09-20). "MariaDB 11.4.0 preview release now available". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2024-08-22.
- ^ "MariaDB 11.4.9 Release Notes". mariadb.com (in الإنجليزية الأمريكية). 2025-11-06. Retrieved 2025-11-07.
- ^ Arnö, Kaj (2025-02-12). "MariaDB 11.8 is LTS". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2025-04-05.
- ^ "MariaDB 11.8.5 Release Notes". mariadb.com (in الإنجليزية الأمريكية). Retrieved 2025-11-17.
- ^ Gebhardt, Ralf (2025-08-07). "Announcing MariaDB Community Server 12.0 GA". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2025-10-06.
- ^ "MariaDB 12.0.2 Release Notes". MariaDB.com (in الإنجليزية الأمريكية). Retrieved 2025-06-05.
- ^ Gilfillan, Ian (2025-08-07). "Release Notes - MariaDB 12.1 Rolling Releases". MariaDB.org (in الإنجليزية الأمريكية). Retrieved 2025-10-06.
- ^ "MariaDB 12.1.1 Release Notes". MariaDB.com (in الإنجليزية الأمريكية). Retrieved 2025-06-05.
- ^ "Features / Replace MySQL with MariaDB". Archived from the original on 21 February 2016. Retrieved 17 September 2014.
- ^ Colin Charles (5 April 2013). "MariaDB now in OpenBSD ports tree". MariaDB blog. Retrieved 4 March 2017.
- ^ "Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7". MariaDB KnowledgeBase. Archived from the original on 5 September 2019. Retrieved 2019-09-07.
- ^ "MariaDB versus MySQL - Compatibility". MariaDB KnowledgeBase. Retrieved 2024-03-27.
- ^ Carey, Scott (28 February 2018). "How ServiceNow deploys MariaDB to handle 25 billion queries per hour". Computerworld. Archived from the original on November 1, 2019.
- ^ "MariaDB Use Case: DBS Bank – ODBMS.org" (in الإنجليزية الأمريكية). Retrieved 2022-03-01.
- ^ Clark, Jack (12 Sep 2013). "Google swaps out MySQL, moves to MariaDB". www.theregister.co.uk. Archived from the original on 28 August 2017. Retrieved 4 September 2017.
- ^ "MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation". Mozilla IT. Archived from the original on September 4, 2014. Retrieved 17 September 2014.
- ^ "Wikipedia Adopts MariaDB". Wikimedia Foundation. 2013-04-22. Archived from the original on 26 December 2018. Retrieved 23 April 2013.
- ^ "Distributions Which Include MariaDB". MariaDB Corporation. Archived from the original on 26 January 2018. Retrieved 25 January 2018.
- ^ "MariaDB replaces MySQL in repositories". Arch Linux. Archived from the original on 10 May 2013. Retrieved 25 March 2013.
- ^ "Install Apache, MariaDB, PHP (LAMP) 2016". Manjaro. Archived from the original on 26 January 2018. Retrieved 25 January 2018.
- ^ "MariaDB Server Default in Debian 9". MariaDB Corporation. 19 June 2017.
- ^ "Features/ReplaceMySQLwithMariaDB". Fedora Project. Archived from the original on 21 February 2016. Retrieved 24 January 2013.
- ^ "Oracle who? Fedora & openSUSE will replace MySQL with MariaDB". ZDNet. 31 January 2013. Archived from the original on 23 December 2014. Retrieved 17 September 2014.
- ^ "7.0 Release Notes : Chapter 17. Web Servers and Services". Red Hat. Archived from the original on 26 January 2018. Retrieved 25 January 2018.
- ^ "Red Hat ditches MySQL, switches to MariaDB". Itwire.com. Archived from the original on 6 August 2013. Retrieved 2013-09-11.
- ^ "CentOS Product Specifications". CentOS. Archived from the original on 15 December 2020. Retrieved 25 January 2018.
- ^ "Mageia 2 Release Notes : MariaDB". Mageia. Archived from the original on 26 January 2018. Retrieved 25 January 2018.
- ^ "openSUSE 12.3 released with MariaDB as default". MariaDB Foundation. 15 March 2013.
- ^ "Release Notes : MariaDB Replaces MySQL". SUSE. Archived from the original on 4 August 2014. Retrieved 25 January 2018.
- ^ "The Slackware Linux Project: Slackware Release Notes". www.slackware.com. Archived from the original on 9 August 2022. Retrieved 13 September 2022.
- ^ "MariaDB now in OpenBSD ports tree". MariaDB Foundation. 5 April 2013. Archived from the original on 10 January 2017. Retrieved 9 January 2017.
- ^ "mariadb-server-10.0.16v0 – multithreaded SQL database (server)". OpenBSD ports. 2015-01-30. Archived from the original on 12 February 2015. Retrieved 2015-02-11.
- ^ "Switch from using MySQL to using MariaDB attempt #2". Archived from the original on 21 August 2018. Retrieved 28 September 2014.
- ^ Wikipedia moving from MySQL to MariaDB, 2012-12-17.
- ^ Wikipedia Adopts MariaDB
- ^ The Register 12 September 2013 Google swaps out MySQL, moves to MariaDB.
- ^ MariaDB Foundation to Safeguard Leading Open Source Database - MariaDB.org
- ^ 1 million euros pledged to new MariaDB Foundation - The H Open: News and Features
- ^ http://www.theregister.co.uk/2013/08/08/google_backs_mariadb/
- ^ http://www.zdnet.com/article/mariadb-gets-shot-in-the-arm-from-intel-led-20m-skysql-injection/
- ^ http://www.eib.org/infocentre/press/releases/all/2017/2017-114-investment-plan-for-europe-eib-supports-mariadb-with-financing-for-accelerated-growth.htm
للاستزادة
- Bartholomew, Daniel (2013). Getting Started with MariaDB. ISBN 9781782168096.
- Bartholomew, Daniel (2014). MariaDB Cookbook. ISBN 978-1-78328-440-5.
- Forta, Ben (2011). MariaDB Crash Course. Addison Wesley. ISBN 0-321-79994-1.
وصلات خارجية
- Official website

- MariaDB Foundation website
- MariaDB, the Backward Compatible Branch of MySQL(R) Database Server at YouTube – a lecture given by Monty Widenius at Google
- CS1 الإنجليزية الأمريكية-language sources (en-us)
- Short description is different from Wikidata
- Articles containing إنگليزية-language text
- Pages using Lang-xx templates
- MariaDB
- برمجيات 2009
- Client-server database management systems
- Cross-platform software
- Free database management systems
- MySQL
- Relational database management systems
- Relational database management software for Linux
- Software forks
- Software using the GNU General Public License
- Free software companies