Maxscale requires GTID repl for failover but servers show gtid by default. I would like a better display of information on this since if a slave is rebuilt and misconfigured with basic binlog_pos it at a glance looks like maxscale is heathy but is in fact no longer HA. This is disastrous if a master goes and stays down to get a replica promoted.
For usability a display like below is ideal to see what the current service status really is
[ACME] root@maxscale-1: etc # maxctrl list servers
The slaves here are clearly configured but ineligible for failover
Developer Description
The GTID alone doesn't show all of the information related to replication. Extending the --fields flag from MXS-5220 to include the SQL and IO thread states and other bits from the slave_connections field would be useful:
"slave_connections": [
{
"connection_name": "",
"gtid_io_pos": "",
"last_io_error": "",
"last_sql_error": "",
"master_host": "127.0.0.1",
"master_port": 3000,
"master_server_id": 3000,
"master_server_name": "server1",
"seconds_behind_master": 0,
"slave_io_running": "Yes",
"slave_sql_running": "Yes",
"using_gtid": "No"
}
],
Attachments
Issue Links
relates to
MXS-5220Allow customization of fields in `maxctrl list` commands
The GTID is the GTID position, not how the GTIDs are being replicated. Not displaying it for the cases where file+position replication is used would break it for all users who use it. I think this would be better solved by adding the information in maxctrl show services and show monitors (have you checked these already?) where the other fine details of replication are located.
markus makela
added a comment - - edited The GTID is the GTID position, not how the GTIDs are being replicated. Not displaying it for the cases where file+position replication is used would break it for all users who use it. I think this would be better solved by adding the information in maxctrl show services and show monitors (have you checked these already?) where the other fine details of replication are located.
People
Unassigned
Bryan Bancroft (Inactive)
Votes:
0Vote for this issue
Watchers:
3Start 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":810,"ttfb":214.19999980926514,"pageVisibility":"visible","entityId":125012,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"e7aa2422-d1b9-42bf-8906-453763492f7b","navigationType":0,"readyForUser":934.4000000953674,"redirectCount":0,"resourceLoadedEnd":519.4000000953674,"resourceLoadedStart":249.40000009536743,"resourceTiming":[{"duration":5.599999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":249.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":255,"responseStart":0,"secureConnectionStart":0},{"duration":5.800000190734863,"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":249.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":255.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":155.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":249.7999997138977,"connectEnd":249.7999997138977,"connectStart":249.7999997138977,"domainLookupEnd":249.7999997138977,"domainLookupStart":249.7999997138977,"fetchStart":249.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":261.09999990463257,"responseEnd":405.5,"responseStart":279,"secureConnectionStart":249.7999997138977},{"duration":269,"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":250.40000009536743,"connectEnd":250.40000009536743,"connectStart":250.40000009536743,"domainLookupEnd":250.40000009536743,"domainLookupStart":250.40000009536743,"fetchStart":250.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":260.90000009536743,"responseEnd":519.4000000953674,"responseStart":272.90000009536743,"secureConnectionStart":250.40000009536743},{"duration":8.300000190734863,"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":250.59999990463257,"connectEnd":250.59999990463257,"connectStart":250.59999990463257,"domainLookupEnd":250.59999990463257,"domainLookupStart":250.59999990463257,"fetchStart":250.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":250.59999990463257,"responseEnd":258.90000009536743,"responseStart":258.90000009536743,"secureConnectionStart":250.59999990463257},{"duration":35.30000019073486,"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":250.7999997138977,"connectEnd":250.7999997138977,"connectStart":250.7999997138977,"domainLookupEnd":250.7999997138977,"domainLookupStart":250.7999997138977,"fetchStart":250.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":263.59999990463257,"responseEnd":286.09999990463257,"responseStart":284.19999980926514,"secureConnectionStart":250.7999997138977},{"duration":35.5,"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":250.90000009536743,"connectEnd":250.90000009536743,"connectStart":250.90000009536743,"domainLookupEnd":250.90000009536743,"domainLookupStart":250.90000009536743,"fetchStart":250.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":265.5,"responseEnd":286.40000009536743,"responseStart":284.7999997138977,"secureConnectionStart":250.90000009536743},{"duration":9.099999904632568,"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":251.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":251.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":260.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":38,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":251.19999980926514,"connectEnd":251.19999980926514,"connectStart":251.19999980926514,"domainLookupEnd":251.19999980926514,"domainLookupStart":251.19999980926514,"fetchStart":251.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":265.69999980926514,"responseEnd":289.19999980926514,"responseStart":286.59999990463257,"secureConnectionStart":251.19999980926514},{"duration":11.699999809265137,"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":251.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":251.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":263.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":38,"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":251.59999990463257,"connectEnd":251.59999990463257,"connectStart":251.59999990463257,"domainLookupEnd":251.59999990463257,"domainLookupStart":251.59999990463257,"fetchStart":251.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":266,"responseEnd":289.59999990463257,"responseStart":288.19999980926514,"secureConnectionStart":251.59999990463257},{"duration":27.699999809265137,"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":259.5,"connectEnd":259.5,"connectStart":259.5,"domainLookupEnd":259.5,"domainLookupStart":259.5,"fetchStart":259.5,"redirectEnd":0,"redirectStart":0,"requestStart":259.5,"responseEnd":287.19999980926514,"responseStart":287.19999980926514,"secureConnectionStart":259.5},{"duration":35.69999980926514,"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":259.59999990463257,"connectEnd":259.59999990463257,"connectStart":259.59999990463257,"domainLookupEnd":259.59999990463257,"domainLookupStart":259.59999990463257,"fetchStart":259.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":259.59999990463257,"responseEnd":295.2999997138977,"responseStart":295.2999997138977,"secureConnectionStart":259.59999990463257},{"duration":59,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":558.6999998092651,"connectEnd":558.6999998092651,"connectStart":558.6999998092651,"domainLookupEnd":558.6999998092651,"domainLookupStart":558.6999998092651,"fetchStart":558.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":586,"responseEnd":617.6999998092651,"responseStart":617.0999999046326,"secureConnectionStart":558.6999998092651},{"duration":256.19999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":803.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":803.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1059.6999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":39,"responseStart":214,"responseEnd":258,"domLoading":217,"domInteractive":1004,"domContentLoadedEventStart":1004,"domContentLoadedEventEnd":1051,"domComplete":1298,"loadEventStart":1298,"loadEventEnd":1298,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":983.1999998092651},{"name":"bigPipe.sidebar-id.end","time":984.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":984.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":985.0999999046326},{"name":"activityTabFullyLoaded","time":1070.1999998092651}],"measures":[],"correlationId":"3e77f937eda5eb","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":99,"dbReadsTimeInMs":12,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Major
The GTID is the GTID position, not how the GTIDs are being replicated. Not displaying it for the cases where file+position replication is used would break it for all users who use it. I think this would be better solved by adding the information in maxctrl show services and show monitors (have you checked these already?) where the other fine details of replication are located.