diff options
author | Izorkin <izorkin@elven.pw> | 2020-05-07 22:47:56 +0300 |
---|---|---|
committer | Izorkin <izorkin@elven.pw> | 2020-05-14 17:29:40 +0300 |
commit | da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc (patch) | |
tree | 1b911d43e842c2c3a124af83327e51fb27bd7b28 /nixos/modules | |
parent | f52700fc146493fc185848200901b561e266cbda (diff) | |
download | nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.tar nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.tar.gz nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.tar.bz2 nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.tar.lz nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.tar.xz nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.tar.zst nixlib-da08b22e1aa4687f5e74f9bab2aedaf4fb018bdc.zip |
nixos/mysql-replication: ignore system databases in binary log
Diffstat (limited to 'nixos/modules')
-rw-r--r-- | nixos/modules/services/databases/mysql.nix | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/nixos/modules/services/databases/mysql.nix b/nixos/modules/services/databases/mysql.nix index 71b7afa3d39c..44183788d936 100644 --- a/nixos/modules/services/databases/mysql.nix +++ b/nixos/modules/services/databases/mysql.nix @@ -320,6 +320,7 @@ in log-bin-index = "mysql-bin-${toString cfg.replication.serverId}.index"; relay-log = "mysql-relay-bin"; server-id = cfg.replication.serverId; + binlog-ignore-db = [ "information_schema" "performance_schema" "mysql" ]; }) (mkIf (!isMariaDB) { plugin-load-add = optional (cfg.ensureUsers != []) "auth_socket.so"; @@ -445,7 +446,6 @@ in ( echo "stop slave;" echo "change master to master_host='${cfg.replication.masterHost}', master_user='${cfg.replication.masterUser}', master_password='${cfg.replication.masterPassword}';" - echo "set global slave_exec_mode='IDEMPOTENT';" echo "start slave;" ) | ${mysql}/bin/mysql -u root -N ''} |