Cloudsoft Zone Build, deploy and scale with practical guides to PHP, Node.js, React, DevOps and AI automation. Explore the guides
Guides topic
MySQL tutorials with CRUD, joins, keys, indexes and command-line administration examples.
How InnoDB clustered and secondary indexes work, and the design rules that follow: short primary keys, composite column order, covering indexes, functional and multi-valued JSON indexes, and safe removal with invisible indexes.
By Cloudsoft Zone
Interview preparation
21 MySQL interview questions with model answers checked against the MySQL 8.4 manual: joins, indexes, EXPLAIN ANALYZE, transactions and isolation levels, window functions, CTEs, keyset pagination, replication and what changed in 8.4.
By Cloudsoft Zone
Troubleshooting guide
Moved WordPress and something broke? Fix database errors, old-domain URLs, serialized data, HTTPS redirect loops and permalink 404s with WP-CLI commands.
By Cloudsoft Zone
Architecture guide
How MySQL 8.4 GTID replication works, when to add semisync, how to configure a source and replicas, the removed SLAVE statements and a safe failover runbook.
By Cloudsoft Zone
Interview preparation
Twelve MySQL 8.4 interview questions on window functions and CTEs, from RANK vs DENSE_RANK to recursive hierarchies, each with tested SQL and its output.
By Cloudsoft Zone
Tutorial
Store flexible data in MySQL 8.4 JSON columns without slow queries: generated-column and functional indexes, JSON_TABLE, partial updates and schema checks.
By Cloudsoft Zone
Troubleshooting guide
Why MySQL rejects emoji with error 1366, how to find utf8mb3 columns, convert tables and connections to utf8mb4, and avoid key-length and collation errors.
By Cloudsoft Zone
Tutorial
Connect to MySQL 8.4 or 9.7 with the mysql client and MySQL Shell: socket versus TCP, verified TLS, option files, login paths, scripting, and fixes for common errors.
By Cloudsoft Zone
Showing 8 articles
