DB Parameters in RHEL

This article provides the steps to configure MySQL database parameters in a RHEL environment for OvalEdge applications. It includes the location of MySQL configuration files, required database parameters, and steps to apply the configuration changes. Proper database configuration helps ensure stable connectivity, optimized performance, and reliable metadata operations within OvalEdge.

Prerequisites

Ensure the following prerequisites are met before starting the configuration:

• Install MySQL 8.4.x on the RHEL server

• Create the ovaledgedb database

• Ensure sudo privileges are available on the server

• Ensure the MySQL service is installed and running

For MySQL 8.4.x installation and ovaledgedb creation, refer to the following document: Installation of MySQL 8.4.x on RHEL 8+

Locate the MySQL Configuration File

• In RHEL environments, the MySQL configuration file is generally available at the following location:

  sudo vi /etc/my.cnf

• For custom MySQL installations, the configuration file may be available at:

  sudo vi /etc/my.cnf.d/mysql-server.cnf

Configure MySQL Parameters

Open the MySQL Configuration File

• Open the MySQL configuration file using one of the following commands:

  sudo vi /etc/my.cnf

  or

  sudo vi /etc/my.cnf.d/mysql-server.cnf

Update the MySQL Parameters

• Add or update the following parameters under the [mysqld] section in the MySQL configuration file.

  [mysqld]
  max_binlog_size=1G
  binlog_expire_logs_seconds=2592000
  group_concat_max_len=4294967295
  max_connections=600
  max_allowed_packet=1G
  bind-address=0.0.0.0
  innodb_buffer_pool_size=8G

  Sample Reference Screenshot:

  

Parameter Description

Parameter	Description
max_binlog_size	Defines the maximum size of binary log files
binlog_expire_logs_seconds	Defines binary log retention duration
group_concat_max_len	Increases maximum length for GROUP_CONCAT() results
max_connections	Defines the maximum number of concurrent MySQL connections
max_allowed_packet	Defines the maximum packet size permitted by MySQL
bind-address	Allows remote connections to the MySQL server
innodb_buffer_pool_size	Allocates memory for InnoDB caching and performance optimization

• Save the file and exit the editor after updating the parameters.

Apply Configuration Changes

Restart the MySQL Service

• Run the following command to apply the updated configuration:

  sudo systemctl restart mysqld

Verify MySQL Service Status

• Run the following command to verify that the MySQL service is running successfully:

  sudo systemctl status mysqld

  Sample Reference Screenshot:

  

---

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.