Hello,
we have multi-mariadb environments and decided to split my.cnf into few smaller configs for easier management and configuration support
However, it came to my attention that mysqld_multi doesn't support includes, or in simple words - doesn't "respect" include setting in my.cnf
This seems to be a very old behavior, since mysql 5.0 http://bugs.mysql.com/bug.php?id=29327
Some patches exist but I'd like to avoid patching it, better have it that functionality out of the box
The patch was provided by one of the aforementioned task's commentators http://bugs.mysql.com/file.php?id=17400&bug_id=29327
I haven't tested it but it looks like a simplest one, so should work.
It adds just few more lines to cover both RedHat and Debian include paths (not sure about Debian though cause I am CentOS user)
The only thing is that it's strictly searching under /etc/mysql.d/ path for *.cnf (in CentOS). (Maybe someone wants to have it under a different dir?)
So probably looking for includedir in my.cnf is desirable. But I would stay with default as is, after all it's FHS compliant
I don't mind if this patch will be included since that's the dir path I anyway planned to use and obviously my files would have *.cnf extension
Thanks!
p.s. found many reports about mysqld_multi include problem here and there, even on Percona forums
I hope MariaDB can finally make it happen!
Alex
added a comment - Hi Elena,
Thanks for replying!
The patch was provided by one of the aforementioned task's commentators
http://bugs.mysql.com/file.php?id=17400&bug_id=29327
I haven't tested it but it looks like a simplest one, so should work.
It adds just few more lines to cover both RedHat and Debian include paths (not sure about Debian though cause I am CentOS user)
The only thing is that it's strictly searching under /etc/mysql.d/ path for *.cnf (in CentOS). (Maybe someone wants to have it under a different dir?)
So probably looking for includedir in my.cnf is desirable. But I would stay with default as is, after all it's FHS compliant
I don't mind if this patch will be included since that's the dir path I anyway planned to use and obviously my files would have *.cnf extension
Thanks!
p.s. found many reports about mysqld_multi include problem here and there, even on Percona forums
I hope MariaDB can finally make it happen!
It doesn't look like a real fix for the non-working directive problem, does it?
Maybe I'm missing something, I'll leave it to serg to decide if it's a proper patch and whether it can be included.
Elena Stepanova
added a comment - It doesn't look like a real fix for the non-working directive problem, does it?
Maybe I'm missing something, I'll leave it to serg to decide if it's a proper patch and whether it can be included.
Yes, you are right, it doesn't look like the fix. more than that it doesn't work.
I am including patch we wrote (and that works)
What it does:
scans all found cnf files for !includedir
scans for *.cnf in !includedir directory
adds those files to previously found my.cnf (.my.cnf) files
passes all files to find_groups
note:
it doesn't look for more !includedir directives in files found
it doesn't parse !include (for single files)
Hope it helps and can be polished/included and finally released
Thanks!
Alex
added a comment - Yes, you are right, it doesn't look like the fix. more than that it doesn't work.
I am including patch we wrote (and that works)
What it does:
scans all found cnf files for !includedir
scans for *.cnf in !includedir directory
adds those files to previously found my.cnf (.my.cnf) files
passes all files to find_groups
note:
it doesn't look for more !includedir directives in files found
it doesn't parse !include (for single files)
Hope it helps and can be polished/included and finally released
Thanks!
People
Sergei Golubchik
Alex
Votes:
1Vote for this issue
Watchers:
4Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":1875.5999994277954,"ttfb":410.79999923706055,"pageVisibility":"visible","entityId":49423,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"915d2342-7a0a-442c-b8d4-f5d8dbbf92e4","navigationType":0,"readyForUser":1929.1999998092651,"redirectCount":0,"resourceLoadedEnd":2551.5,"resourceLoadedStart":418.3999996185303,"resourceTiming":[{"duration":572.6000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":418.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":418.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":991,"responseStart":0,"secureConnectionStart":0},{"duration":572.5999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":418.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":418.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":991.2999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":568.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":418.8999996185303,"connectEnd":418.8999996185303,"connectStart":418.8999996185303,"domainLookupEnd":418.8999996185303,"domainLookupStart":418.8999996185303,"fetchStart":418.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":418.8999996185303,"responseEnd":987.5,"responseStart":987.3999996185303,"secureConnectionStart":418.8999996185303},{"duration":642.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":419.0999994277954,"connectEnd":419.0999994277954,"connectStart":419.0999994277954,"domainLookupEnd":419.0999994277954,"domainLookupStart":419.0999994277954,"fetchStart":419.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":419.0999994277954,"responseEnd":1061.1999998092651,"responseStart":1061.1999998092651,"secureConnectionStart":419.0999994277954},{"duration":646.5,"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":419.3999996185303,"connectEnd":419.3999996185303,"connectStart":419.3999996185303,"domainLookupEnd":419.3999996185303,"domainLookupStart":419.3999996185303,"fetchStart":419.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":419.3999996185303,"responseEnd":1065.8999996185303,"responseStart":1065.8999996185303,"secureConnectionStart":419.3999996185303},{"duration":647.1999998092651,"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":419.5999994277954,"connectEnd":419.5999994277954,"connectStart":419.5999994277954,"domainLookupEnd":419.5999994277954,"domainLookupStart":419.5999994277954,"fetchStart":419.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":419.5999994277954,"responseEnd":1066.7999992370605,"responseStart":1066.7999992370605,"secureConnectionStart":419.5999994277954},{"duration":647.8000001907349,"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":419.79999923706055,"connectEnd":419.79999923706055,"connectStart":419.79999923706055,"domainLookupEnd":419.79999923706055,"domainLookupStart":419.79999923706055,"fetchStart":419.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":419.79999923706055,"responseEnd":1067.5999994277954,"responseStart":1067.5999994277954,"secureConnectionStart":419.79999923706055},{"duration":766.3999996185303,"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":420,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":420,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1186.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":648.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":420.0999994277954,"connectEnd":420.0999994277954,"connectStart":420.0999994277954,"domainLookupEnd":420.0999994277954,"domainLookupStart":420.0999994277954,"fetchStart":420.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":420.0999994277954,"responseEnd":1068.5,"responseStart":1068.5,"secureConnectionStart":420.0999994277954},{"duration":766.3000001907349,"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":420.29999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":420.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1186.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":649.6000003814697,"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":420.3999996185303,"connectEnd":420.3999996185303,"connectStart":420.3999996185303,"domainLookupEnd":420.3999996185303,"domainLookupStart":420.3999996185303,"fetchStart":420.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":420.3999996185303,"responseEnd":1070,"responseStart":1070,"secureConnectionStart":420.3999996185303},{"duration":1010.5,"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":423.5,"connectEnd":423.5,"connectStart":423.5,"domainLookupEnd":423.5,"domainLookupStart":423.5,"fetchStart":423.5,"redirectEnd":0,"redirectStart":0,"requestStart":423.5,"responseEnd":1434,"responseStart":1434,"secureConnectionStart":423.5},{"duration":2100.300000190735,"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":423.5999994277954,"connectEnd":423.5999994277954,"connectStart":423.5999994277954,"domainLookupEnd":423.5999994277954,"domainLookupStart":423.5999994277954,"fetchStart":423.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":423.5999994277954,"responseEnd":2523.8999996185303,"responseStart":2523.8999996185303,"secureConnectionStart":423.5999994277954},{"duration":248.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1223.5,"connectEnd":1223.5,"connectStart":1223.5,"domainLookupEnd":1223.5,"domainLookupStart":1223.5,"fetchStart":1223.5,"redirectEnd":0,"redirectStart":0,"requestStart":1223.5,"responseEnd":1472,"responseStart":1472,"secureConnectionStart":1223.5},{"duration":843.3000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1687.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1687.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2531.199999809265,"responseStart":0,"secureConnectionStart":0},{"duration":848.6999998092651,"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","startTime":1695,"connectEnd":1695,"connectStart":1695,"domainLookupEnd":1695,"domainLookupStart":1695,"fetchStart":1695,"redirectEnd":0,"redirectStart":0,"requestStart":1695,"responseEnd":2543.699999809265,"responseStart":2543.699999809265,"secureConnectionStart":1695},{"duration":856,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1695.5,"connectEnd":1695.5,"connectStart":1695.5,"domainLookupEnd":1695.5,"domainLookupStart":1695.5,"fetchStart":1695.5,"redirectEnd":0,"redirectStart":0,"requestStart":1695.5,"responseEnd":2551.5,"responseStart":2551.5,"secureConnectionStart":1695.5},{"duration":727.7000007629395,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1851.2999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1851.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2579,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":261,"responseStart":410,"responseEnd":413,"domLoading":415,"domInteractive":2587,"domContentLoadedEventStart":2587,"domContentLoadedEventEnd":2636,"domComplete":3080,"loadEventStart":3080,"loadEventEnd":3081,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2552.2999992370605},{"name":"bigPipe.sidebar-id.end","time":2553.2999992370605},{"name":"bigPipe.activity-panel-pipe-id.start","time":2553.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":2554.8999996185303},{"name":"activityTabFullyLoaded","time":2658.3999996185303}],"measures":[],"correlationId":"5e532890998ff2","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":94,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Do you want to provide (contribute) a patch which we could apply? It would probably go much faster this way.