MDEV-21117 has implemented correct binlog crash recovery in semisync replication. The server decides how to recover based on the role it has in the replication topology. In MDEV-21117 it deduces the role based on rpl_semi_sync_slave_enabled and rpl_semi_sync_master_enabled variables.
This leaves an important use case open. Typically not all slaves are semisync. If one has a mix of semysync and async slaves and the master crashes and after a failover wakes up as an async slave it won't have rpl_semi_sync_slave_enabled set and won't be able to recover correctly, because it won't be able to deduce its replication role.
We need to introduce the dedicated option that tells the server its initial¹ role in the replication topology. Perhaps the server can also automatically configure other settings, as appropriate for the specified role.
¹) initial — because the role can change dynamically, but such a change has no impact on crash recovery.
Brandon Nesterenko
made changes -
2024-03-01 14:39
Assignee
Andrei Elkin
[ elkin
]
Brandon Nesterenko
[ JIRAUSER48702
]
Brandon Nesterenko
made changes -
2024-03-04 18:21
Assignee
Brandon Nesterenko
[ JIRAUSER48702
]
Andrei Elkin
[ elkin
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
Sergei Golubchik
made changes -
2024-06-16 16:35
Assignee
Andrei Elkin
[ elkin
]
Brandon Nesterenko
[ JIRAUSER48702
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
Brandon Nesterenko
made changes -
2024-07-06 02:12
issue.field.resolutiondate
2024-07-06 02:12:24.0
2024-07-06 02:12:24.065
Brandon Nesterenko
made changes -
2024-07-06 02:12
Fix Version/s
10.6.19
[ 29833
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.11
[ 27614
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
JiraAutomate
made changes -
2024-07-06 02:12
Fix Version/s
10.11.9
[ 29834
]
Fix Version/s
11.1.6
[ 29835
]
Fix Version/s
11.2.5
[ 29836
]
Fix Version/s
11.4.3
[ 29837
]
Brandon Nesterenko
made changes -
2024-08-23 12:10
Link
This issue relates to MENT-2122
[ MENT-2122
]
{"report":{"fcp":865.8000000715256,"ttfb":304.60000002384186,"pageVisibility":"visible","entityId":127931,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"1fc6fa91-332a-4af2-ab1a-8fb584ae9d9c","navigationType":0,"readyForUser":930.5,"redirectCount":0,"resourceLoadedEnd":446.89999997615814,"resourceLoadedStart":314.10000002384186,"resourceTiming":[{"duration":5.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":314.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":5.800000071525574,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":314.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":320.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":106.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":314.60000002384186,"connectEnd":314.60000002384186,"connectStart":314.60000002384186,"domainLookupEnd":314.60000002384186,"domainLookupStart":314.60000002384186,"fetchStart":314.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":323.89999997615814,"responseEnd":421.2000000476837,"responseStart":350.7000000476837,"secureConnectionStart":314.60000002384186},{"duration":131.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":315.10000002384186,"connectEnd":315.10000002384186,"connectStart":315.10000002384186,"domainLookupEnd":315.10000002384186,"domainLookupStart":315.10000002384186,"fetchStart":315.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":324.5,"responseEnd":446.89999997615814,"responseStart":362.2000000476837,"secureConnectionStart":315.10000002384186},{"duration":54.199999928474426,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":315.3000000715256,"connectEnd":315.3000000715256,"connectStart":315.3000000715256,"domainLookupEnd":315.3000000715256,"domainLookupStart":315.3000000715256,"fetchStart":315.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":325.8000000715256,"responseEnd":369.5,"responseStart":368.8000000715256,"secureConnectionStart":315.3000000715256},{"duration":63.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":315.5,"connectEnd":315.5,"connectStart":315.5,"domainLookupEnd":315.5,"domainLookupStart":315.5,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":326.5,"responseEnd":379.39999997615814,"responseStart":378.7000000476837,"secureConnectionStart":315.5},{"duration":64.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":315.7000000476837,"connectEnd":315.7000000476837,"connectStart":315.7000000476837,"domainLookupEnd":315.7000000476837,"domainLookupStart":315.7000000476837,"fetchStart":315.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":330.39999997615814,"responseEnd":380.10000002384186,"responseStart":379.5,"secureConnectionStart":315.7000000476837},{"duration":14,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":315.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":329.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":64.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":316.39999997615814,"connectEnd":316.39999997615814,"connectStart":316.39999997615814,"domainLookupEnd":316.39999997615814,"domainLookupStart":316.39999997615814,"fetchStart":316.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":331,"responseEnd":380.89999997615814,"responseStart":380.2000000476837,"secureConnectionStart":316.39999997615814},{"duration":13.600000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":316.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":316.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":330.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":64.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":316.8000000715256,"connectEnd":316.8000000715256,"connectStart":316.8000000715256,"domainLookupEnd":316.8000000715256,"domainLookupStart":316.8000000715256,"fetchStart":316.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":331.60000002384186,"responseEnd":381.7000000476837,"responseStart":381,"secureConnectionStart":316.8000000715256},{"duration":32.699999928474426,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":327.7000000476837,"connectEnd":342,"connectStart":342,"domainLookupEnd":342,"domainLookupStart":342,"fetchStart":327.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":342.3000000715256,"responseEnd":360.39999997615814,"responseStart":357.2000000476837,"secureConnectionStart":342},{"duration":28.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":333,"connectEnd":333,"connectStart":333,"domainLookupEnd":333,"domainLookupStart":333,"fetchStart":333,"redirectEnd":0,"redirectStart":0,"requestStart":343,"responseEnd":361.5,"responseStart":358.5,"secureConnectionStart":333},{"duration":214.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":628.6000000238419,"connectEnd":628.6000000238419,"connectStart":628.6000000238419,"domainLookupEnd":628.6000000238419,"domainLookupStart":628.6000000238419,"fetchStart":628.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":808,"responseEnd":843,"responseStart":842.3000000715256,"secureConnectionStart":628.6000000238419},{"duration":119.70000004768372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":844.1000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":844.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":963.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":120,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":865.8000000715256,"connectEnd":865.8000000715256,"connectStart":865.8000000715256,"domainLookupEnd":865.8000000715256,"domainLookupStart":865.8000000715256,"fetchStart":865.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":950.7000000476837,"responseEnd":985.8000000715256,"responseStart":985,"secureConnectionStart":865.8000000715256}],"fetchStart":0,"domainLookupStart":13,"domainLookupEnd":21,"connectStart":21,"connectEnd":46,"secureConnectionStart":32,"requestStart":47,"responseStart":304,"responseEnd":333,"domLoading":308,"domInteractive":1000,"domContentLoadedEventStart":1000,"domContentLoadedEventEnd":1045,"domComplete":1327,"loadEventStart":1327,"loadEventEnd":1328,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":966.8000000715256},{"name":"bigPipe.sidebar-id.end","time":967.6000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":967.8000000715256},{"name":"bigPipe.activity-panel-pipe-id.end","time":971.3999999761581},{"name":"activityTabFullyLoaded","time":1072.3000000715256}],"measures":[],"correlationId":"74052ea3d1d208","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":194,"dbReadsTimeInMs":30,"dbConnsTimeInMs":89,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}