# MySQL8.4.x on RHEL 8/9 This document provides a detailed procedure for installing and configuring MySQL 8.4.x on Red Hat Enterprise Linux (RHEL) 8 or 9 systems. It includes prerequisites, installation steps, initial setup, and recommended performance tuning parameters as per OvalEdge guidelines. ## **Prerequisites** Ensure the following conditions before starting the installation: * A virtual machine (VM) or server running RHEL 8.x or 9.x * A user account with sudo privileges * An active internet connection is required to download packages * SELinux and firewall considerations (adjust as per your security policies) ## Installation Steps 1. **System Update** * Update the system packages. ```bash sudo yum update -y ``` \ *Sample Reference Screenshot:*

2. **Install Required Utilities** * Install `yum-utils` to manage repositories. ```bash sudo yum install -y yum-utils ``` 3. **Configure MySQL Repository** * Download and install the official MySQL 8.4 repository RPM. * **For RHEL 8:** ```bash wget https://dev.mysql.com/get/mysql84-community-release-el8-1.noarch.rpm sudo rpm -ivh mysql84-community-release-el8-1.noarch.rpm ``` * **For RHEL 9:** ```bash wget https://dev.mysql.com/get/mysql84-community-release-el9-1.noarch.rpm sudo rpm -ivh mysql84-community-release-el9-1.noarch.rpm ```

Use the correct .rpm file based on the OS version.

\ \&#xNAN;*Sample Reference Screenshot:*

4. **Disable Default MySQL Module** * Disable the default MySQL module to avoid conflicts. ```bash sudo yum module disable -y mysql ``` \ *Sample Reference Screenshot:*

5. **Install MySQL Server** * Install the MySQL community server package. ```bash sudo yum localinstall -y mysql84-community-release-el8-1.noarch.rpm ``` \ *Sample Reference Screenshot:*

6. **Start and Enable MySQL Service** * Start the MySQL service and enable it to run at boot. ```bash sudo systemctl start mysqld sudo systemctl enable mysqld sudo systemctl status mysqld ``` \ *Sample Reference Screenshot:*

* Verify the installed version: ```bash mysql --version ``` \ *Sample Reference Screenshot:*

7. **Retrieve Temporary Root Password** * Check the MySQL log to retrieve the temporary root password. ```bash sudo grep 'temporary password' /var/log/mysqld.log ``` \ *Sample Reference Screenshot:*

8. **Secure MySQL Installation** * Log in to MySQL and configure the root account. ```bash mysql -u root -p ``` \ *Sample Reference Screenshot:*

* Run the following SQL commands: ```sql ALTER USER 'root'@'localhost' IDENTIFIED BY ''; DELETE FROM mysql.user WHERE User=''; DROP DATABASE IF EXISTS test; DELETE FROM mysql.db WHERE Db='test' OR Db='test_%'; FLUSH PRIVILEGES; ```

Replace <NewSecurePassword> with a strong, secure password.

\ \&#xNAN;*Sample Reference Screenshot:*

9. **Apply Recommended Configuration** * Edit the MySQL configuration file: ```bash sudo vi /etc/my.cnf ``` * Append or update the following parameters: ```ini 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:*

Set bind-address=0.0.0.0 only if MySQL and the application reside on different VMs.
Adjust innodb_buffer_pool_size based on system RAM (typically 50%–70%).

10. **Restart MySQL Service** * Apply the configuration changes by restarting the MySQL service. ```bash sudo systemctl restart mysqld sudo systemctl enable mysqld ``` \ *Sample Reference Screenshot:*

## OvalEdge Database Creation 1. **Import OvalEdge Schema** * Place the `MasterScripts.sql` file (provided by the OvalEdge team) in the MySQL VM.\ \ \&#xNAN;*Sample Reference Screenshot:*

* Connect to MySQL: ```bash mysql -u root -p ``` \ *Sample Reference Screenshot:*

* Run the script: ```sql SOURCE ; ```

Replace <path_to_MasterScripts.sql> with the actual file path.

2. **Verify Database Creation** * Check if the OvalEdge database has been created: ```sql SHOW DATABASES; ``` \ *Sample Reference Screenshot:*