Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

MariaDB vs. MySQL

#1
When I made the shift to the LAMP stack -- well, actually the WAMP stack -- I ended up going to MariaDB for some rather obscure reasons, and while I've reviewed a variety of general articles comparing MySQL and MariaDB, I've not seen anything that makes me think one is a *generally* better choice than the other. 

Obviously everyone's mileage will vary, but I'm curious if there are any showstopper reasons why anyone on here has chosen one over the other for a project or beyond?
#2
I think the main value of the MariaDB project is to ensure that it remains free and open-source.
 
Wikipedia Wrote:Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009

It's similar to the situation when LibreOffice was created as a response to Oracle buying Sun Microsystems which gave them control over the OpenOffice project.
#3
Further to @Peter 's explanation, I heard that Oracle bought mySQL and it's now free software belonging to Oracle vs open source where every one contributes to the development of the software. The original developers - who were concerned about the sale of mySQL to Oracle in 2009 - created MariaDB as a fork of mySQL as open source database software under the GNU General Public License.

Since MariaDB has been created by the original developers of mySQL, they have succeeded in surpassing mySQL as a database that is more in demand. When MariaDB and mySQL are compared, MariaDB appears to be 24% faster than mySQL. Here is a comparison of MariaDB vs mySQL:
https://www.guru99.com/mariadb-vs-mysql.html#11

#4
My non-expert opinion based on very recent research has led me to understand it this way.
It all started with MySQL, but was ultimately bought by a competitor product. There were concerns about development and the company "promised" to continue it. However, the original guys behind MySQL eventually quit and started their own; MariaDB.
This last one has improvements and in "general" surpasses the capabilities of the former. However, the "rub" comes in third party support. MySQL has been around longer and thus you will find "easier" (as in more frequently) examples, code, etc than those for MariaDB.
So, from my perspective, if you have control/choice, I would go for MariaDB if you are intending to develop most of the code. If you are going to copy-paste, continue using "ready-made solutions" (LAMP/WAMP, etc), then you will find the journey less frustrating sticking with MySQL.
[-] The following 1 user Likes hgiova's post:
  • Genesis
#5
hgiova Wrote:This last one has improvements and in "general" surpasses the capabilities of the former. However, the "rub" comes in third party support. MySQL has been around longer and thus you will find "easier" (as in more frequently) examples, code, etc than those for MariaDB.

Most MySQL examples that concerns syntax would still work in MariaDB.
  




Users browsing this thread:
1 Guest(s)

MariaDB vs. MySQL392