DB Parameters in Ubuntu

This document provides the steps to install MySQL, create the ovaledgedb database, and configure MySQL database parameters in an Ubuntu environment for OvalEdge applications. It includes MySQL repository configuration, server installation, database initialization, and parameter updates required for stable database connectivity and optimized performance. Follow the steps in the order provided to complete the setup successfully.

Prerequisites

Ensure the following prerequisites are met before starting the installation:

• Ubuntu 22.04 LTS or later

• Sudo privileges on the target VM

• Stable internet connectivity on the target VM

• Minimum 4 GB RAM available on the server

• Outbound access to https://dev.mysql.com

• MasterScripts SQL file provided by the OvalEdge team

Update System Packages

1. Open Terminal

   • Log in to the Ubuntu VM

2. Update Package Repository Information

   • Run the following command to refresh the package repository metadata:

     sudo apt update -y

     Sample Reference screenshot:

     

Download MySQL APT Configuration Package

1. Download the MySQL Package

   • Run the following command to download the MySQL APT configuration package: https://dev.mysql.com/get/mysql-apt-config_0.8.34-1_all.deb

     wget https://dev.mysql.com/get/mysql-apt-config_0.8.34-1_all.deb

     Sample Reference Screenshot:

     

Configure MySQL APT Repository

1. Install the MySQL Repository Package

   • Run the following command:

     sudo dpkg -i mysql-apt-config_0.8.34-1_all.deb

2. Select MySQL Version

   • During installation:

     • Select MySQL 8.4

     • Select OK and press Enter

   Use the arrow keys and Enter key to navigate the package configuration screen.

   Sample Reference Screenshot:

   

   

Select MySQL and click OK, as shown in the above screenshot.

Update Repository Information

1. Refresh Repository Metadata

   • Run the following command to update the repository information:

     sudo apt update -y

     Sample Reference Screenshot:

     

Install MySQL Server

1. Install MySQL

   • Run the following command:

     sudo apt-get install mysql-server -y

     Sample Reference Screenshot:

     

     

     

2. Configure Root Password

   • During installation:

     • Enter the MySQL root password

     • Confirm the password

Configure the password in accordance with the organizational security policies.

Verify MySQL Installation

1. Verify MySQL Version

   • Run the following command:

     mysql --version

     Sample Reference Screenshot:

     
2. Exit MySQL Shell

   • If the MySQL shell opens, run the following command to exit:

     exit

Configure MySQL Parameters

1. Open MySQL Configuration File

   • Run the following command:

     sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

2. Update MySQL Parameters

3. Add or update the following parameters under the [mysqld] section:

   [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	Descriptio
max_binlog_size	Defines the maximum binary log file size
binlog_expire_logs_seconds	Defines binary log retention duration
group_concat_max_len	Increases maximum GROUP_CONCAT() result length
max_connections	Defines maximum concurrent database connections
max_allowed_packet	Defines the maximum packet size allowed by MySQL
bind-address	Enables remote MySQL access
innodb_buffer_pool_size	Allocates memory for InnoDB caching and performance

• Save the configuration file and exit the editor.

• Set bind-address=0.0.0.0 only when remote database access is required

• Configure innodb_buffer_pool_size based on available server memory

• Recommended buffer pool allocation is 50%–70% of total RAM

Restart and Enable MySQL Service

1. Restart MySQL Service

   • Run the following command:

     sudo systemctl restart mysql

2. Enable MySQL Service

   • Run the following command:

     sudo systemctl enable mysql

     Sample Reference Screenshot:

     

Initialize OvalEdge Database

1. Transfer MasterScripts File

   • Transfer the MasterScripts SQL file provided by the OvalEdge team to the MySQL VM. Example:

     wget <Master_scripts_URL>

     Sample Reference Screenshot:

     
2. Log in to MySQL

   • Run the following command:

     mysql -u root -p

     Sample Reference Screenshot:

     
3. Execute MasterScripts File

   • Run the following command inside the MySQL shell:

     source <Path_of_MasterScripts_file>

4. Exit MySQL Shell

   • Run the following command:

     exit

Verify Database Creation

1. Log in to MySQL

   • Run the following command:

     mysql -u root -p

2. Verify Databases

   • Run the following command:

     SHOW DATABASES;

     Sample Reference Screenshot:

The presence of the ovaledgedb database confirms successful database initialization.

Update Additional MySQL Parameters

1. Open MySQL Configuration File

   • Run one of the following commands based on the server configuration:

     sudo nano /etc/mysql/my.cnf

     or

     sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

2. Update Additional Parameters

   • Add or update the following parameters under the [mysqld] section:

     [mysqld]
     sql_generate_invisible_primary_key = OFF
     max_binlog_size = 512M
     binlog_expire_logs_seconds = 604800
     max_allowed_packet = 256M
     group_concat_max_len = 65535
     innodb_buffer_pool_size = 10GB

     Sample Reference Screenshot:

     

• Save the configuration file and exit the editor.

Apply Configuration Changes

1. Restart MySQL Service

   • Run the following command:

     sudo systemctl restart mysql

     Sample Reference Screenshot:

     
2. Verify MySQL Service Status

   • Run the following command

     sudo systemctl status mysql

     Sample Reference Screenshot:

     

---

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