MariaDB Database Management 10.4.7

06/11/2019 - MariaDB Foundation (Freeware)
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

MariaDB is a community-developed, commercially supported fork of the MySQL Relational Database Management System (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.

MariaDB intended to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands. However, new features diverge more. It includes new storage engines like Aria, ColumnStore, and MyRocks.

MariaDB Database Software

In December 2012 Michael Widenius, David Axmark, and Allan Larsson announced the formation of a foundation that would oversee the development of MariaDB.

Kaj Arno, current CEO of the MariaDB Foundation

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. 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. 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.

Simon 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.” On 1 October 2014, SkySQL Corporation AB changed its name to MariaDB Corporation AB to reflect its role as the main driving force behind the development of MariaDB Server and the biggest support-provider for it. MariaDB is a registered trademark of MariaDB Corporation AB, used under license by the MariaDB Foundation.

From January 2015 to September 2018, Otto Kekalainen was the CEO of the MariaDB Foundation. He stepped down effectively on 1 October of that year. Arjen Lentz was appointed CEO of the Foundation in October 2018, but resigned in December 2018. Kaj Arno joined as the CEO on 1 February 2019. Eric Herman is the current Chairman of the Board.

MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com, and Google.

It turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins, and many other tools that make it very versatile for a wide variety of use cases.

The app is developed as open-source software and as a relational database, it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features.

MariaDB Database Software Features

MariaDB provides the same features of MySQL with some extensions. It is relatively new and advances.

Following is a list of features of MariaDB:
  • MariaDB is licensed under GPL, LGPL, or BSD.
  • MariaDB includes a wide selection of storage engines, including high-performance storage engines, for working with other RDBMS data sources.
  • MariaDB uses a standard and popular querying language.
  • MariaDB runs on a number of operating systems and supports a wide variety of programming languages.
  • MariaDB offers support for PHP, one of the most popular web development languages.
  • MariaDB offers Galera cluster technology.
  • MariaDB also offers many operations and commands unavailable in MySQL and eliminates/replaces features impacting performance negatively.

MariaDB Server began its life as a fork of MySQL, inheriting the strong performance and the legacy Relational DBMS capabilities that made the ecosystem so popular in the first place. In the years since this fork, differences have begun to emerge between these platforms, as It has advanced as a leader in its own right.

mariadb-data-table

These differences translate into advantages, many of which are specific to users, including enhancements to the optimizer, window functions, system and application-time period versioned tables, replication and clustering support, and support for new storage engines like ColumnStore, MyRocks, Spider, and Aria.

In the interest of providing a superior product, the Server utilizes its own testing suite for evaluating new features and patches. This suite includes many more tests and bugs found in these tests are fixed before the code ships. Furthermore, the tests are run against several configurations of Maria DB Server 64 bit, to better test the feature in different environments, and are not run when the feature is not available in the given configuration.

It includes a number of new features and extensions. When the community submits patches or features that are found to be useful, safe, and stable, every effort is made to integrate them with and include in the program.

The list of clients compatible with includes Database Workbench, DBEdit, HeidiSQL, Navicat, phpMyAdmin, and SQLyog. As far as web applications are concerned, official support is provided by Drupal, ERP5, Kajona, MediaWiki, and Moodle.

The developers have their own security patches, in addition to those supplied by MySQL. Critical security issues are rapidly identified, resolved and distributed with new versions of the database server. Details about them are usually made available to the public after the latest editions of MariaDB and MySQL are published. Download MariaDB On Linux Os.

 

MariaDB_Windows_Mainscreen

Comparison of MariaDB And MySQL Database Software

Features MariaDB MySQL
Description MySQL application compatible open-source RDBMS, enhanced with high availability, security, interoperability and performance capabilities. With MariaDB ColumnStore a column-oriented storage engine is available too. Widely used opensource RDBMS
Primary Database Model Relational DBMS Relational DBMS
Secondary database models Document store
Graph DBMS
Document Store
DBaaS offerings (sponsored links)
  • MariaDB Managed Service: A customized MariaDB deployment fully managed by the experts at MariaDB in the cloud of your choice. Keeps you up to date with features, upgrades, hotfixes and security patches.
  • Azure Database for MariaDB: A fully managed, scalable MariaDB relational database with high availability and security built-in at no extra cost
  • Google Cloud SQL: A fully-managed database service for the Google Cloud Platform
  • Azure Database for MySQL: A fully managed, scalable MySQL relational database with high availability and security built in at no extra cost
Implementation of Languages C and C++ C and C++
Server operating systems FreeBSD, Linux, Solaris, Windows FreeBSD, Linux, OS X, Solaris, Windows
Data scheme Yes Yes
XML Support Yes Yes
Secondary Index Yes Yes
APIs and other access methods Proprietary native API, ADO.NET, JDBC, ODBC Proprietary native API, ADO.NET, JDBC, ODBC
Supported Programming Laguages Ada, C, C#, C++, D, Eiffel, Erlang Go, Haskell, Java, JavaScript(Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl Ada, C, C#, C++, D, Eiffel, Erlang Go, Haskell, Java, JavaScript(Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl
Server Side Script Yes Yes
Triggers Yes Yes
Partitioning methods Horizontal partitioning, sharding with Spider storage engine or Galera cluster Horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric
Replication Method Master-master replication Master-master replication
MapReduce No No
Consistency concepts Immediate Consistency Immediate Consistency
Foreign keys Yes Yes
Transaction Concept ACID ACID
Concurrency Yes Yes
Durability yes yes
In-memory capabilities yes yes
User concepts fine-grained access rights according to SQL-standard Users with fine-grained authorization concept

System Requirements

Processor Intel Core Processor
RAM 512 MB RAM
Operating System Windows 7, Windows 8, Windows 10, Linux OS

Technical Specification

Software Name MariaDB Database Software V 10.4.7
File Size Windows: 53.3 MB Linux: 308 MB
Language English
License Free
Developer MariaDB Foundation

Add a Comment

Your email address will not be published. Required fields are marked *