Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[MySQL binlog] not readable from MariaDB #5418

Closed
rdxmb opened this issue Feb 12, 2019 · 1 comment
Closed

[MySQL binlog] not readable from MariaDB #5418

rdxmb opened this issue Feb 12, 2019 · 1 comment
Labels
area/mysql bug unexpected problem or unintended behavior

Comments

@rdxmb
Copy link
Contributor

rdxmb commented Feb 12, 2019

Relevant telegraf.conf:

[[inputs.mysql]]
  servers = ["root:$MYSQL_ROOT_PASSWORD@tcp(127.0.0.1:3306)/?tls=false"]
  gather_table_schema = false
  gather_process_list = false
  gather_user_statistics = false
  gather_info_schema_auto_inc = false
  gather_innodb_metrics = false
  gather_slave_status = true
  gather_binary_logs = true
  gather_table_io_waits = false
  gather_table_lock_waits = false
  gather_index_io_waits = false
  gather_event_waits = false
  gather_file_events_stats = false
  gather_perf_events_statements = false
  interval_slow = "30m"
  metric_version = 2

System info:

Kubernetes POD including MariaDB and telegraf container

2019-02-12T20:03:03Z I! Starting Telegraf 1.9.4
2019-02-12T20:03:03Z I! Using config file: /etc/telegraf/telegraf.conf
2019-02-12T20:04:00Z E! [inputs.mysql]: Error in plugin: Error 1381: You are not using binary logging

with official MariaDB-Image tag: "10.3.12" (which is "latest" at the moment)

mounted config to /etc/mysql.d/slave.cnf

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

sql_mode = "ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

bind-address            = 0.0.0.0
key_buffer_size         = 16M
max_allowed_packet      = 16M                                                                          
thread_stack            = 192K                                                                         
thread_cache_size       = 8                                                                            
myisam-recover-options  = BACKUP                                                                       
query_cache_limit       = 1M                                                                           
query_cache_size        = 16M                                                                          
log_error = /var/log/mysql/error.log                                                                   
server-id               = 102                                                                          
read_only               = 1                                                                            
report-host             = myhost
log_bin                 = /var/log/mysql/mysql-bin.log                                                 
expire_logs_days        = 10                                                                           
max_binlog_size         = 100M                                                                         
binlog_do_db            = pdns
innodb_file_per_table   = 1
@rdxmb
Copy link
Contributor Author

rdxmb commented Feb 13, 2019

sorry, this was a problem with a non-parsed mysql-config

@rdxmb rdxmb closed this as completed Feb 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/mysql bug unexpected problem or unintended behavior
Projects
None yet
Development

No branches or pull requests

2 participants