What is the difference between mysql-server and mysql-client?

7

It is said that using the apt-get install mariadb-server command would also install mariadb-cliente .

I understand that the server can be said to be where the data persists, however I lack an understanding of the client .

If applicable, is Mysql and Mariadb the same?

    
asked by anonymous 15.09.2017 / 15:49

2 answers

10

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

15.09.2017 / 16:06
6

While the Mysql-server is where the data is stored, it is in fact the database, Mysql-client, for you to connect to, and manage the databases (mysql-servers), be they local or even remote.

Mariadb, was created by the same creator of MySQL, is a fork MySQL, so there is a lot of compatibility, however, they are different DBMS

    
15.09.2017 / 16:04