Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
DDL executed on primary may be blocked by any long running SELECT on replica, thus breaking the "high availability" of this setup. It seems there is no way even to force limited wait time for DDL on replica.
Please, add server variable to force priority for SQL thread in such cases, similar to what happens in Galera.
UPDATE:
from MDEV-29569, which is the same request, but has one additional information:
"Proper logging options (similar to those we have in Galera) should also be added, to help understand the reason of error local connection to slave may get."
Attachments
Issue Links
- is duplicated by
-
MDEV-29569 Add option for SQL thread to terminate all transactions and statements that block it
- Closed
-
MDEV-34857 Implement --slave-abort-blocking-timeout
- Closed