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 DATABASEInformation Schemadatabase

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.

BinlogFlushread-only

0 likes · 6 min read

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

MaGe Linux Operations

Dec 14, 2022 · Fundamentals

Master Python’s @property: Turn Methods into Read‑Only Attributes

Learn how Python’s @property decorator transforms methods into read‑only attributes, enabling attribute‑style access, preventing unintended modifications, and illustrating proper usage with code examples that show correct and incorrect calls, common pitfalls, and best practices for encapsulating data.

DecoratorEncapsulationProperty

0 likes · 4 min read

Master Python’s @property: Turn Methods into Read‑Only Attributes