MySQL 8 vs MariaDB 10.4

• FEDERATED
• MEMORY
• InnoDB
• Performance_Schema
• MyISAM
• MRG_MYISAM
• BLACKHOLE
• CSV
• ARCHIVE

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

Plugins (6)

• TokuDB
• RocksDB
• Spider
• Connect
• OQGRAPH
• Mroonga

• Group Replication (available as a plugin)
• MySQL Shell
• MySQL Router

• Galera 4 (available in a separate package)

• MySQL Router (GPLv2) [CE/EE]
• 3rd Party ProxySQL

• Maxscale (2.X versions are using the BSL licence)

• 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]

• 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

3rd Party

• Percona Server 5.7 and 8.0

3rd Party:

• Inexpensive Datamasking for MySQL with ProxySQL [CE]

3rd Party

• Percona Audit Log Plugin

• Mysqldump
• Mysqlpump
• MySQL Enterprise Backup [EE]
• The Clone Plugin (8.0.17)

3rd Party

• Percona XtraBackup [CE]
• Mydumper

• Mysqldump
• Mariabackup

3rd Party

• Mydumper

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

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