Skip to content

Instantly share code, notes, and snippets.

@lefred
lefred / mysql_8_replication_observability.sql
Last active July 31, 2025 08:15
Get replication information
use sys;
DROP VIEW IF EXISTS replication_status_full;
CREATE
ALGORITHM = MERGE
SQL SECURITY INVOKER
VIEW replication_status_full
AS
SELECT
concat(s.channel_name, ' (', w.worker_id,')') AS channel,
c.host,