Re: MySQL Shell 8.0.16

[Dayo Lasode]

Hi,


I had a lab instance of the InnoDB cluster (3 nodes) running MySQL Enterprise 5.7.26 (shell v8.011) in single-primary mode

I upgraded one of the R/O members to Enterprise 8.0.16 (and shell v8.0.16), wishing to explore the new features of the shell, specifically the version information provided as part of the status() method but this isn't displayed by default? (see below)

root@controller:~# ansible -m shell -a "mysqld --version && mysqlsh --version" mysqldbs


mysdbox2 | CHANGED | rc=0 >>
/usr/sbin/mysqld Ver 8.0.16-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial)
mysqlsh Ver 8.0.16-commercial for Linux on x86_64 - for MySQL 8.0.16 (MySQL Enterprise Server - Commercial)

mysdbox1 | CHANGED | rc=0 >>
mysqld Ver 5.7.26 for Linux on x86_64 (MySQL Commercial Server (Advanced))
mysqlsh Ver 8.0.11 for Linux on x86_64 - for MySQL 8.0.11 (MySQL Enterprise Server - Commercial)

mysdbox3 | CHANGED | rc=0 >>
mysqld Ver 5.7.26 for Linux on x86_64 (MySQL Commercial Server (Advanced))
mysqlsh Ver 8.0.11 for Linux on x86_64 - for MySQL 8.0.11 (MySQL Enterprise Server - Commercial)


## On the upgraded member ##

root@mysdbox2:~# mysqlsh --uri clustadmin@localhost:1485 -- cluster status
Please provide the password for 'clustadmin@localhost:1485': ********
Save password for 'clustadmin@localhost:1485'? [Y]es/[N]o/Ne[v]er (default No):
{
"clusterName": "labcluster_home",
"defaultReplicaSet": {
"name": "default",
"primary": "mysdbox1:1485",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"mysdbox1:1485": {
"address": "mysdbox1:1485",
"mode": "R/W",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
},
"mysdbox2:1485": {
"address": "mysdbox2:1485",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
},
"mysdbox3:1485": {
"address": "mysdbox3:1485",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
}
},
"topologyMode": "Single-Primary"
},
"groupInformationSourceMember": "mysdbox1:1485"
}
root@mysdbox2:~#


The queryMembers option enables the display of the version information but only for the 5.7.26 instances. Version information is not displayed for v8.0.16 (below)

root@mysdbox2:~# mysqlsh --uri clustadmin@localhost:1485 -- cluster status --queryMembers=true
Please provide the password for 'clustadmin@localhost:1485': ********
Save password for 'clustadmin@localhost:1485'? [Y]es/[N]o/Ne[v]er (default No):
{
"clusterName": "labcluster_home",
"defaultReplicaSet": {
"name": "default",
"primary": "mysdbox1:1485",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"mysdbox1:1485": {
"address": "mysdbox1:1485",
"autoRejoinRunning": false,
"mode": "R/W",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"transactions": {
"connection": {
"lastHeartbeatTimestamp": "",
"receivedHeartbeats": 0,
"receivedTransactionSet": "03f40eaf-77cc-11e9-af8b-0800273ec00f:1-11064:1000017-1000027,
b5c4aadc-77ca-11e9-a81a-0800273ec00f:1-14",
"threadId": null
},
"coordinator": {
"threadId": 42
},
"workers": [
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11064",
"threadId": 43
},
{
"lastSeen": "",
"threadId": 44
},
{
"lastSeen": "",
"threadId": 45
},
{
"lastSeen": "",
"threadId": 46
},
{
"lastSeen": "",
"threadId": 47
},
{
"lastSeen": "",
"threadId": 48
},
{
"lastSeen": "",
"threadId": 49
},
{
"lastSeen": "",
"threadId": 50
}
]
},
"version": "5.7.26"
},
"mysdbox2:1485": {
"address": "mysdbox2:1485",
"autoRejoinRunning": false,
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"transactions": {
"connection": {
"lastHeartbeatTimestamp": "",
"lastQueued": {
"endTimestamp": "2019-05-17 12:45:19.470480",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"queueTime": 0.000044,
"startTimestamp": "2019-05-17 12:45:19.470436",
"transaction": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11064"
},
"receivedHeartbeats": 0,
"receivedTransactionSet": "03f40eaf-77cc-11e9-af8b-0800273ec00f:1-11064:1000017-1000027,
b5c4aadc-77ca-11e9-a81a-0800273ec00f:1-14",
"threadId": null
},
"coordinator": {
"lastProcessed": {
"bufferTime": 0.000039,
"endTimestamp": "2019-05-17 12:45:19.470559",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"startTimestamp": "2019-05-17 12:45:19.470520",
"transaction": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11064"
},
"threadId": 59
},
"workers": [
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 60
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 61
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 62
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 63
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 64
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 65
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 66
},
{
"lastApplied": {
"applyTime": null,
"endTimestamp": "",
"immediateCommitTimestamp": "",
"immediateCommitToEndTime": null,
"originalCommitTimestamp": "",
"originalCommitToEndTime": null,
"retries": 0,
"startTimestamp": "",
"transaction": ""
},
"threadId": 67
}
]
}
},
"mysdbox3:1485": {
"address": "mysdbox3:1485",
"autoRejoinRunning": false,
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"transactions": {
"connection": {
"lastHeartbeatTimestamp": "",
"receivedHeartbeats": 0,
"receivedTransactionSet": "03f40eaf-77cc-11e9-af8b-0800273ec00f:1-11064:1000017-1000027,
b5c4aadc-77ca-11e9-a81a-0800273ec00f:1-14",
"threadId": null
},
"coordinator": {
"threadId": 39
},
"workers": [
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11064",
"threadId": 40
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11043",
"threadId": 41
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11034",
"threadId": 42
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:11035",
"threadId": 43
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:10819",
"threadId": 44
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:10820",
"threadId": 45
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:10821",
"threadId": 46
},
{
"lastSeen": "03f40eaf-77cc-11e9-af8b-0800273ec00f:10823",
"threadId": 47
}
]
},
"version": "5.7.26"
}
},
"topologyMode": "Single-Primary"
},
"groupInformationSourceMember": "mysdbox1:1485"
}
root@mysdbox2:~#


Any ideas?

Thanks
Dayo