Federated Engine

Aikesheng Open Source Community

Apr 21, 2022 · Databases

Investigation of MySQL 5.7 Opening‑Table State Caused by Federated Engine Queries

The article analyzes why a MySQL 5.7.32 instance’s monitoring thread remains in the Opening table state when querying information_schema.tables, discovers the involvement of the Federated storage engine, reproduces the issue with a non‑existent remote server, and confirms the root cause through controlled experiments.

Database MonitoringFederated EngineMySQL

0 likes · 4 min read

Investigation of MySQL 5.7 Opening‑Table State Caused by Federated Engine Queries

Aikesheng Open Source Community

May 17, 2021 · Databases

Using MySQL Federated Storage Engine for Remote Table Access

This article explains how to enable and configure MySQL's Federated storage engine to access remote tables without data synchronization, covering engine architecture, supported features, environment setup, server configuration, table creation, data manipulation, and binlog verification, along with practical code examples.

Database ReplicationFederated EngineMySQL

0 likes · 10 min read

Using MySQL Federated Storage Engine for Remote Table Access