MySQL – Page 2 – ITFROMZERO – Share tobe shared!

MySQL Semi-synchronous Replication: Zero Data Loss Without Group Replication

By admin June 13, 2026

MySQL Semi-synchronous Replication ensures zero data loss for production databases by requiring at least one slave to acknowledge receipt of the binlog before the master commits. This article compares async, semi-sync, and Group Replication, analyzes when each is appropriate, and provides a step-by-step deployment guide from enabling the plugin to real-world monitoring.

MySQL

MySQL Document Store: Use MySQL as NoSQL with X DevAPI — No Need to Switch Databases

By admin June 13, 2026

MySQL Document Store lets you store JSON documents as flexibly as MongoDB — right inside MySQL, without adding a new database engine to your stack. This article walks through using X DevAPI from MySQL Shell and Python to create collections, query documents, build indexes, and mix document and relational data within the same instance.

MySQL

A Guide to Using mysqlcheck for MySQL Database Maintenance, Optimization, and Table Repair

By admin June 13, 2026

A detailed guide on using mysqlcheck to check for table corruption, repair broken tables, and optimize MySQL database performance — with practical tips from real production incidents.

MySQL

How to Use MySQLTuner to Diagnose and Quickly Optimize MySQL Server Configuration

By admin June 13, 2026

MySQLTuner is a Perl script that analyzes your running MySQL configuration and delivers specific optimization recommendations in just a few minutes. This guide walks through installation, interpreting the output, and applying key settings like innodb_buffer_pool_size and thread_cache_size in practice.

MySQL

Dockerize MySQL for Dev Environments: Using Init Scripts to Auto-Initialize Schema and Sample Data

By admin June 13, 2026

A guide to Dockerizing MySQL with init scripts — automatically creating schema and seed data when the container first starts. Set up in 5 minutes, giving the whole team a consistent environment with zero manual steps.

MySQL

Configuring Transparent Data Encryption (TDE) in MySQL 8: Protecting Sensitive Data at the Storage Layer (At-Rest)

By admin June 13, 2026

TDE (Transparent Data Encryption) in MySQL 8 encrypts data at the storage layer, protecting .ibd tablespace files from being read directly — with no application code changes required. This guide walks through the full setup: installing the keyring component, encrypting tables and tablespaces, rotating the master key on a schedule, and verifying and monitoring real-world effectiveness.

MySQL

MySQL Thread Pool: The ‘Lifesaver’ for Handling Thousands of Database Connections

By admin June 10, 2026

Don't let MySQL collapse under connection overload. A detailed guide on configuring Thread Pool to optimize CPU, reduce context switching, and keep your database stable under heavy pressure.

MySQL

Add Columns to a 200 Million Record Table in 0.1 Seconds: The Power of ALGORITHM=INSTANT in MySQL 8.0

By admin June 8, 2026

Discover how to use ALGORITHM=INSTANT in MySQL 8.0 to add or drop columns on tables with hundreds of millions of records in milliseconds, completely eliminating downtime.

MySQL

MySQL Histograms: The Secret to Speeding Up Queries Without Adding Indexes

By admin June 7, 2026

Don't let the MySQL Optimizer guess! Learn how to use Histogram Statistics to speed up queries, optimize data distribution, and reduce index overhead on large tables.

MySQL

Cleaning Up Million-Row MySQL Tables: Don’t Let DELETE Commands Crash Your System

By admin June 7, 2026

Don't let a DELETE command crash your server! Discover 3 safe techniques for cleaning up million-row MySQL tables: Batching, Partitioning, and pt-archiver based on real-world experience.