Skip to content
geeksforgeeks
  • Courses
    • DSA to Development
    • Get IBM Certification
    • Newly Launched!
      • Master Django Framework
      • Become AWS Certified
    • For Working Professionals
      • Interview 101: DSA & System Design
      • Data Science Training Program
      • JAVA Backend Development (Live)
      • DevOps Engineering (LIVE)
      • Data Structures & Algorithms in Python
    • For Students
      • Placement Preparation Course
      • Data Science (Live)
      • Data Structure & Algorithm-Self Paced (C++/JAVA)
      • Master Competitive Programming (Live)
      • Full Stack Development with React & Node JS (Live)
    • Full Stack Development
    • Data Science Program
    • All Courses
  • Tutorials
    • Data Structures & Algorithms
    • ML & Data Science
    • Interview Corner
    • Programming Languages
    • Web Development
    • CS Subjects
    • DevOps And Linux
    • School Learning
  • Practice
    • Build your AI Agent
    • GfG 160
    • Problem of the Day
    • Practice Coding Problems
    • GfG SDE Sheet
  • Contests
    • Accenture Hackathon (Ending Soon!)
    • GfG Weekly [Rated Contest]
    • Job-A-Thon Hiring Challenge
    • All Contests and Events
  • Databases
  • SQL
  • MySQL
  • PostgreSQL
  • PL/SQL
  • MongoDB
  • SQL Cheat Sheet
  • SQL Interview Questions
  • MySQL Interview Questions
  • PL/SQL Interview Questions
  • Learn SQL and Database
Open In App
Next Article:
Difference between SQLite and MariaDB
Next article icon

Difference Between MySQL and MariaDB

Last Updated : 18 Jun, 2024
Comments
Improve
Suggest changes
Like Article
Like
Report

MySQL and MariaDB are two popular relational database management systems (RDBMS) that share a common history but have evolved into distinct products with their own unique features and capabilities. Originally developed by MySQL AB, MySQL is now owned by Oracle Corporation, while MariaDB was forked from MySQL by its original developers. Both databases are widely used for managing structured data and are known for their performance, reliability, and scalability. This article explores the key differences between MySQL and MariaDB, helping you understand their origins, feature sets, performance and characteristics.

Introduction to MySQL and MariaDB

MySQL

MySQL is an open-source relational database management system(RDBMS) based on Structured Query Language (SQL). It is developed and managed by oracle corporation and initially released on 23 may, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data. After the acquisition of MySQL by Oracle, some issues happened with the usage of the database and hence MariaDB was developed.

MariaDB

MariaDB is an open source relational database management system (RDBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It is developed by MariaDB Foundation and initially released on 29 October 2009. MariaDB has a significantly high number of new features, which makes it better in terms of performance and user-orientation than MySQL.

Difference between MySQL and MariaDB:

S.NO.MySQLMariaDB
1.MySQL is written in C and C++ languages.MariaDB is written in C, C++, Perl and Bash languages.
2.It was initially released on 1995.It was initially released on 2009.
3.The performance of MySQL is not that great when compared to MariaDB.The performance of MariaDB is far better than MySQL.
4.It does not provide a replacement for MariaDB.It provides a drop-in replacement for MySQL.
5.Data masking is done in MySQL.There is no data masking.
6.Proprietary code is accessible in MySQL enterprise edition.Proprietary code is not accessible in MariaDB.
7.It does not support binary logs or temporary table Space.It supports temporary table Space and binary encryption.
8.It can not handle large-sized data easily.It can handle large-sized data easily.
9.Privilege checks are not that fast in MySQL.Privilege checks are done faster in MariaDB.
10.MySQL has 1600 forks .MariaDB has 868 forks.
11.Famous companies like Airbnb, Pinterest, Slack, Udemy, Twitter uses MySQL.Famous companies like CUNY, Accenture, Docplanner, Grooveshark, Northrop Grumman, uses MariaDB.
12.Server operating systems for MySQL are FreeBSD, Linux, OS X, Solaris, Windows i.e OS X is supported in MySQL as a server.Server operating systems for are FreeBSD, Linux, Solaris, Windows i.e OS X is not supported in MariaDB as a server.

Next Article
Difference between SQLite and MariaDB

V
VishwashVishwakarma
Improve
Article Tags :
  • DBMS
  • Difference Between
  • SQL
  • mysql

Similar Reads

  • Difference between SQLite and MariaDB
    1. SQLite : SQLite is a software library that provides relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system (DBMS) or requiring a database
    3 min read
  • Difference between Redis and MariaDB
    1. Redis : Redis stands for Remote Dictionary Server which is an in-memory data structure project implementing a distributed, in-memory key–value database with optional durability. Redis is developed by Redis labs and initially released on May 10, 2009. It is written in ANSI and C languages. Redis o
    2 min read
  • Difference between Oracle and MariaDB
    1. Oracle: Oracle is commercial software developed by Oracle Corporation. Oracle widely uses RDBMS. Oracle allows quick and safe store and retrieval of data. It is used for running Online Transaction Processing and Data Warehousing. Oracle runs on the most major operating systems like Mac OS, Unix,
    2 min read
  • Difference between MySQL and mSQL
    1. mSQL : Mini SQL, or mSQL, is a lightweight database engine designed to provide fast access to stored data with low memory requirements. As its name implies, mSQL offers a subset of SQL as its query interface. 2. MySQL : MySQL is an open-source relational database management system (RDBMS) based o
    2 min read
  • Difference between Neo4j and MariaDB
    1. Neo4j : Neo4j is most famous graph database management system and it is also a NoSQL database system developed by Neo4j, Inc. Neo4j is different from Mysql or MongoDB as it has its features that’s makes it special compared to other Database Management System. Neo4j stores and present data in form
    3 min read
  • Difference Between MongoDB and MariaDB
    When comparing MongoDB vs MariaDB, it is essential to understand their unique strengths and features. MongoDB is a document-oriented NoSQL database, ideal for flexibility and scalability with unstructured data. In respect, MariaDB is a relational database focused on MySQL compatibility by offering r
    4 min read
  • Difference between MySQL and IBM Db2
    1. MySQL : MySQL is an open-source relational database management system (RDBMS) based on Structured Query Language (SQL). It is developed and managed by oracle corporation and initially released on 23 May, 1995. It is widely being used in many small and large scale industrial applications and capab
    2 min read
  • Difference between MySQL and HBase
    In the world of database management systems, MySQL and HBase are two of the most popular options. MySQL is a traditional relational database management system, while HBase is a NoSQL, column-oriented database system that is specifically designed for big data applications. In this article, we will ex
    4 min read
  • Difference between PouchDB and MariaDB
    1. PouchDB : PouchDB is an open-source, NoSQL, in-line database. It is designed after CouchDB, which is a NoSQL database that powers npm. It is written in JavaScript language. There is no need to perform queries over the network as PouchDB resides inside the browser and thus it makes it extremely fa
    2 min read
  • Difference Between Hadoop and SQL
    Hadoop: It is a framework that stores Big Data in distributed systems and then processes it parallelly. Four main components of Hadoop are Hadoop Distributed File System(HDFS), Yarn, MapReduce, and libraries. It involves not only large data but a mixture of structured, semi-structured, and unstructu
    3 min read
geeksforgeeks-footer-logo
Corporate & Communications Address:
A-143, 7th Floor, Sovereign Corporate Tower, Sector- 136, Noida, Uttar Pradesh (201305)
Registered Address:
K 061, Tower K, Gulshan Vivante Apartment, Sector 137, Noida, Gautam Buddh Nagar, Uttar Pradesh, 201305
GFG App on Play Store GFG App on App Store
Advertise with us
  • Company
  • About Us
  • Legal
  • Privacy Policy
  • In Media
  • Contact Us
  • Advertise with us
  • GFG Corporate Solution
  • Placement Training Program
  • Languages
  • Python
  • Java
  • C++
  • PHP
  • GoLang
  • SQL
  • R Language
  • Android Tutorial
  • Tutorials Archive
  • DSA
  • Data Structures
  • Algorithms
  • DSA for Beginners
  • Basic DSA Problems
  • DSA Roadmap
  • Top 100 DSA Interview Problems
  • DSA Roadmap by Sandeep Jain
  • All Cheat Sheets
  • Data Science & ML
  • Data Science With Python
  • Data Science For Beginner
  • Machine Learning
  • ML Maths
  • Data Visualisation
  • Pandas
  • NumPy
  • NLP
  • Deep Learning
  • Web Technologies
  • HTML
  • CSS
  • JavaScript
  • TypeScript
  • ReactJS
  • NextJS
  • Bootstrap
  • Web Design
  • Python Tutorial
  • Python Programming Examples
  • Python Projects
  • Python Tkinter
  • Python Web Scraping
  • OpenCV Tutorial
  • Python Interview Question
  • Django
  • Computer Science
  • Operating Systems
  • Computer Network
  • Database Management System
  • Software Engineering
  • Digital Logic Design
  • Engineering Maths
  • Software Development
  • Software Testing
  • DevOps
  • Git
  • Linux
  • AWS
  • Docker
  • Kubernetes
  • Azure
  • GCP
  • DevOps Roadmap
  • System Design
  • High Level Design
  • Low Level Design
  • UML Diagrams
  • Interview Guide
  • Design Patterns
  • OOAD
  • System Design Bootcamp
  • Interview Questions
  • Inteview Preparation
  • Competitive Programming
  • Top DS or Algo for CP
  • Company-Wise Recruitment Process
  • Company-Wise Preparation
  • Aptitude Preparation
  • Puzzles
  • School Subjects
  • Mathematics
  • Physics
  • Chemistry
  • Biology
  • Social Science
  • English Grammar
  • Commerce
  • World GK
  • GeeksforGeeks Videos
  • DSA
  • Python
  • Java
  • C++
  • Web Development
  • Data Science
  • CS Subjects
@GeeksforGeeks, Sanchhaya Education Private Limited, All rights reserved
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy
Lightbox
Improvement
Suggest Changes
Help us improve. Share your suggestions to enhance the article. Contribute your expertise and make a difference in the GeeksforGeeks portal.
geeksforgeeks-suggest-icon
Create Improvement
Enhance the article with your expertise. Contribute to the GeeksforGeeks community and help create better learning resources for all.
geeksforgeeks-improvement-icon
Suggest Changes
min 4 words, max Words Limit:1000

Thank You!

Your suggestions are valuable to us.

What kind of Experience do you want to share?

Interview Experiences
Admission Experiences
Career Journeys
Work Experiences
Campus Experiences
Competitive Exam Experiences