Skip to content

Input plugin mysql.conf "gather_binary_logs" is not compatible for mysql 8.0 #9063

@zzcpower

Description

@zzcpower

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

Metadata

Metadata

Assignees

Labels

area/mysqlgood first issueThis is a smaller issue suited for getting started in Telegraf, Golang, and contributing to OSS.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions