最近一個電子看板小專案上線，由于資料庫非常小，而且資料也不太重要，因此未選擇XtraBackup備份，打算用AutoMySQLBackup來備份，結果部署后測驗發現，有一些小問題是之前解決過的，有一些是MySQL 5.7版本才有的，下面記錄一下解決程序，關于AutoMySQLBackup的基礎知識，參考我這篇博客“MySQL備份還原——AutoMySQLBackup介紹”，這里不做詳細介紹，這里的MySQL版本： 5.7.30
測驗程序，備份日志出現下面告警資訊：
###### WARNING ######Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysql: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.mysqldump: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.mysqlshow: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.mysqldump: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.mysqldump: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.mysqldump: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.mysqldump: [Warning] Using a password on the command line interface can be insecure.
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
1：解決“WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.”報錯：
因為從MySQL 5.7.11開始，開始使用--ssl-mode引數，而拋棄/丟棄了引數--ssl，所以之前的MySQL版本不會遇到這個告警資訊，關于這方面的知識，具體參考下面官方檔案資料：
MySQL client programs now support an --ssl-mode option that enables you to specify the security state of the connection to the server. Permitted option values are PREFERRED (establish an encrypted connection if the server supports the capability, falling back to an unencrypted connection otherwise), DISABLED (establish an unencrypted connection), REQUIRED (establish an encrypted connection, or fail), VERFIFY_CA (like REQUIRED, but additionally verify the server certificate), VERIFY_IDENTITY (like VERIFY_CA, but additionally verify that the server certificate matches the host name to which the connection is attempted). For backward compatibility, the default is PREFERRED if --ssl-mode is not specified.
These clients support --ssl-mode: mysql, mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport, mysqlshow, mysqlpump, mysqlslap, mysqltest, mysql_upgrade.
The --ssl-mode option comprises the capabilities of the client-side --ssl and --ssl-verify-server-cert options. Consequently, both of those options are now deprecated and will be removed in a future MySQL version. Use --ssl-mode=REQUIRED instead of --ssl=1 or --enable-ssl. Use --ssl-mode=DISABLED instead of --ssl=0, --skip-ssl, or --disable-ssl. Use --ssl-mode=VERIFY_IDENTITY instead of --ssl-verify-server-cert options. (The server-side --ssl option is not deprecated.)
For the C API, the new MYSQL_OPT_SSL_MODE option for mysql_options() corresponds to the --ssl-mode option. The MYSQL_OPT_SSL_ENFORCE and MYSQL_OPT_SSL_VERIFY_SERVER_CERT options for mysql_options() correspond to the client-side --ssl and --ssl-verify-server-cert options. They are now deprecated and will be removed in a future MySQL version. Use MYSQL_OPT_SSL_MODE with an option value of SSL_MODE_REQUIRED or SSL_MODE_VERIFY_IDENTITY instead.
For more information, see Command Options for Encrypted Connections, and mysql_options().
In consequence of this change, the minor C API version number was incremented
所以這里有兩個解決方案，都非常簡單：
1：在組態檔里面設定CONFIG_mysql_dump_usessl='no'后即可解決，簡單快捷，不用修改代碼
# Use ssl encryption with mysqldump
CONFIG_mysql_dump_usessl='no'
2：修改腳本automysqlbackup，具體操作，將腳本中的--ssl選項替換為--ssl-mode，治標治本，當然最正確的方法是根據MySQL版本選擇引數，
2：解決上面問題后，報錯的提示變為下面這個樣子，之前這篇博客“MySQL備份還原——AutoMySQLBackup介紹”中介紹的方法不靈了，因為MySQL版本變化了，輸出資訊變化了，之前的方法自然失靈了，世界總是變化的，很難有一成不變的事物！
###### WARNING ######Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqlshow: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
修改腳本automysqlbackup（這個腳本視Linux版本不同，位置有所不同，一般位于/usr/local/bin/automysqlbackup或/usr/bin/automysqlbackup下面），在removeIO后面加上這段代碼解決這個問題：
# Remove annoying warning message since MySQL 5.7if [[ -s "$log_errfile" ]]; then
sedtmpfile="/tmp/$(basename $0).$$.tmp"grep -v "mysqldump: \[Warning\] Using a password on the command line interface can be insecure." "$log_errfile" | \
grep -v "mysql: \[Warning\] Using a password on the command line interface can be insecure." | \ grep -v "mysqlshow: \[Warning\] Using a password on the command line interface can be insecure." > $sedtmpfilemv $sedtmpfile $log_errfile
fi
如果你能駕馭工具，自然得心應手，隨著平臺環境、版本的變化，出現的各種問題都能被你解決，如果你只是被動的使用工具，那么遇到一點小問題，就會束手無策，作業這么多年，感覺DBA的硬技能中的一非常重要的能力：解決問題的能力，這個能力需要不斷通過實戰鍛煉、培養、升級！
參考資料：
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-11.html
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/29430.html
標籤：MySQL
上一篇：Hive-視窗函式