mysql 5.7 support

[wochjop]

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!!