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

go-ini/ini: MySQL configuration fails to start due to unnecessary backtick escaping in values with semicolons #933

Open
leeworker opened this issue Dec 3, 2024 · 0 comments

Comments

@leeworker
Copy link

leeworker commented Dec 3, 2024

Description

When using go-ini/ini package to generate MySQL configuration files, the package automatically adds backticks to values containing semicolons. This causes MySQL server startup failures, particularly when setting values like sql-mode that commonly contain semicolons.

Impact

This issue affects MySQL configuration generation, causing the following problems:

  1. MySQL server fails to start due to invalid configuration format
  2. Values like plugin-load-add = semisync_master.so;semisync_slave.so are incorrectly escaped to plugin-load-add = `semisync_master.so;semisync_slave.so`

Current Behavior

Generated my.cnf:

[root@lxz ~]# kubectl get cm percona-mysql-test-mysql -n base -o yaml
apiVersion: v1
data:
my.cnf: |
[mysqld]
innodb-buffer-pool-instances = 4
innodb-buffer-pool-size = 4505M
innodb-log-file-size = 512M
innodb_buffer_pool_size = 4G
innodb_flush_log_at_trx_commit = 1
innodb_log_file_size = 1G
max-binlog-size = 1G
max_connections = 1000
plugin-load-add = semisync_master.so;semisync_slave.so

image
image
Related issues:#792

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant