Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

What is the difference between MySQL and MariaDB database?

Tags:

mysql

relational-database

mariadb

xampp

I have been using XAMPP for a long time and was surprised that XAMPP has switched to MariaDB from MySQL.

https://www.apachefriends.org/index.html

How will this change impact on existing developers using MySQL? For example, can existing development tools for MySQL work seamlessly with MariaDB? What are notable difference between MySQL and MariaDB that developers need to take note?

I am not sure if it is advisable to upgrade XAMPP version because of this database change. I am worried of the migration of data from MySQL to MariaDB.

like image 991
guagay_wk Avatar asked Dec 08 '15 08:12

guagay_wk

People also ask

Which database is better MariaDB or MySQL?

Generally speaking, MariaDB shows improved speed when compared to MySQL. In particular, MariaDB offers better performance when it comes to views and handling flash storage through its RocksDB engine. MariaDB also outperforms MySQL when it comes to replication.

How is MariaDB different from MySQL?

MariaDB has 12 new storage engines, whereas MySQL has lesser storage engines. MariaDB has a larger connection pool supporting up to 200,000+ connections, whereas MySQL has a smaller connection pool. Comparing MariaDB vs MySQL performance, In MariaDB, replication is faster, whereas in MySQL, replication is slower.

Is MariaDB a MySQL database?

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its ...

Why is MariaDB called MySQL?

The name MySQL (just like the MyISAM storage engine) comes from Monty's first daughter My. The first part of 'MySQL' is pronounced like the English adjective, even if this doesn't match the correct pronunciation of the Finnish name. MariaDB continues this tradition by being named after his younger daughter, Maria.

1 Answers

"For example, can existing development tools for MySQL work seamlessly with MariaDB?"

A common development tool for MySQL is MySQL Workbench. MySQL Workbench may not support MariaDB.

See this: MySQL Workbench 6.3.5 crashes when opening XAMPP MySQL local database

Another one here: MySQL Workbench incompatible/nonstandard server

Having said that, there are other options to MySQL Workbench (a good alternative is HeidiSQL for example, which works great by the way with the local MariaDB install by XAMPP).

But all of this is minor I believe, for the most part the move to MariaDB is painless and you won't notice any difference. The great thing is that there always seems to be good information online about anything you might run into anyway. I wouldn't worry much at all about "the migration of data from MySQL to MariaDB."

(Curious if user1824987 made the move and if so if they found any way they were impacted by it.)

like image 60
C0MPU7ER Avatar answered Nov 12 '22 19:11

C0MPU7ER
Sign in to Comment

Related questions

Updating millions of records on inner joined subquery - optimization techniques
Is it possible to get InnoDB internal row ID?
MySql - What happens when i update with 'and'
mySQL: utf8 charset on index table and duplicate key error
How to repair, or drop/create a corrupted table in mysql?
What is the best approach to sort MySQL table rows by user choice?
ASP.NET-Identity limit UserNameIndex length
Vagrant SSH - Setting up and connecting to MySQL
Laravel Crypt - Comparing Values
How do I automatically clear output in MySQL workbench?
How to display data from mysql using angular.js PHP?
After DB version change, index won't be used automatically
Alter the LAST_INSERT_ID() from within a TRIGGER in MySQL
A strange deadlock in Mysql
Retrieve image from mysql-php(android)
Select 2 rows from table 1(with UNION) if pair doesn't exist in table 2
How can i query two different tables in mysql
Long running mysql "cleaning up" transaction
MySQL Workbench Connection Encoding
How to log queries to stdout on MySQL?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!