Server and Client
The server package will install the database server (Mysql / MariaDB) with which you can interact using a client. You can use the client to send commands to any server; on a remote computer or your own computer.
The server is used to persist the data and provide a query interface to it (SQL).
The purpose of the client is to allow you to use this query interface. The client package also comes with utilities that enable easy backup and restore of data and server administration.
MariaDB and MySQL
They are not the same, they are very similar / are always associated , perhaps because most commonly MariaDB is referred to a continuation of MySQL and because the other factor in the database is related to the same MySQL founder (and the names of his children). There are a number of differences between the two, in addition to the licenses.
MariaDB is a binary drop-in earlier than MySQL . What this means is:
- Data definition tables and tables ( .frm ) are binary-compatible.
- All APIs , client structures and protocols are identical.
- All file names, binaries, paths, ports, sockets, and so on must be the same.
- All MySQL connectors work unchanged with MariaDB.
- The mysql-client package also works with the MariaDB server.
In most common practice scenarios, MariaDB version 5.x.y
will work just like MySQL 5.x.y
, since MariaDB follows the MySQL version, that is, the version number is used to indicate with which version of MySQL it is compatible .
MariaDB originated as a fork of MySQL by Michael Monty Widenius, one of the original MySQL developers and co-founder of MySQL Ab. The MariaDB Foundation
The main motivation on the part of MariaDB was to provide a FLOSS of MySQL, in case Oracle becomes fully corporate with MySQL. It should be noted that Monty was against the acquisition of MySQL (via Sun's acquisition) by Oracle:
I want to ensure that the MySQL code base (under the name of MariaDB) will survive as open source , despite what Oracle can do. ¹
Although MariaDB is supposed to be compatible with MySQL, for one reason or another some compatibility and different features :
- MariaDB includes all popular open source engines, there is no InnoDB, the XtraDB to> acting as a drop-in replacement,
-
MariaDB claims several speed improvements over MySQL, and
-
There are some new FLOSS extensions that MySQL does not have.
MariaDB also claims to be full SQL99 , just like MySQL, so there should be no differences in queries.
Curiosity
The names of the databases are closely related to the names of Monty's children, one bank for Maria (MariaDB), one for My (MySQL) and one for her child Max (MaxDB). What father does this for his daughters?
Sources