Deployment Overview of MySQL on Server¶

Prerequisites and Basic Requirements¶

The application deployment requires a server running one of the following operating systems with root or sudo privileges:

Ubuntu or Debian
CentOS, Rocky Linux, or AlmaLinux

The following system packages are installed as part of the deployment:

On RHEL-based systems: mysql-server, nano, vim, net-tools, bind-utils
On Debian-based systems: mariadb-server, nano, vim, htop, net-tools, dnsutils

File and Directory Structure¶

The deployment installs the standard MySQL/MariaDB server binaries and configurations to the default locations provided by the respective operating system package managers. No custom file paths or directory structures are specified in the deployment configuration.

Application Installation Process¶

The application is installed using the native package manager for the operating system. The version of the software corresponds to the version available in the default repositories of the specific Linux distribution at the time of installation.

On RHEL-based systems, the yum package manager installs mysql-server.
On Debian-based systems, the apt package manager installs mariadb-server.

Databases¶

The deployment configures the system to allow external connections to the database service on port 3306.

Parameter	Value
Service Name	`mysqld` (RHEL) or `mariadb.service` (Debian)
Default Port	3306
Protocol	TCP

Access Rights and Security¶

Firewall rules are applied to permit network traffic to the database port.

On RHEL-based systems, firewalld is configured to allow TCP traffic on port 3306 in the public zone.
On Debian-based systems, the firewall configuration commands are present in the script but commented out, meaning no automatic ufw rules are applied during the automated installation process shown in the provided data.

Starting, Stopping, and Updating¶

The database service is managed via systemd. The installation process starts the service and enables it to launch automatically on system boot.

To start the service:
RHEL: systemctl start mysqld
Debian: systemctl start mariadb.service
To enable the service on boot:
RHEL: systemctl enable mysqld
Debian: systemctl enable mariadb.service