MySQL - Revision history

Fturco: replace http:// with https://

2026-05-03T09:11:30Z

replace http:// with https://

← Older revision		Revision as of 09:11, 3 May 2026
Line 315:		Line 315:
	For more info, see:		For more info, see:
	* https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility		* https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility
	* ~~http~~://qgqlochekone.blogspot.com/2020/04/mariadb-mysql-and-mysqlworkbench.html		* https://qgqlochekone.blogspot.com/2020/04/mariadb-mysql-and-mysqlworkbench.html

	[[Category:Newbie]]		[[Category:Newbie]]

Greenman: /* MariaDB vs MySQL */ copyedit, remove dubious claims

2025-03-11T23:25:03Z

MariaDB vs MySQL: copyedit, remove dubious claims

← Older revision		Revision as of 23:25, 11 March 2025
Line 276:		Line 276:
	= MariaDB vs 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".		It is more a matter of compatibility than of performance and characteristics 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.		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.

	~~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, Percona Server, which is the same MySQL service but with special aggressive optimization patches for servers. Percona mysql code must be compiled in Alpine linux.

	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 be compiled in Alpine linux.

	== Comparison table ==		== Comparison table ==

Greenman: /* Comparison table */ temporal

2025-03-11T23:21:25Z

Comparison table: temporal

← Older revision		Revision as of 23:21, 11 March 2025
Line 303:		Line 303:
	\|-		\|-
	\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes		\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes
			\|-
			\| Temporal tables \|\| yes \|\| no
	\|-		\|-
	\| Monitoring \|\| SQLyog \|\| MySQLworkbench		\| Monitoring \|\| SQLyog \|\| MySQLworkbench
Line 308:		Line 310:
	\| Routing \|\| MariaDB MaxScale \|\| MySQL Router		\| Routing \|\| MariaDB MaxScale \|\| MySQL Router
	\|-		\|-
	\| Analytics \|\| MariaDB ColumnStore \|\| ~~not have~~		\| Analytics \|\| MariaDB ColumnStore \|\| no
	\|-		\|-
	\| Git starred times (~~github~~)\|\| [https://github.com/MariaDB/server around 5.9k] \|\| [https://github.com/mysql/mysql-server around 11.2k]		\| Git starred times (GitHub)\|\| [https://github.com/MariaDB/server around 5.9k] \|\| [https://github.com/mysql/mysql-server around 11.2k]
	\|}		\|}

Greenman: /* Comparison table */

2025-03-11T23:19:42Z

Comparison table

← Older revision		Revision as of 23:19, 11 March 2025
Line 295:		Line 295:
	\|-		\|-
	\| Performance \|\| just a little faster \|\| less, there is almost no difference		\| Performance \|\| just a little faster \|\| less, there is almost no difference
			\|-
			\| Vectors \|\| Yes, from MariaDB 11.7 \|\| Enterprise-only
	\|-		\|-
	\| Initial version \|\| 2009 (5.3) \|\| 1995 (3.0)		\| Initial version \|\| 2009 (5.3) \|\| 1995 (3.0)
	\|-		\|-
	\| Data masking \|\| no \|\| ~~yes (~~Enterprise only)		\| Data masking \|\| no \|\| Enterprise-only
	\|-		\|-
	\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes		\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes

Greenman: /* Comparison table */ around 10

2025-03-11T23:18:14Z

Comparison table: around 10

← Older revision		Revision as of 23:18, 11 March 2025
Line 292:		Line 292:
	! Characteristic !! MariaDB !! MySQL		! Characteristic !! MariaDB !! MySQL
	\|-		\|-
	\| Storage Engines \|\| ~~up to 12~~ but ~~many~~ in development stage \|\| less but well tested		\| Storage Engines \|\| ~10, but some in development stage \|\| less but well tested
	\|-		\|-
	\| Performance \|\| just a little faster \|\| less, there is almost no difference		\| Performance \|\| just a little faster \|\| less, there is almost no difference

Greenman: /* MariaDB vs MySQL */ clarify, copyedit

2025-03-11T23:16:15Z

MariaDB vs MySQL: clarify, copyedit

← Older revision		Revision as of 23:16, 11 March 2025
Line 298:		Line 298:
	\| Initial version \|\| 2009 (5.3) \|\| 1995 (3.0)		\| Initial version \|\| 2009 (5.3) \|\| 1995 (3.0)
	\|-		\|-
	\| Data masking \|\| no \|\| yes		\| Data masking \|\| no \|\| yes (Enterprise only)
	\|-		\|-
	\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes		\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes
Line 304:		Line 304:
	\| Monitoring \|\| SQLyog \|\| MySQLworkbench		\| Monitoring \|\| SQLyog \|\| MySQLworkbench
	\|-		\|-
	\| Routing \|\| MariaDB MaxScale \|\| ~~Mysql~~ Router		\| Routing \|\| MariaDB MaxScale \|\| MySQL Router
	\|-		\|-
	\| Analytics \|\| MariaDB ColumnStore \|\| not have		\| Analytics \|\| MariaDB ColumnStore \|\| not have

Greenman: /* MySQL (MariaDB) - Production usage */ copyedit

2025-03-11T23:13:31Z

MySQL (MariaDB) - Production usage: copyedit

← Older revision		Revision as of 23:13, 11 March 2025
Line 15:		Line 15:
	[https://mariadb.org/ MariaDB] is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.		[https://mariadb.org/ MariaDB] is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.

	This page ~~assumed~~ that you have a general knowledge about MariaDB, so if you are new to MySQL first take a look at the [[MariaDB\|MariaDB wiki page]] for information about how ~~are~~ packaged for ~~alpine linux~~.		This page assumes that you have a general knowledge about MariaDB, so if you are new to MySQL first take a look at the [[MariaDB\|MariaDB wiki page]] for information about how it is packaged for Alpine Linux.

	== Installation ==		== Installation ==

Greenman: /* Comparison table */

2025-03-11T23:04:41Z

Comparison table

← Older revision		Revision as of 23:04, 11 March 2025
Line 311:		Line 311:
	\|}		\|}

	For more info ~~check a review here~~: http://qgqlochekone.blogspot.com/2020/04/mariadb-mysql-and-mysqlworkbench.html		For more info, see:
			* https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility
			* http://qgqlochekone.blogspot.com/2020/04/mariadb-mysql-and-mysqlworkbench.html

	[[Category:Newbie]]		[[Category:Newbie]]

Greenman: /* Comparison table */ MariaDB has had since 5.3, in the previous decade :)

2025-03-11T23:02:42Z

Comparison table: MariaDB has had since 5.3, in the previous decade :)

← Older revision		Revision as of 23:02, 11 March 2025
Line 300:		Line 300:
	\| Data masking \|\| no \|\| yes		\| Data masking \|\| no \|\| yes
	\|-		\|-
	\| ~~dynamic~~ columns \|\| no \|\| yes		\| Dynamic columns \|\| [https://mariadb.com/kb/en/dynamic-columns/ yes] \|\| yes
	\|-		\|-
	\| Monitoring \|\| SQLyog \|\| MySQLworkbench		\| Monitoring \|\| SQLyog \|\| MySQLworkbench

Faust: rephrase and update GH stars

2025-03-11T22:05:20Z

rephrase and update GH stars

← Older revision		Revision as of 22:05, 11 March 2025
Line 1:		Line 1:
	MySQL is the most popular database ~~manager~~ in free software for two simple reasons (which are not the best technical reasons):		MySQL is the most popular relational database server in free software for two simple reasons (which are not the best technical reasons):
	# It's simple and very easy to use		# It's simple and very easy to use
	# It is very similar to SQLSERVER and is also used in other systems		# 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 compatibility and differences, but in short there's no great differences, if you have doubts check [[MySQL#MariaDB vs MySQL\|MariaDB vs MySQL section here]]		'''In the world of Linux Alpine there is a software that provides it''', it is [[MariaDB]], here we have a brief of info about compatibility and differences, but in short there's no great differences, if you have doubts check [[MySQL#MariaDB vs MySQL\|MariaDB vs MySQL section here]]

	'''In the wiki there are two approaches for its use''', the professional one (for servers and deploys) and the [[MariaDB\|fast and simple]] usage (for developers and/or enthusiasts):		'''In the wiki there are two approaches for its use''', the professional one (for servers and deploys) and the [[MariaDB\|fast and simple]] usage (for developers and/or enthusiasts):
Line 308:		Line 308:
	\| Analytics \|\| MariaDB ColumnStore \|\| not have		\| Analytics \|\| MariaDB ColumnStore \|\| not have
	\|-		\|-
	\| Git starred times (github)\|\| [https://github.com/MariaDB/server around 3.6k] \|\| [https://github.com/mysql/mysql-server around 6k]		\| Git starred times (github)\|\| [https://github.com/MariaDB/server around 5.9k] \|\| [https://github.com/mysql/mysql-server around 11.2k]
	\|}		\|}