Deploying the LNMP Stack: Nginx, MySQL 8, and PHP 7 from Source
Prerequisites and Source Acquisition
To build the LNMP (Linux, Nginx, MySQL, PHP) environment, begin by establishing a build directory and fetching the required packages. This setup utilizes Nginx 1.17, PHP 7.3, and the MySQL 8.0 RPM bundle. Additionally, compiling certain dependencies requires a modern version of CMake.
mkdir -p /opt/stack_bui ...
Posted on Thu, 27 Aug 2026 16:46:19 +0000 by toma42
Leveraging Stored Routines, Triggers, and MySQL 8 Advanced Features
Encapsulating Business Logic with Stored Procedures and Functions
Stored procedures and stored functions bundle multiple SQL statements into reusable server-side objects, reducing network overhead and improving security. A stored procedure accepts input, output, or both types of parameters, while a stored function always returns a single value. ...
Posted on Tue, 14 Jul 2026 16:59:58 +0000 by ClaytonBellmor
Deploying MySQL 8.0 on CentOS 7: A Step-by-Step Walkthrough
Prerequisites and Initial Setup
Start with a minimal CentOS 7 environment to avoid conflicts. Create a temporary workspace for the installation bundle.
mkdir -p /mysql
cd /mysql
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
Cleaning Up Existing MariaDB o ...
Posted on Mon, 18 May 2026 17:50:33 +0000 by FURQAN