Deployment Overview of MySQL on Server¶

Prerequisites and Basic Requirements¶

To ensure a successful deployment, the server must meet the following requirements:

• Operating System:

• Ubuntu or Debian-based distributions.

• RHEL-based distributions (CentOS, Rocky Linux, or AlmaLinux).

• Privileges: Root or sudo access is required to install packages and manage services.

• Network Requirements: Access to package repositories via the internet must be available.

Application installation process¶

The application is installed using the native package manager of the operating system to ensure optimal performance and stability. The specific method depends on the detected distribution:

For Ubuntu/Debian systems:

1. The package repository cache is updated.

2. The mariadb-server package is installed along with utility tools including nano, vim, htop, net-tools, and dnsutils.

3. The MariaDB service is started and configured to launch automatically upon system boot.

For RHEL/CentOS/Rocky/AlmaLinux systems:

1. The mysql-server package is installed along with utility tools including nano, vim, net-tools, and bind-utils.

2. The MySQL service is started and configured to launch automatically upon system boot.

Access Rights and Security¶

Security configurations are applied via the system firewall to restrict access to the database engine:

• Firewall Management:

• On RHEL-based systems, the firewall is configured to allow incoming traffic on TCP port 3306 in the public zone.

• The configuration is set as permanent to ensure rules persist after a reboot.

Databases¶

The deployment installs a database management system (MariaDB or MySQL) directly on the host operating system.

Available ports for connection¶

The following port is opened for database connectivity:

• 3306/tcp: Database service access.