MySQL Forums
Forum List  »  MySQL Shell

Re: MySQL Shell 8.0.16
Posted by: Dayo Lasode
Date: May 17, 2019 06:41AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1069
April 25, 2019 03:47PM
Re: MySQL Shell 8.0.16
545
May 17, 2019 06:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.