Type:
Task
Priority:
Major
Resolution:
Fixed
Background
When we need to update server SSL certs for renewal, we have to restart the mariadb server. This can be problematic for production servers where we do not frequently restart the service. This is particularly acute when using short-lived certs such as those provided by LetsEncrypt .
Cert Renewals will be less disruptive it is is possible to issue a command to mariadb server to make the server reload the server certificate and/or CRL, as needed.
A similar case is open for MySQL (refer: https://bugs.mysql.com/bug.php?id=75404 ), but does not appear to have gained traction.
Acceptance Criteria
Ability added to flush server SSL certificates, without requiring a server restart.
Ability added to flush server CRL, without requiring server restart.
Raised this as a task, as I can't raise it as a feature request...
Thanks.
Ralf Gebhardt
made changes -
2018-05-24 16:52
Field
Original Value
New Value
Fix Version/s
10.4
[ 22408
]
Sergei Golubchik
made changes -
2018-05-24 17:17
Priority
Minor
[ 4
]
Major
[ 3
]
Julien Fritsch
made changes -
2018-07-05 12:50
Link
This issue is part of PT-73
[ PT-73
]
Julien Fritsch
made changes -
2018-07-05 12:52
Link
This issue is part of PT-73
[ PT-73
]
Julien Fritsch
made changes -
2018-07-05 12:56
Epic Link
PT-73
[ 68549
]
Sergei Golubchik
made changes -
2018-11-28 15:40
Assignee
Vladislav Vaintroub
[ wlad
]
Vladislav Vaintroub
made changes -
2018-12-03 13:50
Assignee
Vladislav Vaintroub
[ wlad
]
Sergei Golubchik
[ serg
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
Sergei Golubchik
made changes -
2018-12-06 18:37
Assignee
Sergei Golubchik
[ serg
]
Vladislav Vaintroub
[ wlad
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
Vladislav Vaintroub
made changes -
2018-12-12 21:59
issue.field.resolutiondate
2018-12-12 21:59:29.0
2018-12-12 21:59:29.06
Vladislav Vaintroub
made changes -
2018-12-12 21:59
Fix Version/s
10.4.1
[ 23228
]
Fix Version/s
10.4
[ 22408
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:23
Workflow
MariaDB v3
[ 87413
]
MariaDB v4
[ 133552
]
Sergei Golubchik
made changes -
2023-01-13 12:11
Link
This issue relates to MENT-1709
[ MENT-1709
]
{"report":{"fcp":1847.8000001907349,"ttfb":226.30000019073486,"pageVisibility":"visible","entityId":67711,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"f222af95-802c-4d2b-aee2-48e1842aaae0","navigationType":0,"readyForUser":1569.2000000476837,"redirectCount":0,"resourceLoadedEnd":1781.7000000476837,"resourceLoadedStart":317.2000000476837,"resourceTiming":[{"duration":452.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":317.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":317.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":770.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":456,"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":317.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":317.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":773.5,"responseStart":0,"secureConnectionStart":0},{"duration":536.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":317.7000000476837,"connectEnd":317.7000000476837,"connectStart":317.7000000476837,"domainLookupEnd":317.7000000476837,"domainLookupStart":317.7000000476837,"fetchStart":317.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":317.7000000476837,"responseEnd":854,"responseStart":854,"secureConnectionStart":317.7000000476837},{"duration":606.8999998569489,"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":317.80000019073486,"connectEnd":317.80000019073486,"connectStart":317.80000019073486,"domainLookupEnd":317.80000019073486,"domainLookupStart":317.80000019073486,"fetchStart":317.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":317.80000019073486,"responseEnd":924.7000000476837,"responseStart":924.7000000476837,"secureConnectionStart":317.80000019073486},{"duration":610.3999998569489,"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":318.10000014305115,"connectEnd":318.10000014305115,"connectStart":318.10000014305115,"domainLookupEnd":318.10000014305115,"domainLookupStart":318.10000014305115,"fetchStart":318.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":318.10000014305115,"responseEnd":928.5,"responseStart":928.5,"secureConnectionStart":318.10000014305115},{"duration":611,"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":318.2000000476837,"connectEnd":318.2000000476837,"connectStart":318.2000000476837,"domainLookupEnd":318.2000000476837,"domainLookupStart":318.2000000476837,"fetchStart":318.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":318.2000000476837,"responseEnd":929.2000000476837,"responseStart":929.2000000476837,"secureConnectionStart":318.2000000476837},{"duration":621.2999999523163,"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":318.40000009536743,"connectEnd":318.40000009536743,"connectStart":318.40000009536743,"domainLookupEnd":318.40000009536743,"domainLookupStart":318.40000009536743,"fetchStart":318.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":318.40000009536743,"responseEnd":939.7000000476837,"responseStart":939.7000000476837,"secureConnectionStart":318.40000009536743},{"duration":707.7999999523163,"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":318.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":318.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1026.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":846.3999998569489,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":318.80000019073486,"connectEnd":318.80000019073486,"connectStart":318.80000019073486,"domainLookupEnd":318.80000019073486,"domainLookupStart":318.80000019073486,"fetchStart":318.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":318.80000019073486,"responseEnd":1165.2000000476837,"responseStart":1165.2000000476837,"secureConnectionStart":318.80000019073486},{"duration":1056.1000001430511,"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":319.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":319.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1375.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":846.0999999046326,"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":319.60000014305115,"connectEnd":319.60000014305115,"connectStart":319.60000014305115,"domainLookupEnd":319.60000014305115,"domainLookupStart":319.60000014305115,"fetchStart":319.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":319.60000014305115,"responseEnd":1165.7000000476837,"responseStart":1165.7000000476837,"secureConnectionStart":319.60000014305115},{"duration":1393.4000000953674,"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":320.90000009536743,"connectEnd":320.90000009536743,"connectStart":320.90000009536743,"domainLookupEnd":320.90000009536743,"domainLookupStart":320.90000009536743,"fetchStart":320.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":320.90000009536743,"responseEnd":1714.3000001907349,"responseStart":1714.3000001907349,"secureConnectionStart":320.90000009536743},{"duration":1395.5999999046326,"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":320.90000009536743,"connectEnd":320.90000009536743,"connectStart":320.90000009536743,"domainLookupEnd":320.90000009536743,"domainLookupStart":320.90000009536743,"fetchStart":320.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":320.90000009536743,"responseEnd":1716.5,"responseStart":1716.5,"secureConnectionStart":320.90000009536743},{"duration":551.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1068.3000001907349,"connectEnd":1068.3000001907349,"connectStart":1068.3000001907349,"domainLookupEnd":1068.3000001907349,"domainLookupStart":1068.3000001907349,"fetchStart":1068.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1068.3000001907349,"responseEnd":1620.1000001430511,"responseStart":1620.1000001430511,"secureConnectionStart":1068.3000001907349},{"duration":395.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1468.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1468.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1863.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":125.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1656.6000001430511,"connectEnd":1656.6000001430511,"connectStart":1656.6000001430511,"domainLookupEnd":1656.6000001430511,"domainLookupStart":1656.6000001430511,"fetchStart":1656.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":1656.6000001430511,"responseEnd":1781.7000000476837,"responseStart":1781.7000000476837,"secureConnectionStart":1656.6000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":12,"responseStart":226,"responseEnd":312,"domLoading":278,"domInteractive":1940,"domContentLoadedEventStart":1940,"domContentLoadedEventEnd":2035,"domComplete":2340,"loadEventStart":2340,"loadEventEnd":2340,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1881.1000001430511},{"name":"bigPipe.sidebar-id.end","time":1882.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1882.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1898.9000000953674},{"name":"activityTabFullyLoaded","time":2071.800000190735}],"measures":[],"correlationId":"f0302f7407cf4f","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":154,"dbReadsTimeInMs":34,"dbConnsTimeInMs":45,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Hi ralf.gebhardt, I can try. When is the deadline?