Type:
Task
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
None
Fix Version/s:
None
Component/s:
None
The goal is to implement proxy redirection protocol describe in MDEV-15935 :
Connection process would ends with OK_Packet that may indicate redirection mechanism with the format
"Location: mysql:[replication:|loadbalance:|sequential:] //<hostDescription>[,<hostDescription>...] /[database] [?<key1>=<value1>[&<key2>=<value2>] ]\n" in `info` field.
Connector, if having an option that permits redirection, must then redirect to the indicated location and close initial socket.
A successful redirection can be cached for some time if ttl is set. If some following connection establishment use a cache location and fail to connect, the connector will then try to reconnect to initial host silently.
relates to
MDEV-15935
Connection Redirection Mechanism in MariaDB Client/Server Protocol
Closed
{"report":{"fcp":1144.7999992370605,"ttfb":365.3999996185303,"pageVisibility":"visible","entityId":85996,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"97325aac-c93c-4618-b961-81e33f81ceda","navigationType":0,"readyForUser":1204.6999998092651,"redirectCount":0,"resourceLoadedEnd":1262,"resourceLoadedStart":371.19999980926514,"resourceTiming":[{"duration":250.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":371.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":371.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":621.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":250.4000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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","startTime":371.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":371.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":622,"responseStart":0,"secureConnectionStart":0},{"duration":303,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":371.79999923706055,"connectEnd":371.79999923706055,"connectStart":371.79999923706055,"domainLookupEnd":371.79999923706055,"domainLookupStart":371.79999923706055,"fetchStart":371.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":371.79999923706055,"responseEnd":674.7999992370605,"responseStart":674.7999992370605,"secureConnectionStart":371.79999923706055},{"duration":360.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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","startTime":372,"connectEnd":372,"connectStart":372,"domainLookupEnd":372,"domainLookupStart":372,"fetchStart":372,"redirectEnd":0,"redirectStart":0,"requestStart":372,"responseEnd":732.3999996185303,"responseStart":732.3999996185303,"secureConnectionStart":372},{"duration":365.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":372.19999980926514,"connectEnd":372.19999980926514,"connectStart":372.19999980926514,"domainLookupEnd":372.19999980926514,"domainLookupStart":372.19999980926514,"fetchStart":372.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":372.19999980926514,"responseEnd":737.6999998092651,"responseStart":737.6999998092651,"secureConnectionStart":372.19999980926514},{"duration":365.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":372.3999996185303,"connectEnd":372.3999996185303,"connectStart":372.3999996185303,"domainLookupEnd":372.3999996185303,"domainLookupStart":372.3999996185303,"fetchStart":372.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":372.3999996185303,"responseEnd":738.1999998092651,"responseStart":738.1999998092651,"secureConnectionStart":372.3999996185303},{"duration":366,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":372.5999994277954,"connectEnd":372.5999994277954,"connectStart":372.5999994277954,"domainLookupEnd":372.5999994277954,"domainLookupStart":372.5999994277954,"fetchStart":372.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":372.5999994277954,"responseEnd":738.5999994277954,"responseStart":738.5999994277954,"secureConnectionStart":372.5999994277954},{"duration":450.9000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":372.79999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":372.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":823.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":366.29999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":373,"connectEnd":373,"connectStart":373,"domainLookupEnd":373,"domainLookupStart":373,"fetchStart":373,"redirectEnd":0,"redirectStart":0,"requestStart":373,"responseEnd":739.2999992370605,"responseStart":739.2999992370605,"secureConnectionStart":373},{"duration":450.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":373.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":373.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":823.7999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":366.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":373.3999996185303,"connectEnd":373.3999996185303,"connectStart":373.3999996185303,"domainLookupEnd":373.3999996185303,"domainLookupStart":373.3999996185303,"fetchStart":373.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":373.3999996185303,"responseEnd":740,"responseStart":740,"secureConnectionStart":373.3999996185303},{"duration":718.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":374.29999923706055,"connectEnd":374.29999923706055,"connectStart":374.29999923706055,"domainLookupEnd":374.29999923706055,"domainLookupStart":374.29999923706055,"fetchStart":374.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":374.29999923706055,"responseEnd":1093.0999994277954,"responseStart":1093.0999994277954,"secureConnectionStart":374.29999923706055},{"duration":887.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":374.3999996185303,"connectEnd":374.3999996185303,"connectStart":374.3999996185303,"domainLookupEnd":374.3999996185303,"domainLookupStart":374.3999996185303,"fetchStart":374.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":374.3999996185303,"responseEnd":1262,"responseStart":1262,"secureConnectionStart":374.3999996185303},{"duration":323.4000005722046,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":836.2999992370605,"connectEnd":836.2999992370605,"connectStart":836.2999992370605,"domainLookupEnd":836.2999992370605,"domainLookupStart":836.2999992370605,"fetchStart":836.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":836.2999992370605,"responseEnd":1159.6999998092651,"responseStart":1159.6999998092651,"secureConnectionStart":836.2999992370605},{"duration":195.79999923706055,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1138.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1138.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1334.2999992370605,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":210,"responseStart":365,"responseEnd":367,"domLoading":369,"domInteractive":1291,"domContentLoadedEventStart":1291,"domContentLoadedEventEnd":1331,"domComplete":1986,"loadEventStart":1986,"loadEventEnd":1988,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1269.2999992370605},{"name":"bigPipe.sidebar-id.end","time":1270.0999994277954},{"name":"bigPipe.activity-panel-pipe-id.start","time":1270.2999992370605},{"name":"bigPipe.activity-panel-pipe-id.end","time":1273.0999994277954},{"name":"activityTabFullyLoaded","time":1337.7999992370605}],"measures":[],"correlationId":"8802aef16f66d4","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":101,"dbReadsTimeInMs":14,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}