View source for MySQL

MySQL is the most popular database manager in free software for two simple reasons (which are not the best technical reasons):
# It's simple and very easy to use
# It is very similar to SQLSERVER and is also used in other systems

'''In the world of Linux Alpine there is a software that provides it''', it is the [[MariaDB]], here we have a brief of info about compatibiliti and differences, but in resume there's no great differences, if you have douobts check [[Mysql#MariaDB_vs_MySQL|MariaDB_vs_MySQL section here]]

'''In the wiki there are two approaches for its use''', [[Production_DataBases_:_mysql|the professional one]] (for servers and deploys) and the [[MariaDB|fast and simple]] usage (for developers and/or enthusiasts):

= MariaDB - fast and simple use =

{{:MariaDB}}

= MySQL (MariaDB) - Production usage =

{{:Production_DataBases_:_mysql}}

= MariaDB vs MySQL =

It is more a matter of compatibility than of performance and characteristics (with the arrival of MySQL v8) .. and it depends on whether there is a purely business and support approach "zero concern".

MySQL, being from Oracle, establishes limits if a license is not purchased, MariaDB has a large connection pool, more than 200,000 connections, while MySQL has a smaller connection pool if it is not licensed.

However, MariaDB does not support data masking and dynamic column while MySQL supports it, also MariaDB although it has 12 new storage engines while MySQL has less these are very new and MySQL's are widely known and tested.

In terms of performance, MariaDB is only a little faster than MySQL, this is because MySQL implements more business features, but this is only noticeable using these many features.

Which is more optimal this is not clear .. in general MySQL should be less, and MariaDB faster, there is a third option which is Percona which is the same MySQL service but with special aggressive optimization patches for servers. Percona mysql code must compile in Alpine linux.

== Comparison table ==

{| class="wikitable"
|-
! Characteristic !! MariaDB !! MySQL
|-
| Storage Engines || up to 12 but many in develop stage || less but well tested
|-
| Performance || just a little faster || less, there is almost no difference
|-
| Initial version  || 2009 (5.3) || 1995 (3.0)
|-
| Data masking || no || yes
|-
| dynamic columns || no || yes
|-
| Monitoring || SQLyog || MySQLworkbench
|-
| Routing || MariaDB MaxScale || Mysql Router
|-
| Analytics || MaraiDB ColumnStore || not have
|-
| Git vitoried times (gitlab/github)|| around 3k || around 4k
|}

For more info check a review here: http://qgqlochekone.blogspot.com/2020/04/mariadb-mysql-and-mysqlworkbench.html


[[Category:Newbie]]
[[Category:Server]]
[[Category:Database]]
[[Category:Development]]