MariaDB

from Wikipedia, the free encyclopedia
MariaDB

logo
Basic data

developer MariaDB Corporation ,
MariaDB Foundation
Publishing year October 29, 2009
Current  version 10.5.5
( August 10, 2020 )
Current preliminary version 10.5.3
operating system Microsoft Windows , macOS , Linux , Solaris , OpenBSD
programming language C , C ++ , Perl
category DBMS
License GNU General Public License , GNU Lesser General Public License
German speaking No
mariadb.com

MariaDB is a free , relational open source - database management system , which through a spin-off (Fork) from MySQL has emerged. The project was earlier MySQL's lead developer Michael Widenius initiated, which includes the Storage - Engine Aria developed on which MariaDB originally built (the software layer, which contains the base functionality of the database to create, read, modify, delete that data) .

Naming

Since Oracle holds the trademark rights to MySQL, new names had to be found for the database system and its storage engines. The name MariaDB goes back to Widenius ' younger daughter Maria; his other daughter My was already the namesake for MySQL.

distribution

Since the end of 2012, some Linux distributions have replaced MySQL with MariaDB as the standard installation, including Fedora , CentOS , openSUSE , Slackware and Arch Linux . The Wikimedia Foundation , which also provides the servers for Wikipedia , switched its productive systems to MariaDB in April 2013. This means that one of the world's largest web platforms has said goodbye to MySQL.

MariaDB users include:

MariaDB server

The MariaDB Enterprise Version is aimed at customers with business-critical applications. This is preconfigured for high-performance and secure operation and offers differentiated auditing, fast backups for large databases and end-to-end encryption for data on clusters.
The MariaDB Community Server, on the other hand, also contains features under development. Both versions are sold under an open source license, whereas Oracle only has the MySQL Community version under a free GPL variant. The MariaDB server can be used even without a support contract.
It is similar in functionality to the MySQL Enterprise version, e.g. B. an audit and thread pooling plug-in are included.

MariaDB Galera Cluster

Up to version MariaDB Server 10.0 there are two binary versions (with and without MariaDB Galera cluster support). Since MariaDB Server 10.1, Galera cluster support has been integrated as a high availability solution.

MariaDB ColumnStore

With a new ColumnStore, MariaDB offers a combination of a relational database with big data technologies. MariaDB ColumnStore works as a column-oriented storage engine and supports massive parallel query distribution and parallel loading of data. The publication took place as open source under GPL2, a fork based on InfiniDB and contributions from the open source community. MariaDB ColumnStore is ANSI SQL capable and enables the same queries, aggregations and functions as conventional SQL databases. In addition, ColumnStore can be used together with relational engines, so that a common use of traditional relational storage and column-oriented storage in a database is possible.

MariaDB-MaxScale

MariaDB-MaxScale is an application-to-database gateway that is used between client applications and databases. Its purpose is to improve database availability, security and scalability without changing the application. The MySQL Community awarded MaxScale the “Application of the Year 2016” award. The MySQL Community Awards are given annually to people and projects that support and expand the MySQL ecosystem.

Clustrix

In September 2018 it was announced that MariaDB would acquire Clustrix. With the purchase of Clustrix and the integration of their cluster processes, MariaDB is to be made available for scalable, distributed use in a short time. Instead of having to laboriously develop the necessary technology yourself, adjustments to APIs should suffice - at least MariaDB is already equipped for the connection of external database engines .

MariaDB Foundation

In December 2012, the former MySQL founders Michael Widenius, David Axmark and Allan Larsson founded the independent MariaDB Foundation. The foundation aims to protect the interests of the users and developers of MariaDB and to ensure that the free database remains free. The goals of the foundation also include improving database technology, including implementing standards and ensuring interoperability with other databases .

MariaDB Corporation

The main developer of the free database system is MariaDB Corporation. The company was founded by former MySQL developers under the name SkySQL and renamed MariaDB Corporation on October 1, 2014. The latest round of funding brought in $ 9 million, including from Intel Capital and California Technology Ventures . Michael Howard succeeds CEO Patrick Sallner, who left in mid-2015. MySQL and MariaDB creator Monty Widenius is the company's CTO. The company offers support, training and remote administration of MySQL and MariaDB databases. The company's business model is to use these services to obtain the financial resources to further develop the open source system. On February 26, 2018, the company announced the founding of MariaDB Labs as part of its international user conference M | 18 . Research into innovative database processes is to be carried out here. Initially, the cooperation with Intel is planned with the aim of developing a reference architecture for databases with distributed storage and server landscapes.

compatibility

The MariaDB and MySQL servers are not monolithic database servers such as B. PostgreSQL . These servers can be thought of as a framework for “pluggable engines”. Since MariaDB 10.2, both have used the identical InnoDB engine as the standard engine, which applications usually also use. The SQL dialect corresponds to "Standard SQL", and there are no essential differences between MySQL and MariaDB.

From the application point of view, MySQL can often be replaced by MariaDB without any problems, since there are hardly any incompatibilities for traditional functions. The InnoDB data files are compatible and thus interchangeable. For newer MySQL features, however, MariaDB may not yet offer a corresponding equivalent (e.g. geographical functions) or deliberately chose an incompatible implementation (e.g. GTID and JSON). The list of incompatibilities gets longer with each version.

In the classic storage of passwords and classic replication, MariaDB and MySQL are fully compatible, so that replications between MariaDB and MySQL can be set up without problems. When using new features of MariaDB and MySQL in these areas, however, incompatibilities arise on the administration side.

The internal processing of the Query Optimizer and Planner differ significantly, because Monty Widenius was disappointed with the MySQL 5.6 code. Based on his judgment, MariaDB decided to redesign the Query Optimizer, Query Planner and replication to achieve performance gains.

As of MariaDB Server 10.3, the compatibility with Oracle databases is increased. Stored procedures (Oracle PL / SQL ) and sequences can now also be created in the SQL syntax of the Oracle DB.

MariaDB servers can also be maintained and administered with MySQL Workbench .

Customer service

Similar to database systems from other manufacturers, MariaDB also offers commercial customer service ("corporation support") and advice as well as remote administration ("remote administration") of your database systems. Numerous kernel developers of the two free database systems MySQL and MariaDB are also active in customer service at MariaDB Corporation.

conference

The annual conference on the MariaDB database is OpenWorks . It took place in New York for the sixth time in 2019. There were more than 60 keynotes, workshops and sessions around MariaDB.

financing

Google supports the MariaDB Foundation . In 2013, MariaDB Corporation received more than $ 20 million from various companies. The EU invested around 25 million euros in MariaDB in 2017.

history

The MariaDB Foundation guarantees that each minor version number will receive a minimum of five years of maintenance . The publication date indicated below are doing the time of the first show back, not the general availability ( General Availability , GA), which a few weeks or months was later. Since version 5.5 is included in many Linux distributions whose maintenance ends after 2017, the support period for this version has been extended by three years by the MariaDB Foundation. The version jump from 5.5 to 10.0 is intended to take into account the fact that MariaDB will functionally remove itself from MySQL from version 10 onwards.

version Released on Support up Last version Description / note
Older version; no longer supported: 5.1 Oct 29, 2009 0Feb. 1, 2015 5.1.67 Initial split
Older version; no longer supported: 5.2 Apr 10, 2010 Nov 10, 2015 5.2.14 SphinxSE as a full text search engine ; Authentication via plugin
Older version; no longer supported: 5.3 July 26, 2011 01st Mar 2017 5.3.12 Subqueries ; GIS query operations
Older version; no longer supported: 5.5 Feb 25, 2012 Apr 11, 2020 5.5.68 Improved thread pooling; faster heap tables
Older version; no longer supported: 10.0 Nov 12, 2012 31 Mar 2019 10.0.38 Multisource replication ; Cassandra available as a NoSQL engine
Older version; still supported: 10.1 June 30, 2014 Oct 17, 2020 10.1.46 Table , tablespace and log encryption; Page Compression for InnoDB , XtraDB and FusionIO
Older version; still supported: 10.2 Apr 18, 2016 May 23, 2022 10.2.33
Older version; still supported: 10.3 April 16, 2017 May 25, 2023 10.3.24 Versionable tables; DBMS independent column compression
Older version; still supported: 10.4 0Nov 9, 2018 June 18, 2024 10.4.14 Automatic DoS and password cracking detection; Column orientation
Current version: 10.5 04th Dec 2019 June 24, 2025 10.5.5
Legend:
Older version; no longer supported
Older version; still supported
Current version
Current preliminary version
Future version

Web links

Individual evidence

  1. ↑ MariaDB 5.1.38 Release Notes . October 29, 2009 (accessed February 5, 2019).
  2. ↑ mariadb.org . August 11, 2020.
  3. ↑ MariaDB 10.5.3 Release Candidate now available ( English ) MariaDB.org. Retrieved May 13, 2020.
  4. ↑ a b mariadb.org .
  5. ↑ mariadb.com .
  6. ↑ mariadb.com .
  7. ↑ The mariadb Open Source Project on Open Hub: Languages ​​Page (English) . (accessed July 25, 2018).
  8. ↑ The MariaDB Open Source Project on Open Hub: Languages Page . In: Open Hub . (English, accessed July 24, 2018).
  9. ↑ mariadb.com .
  10. ↑ mariadb.com .
  11. ↑ mariadb.com .
  12. ↑ askmonty.org Why is the project called MariaDB?
  13. ↑ The History of MySQL and MariaDB - Keynote by Kaj Arnö. Retrieved January 2, 2016 .
  14. ↑ Mirko Lindner: Slackware switches to MariaDB. In: pro-linux.de . Mirko Lindner, March 25, 2013, accessed April 7, 2013 .
  15. ↑ Christian Kirsch: Wikipedia changes from MySQL to MariaDB. In: Heise online . April 23, 2013, accessed April 24, 2013 .
  16. ↑ Martin Schindler: Wikipedia moves from MySQL to MariaDB. In: silicon.de. NetMediaEurope, December 18, 2012, p. 1 , accessed April 7, 2013 .
  17. ^ Bartlomiej Piotrowski: MariaDB replaces MySQL in repositories. In: archlinux.org/news. Arch Linux , March 25, 2013, accessed September 11, 2013 .
  18. ↑ http://packages.debian.org/stretch/default-mysql-server
  19. ↑ Oracle who? Fedora & openSUSE will replace MySQL with MariaDB January 31, 2013
  20. ^ Distributions Which Include MariaDB. In: mariadb.com. Retrieved August 9, 2018 .
  21. ^ Jack Clark: Google swaps out MySQL, moves to MariaDB. In: The Register. September 12, 2013, accessed July 20, 2017 .
  22. ↑ MySQL 5.1 vs. MySQL 5.5: Floats, Doubles, and Scientific Notation , January 17, 2013
  23. ↑ NetSuite OpenAir Enhancements April 16, 2016. In: NetSuite OpenAir. Retrieved July 20, 2017 (English).
  24. ↑ mariadb-server-10.0.16v0 - multithreaded SQL database (server). In: OpenBSD ports. January 30, 2015, accessed July 20, 2017 .
  25. ↑ Switch from using MySQL to using MariaDB attempt # 2. In: marc.info. September 13, 2014, accessed July 20, 2017 .
  26. ↑ openSUSE Dumps MySQL Makes MariaDB Default Database ( Memento from May 10, 2013 in the Internet Archive ).
  27. ↑ Red Hat ditches MySQL, switches to MariaDB. In: Itwire.com. Retrieved September 11, 2013 .
  28. ↑ SaltOS sees gains with subqueries in MariaDB. In: mariadb.com. MariaDB Foundation, accessed August 9, 2018 .
  29. ↑ Slackware News - '' Slackware switching to the MariaDB database ''. Slackware.com, March 23, 2013, accessed April 16, 2013 .
  30. ↑ https://launchpad.net/ubuntu/trusty/+source/mariadb-5.5
  31. ↑ Wikipedia Adopts MariaDB. In: blog.wikimedia.org. Wikimedia Foundation , April 22, 2013, accessed September 29, 2013 .
  32. ^ Web of Trust (WOT) trusts the MariaDB upgrade. MariaDB Foundation, accessed September 29, 2013 .
  33. ↑ free and open-source web server solution stack for professional PHP development on the Windows. In: wpn-xm.org. MariaDB Foundation, accessed August 9, 2018 .
  34. ↑ TeamSpeak3 replaces MySQL plug-in in favor of MariaDB. TeamSpeak Systems GmbH, September 30, 2014, accessed on September 3, 2014 (English).
  35. ^ New XAMPP with MariaDB
  36. ^ How Zimbra is Changing. In: blog.zimbra.com. Zimbra, accessed August 9, 2018 .
  37. ↑ Nirbhay Choubey: MariaDB 10.1.1: Galera support. In: mariadb.org. October 31, 2014, accessed February 28, 2016 .
  38. ↑ Andrea Held : MariaDB: Big Data Analytics Engine with ColumnStore. In: Informatik Aktuell . April 6, 2016, accessed June 1, 2017 .
  39. ↑ Rainald Menge-Sonnentag: MariaDB publishes a column-oriented database engine. In: Heise online. December 14, 2016, accessed June 1, 2017 .
  40. ↑ Security, high availability and scalability for MariaDB and MySQL ( Memento from April 22, 2016 in the Internet Archive ) MariaDB MaxScale
  41. ↑ Andrea Held: MySQL Community Awards: MariaDB MaxScale is named "Application of the Year 2016". In: Informatik Aktuell. April 22, 2016, accessed June 1, 2017 .
  42. ↑ https://www.heise.de/developer/meldung/MariaDB-strebt-nach-Skalierbarkeit-und-uebernehmen-dafuer-Clustrix-4170097.html
  43. ↑ https://www.informatik-aktuell.de/aktuelle-meldung/2018/september/mariadb-neue-cluster-options-und-wechsel-in-der-fuehrung.html
  44. ↑ MySQL founders start foundation for MariaDB. Retrieved October 11, 2016 .
  45. ↑ MariaDB press release. (No longer available online.) Archived from the original on October 11, 2016 ; accessed on October 11, 2016 (English).
  46. ↑ MariaDB Corporation receives fresh capital. Retrieved October 11, 2016 .
  47. ↑ Andrea Held: MariaDB: Remote DBA and Support. In: Informatik Aktuell. October 11, 2016, accessed June 1, 2017 .
  48. ↑ MariaDB Labs researches new database technologies. In: Informatik Aktuell. February 27, 2018, accessed February 28, 2018 .
  49. ^ Incompatibilities and Feature Differences Between MariaDB 10.3 and MySQL 5.7. Retrieved September 7, 2019 .
  50. ^ MariaDB versus MySQL - Compatibility. Retrieved September 7, 2019 .
  51. ↑ Lisa Griesmann: MariaDB TX 3.0. In: Informatik Aktuell. May 24, 2018. Retrieved May 25, 2018 .
  52. ↑ Section “MySQL Workbench and MariaDB” in the article “MySQL Workbench” in the Ubuntuusers.de Wiki
  53. ↑ https://mariadb.com/sites/default/files/MariaDB_Services_RemoteDBA.pdf MariaDB and MySQL Remote DBA
  54. ↑ MariaDB OpenWorks: Big conference on the open source database. In: Informatik Aktuell (magazine) . February 26, 2019, accessed February 26, 2019 .
  55. ↑ Gavin Clarke: Google sniffs at MySQL fork MariaDB: Yum. Have an engineer. In: The Register. August 8, 2013, accessed July 9, 2018 .
  56. ^ Toby Wolpe: MariaDB gets shot in the arm from Intel-led $ 20m SkySQL injection. In: ZDNet . CBS Interactive, October 23, 2013, accessed July 9, 2018 .
  57. ↑ Andrea Held: MariaDB: 25 million euros in funding from the European Investment Bank. In: Informatik Aktuell. May 8, 2017. Retrieved June 1, 2017 .
  58. ↑ Martin Schindler: EU invests 25 million euros in MariaDB. In: silicon.de. May 8, 2017. Retrieved June 1, 2017 .
  59. ↑ a b c Maintenance Policy ( English ) MariaDB.com. Retrieved July 25, 2018.
  60. ↑ Rasmus Johansson: Explanation on MariaDB 10.0 ( English ) MariaDB.org. August 13, 2012. Retrieved July 25, 2018.
  61. ↑ MariaDB 5.1.67 Release Notes ( English ) MariaDB.com. January 30, 2013. Retrieved July 25, 2018.
  62. ↑ MariaDB 5.2.14 Release Notes ( English ) MariaDB.com. January 30, 2013. Retrieved July 25, 2018.
  63. ↑ Changes & Improvements in MariaDB 5.2. MariaDB.com, accessed August 5, 2018 .
  64. ↑ MariaDB 5.3.12 Release Notes ( English ) MariaDB.com. January 30, 2013. Retrieved July 25, 2018.
  65. ↑ Changes & Improvements in MariaDB 5.3. MariaDB.com, accessed August 5, 2018 .
  66. ↑ https://mariadb.org/mariadb-10-4-13-10-3-23-10-2-32-10-1-45-and-5-5-68-now-available/ ( English ) mariadb.org. May 13, 2020. Accessed May 13, 2020.
  67. ↑ Changes & Improvements in MariaDB 5.5. MariaDB.com, accessed August 5, 2018 .
  68. ↑ MariaDB 10.0.38 Release Notes ( English ) MariaDB.com. January 31, 2019. Accessed April 6, 2020.
  69. ↑ Changes & Improvements in MariaDB 10.0. MariaDB.com, accessed August 5, 2018 .
  70. ↑ a b c d e MariaDB 10.5.5, 10.4.14, 10.3.24, 10.2.33 and 10.1.46 now available ( English ) mariadb.org. August 11, 2020. Accessed August 11, 2020.
  71. ↑ Changes & Improvements in MariaDB 10.1. MariaDB.com, accessed August 5, 2018 .
  72. ↑ Changes & Improvements in MariaDB 10.3. MariaDB.com, accessed August 5, 2018 .
  73. ↑ Plans for MariaDB 10.4. MariaDB.com, accessed August 5, 2018 .