MySQL 8 vs MariaDB 10.4



MySQL 8 MariaDB 10.4
Storage Engines
  • FEDERATED
  • MEMORY
  • InnoDB
  • Performance_Schema
  • MyISAM
  • MRG_MYISAM
  • BLACKHOLE
  • CSV
  • ARCHIVE
Default Installation (8)

  • CSV
  • MRG_MyISAM
  • MEMORY
  • Aria
  • MyISAM
  • SEQUENCE
  • InnoDB
  • PERFORMANCE_SCHEMA

Plugins (6)

  • TokuDB
  • RocksDB
  • Spider
  • Connect
  • OQGRAPH
  • Mroonga
Clustering Options InnoDB Cluster which consists of:

  • Group Replication (available as a plugin)
  • MySQL Shell
  • MySQL Router
MariaDB Galera Cluster:

  • Galera 4 (available in a separate package)
Routing & Proxy
  • MySQL Router (GPLv2) [CE/EE]
  • 3rd Party ProxySQL
  • Maxscale (2.X versions are using the BSL licence)
Security and Encryption (Data-at-Rest) Encryption

  • MySQL System Tablespace Encryption
  • General Tablespace Encryption
  • Undo log
  • Redo log
  • Binary and relay log encryption
  • Audit log
  • Keyring
    • keyring_file
    • keyring_encrypted_file [E]
    • keyring_okv [E]
    • keyring_aws [E]
    • HashiCorp Vault Keyring [E]
(TDE) Transparent Data Encryption

  • Everything including all tables
  • Individual tables
  • Everything, excluding individual tables

Key Management and Encryption Plugin

  • Data-at-rest with Encryption Key Management
  • File Key Management
  • AWS Key Management
  • Eperi Key Management
  • Plugin API
Security and Encryption
– HC Vault
In MySQL 8.0.18 available as an Enterprise plugin

3rd Party

  • Percona Server 5.7 and 8.0
MariaDB 10.4 has a feature request
Data Masking MySQL Enterprise Data Masking and De-Identification [EE only feature]

3rd Party:

  • Inexpensive Datamasking for MySQL with ProxySQL [CE]
Data masking by using MaxScale proxy
Auditing MySQL Enterprise Audit [EE]

3rd Party

  • Percona Audit Log Plugin
MariaDB Audit Plugin
Backup and Recovery
  • Mysqldump
  • Mysqlpump
  • MySQL Enterprise Backup [EE]
  • The Clone Plugin (8.0.17)

3rd Party

  • Percona XtraBackup [CE]
  • Mydumper
  • Mysqldump
  • Mariabackup

3rd Party

  • Mydumper
Key Default Variables innodb_autoinc_lock_mode=2

log_bin=ON

max_allowed_packet=64M

open_files_limit=10000

Query cache removed:
Check MySQL Blog

table_open_cache_instances=16

table_open_cache=4000

thread_cache_size=9

binlog_format=ROW

binlog_group_commit_sync_delay

DEPRECATED

log_slave_updates=ON

sync_binlog=1

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,
NO_ZERO_IN_DATE, NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_ENGINE_SUBSTITUTION

innodb_autoinc_lock_mode=1

log_bin=OFF

max_allowed_packet=16M

open_files_limit=4186

query_cache_type=off
But  query_cache_limit=1M

table_open_cache_instances=8

table_open_cache=2000

thread_cache_size=151

binlog_format=MIXED

innodb_locks_unsafe_for_binlog

log_slave_updates=OFF

sync_binlog=0

sql_mode=STRICT_TRANS_TABLES,
ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER,
NO_ENGINE_SUBSTITUTION

 

 

 

 

MySQL 8 vs MariaDB 10.4

 



You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *