GTID mode and mysql_upgrade. Prior to MySQL 5.6.7, mysql_upgrade could not connect to
a MySQL Server that was running with --gtid-mode=ON [2057] unless mysql_upgrade was run
with --write-binlog=OFF [255]. (Otherwise, mysqld had to be restarted with --gtid-mode=OFF
before running mysql_upgrade, then restarted with --gtid_mode=ON afterwards.) This is not
an issue in MySQL 5.6.7 and later, where mysql_upgrade runs with --write-binlog=OFF by
default. (Bug #13833710) However, it is not recommended to do so, since mysql_upgrade can make
changes to system tables that use the MyISAM storage engine, which is nontransactional.
... zobacz całą notatkę
Komentarze użytkowników (0)