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:

1. Edit the MySQL configuration file.

   copy

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

2. 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

3. Save your changes and close the configuration file.

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

   copy

   acli ide:service-restart mysql

5. 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   |
   +---------------+-------+