怎么新建MySQL数据库

发布时间:2021-10-12 作者:admin
阅读:905

    这篇文章主要给大家分享mongodb添加arbiter节点的步骤和过程,对大家了解mongodb添加节点有一定的帮助,感兴趣的朋友可以参考一下,希望大家阅读完这篇文章能有所收获,下面我们一起来学习一下吧。

    在创建mongodb的replica set的时候,只是做成了1主2从,没有做成1主1从1仲裁。这我们将一个几点从replica set中删除,再以仲裁节点的身份加入到replica set中:

    1.初始状态:

shard1ReplSet:PRIMARY> rs.status();rs.status();
{
  "set" : "shard1ReplSet",
  "date" : ISODate("2017-02-21T07:48:03.058Z"),
  "myState" : 1,
  "term" : NumberLong(1),
  "heartbeatIntervalMillis" : NumberLong(2000),
  "optimes" : {
    "lastCommittedOpTime" : {
      "ts" : Timestamp(0, 0),
      "t" : NumberLong(-1)
    },
    "appliedOpTime" : {
      "ts" : Timestamp(1487663274, 1),
      "t" : NumberLong(1)
    },
    "durableOpTime" : {
      "ts" : Timestamp(1487587982, 1),
      "t" : NumberLong(-1)
    }
  },
  "members" : [
    {
      "_id" : 0,
      "name" : "10.13.0.130:22001",
      "health" : 1,
      "state" : 1,
      "stateStr" : "PRIMARY",
      "uptime" : 76672,
      "optime" : {
        "ts" : Timestamp(1487663274, 1),
        "t" : NumberLong(1)
      },
      "optimeDate" : ISODate("2017-02-21T07:47:54Z"),
      "electionTime" : Timestamp(1487587993, 1),
      "electionDate" : ISODate("2017-02-20T10:53:13Z"),
      "configVersion" : 1,
      "self" : true
    },
    {
      "_id" : 1,
      "name" : "10.13.0.131:22001",
      "health" : 1,
      "state" : 2,
      "stateStr" : "SECONDARY",
      "uptime" : 75300,
      "optime" : {
        "ts" : Timestamp(1487663274, 1),
        "t" : NumberLong(1)
      },
      "optimeDurable" : {
        "ts" : Timestamp(1487587982, 1),
        "t" : NumberLong(-1)
      },
      "optimeDate" : ISODate("2017-02-21T07:47:54Z"),
      "optimeDurableDate" : ISODate("2017-02-20T10:53:02Z"),
      "lastHeartbeat" : ISODate("2017-02-21T07:48:02.150Z"),
      "lastHeartbeatRecv" : ISODate("2017-02-21T07:48:02.215Z"),
      "pingMs" : NumberLong(0),
      "syncingTo" : "10.13.0.132:22001",
      "configVersion" : 1
    },
    {
      "_id" : 2,
      "name" : "10.13.0.132:22001",
      "health" : 1,
      "state" : 2,
      "stateStr" : "SECONDARY",
      "uptime" : 75300,
      "optime" : {
        "ts" : Timestamp(1487663274, 1),
        "t" : NumberLong(1)
      },
      "optimeDurable" : {
        "ts" : Timestamp(1487587982, 1),
        "t" : NumberLong(-1)
      },
      "optimeDate" : ISODate("2017-02-21T07:47:54Z"),
      "optimeDurableDate" : ISODate("2017-02-20T10:53:02Z"),
      "lastHeartbeat" : ISODate("2017-02-21T07:48:02.889Z"),
      "lastHeartbeatRecv" : ISODate("2017-02-21T07:48:01.503Z"),
      "pingMs" : NumberLong(0),
      "syncingTo" : "10.13.0.130:22001",
      "configVersion" : 1
    }
  ],
  "ok" : 1
}
shard1ReplSet:PRIMARY> 
shard1ReplSet:PRIMARY> 
shard1ReplSet:PRIMARY> 
shard1ReplSet:PRIMARY> 

    2.删除节点:

shard1ReplSet:PRIMARY> rs.remove("10.13.0.132:22001"); rs.remove("10.13.0.132:22001"); 
{ "ok" : 1 }
shard1ReplSet:PRIMARY> rs.status();rs.status();
{
  "set" : "shard1ReplSet",
  "date" : ISODate("2017-02-21T07:50:52.934Z"),
  "myState" : 1,
  "term" : NumberLong(1),
  "heartbeatIntervalMillis" : NumberLong(2000),
  "optimes" : {
    "lastCommittedOpTime" : {
      "ts" : Timestamp(0, 0),
      "t" : NumberLong(-1)
    },
    "appliedOpTime" : {
      "ts" : Timestamp(1487663447, 1),
      "t" : NumberLong(1)
    },
    "durableOpTime" : {
      "ts" : Timestamp(1487587982, 1),
      "t" : NumberLong(-1)
    }
  },
  "members" : [
    {
      "_id" : 0,
      "name" : "10.13.0.130:22001",
      "health" : 1,
      "state" : 1,
      "stateStr" : "PRIMARY",
      "uptime" : 76841,
      "optime" : {
        "ts" : Timestamp(1487663447, 1),
        "t" : NumberLong(1)
      },
      "optimeDate" : ISODate("2017-02-21T07:50:47Z"),
      "electionTime" : Timestamp(1487587993, 1),
      "electionDate" : ISODate("2017-02-20T10:53:13Z"),
      "configVersion" : 2,
      "self" : true
    },
    {
      "_id" : 1,
      "name" : "10.13.0.131:22001",
      "health" : 1,
      "state" : 2,
      "stateStr" : "SECONDARY",
      "uptime" : 75470,
      "optime" : {
        "ts" : Timestamp(1487663447, 1),
        "t" : NumberLong(1)
      },
      "optimeDurable" : {
        "ts" : Timestamp(1487587982, 1),
        "t" : NumberLong(-1)
      },
      "optimeDate" : ISODate("2017-02-21T07:50:47Z"),
      "optimeDurableDate" : ISODate("2017-02-20T10:53:02Z"),
      "lastHeartbeat" : ISODate("2017-02-21T07:50:51.182Z"),
      "lastHeartbeatRecv" : ISODate("2017-02-21T07:50:52.212Z"),
      "pingMs" : NumberLong(0),
      "configVersion" : 2
    }
  ],
  "ok" : 1
}
shard1ReplSet:PRIMARY> 
shard1ReplSet:PRIMARY> 
shard1ReplSet:PRIMARY> 

    3.添加成arbiter节点:

shard1ReplSet:PRIMARY> rs.addArb("10.13.0.132:22001");rs.addArb("10.13.0.132:22001");
{ "ok" : 1 }
shard1ReplSet:PRIMARY> 
shard1ReplSet:PRIMARY> rs.status();rs.status();
{
  "set" : "shard1ReplSet",
  "date" : ISODate("2017-02-21T07:54:05.161Z"),
  "myState" : 1,
  "term" : NumberLong(1),
  "heartbeatIntervalMillis" : NumberLong(2000),
  "optimes" : {
    "lastCommittedOpTime" : {
      "ts" : Timestamp(0, 0),
      "t" : NumberLong(-1)
    },
    "appliedOpTime" : {
      "ts" : Timestamp(1487663637, 1),
      "t" : NumberLong(1)
    },
    "durableOpTime" : {
      "ts" : Timestamp(1487587982, 1),
      "t" : NumberLong(-1)
    }
  },
  "members" : [
    {
      "_id" : 0,
      "name" : "10.13.0.130:22001",
      "health" : 1,
      "state" : 1,
      "stateStr" : "PRIMARY",
      "uptime" : 77034,
      "optime" : {
        "ts" : Timestamp(1487663637, 1),
        "t" : NumberLong(1)
      },
      "optimeDate" : ISODate("2017-02-21T07:53:57Z"),
      "electionTime" : Timestamp(1487587993, 1),
      "electionDate" : ISODate("2017-02-20T10:53:13Z"),
      "configVersion" : 3,
      "self" : true
    },
    {
      "_id" : 1,
      "name" : "10.13.0.131:22001",
      "health" : 1,
      "state" : 2,
      "stateStr" : "SECONDARY",
      "uptime" : 75662,
      "optime" : {
        "ts" : Timestamp(1487663637, 1),
        "t" : NumberLong(1)
      },
      "optimeDurable" : {
        "ts" : Timestamp(1487587982, 1),
        "t" : NumberLong(-1)
      },
      "optimeDate" : ISODate("2017-02-21T07:53:57Z"),
      "optimeDurableDate" : ISODate("2017-02-20T10:53:02Z"),
      "lastHeartbeat" : ISODate("2017-02-21T07:54:03.210Z"),
      "lastHeartbeatRecv" : ISODate("2017-02-21T07:54:02.211Z"),
      "pingMs" : NumberLong(0),
      "configVersion" : 3
    },
    {
      "_id" : 2,
      "name" : "10.13.0.132:22001",
      "health" : 1,
      "state" : 7,
      "stateStr" : "ARBITER",
      "uptime" : 5,
      "lastHeartbeat" : ISODate("2017-02-21T07:54:03.214Z"),
      "lastHeartbeatRecv" : ISODate("2017-02-21T07:54:02.274Z"),
      "pingMs" : NumberLong(0),
      "configVersion" : 3
    }
  ],
  "ok" : 1
}
shard1ReplSet:PRIMARY> 

    注1: mongodb 3.4之后,虽然要求config server为replica set,但是不支持arbiter。

    添加的时候,会报错:

cfgReplSet:PRIMARY> rs.addArb("10.13.0.132:21000");rs.addArb("10.13.0.132:21000");
{
  "ok" : 0,
  "errmsg" : "Arbiters are not allowed in replica set configurations being used for config servers",
  "code" : 103,
  "codeName" : "NewReplicaSetConfigurationIncompatible"
}
cfgReplSet:PRIMARY> 

    注2:rs.reconfig()也可以进行操作,效果类似re.remove+rs.addArb,详见:mongodb官方文档- Remove Members from Replica Set

    总结

    以上就是关于mongodb添加arbiter节的介绍啦,上述示例具有一定的借鉴价值,有需要的朋友可以了解看看,想要了解更多mongodb添加节点的内容,大家可以继续浏览群英网络其他相关的文章。

文本转载自脚本之家

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:mmqy2019@163.com进行举报,并提供相关证据,查实之后,将立刻删除涉嫌侵权内容。

二维码-群英

长按识别二维码并关注微信

更方便到期提醒、手机管理

7*24 全天候服务

售前 400-678-4567

售后 0668-2555666

售后 400 678 4567

信息安全 0668-2555 118

域名空间 3004329145