This repository was archived by the owner on Sep 17, 2024. It is now read-only.
This repository was archived by the owner on Sep 17, 2024. It is now read-only.
mysqldbcompare fails with event definitions. #47
Open
Description
mysqldbcompare gets events info from INFORMATION_SCHEMA.EVENTS:
SELECT EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_DEFINITION,
EVENT_TYPE, INTERVAL_FIELD, INTERVAL_VALUE, STATUS,
ON_COMPLETION, STARTS, ENDS
FROM
INFORMATION_SCHEMA.EVENTS
WHERE
EVENT_SCHEMA = 'schema' AND EVENT_NAME = 'name';
The trouble is that events replicated from master to slave will have their 'STATUS' field changed from 'ENABLED' to 'SLAVESIDE_DISABLED' and this will make replicated database comparisons always fail.
Metadata
Metadata
Assignees
Labels
No labels