Disable MySQL bin log on Bitnami

if you have cloud sevrer with less disk space, it is better disable MySQL bin log as it take approx 3 GB of disk space on bitnami server.

To disable MySQL binlog, edit mysql config file.

vi /opt/bitnami/mysql/my.cnf

Find

Advertisement

[mysqld]

Add below

disable_log_bin

Here is what i have in the my.cnf

root@wordpress-vm:~# cat /opt/bitnami/mysql/my.cnf

[mysqladmin]

user=root

[mysqld]

disable_log_bin basedir=/opt/bitnami/mysql datadir=”/opt/bitnami/mysql/data” port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock tmpdir=/opt/bitnami/mysql/tmp max_allowed_packet=32M bind-address=127.0.0.1 skip-name-resolve=1 default-authentication-plugin=mysql_native_password character-set-server=UTF8 collation-server=utf8_general_ci

[client]

port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock default-character-set=UTF8

[manager]

port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock pid-file=/opt/bitnami/mysql/tmp/manager.pid default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin !include /opt/bitnami/mysql/bitnami/my.cnf root@wordpress-vm:~#

Now restart MySQL

/opt/bitnami/ctlscript.sh stop mysql
/opt/bitnami/ctlscript.sh start mysql

You can now remove the file starting with binlog from folder /opt/bitnami/mysql/data

rm -f /opt/bitnami/mysql/data/binlog.*
Add a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Advertisement