Skip to content
Related Articles

Related Articles

Difference between MySQL and HBase

View Discussion
Improve Article
Save Article
  • Last Updated : 08 Jun, 2022

1. MySQL: MySQL is an open-source relational database management system based on Structured Query Language (SQL). It is developed and managed by oracle corporation and was initially released on 23 May 1995. It is widely being used in many small and large-scale industrial applications and is capable of handling a large volume of data. 

2. HBase: This model is used to provide random access to a large amount of structured data. It builds on the top of the Hadoop file system and is column-oriented in nature. It is used to store the data in HDFS. It is an open-source database that provides data replication. Three important components of HBase are HMaster, Region server, and Zookeeper. 

Difference between MySQL and HBase:

S. No.ParametersMySQLHBase
1.Data TypeMySQL manages Structured data.HBase manages Structured data, Unstructured data.
2.SQLIt requires Structured Query Language (SQL).It does not require Structured Query Language.
3.Database modelRelational Database Management System (RDBMS)Column-Oriented database
4.Secondary Database modelThe secondary database model supported is Document Store.No secondary database model is used.
5.Websitewww.mysql.comhbase.apache.org
6.Documentationdev.mysql.com/­dochbase.apache.org
7.Developed byOracle Apache Software Foundation 
8.Operating SystemThe operating systems supported by MySQL are Windows, macOS, Linux, Unix, AmigaOS, BSD, z/OS, and Android.The operating systems supported by HBase are Windows, macOS, Linux, Unix, BSD, and z/OS.
9.ACID propertyIt follows the ACID (Atomic, Consistency, Isolated, Durability) property.It doesn’t follow the ACID property.
10.Replication MethodsReplication methods used here are Master-Master Replication and Master-Slave Replication.The replication method used here is Master-Slave Replication.
11.ImplementationIt is implemented in C/C++ programming languages.It is implemented in the Java programming language.
12.Supported Programming LanguagesThe languages supported by MYSQL are C, C#, C++, Python, Ruby, Java, PHP, JavaScript, and others.The language supported by HBase is Java.
13.Amount of DataIt handles data in less volume.It handles data in high volume.
14.APIsAPIs and other access methods used by MySQL are ADO.NET, JDBC, and ODBC.APIs and other access methods used by HBase are JDBC.
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!