NNoah Grinstein·6h agoSelf-Host WordPress on Control Plane: MariaDB, Media Storage, and the Admin Login Set Up for YouSelf-host WordPress on Control Plane with bundled MariaDB, persistent media storage, and the admin login set up for you.8 min read·controlplane-eng.hashnode.dev
SShubham Baldava·15h agoMySQL to Snowflake: A Binlog Pipeline in Order, With the Exact Error at Each StepBinlog, token, first sync, first query and change sync, each with the error text it can produce and the fix.9 min read·olake-blog.hashnode.dev
ZZyVOP·15h agoZero-Downtime Database Migrations: How to Change a Live Schema SafelyA practical playbook for changing a live database schema with no downtime: expand and contract, safe locks, batched backfills, and rollbacks.10 min read·blog.zyvop.com
HHritik ranjan·2d agoBuilding a Three-Tier DevOps Learning Tracker on Kubernetes with Minikube — Complete End-to-End GuideFrom Docker Compose to Kubernetes — Architecture, Deployment, Persistent Storage, Real Troubleshooting, Bugs, Fixes, and DevOps Interview Learnings53 min read·blogs.hritikranjan.in
DDaanial Farrukh·2d agoPostfix in a Chroot Cannot See Your MySQL Socket — Why Mail Stopped Both WaysPostfix logs "virtual_alias_maps map lookup problem" and mail stops both ways, yet postmap works as root. The cause is the chroot column. One-line fix.11 min read·quabin.hashnode.dev
MMahir Faysal·2d agoSQL WHERE vs HAVING: Differences, Execution Order and When to Use Each (Tested Examples)WHERE filters individual rows before they are grouped, and HAVING filters whole groups after GROUP BY has run. That's why only HAVING can use aggregate functions such as SUM(), COUNT() and AVG(). Use15 min read·mfaysaldev.hashnode.dev
Rrohit kumawat·2d agoMySQL Query Optimization: 15 Practical Techniques to Speed Up Slow QueriesLearn how MySQL query optimization works, understand execution plans, use indexes effectively, and improve database performance with practical SQL examples.7 min read·skillhost.hashnode.dev
SSarwar Hossein·2d agoShowing every matching page in a PDF search: one query, a pagination gotcha, and two-page spreadsHow we added "Show All Matching Pages" to a WordPress PDF search plugin, fixed an N+1 query, and mapped PDF pages to a flipbook's spread layout.8 min read·webequipe.hashnode.dev
QQuayen·2d agoStreaming MySQL to BigQuery with the binlog: how CDC works, and the parts that biteMost teams start syncing MySQL to BigQuery with a nightly dump or a query like SELECT * FROM orders WHERE updated_at > :last_run. It works until someone asks why deleted orders still show up in the da6 min read·quayen.hashnode.dev
AAnish Ansari·4d agoSystem Design Drill Day 14: URL Shortener and Unique ID GenerationHow to design a URL shortener: base62 codes, ID generation strategies, 301 vs 302 redirects, Redis caching and async click analytics.6 min read·blog.anishansari.com.np
