1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
| MySQL 10.0.139.163:33006 ssl JS > rs.setPrimaryInstance('root@10.0.139.163:33006') t-luhx03-v-szzb:33006 will be promoted to PRIMARY of 'replset1'. The current PRIMARY is t-luhx01-v-szzb:33006.
* Connecting to replicaset instances ** Connecting to t-luhx01-v-szzb:33006 ** Connecting to t-luhx02-v-szzb:33006 ** Connecting to t-luhx03-v-szzb:33006 ** Connecting to t-luhx01-v-szzb:33006 ** Connecting to t-luhx02-v-szzb:33006 ** Connecting to t-luhx03-v-szzb:33006
* Performing validation checks ** Checking async replication topology... ** Checking transaction state of the instance...
* Synchronizing transaction backlog at t-luhx03-v-szzb:33006
* Updating metadata
* Acquiring locks in replicaset instances ** Pre-synchronizing SECONDARIES ** Acquiring global lock at PRIMARY ** Acquiring global lock at SECONDARIES
* Updating replication topology ** Configuring t-luhx01-v-szzb:33006 to replicate from t-luhx03-v-szzb:33006 ** Changing replication source of t-luhx02-v-szzb:33006 to t-luhx03-v-szzb:33006
t-luhx03-v-szzb:33006 was promoted to PRIMARY.
MySQL 10.0.139.163:33006 ssl JS > rs.status() { "replicaSet": { "name": "replset1", "primary": "t-luhx03-v-szzb:33006", "status": "AVAILABLE", "statusText": "All instances available.", "topology": { "t-luhx01-v-szzb:33006": { "address": "t-luhx01-v-szzb:33006", "instanceRole": "SECONDARY", "mode": "R/O", "replication": { "applierStatus": "APPLIED_ALL", "applierThreadState": "Waiting for an event from Coordinator", "applierWorkerThreads": 4, "receiverStatus": "ON", "receiverThreadState": "Waiting for master to send event", "replicationLag": null }, "status": "ONLINE" }, "t-luhx02-v-szzb:33006": { "address": "t-luhx02-v-szzb:33006", "instanceRole": "SECONDARY", "mode": "R/O", "replication": { "applierStatus": "APPLIED_ALL", "applierThreadState": "Waiting for an event from Coordinator", "applierWorkerThreads": 4, "receiverStatus": "ON", "receiverThreadState": "Waiting for master to send event", "replicationLag": null }, "status": "ONLINE" }, "t-luhx03-v-szzb:33006": { "address": "t-luhx03-v-szzb:33006", "instanceRole": "PRIMARY", "mode": "R/W", "status": "ONLINE" } }, "type": "ASYNC" } }
|