Skip to content

Instantly share code, notes, and snippets.

@lefred
lefred / mysql_8_replication_observability.sql
Last active June 8, 2024 09:31
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,