How to disable the Binary Log (BinLog) for MySQL/MariaDB in Plesk for Linux?

Question

How to disable MySQL/MariaDB binary log (BinLog) in Plesk for Linux?

Answer

To disable the binary log, add the appropriate option to its configuration.

1. Connect to the server via SSH

2. Edit the MySQL configuration file:

   • RHEL, CentOS, AlmaLinux, and CloudLinux

     # vi /etc/my.cnf

   • Debian and Ubuntu

     # vi /etc/mysql/my.cnf

3. Add the option under [mysqld]

   [mysqld]
   skip-log-bin

4. Save the changes and close the file

5. Restart MySQL to apply the changes

   # systemctl restart mysql