Hi there,
The error log is generated by "gather_binary_log" in mysql.conf for mysql 8.0
Telegraf runs successfully in mysql 5.7. And it runs successfully if I comment the "gather_binary_logs = True" for mysql 8.0
In my opinion, the problem is occurred because of the update of binary log in mysql 8.0
If we look at the difference of binary log between 8.0 and 5.7, we can find that there is one more column "Encrypted" in mysql 8.0. It seems that our code mysql.go has not been compatible with this update yet.
See the difference of binary logs in the links below.
https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
THANKS
Zichu
Hi there,
The error log is generated by "gather_binary_log" in mysql.conf for mysql 8.0
Telegraf runs successfully in mysql 5.7. And it runs successfully if I comment the "gather_binary_logs = True" for mysql 8.0
In my opinion, the problem is occurred because of the update of binary log in mysql 8.0
If we look at the difference of binary log between 8.0 and 5.7, we can find that there is one more column "Encrypted" in mysql 8.0. It seems that our code mysql.go has not been compatible with this update yet.
See the difference of binary logs in the links below.
https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
THANKS
Zichu