Disabling Binary Logging (binlog) in MySQL 8 (Cloud IDE)

Overview

Binary logging (binlog) in MySQL enables replication and data recovery. If you do not require these features, disable binary log to improve performance and reduce disk usage. This article provides step-by-step instructions to disable binary log in MySQL 8 within the Cloud IDE.

Disabling Binlog in Cloud IDE

To disable binlog in Cloud IDE:

• Edit the MySQL configuration file.

  copy

  /home/ide/configs/mysql/settings.cnf

• Locate the [mysqld] section in the file and add the following line to disable binary logging:

  copy

  skip-log-bin

  For example,

  copy

  [mysqld]
  skip-log-bin

• Save your changes and close the configuration file.

• Restart the MySQL service to apply the changes. Run the following command:

  copy

  acli ide:service-restart mysql

• Run the following command to verify that Binlog is disabled:

  copy

  drush sqlq "SHOW VARIABLES LIKE 'log_bin';"

  The following output is displayed:

  copy

  +---------------+-------+
  | Variable_name | Value |
  +---------------+-------+
  | log_bin       | OFF   |
  +---------------+-------+