--- title: "#mysql articles | Hashnode" description: "MySQL is an open-source relational database management system. Its name is a combination of \"My\", the name of co-founder Michael Widenius's daughter, and \"SQ..." url: "https://hashnode.com/tag/mysql" --- Tag # #mysql 2,470 posts · 17,803 followers [Noah Grinstein](https://hashnode.com/@noahcontrolplane) · [6h ago](https://hashnode.com/posts/self-host-wordpress-on-control-plane-mariadb-media-storage-and-the-admin-login-set-up-for-you/6af47ad8d3841aebdfcffa68) ### [Self-Host WordPress on Control Plane: MariaDB, Media Storage, and the Admin Login Set Up for You](https://controlplane-eng.hashnode.dev/self-host-wordpress-on-control-plane-mariadb-media-storage-and-the-admin-login-set-up-for-you?utm_source=hashnode&utm_medium=feed) Self-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](https://controlplane-eng.hashnode.dev/self-host-wordpress-on-control-plane-mariadb-media-storage-and-the-admin-login-set-up-for-you?utm_source=hashnode&utm_medium=feed) [Shubham Baldava](https://hashnode.com/@shubham-olake) · [15h ago](https://hashnode.com/posts/mysql-to-snowflake-a-binlog-pipeline-in-order-with-the-exact-error-at-each-step/6af3ffe2408ea79733d51fa9) ### [MySQL to Snowflake: A Binlog Pipeline in Order, With the Exact Error at Each Step](https://olake-blog.hashnode.dev/mysql-to-snowflake-a-binlog-pipeline-in-order-with-the-exact-error-at-each-step?utm_source=hashnode&utm_medium=feed) Binlog, 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](https://olake-blog.hashnode.dev/mysql-to-snowflake-a-binlog-pipeline-in-order-with-the-exact-error-at-each-step?utm_source=hashnode&utm_medium=feed) [ZyVOP](https://hashnode.com/@zyvop) · [15h ago](https://hashnode.com/posts/zero-downtime-database-migrations-how-to-change-a-live-schema-safely-zehkb/6af3ff8876bbc43ce80925bd) ### [Zero-Downtime Database Migrations: How to Change a Live Schema Safely](https://blog.zyvop.com/zero-downtime-database-migrations-how-to-change-a-live-schema-safely-zehkb?utm_source=hashnode&utm_medium=feed) A 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](https://blog.zyvop.com/zero-downtime-database-migrations-how-to-change-a-live-schema-safely-zehkb?utm_source=hashnode&utm_medium=feed) [Hritik ranjan](https://hashnode.com/@luvranjan143) · [2d ago](https://hashnode.com/posts/devops-learning-tracker-kubernetes-minikube/6af1830a97c64d348b05898b) ### [Building a Three-Tier DevOps Learning Tracker on Kubernetes with Minikube — Complete End-to-End Guide](https://blogs.hritikranjan.in/devops-learning-tracker-kubernetes-minikube?utm_source=hashnode&utm_medium=feed) From Docker Compose to Kubernetes — Architecture, Deployment, Persistent Storage, Real Troubleshooting, Bugs, Fixes, and DevOps Interview Learnings 53 min read · [blogs.hritikranjan.in](https://blogs.hritikranjan.in/devops-learning-tracker-kubernetes-minikube?utm_source=hashnode&utm_medium=feed) [Daanial Farrukh](https://hashnode.com/@daanial) · [2d ago](https://hashnode.com/posts/postfix-in-a-chroot-cannot-see-your-mysql-socket-why-mail-stopped-both-ways/6af2087232f9373ba463564f) ### [Postfix in a Chroot Cannot See Your MySQL Socket — Why Mail Stopped Both Ways](https://quabin.hashnode.dev/postfix-in-a-chroot-cannot-see-your-mysql-socket-why-mail-stopped-both-ways?utm_source=hashnode&utm_medium=feed) Postfix 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](https://quabin.hashnode.dev/postfix-in-a-chroot-cannot-see-your-mysql-socket-why-mail-stopped-both-ways?utm_source=hashnode&utm_medium=feed) [Mahir Faysal](https://hashnode.com/@mfaysaldev) · [2d ago](https://hashnode.com/posts/sql-where-vs-having/6af1f54fa38f05dd11b20cc7) ### [SQL WHERE vs HAVING: Differences, Execution Order and When to Use Each (Tested Examples)](https://mfaysaldev.hashnode.dev/sql-where-vs-having?utm_source=hashnode&utm_medium=feed) 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(). Use 15 min read · [mfaysaldev.hashnode.dev](https://mfaysaldev.hashnode.dev/sql-where-vs-having?utm_source=hashnode&utm_medium=feed) [rohit kumawat](https://hashnode.com/@skillhost) · [2d ago](https://hashnode.com/posts/mysql-query-optimization/6af19a891bd9779361df26e4) ### [MySQL Query Optimization: 15 Practical Techniques to Speed Up Slow Queries](https://skillhost.hashnode.dev/mysql-query-optimization?utm_source=hashnode&utm_medium=feed) Learn 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](https://skillhost.hashnode.dev/mysql-query-optimization?utm_source=hashnode&utm_medium=feed) [Sarwar Hossein](https://hashnode.com/@sarwar3511) · [2d ago](https://hashnode.com/posts/wordpress-pdf-search-every-matching-page/6af19287f2a16b5b3eb176bc) ### [Showing every matching page in a PDF search: one query, a pagination gotcha, and two-page spreads](https://webequipe.hashnode.dev/wordpress-pdf-search-every-matching-page?utm_source=hashnode&utm_medium=feed) How 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](https://webequipe.hashnode.dev/wordpress-pdf-search-every-matching-page?utm_source=hashnode&utm_medium=feed) [Quayen](https://hashnode.com/@quayen) · [2d ago](https://hashnode.com/posts/streaming-mysql-to-bigquery-with-the-binlog-how-cdc-works-and-the-parts-that-bite/6af1824097c64d348b02ff31) ### [Streaming MySQL to BigQuery with the binlog: how CDC works, and the parts that bite](https://quayen.hashnode.dev/streaming-mysql-to-bigquery-with-the-binlog-how-cdc-works-and-the-parts-that-bite?utm_source=hashnode&utm_medium=feed) Most 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 da 6 min read · [quayen.hashnode.dev](https://quayen.hashnode.dev/streaming-mysql-to-bigquery-with-the-binlog-how-cdc-works-and-the-parts-that-bite?utm_source=hashnode&utm_medium=feed) [Anish Ansari](https://hashnode.com/@anish78) · [4d ago](https://hashnode.com/posts/system-design-drill-day-14-url-shortener-and-unique-id-generation/6aeefb7e0ff76b608cc9d876) ### [System Design Drill Day 14: URL Shortener and Unique ID Generation](https://blog.anishansari.com.np/system-design-drill-day-14-url-shortener-and-unique-id-generation?utm_source=hashnode&utm_medium=feed) How 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](https://blog.anishansari.com.np/system-design-drill-day-14-url-shortener-and-unique-id-generation?utm_source=hashnode&utm_medium=feed)