+1 (276) 265-7197

Operations

From One LAMP Box to Two App Servers: The Four Things That Break

October 26, 2026 · StackPioneer

Adding a second web server to a legacy PHP app is mostly not a load-balancer problem. Sessions on local disk, uploads in the document root, cron running twice, and caches that only clear on one node — here is how to find each one and fix it without a rewrite.

Read more

A Staging Copy of Production That Won't Leak Customer Data

October 12, 2026 · StackPioneer

Most legacy PHP apps have no usable staging environment, so upgrades get rehearsed in production. Here is a repeatable way to build one from a restored backup: scripted anonymization of the MySQL dump, neutered outbound mail and payment keys, and a refresh job that runs on a schedule.

Read more

Atomic Deploys for a Legacy PHP App (and What to Do About OPcache)

September 21, 2026 · StackPioneer

Deploying by rsync or FTP into the live document root means every visitor during the copy sees a half-updated application. Symlinked release directories, a deliberate OPcache reset, and migrations split from code deploys fix that in an afternoon — no pipeline rewrite required.

Read more

Moving a LAMP Application to AWS Without Rewriting It

September 18, 2026 · StackPioneer

A lift-and-shift plan for a production PHP/MySQL app: inventory the server you actually have, EC2 plus RDS instead of a rewrite, uploads off the local disk, a replica-based database cutover, and a rollback path that stays warm for a week.

Read more

Changing a 200 GB Table Without Taking the Site Down

September 16, 2026 · StackPioneer

ALTER TABLE on a large InnoDB table is the migration that takes the site down at 2 a.m. Here is how to tell which changes are instant in MySQL 8, when to reach for pt-online-schema-change or gh-ost, and how to rehearse either one.

Read more

Still on CentOS 7? Planning the Move to Rocky or Alma 9

September 14, 2026 · StackPioneer

CentOS 7 lost updates in June 2024. Here is the honest comparison of in-place upgrade versus build-new-and-cut-over, plus the four things that actually break on EL9: OpenSSL 3 crypto policies, MariaDB-by-default, SELinux, and the PHP that came from SCL.

Read more

MySQL 8.0 Is Ending: Planning the Move to 8.4 LTS

September 11, 2026

MySQL 8.0 reaches end of life in April 2026 and 8.4 LTS is the successor. What actually breaks — mysql_native_password, removed replication options, retired variables — and how to rehearse the upgrade on a replica.

Read more