read_only | BestHub

Aikesheng Open Source Community

May 28, 2024 · Databases

Root Cause Analysis of Unexpected read_only Setting in MySQL After Server Restart

This article details a step‑by‑step investigation of why a MySQL 8.0.25 server becomes read‑only after a patch‑induced restart, revealing that a persisted configuration in mysqld‑auto.cnf set by PERSIST_ONLY caused the discrepancy and how to verify and resolve it.

ConfigurationMySQLPERSIST_ONLY

0 likes · 13 min read

Root Cause Analysis of Unexpected read_only Setting in MySQL After Server Restart

Aikesheng Open Source Community

Mar 26, 2024 · Databases

MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions

This article explains the MySQL 8.0.22 READ ONLY option for individual databases, demonstrates how to enable and verify the read‑only state with ALTER DATABASE and SHOW CREATE DATABASE commands, shows the impact on DDL/DML operations, lists usage restrictions, and notes exceptional cases and backup considerations.

ALTER DATABASEDatabaseINFORMATION_SCHEMA

0 likes · 11 min read

MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions

Aikesheng Open Source Community

Mar 7, 2023 · Databases

FLUSH Statements Write to Binlog on read_only MySQL Replicas Causing GTID Inconsistency

The article explains how executing FLUSH commands on MySQL replicas that are in read_only mode can still write to the binary log, generate new GTIDs, and lead to GTID mismatches between primary and replica, especially when tools like ClickHouse issue such statements.

GTIDMySQLReplication

0 likes · 6 min read

FLUSH Statements Write to Binlog on read_only MySQL Replicas Causing GTID Inconsistency