MySQL vs MariaDB

 

MySQL License(==Subscription) by Oracle

연간 Enterprise 이용료가 150만원이나 하는 MySQL..

 

Oracle에 묶인게 맘에 들지 않았던 MySQL 개발자들이 뛰쳐나와 개발한 것이 MariaDB이다.

MySQL과 다르게 오픈소스로 Free Software (무료)다.

 

오늘은 같은듯 다른듯한 이 두 DB의 주요 차이점을 정리한다.

 

	MySQL	MariaDB
JSON type	support	not support but alias for JSON which is actually a LONGTEXT
Default Authentication	caching_sha2_password (using SHA-256) as default (after 8.0 version)	only use authentication through plugins
Oracle Compatibility	Basic compatibility	High level support
Encryption	redo/undo logs (when configured to do so) doesn't encrypt temporary tablespace or binary logs	support binary log encryption and temporary table encryption (Defaut)
Key Management	support many plugins but only available in Enterprise Edition	support AWS key management plugin
Sys Schema	include sys schema (help DBA and S/W Engineers interpret data collected by the Performance Schema). => used for optimazation, diagnosis	doesn't have enhancement included
Validate Password	Default support	doesn't
Super read-only	support super read-only mode.  read the document	Not Support
Invisible Columns	Not Support	allow creating columns which aren't listed int the results of a SELECT statement, nor assigned a value in INSERT statement when their name isn't mentioned in the statement
ThreadPool	Only Support in Enterprise	Support connection thread Pools, which are effective in where queries are relatively short and the load is CPU bound.

 

 

Performance Benchmark Test

InnoDB (MySQL 8.0) vs MyRocks (MariaDB 10.3.7)

using Sysbench 1.0.14

초당 쿼리수 MySQL (InnoDB 압승)

 

 

Conclusion

성능은 MySQL, 비용은 공짜인 MariaDB

그만 아라보자

 

 

---

🔗 Reference

MariaDB vs MySQL - Comparing MySQL 8.0 with MariaDB 10.3