MySQL binary logs enabled by default
Bug #1533805 reported by
Andrii Petrenko
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Fuel for OpenStack |
Fix Released
|
High
|
Andrii Petrenko | ||
6.1.x |
Fix Released
|
High
|
Alexey Stupnikov | ||
7.0.x |
Fix Released
|
High
|
Alexey Stupnikov | ||
8.0.x |
Fix Released
|
High
|
Andrii Petrenko | ||
Mitaka |
Fix Released
|
High
|
Andrii Petrenko |
Bug Description
Default setting for MySQL enabled binary logging. Binary logging is not necessary for Galera replication and just waste disk space. in case of small disk on the controller and high activity of the cloud/zabbix can cause MySQL failure.
Details:
initial state:
71G /var/lib/mysql
Cleaned up by command
mysql> purge binary logs to 'mysql-bin.000078';
Query OK, 0 rows affected (10.18 sec)
After clean up:
38G /var/lib/mysql
Solving:
comments or remove from mysql config options:
log_bin
expire_logs_days
max_binlog_size
tags: | added: support |
Changed in fuel: | |
assignee: | nobody → Davanum Srinivas (DIMS) (dims-v) |
status: | New → In Progress |
Changed in fuel: | |
status: | Invalid → In Progress |
tags: | added: on-verification |
tags: | added: rn7.0-mu2 |
tags: | added: on-verification |
tags: | added: area-docs |
tags: | added: 8.0 release-notes-done |
tags: | removed: 8.0 on-verification release-notes-done |
tags: | added: on-verification |
To post a comment you must log in.
Andrii,
fyi - https:/ /github. com/openstack/ fuel-library/ commit/ 9021076349fa8e6 641338d9b3e8771 688b9c43e0
https:/ /bugs.launchpad .net/fuel/ +bug/1420825