2022-01-07 15:53:05 0 [Note] WSREP: Joiner monitor thread started to monitor
WSREP_SST: [INFO] new ssl configuration options (ssl-ca[path], ssl-cert and ssl-key) are ignored by SST due to presence of the tca[path], tcert and/or tkey in the [sst] section (20220107 15:53:05.322)
WSREP_SST: [INFO] Using stunnel for SSL encryption: CA: '', CAPATH='', ssl-mode='REQUIRED' (20220107 15:53:05.346)
For rsynch method do not allow SST between major releases (e.g. 10.4 -> 10.5)
Not clear what to do with 10.3. Let x be major release number in donor and y be maror release number in joiner. What to do if
y - x > 1 (e.g. donor 10.4, joiner 10.6)
y - x < 0 (e.g. donor 10.6, joiner 10.4)
If donor e.g 10.4.x and joiner 10.5.x then set up INNOPREPARE at joiner so that it will use 10.4.x mariabackup binary (make this generic e.g. it will do same for 10.5.x vs 10.6.x)
else use current mariabackup binary
after SST has completed and we have started MariaDB execute mysql_upgrade if major version has changed
Jan Lindström (Inactive)
added a comment - - edited Plan:
Add sending donors server version to jointer
Add finding out joiners server version
Add both to error log
Check donor's and joiners versions
If donor < 10.2 reject SST with clear error
For rsynch method do not allow SST between major releases (e.g. 10.4 -> 10.5)
Not clear what to do with 10.3. Let x be major release number in donor and y be maror release number in joiner. What to do if
y - x > 1 (e.g. donor 10.4, joiner 10.6)
y - x < 0 (e.g. donor 10.6, joiner 10.4)
If donor e.g 10.4.x and joiner 10.5.x then set up INNOPREPARE at joiner so that it will use 10.4.x mariabackup binary (make this generic e.g. it will do same for 10.5.x vs 10.6.x)
else use current mariabackup binary
after SST has completed and we have started MariaDB execute mysql_upgrade if major version has changed
People
Julius Goryavsky
Ramesh Sivaraman
Votes:
0Vote for this issue
Watchers:
7Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":852.6000003814697,"ttfb":251.5,"pageVisibility":"visible","entityId":106479,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"3ce83cd1-e4ca-4bfb-a6dd-cd4905ff3497","navigationType":0,"readyForUser":950.9000000953674,"redirectCount":0,"resourceLoadedEnd":772.6000003814697,"resourceLoadedStart":257,"resourceTiming":[{"duration":93.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":350.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":94.09999990463257,"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":257.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":257.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":158.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":257.5,"connectEnd":257.5,"connectStart":257.5,"domainLookupEnd":257.5,"domainLookupStart":257.5,"fetchStart":257.5,"redirectEnd":0,"redirectStart":0,"requestStart":355.2000002861023,"responseEnd":416.1000003814697,"responseStart":381.90000009536743,"secureConnectionStart":257.5},{"duration":171,"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":257.7000002861023,"connectEnd":257.7000002861023,"connectStart":257.7000002861023,"domainLookupEnd":257.7000002861023,"domainLookupStart":257.7000002861023,"fetchStart":257.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":355.80000019073486,"responseEnd":428.7000002861023,"responseStart":380.2000002861023,"secureConnectionStart":257.7000002861023},{"duration":125.7000002861023,"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":257.90000009536743,"connectEnd":257.90000009536743,"connectStart":257.90000009536743,"domainLookupEnd":257.90000009536743,"domainLookupStart":257.90000009536743,"fetchStart":257.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":357,"responseEnd":383.6000003814697,"responseStart":382.7000002861023,"secureConnectionStart":257.90000009536743},{"duration":121.89999961853027,"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":258.1000003814697,"connectEnd":258.1000003814697,"connectStart":258.1000003814697,"domainLookupEnd":258.1000003814697,"domainLookupStart":258.1000003814697,"fetchStart":258.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":358.30000019073486,"responseEnd":380,"responseStart":379,"secureConnectionStart":258.1000003814697},{"duration":126.19999980926514,"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":258.2000002861023,"connectEnd":258.2000002861023,"connectStart":258.2000002861023,"domainLookupEnd":258.2000002861023,"domainLookupStart":258.2000002861023,"fetchStart":258.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":359.30000019073486,"responseEnd":384.40000009536743,"responseStart":383.7000002861023,"secureConnectionStart":258.2000002861023},{"duration":100.59999990463257,"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":258.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":258.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":359,"responseStart":0,"secureConnectionStart":0},{"duration":166.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":258.6000003814697,"connectEnd":258.6000003814697,"connectStart":258.6000003814697,"domainLookupEnd":258.6000003814697,"domainLookupStart":258.6000003814697,"fetchStart":258.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":361.1000003814697,"responseEnd":425.30000019073486,"responseStart":422.6000003814697,"secureConnectionStart":258.6000003814697},{"duration":101.69999980926514,"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":258.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":258.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":360.5,"responseStart":0,"secureConnectionStart":0},{"duration":133.90000009536743,"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":258.90000009536743,"connectEnd":373.80000019073486,"connectStart":373.80000019073486,"domainLookupEnd":373.80000019073486,"domainLookupStart":373.80000019073486,"fetchStart":258.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":374.2000002861023,"responseEnd":392.80000019073486,"responseStart":387.40000009536743,"secureConnectionStart":373.80000019073486},{"duration":456.40000009536743,"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":272.2000002861023,"connectEnd":272.2000002861023,"connectStart":272.2000002861023,"domainLookupEnd":272.2000002861023,"domainLookupStart":272.2000002861023,"fetchStart":272.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":628.1000003814697,"responseEnd":728.6000003814697,"responseStart":723.5,"secureConnectionStart":272.2000002861023},{"duration":500.30000019073486,"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":272.30000019073486,"connectEnd":272.30000019073486,"connectStart":272.30000019073486,"domainLookupEnd":272.30000019073486,"domainLookupStart":272.30000019073486,"fetchStart":272.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":760.2000002861023,"responseEnd":772.6000003814697,"responseStart":771.4000000953674,"secureConnectionStart":272.30000019073486},{"duration":168.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":613.8000001907349,"connectEnd":613.8000001907349,"connectStart":613.8000001907349,"domainLookupEnd":613.8000001907349,"domainLookupStart":613.8000001907349,"fetchStart":613.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":743.7000002861023,"responseEnd":782.2000002861023,"responseStart":781.4000000953674,"secureConnectionStart":613.8000001907349},{"duration":147.90000009536743,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":845.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":845.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":993.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":159.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":867.8000001907349,"connectEnd":867.8000001907349,"connectStart":867.8000001907349,"domainLookupEnd":867.8000001907349,"domainLookupStart":867.8000001907349,"fetchStart":867.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":984.4000000953674,"responseEnd":1027.2000002861023,"responseStart":1026.5,"secureConnectionStart":867.8000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":81,"responseStart":251,"responseEnd":272,"domLoading":255,"domInteractive":1029,"domContentLoadedEventStart":1029,"domContentLoadedEventEnd":1080,"domComplete":1478,"loadEventStart":1478,"loadEventEnd":1478,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":995.7000002861023},{"name":"bigPipe.sidebar-id.end","time":996.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":996.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.end","time":997.7000002861023},{"name":"activityTabFullyLoaded","time":1102.6000003814697}],"measures":[],"correlationId":"a0433f3b3fb7f9","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":12,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-12353 Efficient InnoDB redo log record format
Plan: