installing mysql mariadb code example

Example 1: install mariadb

sudo apt update
sudo apt-get -y install mariadb-server
sudo systemctl start mariadb
sudo systemctl enable mariadb

Example 2: mariadb vs mysql

/* Differences Table
Parameter								MariaDB																												MySQL
Storage Engines							MariaDB has 12 new storage engines that you won't find in MySQL.													Fewer options for storage
Speed Improvements						MariaDB shows an improved speed when compared to MySQL.																Slower speed
Initial release							2009																												1995
Server operating systems				FreeBSD, Linux, Solaris, Windows																					FreeBSD, Linux, OS X, Solaris, Windows
Faster cache/indexes					An INSERT statement can be completed 24% faster																		Slower
Larger and Faster Connection Pool		Advanced thread pool capable of running faster and supporting up to 200,000+ connections.							Cannot support up to 200,000 connections per time.
Improved Replication					Safer and faster. Updates 2x faster																					Community edition allows a static number of threads to be connected. MySQL's enterprise plan comes with thread capabilities.
New Features/Extensions					Comes with new features and extensions including the JSON, WITH and KILL statements.								The new MariaDB features are not provided in MySQL.
Missing Features						Lacks some of the features provided by the MySQL enterprise edition. Offers alternative open-source plugins.		The Enterprise Edition of MySQL uses a proprietary code. Only users of MySQL Enterprise Edition have access to this.
Priority code							Doesn't allow access to this propriety content and is a closed source.												Uses some proprietary code in its Enterprise Edition.
Data Masking							No																													Yes
Dynamic columns							No																													Yes
Monitoring								SQLyog																												MySQL workbench
Routing									MariaDB MaxScale																									Mysql Router
Analytics								MariaDB ColumnStore																									No
Secondary database model				Document store and Graph DBMS																						Document store
Git hub stars							2.8 k																												4k
Forks									868																													1.6 K
Famous companies using					Nrise, Accenture, Docplanner, Grooveshark.																			Airbnb, Uber Technogloeis, Netflix, Dropbox.
*/