Page 4 - MySQL

MySQL

AI generated

Point-in-Time Recovery with Binlogs in MySQL

Maxim Mironjuk - November 07, 2025

A daily backup alone only saves the state from midnight. Point-in-time recovery combines a base backup with a targeted replay of binlogs and restores a MySQL database up to the last correct transaction, right before a faulty DELETE or DROP.

SQL MySQL

AI generated

Using JSON Columns in Relational Databases

Maxim Mironjuk - November 05, 2025

JSON columns give a relational database exactly the modeling freedom that otherwise serves as an argument for a NoSQL switch, without giving up transactions, joins, and referential integrity. Whoever correctly indexes, queries, and validates JSONB in PostgreSQL or JSON in MySQL covers many semi-structured use cases within the existing database.

MySQL

AI generated

MySQL Group Replication for High Availability

Maxim Mironjuk - October 22, 2025

MySQL Group Replication builds a self-managing cluster directly into the database, including conflict checking, group membership and automatic failover, without an external orchestrator having to decide which node is primary. That significantly reduces the number of moving parts in a high availability architecture.

Magento MySQL

AI generated

Database Healthcheck: Checklist for Magento Stores

Maxim Mironjuk - October 22, 2025

A regular database healthcheck catches problems before they turn into checkout outages: an undersized buffer pool, undetected slow queries, growing replication lag, fragmented tables, and untested backups are the most common silent risks in Magento databases. This checklist bundles every relevant check point into one repeatable workflow.

Magento MySQL

AI generated

EAV vs. Flat Table in Magento 2 | When Which Data Structure Makes Sense

Maxim Mironjuk - October 19, 2025

Magento 2 ships with EAV, a very flexible model for product and customer data. At the same time, classic flat tables are the better decision for many custom modules. The art lies in not confusing the two.

MySQL

AI generated

Change Buffer and Undo Logs: InnoDB's Invisible Workers Explained

Maxim Mironjuk - October 16, 2025

The change buffer delays expensive random I/O for secondary indexes, and undo logs keep old row versions available for MVCC and rollback. Both mostly work completely unnoticed in the background, until a long-running transaction or a write spike suddenly turns one of them into the limiting factor.

PHPStorm MySQL PHP Git

AI generated

50 PHPStorm Tools, Plugins and Shortcuts for PHP Teams

Maxim Mironjuk - October 15, 2025

PHPStorm is far more than an editor with syntax highlighting. Anyone who only uses the surface gives away dozens of minutes every day. The right combination of shortcuts, plugins and team configuration makes the difference between an IDE that gets in the way and one that actively supports the developer.

MySQL

AI generated

MySQL Binlog Formats: Statement, Row, Mixed

Maxim Mironjuk - October 13, 2025

The binlog format determines whether MySQL replication stays reliable with non-deterministic statements or silently drifts apart. STATEMENT, ROW and MIXED differ fundamentally in size, safety and traceability, and choosing the right format is one of the most consequential configuration decisions in any MySQL installation.

MySQL

AI generated

The Adaptive Hash Index: Understanding and Tuning Automatic InnoDB Optimization

Maxim Mironjuk - September 28, 2025

The Adaptive Hash Index watches access patterns on B-tree pages inside the buffer pool and automatically builds an in-memory hash structure meant to speed up equality lookups. It works well as long as access patterns are genuinely repetitive and uniform, but under heavy write load it can become a bottleneck in its own right.

Magento Docker Elasticsearch MySQL

AI generated

Docker for Magento: PHP-FPM, Nginx, Node, Elasticsearch/OpenSearch and DB

Maxim Mironjuk - September 27, 2025

Magento 2 needs a precisely tuned service stack. PHP-FPM, Nginx, MariaDB, Redis, Elasticsearch or OpenSearch, and a Node container for frontend builds: each of these services has specific configuration requirements that differ in Docker from a classic server installation. Knowing these differences is what lets you build a stable and performant Magento Docker stack.