mysql 5.7 support
Opened this issue · 0 comments
mysql 5.7 deprecates information_schema in favor of performance_schema for global_variables. This affects:
mysql_run -Q -sw -O $MYSQL $MYSQL_OPTIONS_REPL -BN -e "select replace(var\ iable_value,'\n','') as variable_value from information_schema.global_variables\ where variable_name in ('gtid_executed')" > $slave_status_file
And
mysql_run -Q -sw -O $MYSQL $MYSQL_OPTIONS_REPL -BN -e "select variable_name,\ replace(variable_value,'\n','') as variable_value from information_schema.globa\ l_variables where variable_name in ('server_uuid','gtid_executed')" > $master_s\ tatus_file
information_schema.global_variables is deprecated in favor of performance_schema.global_variables. See http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_show_compatibility_56.
This is reflected in the logs by the following entry:
mysql_prm_gtid(p_mysql)[10769]: 2016/09/02_13:24:44 ERROR: ERROR 3167 (HY000) at line 1: The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
Additionally, the grep on this warning doesn't work anymore:
echo "$error" | egrep -v '^Warning: Using a password on the command line'\
See how mysql client 5.7 prints the warning:
mysql: [Warning] Using a password on the command line interface can be insecure.
Which makes the grep ineffective, which means a lot of spam in the logs.
Besides these two minor things, we haven't found any other problems using 5.7.
Last but not least: Thanks for the great work!!