Skip to content

Instantly share code, notes, and snippets.

@hden

hden/my.cnf

Created October 26, 2018 09:13
Show Gist options
  • Save hden/b4508e0125b53d6a7c8f5566dc114cd3 to your computer and use it in GitHub Desktop.
Save hden/b4508e0125b53d6a7c8f5566dc114cd3 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL best practice for data analysis.
Raw
my.cnf
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
# Enabling the binlog
binlog_format = row
binlog_row_image = full
# Starting with MySQL 5.6 row based replication can be configured to include the original SQL statement with each binlog event.
binlog_rows_query_log_events = on
# Enforce real UTF-8.
# See https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
# As long as possible.
expire_logs_days = 10
# GTIDs, not necessary if you're using AWS Aurora.
gtid_mode = on
enforce_gtid_consistency = on
[mysqldump]
# Prevents you from blowing memory when dumping large tables.
quick
quote_names
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment