DODafe Omareinv-84.hashnode.dev·3d ago · 5 min readSpec first, trust never: Building a MySQL job queue with an LLMA few jobs ago, I worked somewhere with a homemade MySQL job queue. It had it all: concurrency bugs, jobs that ran twice, jobs that ran never, and a table with no cleanup plan that quietly hit 200 mil00
AalexCRAZY74inalex-crazy74.hashnode.dev·6d ago · 6 min readWhy Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS PhysicsIf you have ever designed inventory accounting, an ERP system, or billing, you know: calculating stock balances is a minefield. In SQL textbooks, everything looks clean: run SUM(quantity) over transac00
JAJaafar Abazidinmantekio.hashnode.dev·Jul 24 · 21 min readArabic search in WordPress: the matches it silently missesTwo hundred and fifty thousand articles, and the thing editors complained about was the search box. Not the accuracy of it. The wait. Type a name into the newsroom's admin search, go and do something 00
SHSanskriti Harmukhinvultr.hashnode.dev·Jul 24 · 3 min readDeploying MariaDB on KubernetesMariaDB is a popular open-source relational database. Running it on Kubernetes gets you portability across environments, CI/CD integration, and automated backup/recovery alongside the usual scalabilit00
MSManu Shuklainecorpit.hashnode.dev·Jul 20 · 18 min readMySQL 8.0 EOL on 31 July 2026: extended support costs and the 8.4 upgrade planMySQL 8.0 EOL on 31 July 2026: extended support costs and the 8.4 upgrade plan Summary. Amazon RDS for MySQL 8.0 reaches end of standard support on 31 July 2026, and RDS Extended Support charges begin00
BRBharan Reddyinbharanblog.hashnode.dev·Jul 13 · 7 min readDevOps & Cloud Infrastructure Focus Building, Fixing, and Exposing a 2-Tier Flask App with Docker, Makefiles, and AWS EC2Streamlining Your DevOps Workflow: A Practical Guide to Docker, Makefiles, and Automation As DevOps engineers and developers, efficiency is our ultimate goal. We frequently run tedious multi-step comm00
ATApoorv Tyagiinapoorvtyagi.tech·Jul 11 · 14 min readHow to Size Java Database Connection Pools in KubernetesIntroduction I was reviewing a PR at work a month ago where a new application was setting up its database service, and I saw the connection pool properties, which made me think about how a small confi00
PMPRAVIN Minpravinm.hashnode.dev·Jul 12 · 2 min readWhat is SQL? Understanding SQL Basics, DDL, DML, DCL, Tables, Rows & ColumnsWhat is SQL? SQL stands for Structured Query Language. It is the standard language used to communicate with relational databases. Using SQL, we can: Create databases Create tables Insert records R00
MDMithrugan DevOpsinmithrugan-devops.hashnode.dev·Jul 11 · 3 min readAWS RDS Blue/Green Deployment: Step-by-Step Zero Downtime MySQL Upgrade GuideRecently, I upgraded a production Amazon RDS MySQL database from MySQL 8.0 to MySQL 8.4 LTS using Amazon RDS Blue/Green Deployment. Since this was a production environment serving live users, the prim00
AAAjin aniyaninmysqlfuel.hashnode.dev·Jul 10 · 12 min readMySQL Backup and Restore: A Complete Guide for Developers and DBAsSomewhere around 1 a.m. is usually when people find out their MySQL backup script broke three weeks ago. The cron job is still running. The log still says "backup completed successfully." And the .sql00
