美文网首页
mongodb3.6副本集升级为分片副本集

mongodb3.6副本集升级为分片副本集

作者: OrangeLoveMilan | 来源:发表于2020-05-25 10:47 被阅读0次

    服务器信息

    ip 系统 配置 服务 目录
    172.24.32.201 centos7.7 2c4g mongo-primary /var/lib/mongo (the data directory) /var/log/mongodb (the log directory)
    172.24.32.201 centos7.7 2c4g mongo-secondary /var/lib/mongo27018 (the data directory) /var/log/mongodb27018 (the log directory)
    172.24.32.201 centos7.7 2c4g mongo-secondary /var/lib/mongo27019 (the data directory) /var/log/mongodb27019 (the log directory)

    由于config、mongos、mongod全部在一台服务器上。所以这里用目录区分

    整理下服务目录和文件名

    这里先清空之前的架构为一主两从的三副本集,整理下目录名和文件名

    systemctl stop mongod
systemctl stop mongod27018
systemctl stop mongod27019

    rm -rf /var/lib/mongo/*
rm -rf /var/lib/mongo2701*/*

    mongo27017的信息

    • 配置文件
      /etc/mongod27017.conf
    • 启动文件
      /usr/lib/systemd/system/mongod27017.service

    mongo27018的信息

    • 配置文件
      /etc/mongod27018.conf
    • 启动文件
      /usr/lib/systemd/system/mongod27018.service

    mongo27019的信息

    • 配置文件
      /etc/mongod27019.conf
    • 启动文件
      /usr/lib/systemd/system/mongod27019.service

    启动

    systemctl daemon-reload
systemctl start mongod27017
systemctl start mongod27018
systemctl start mongod27019

    进入并创建副本集

    mongo 127.0.0.1:27017/admin
config = {
       _id : "lugotestrepl",
       members : [
            {_id : 0, host : "127.0.0.1:27017" , priority:33},
            {_id : 1, host : "127.0.0.1:27018" , priority:2},
            {_id : 2, host : "127.0.0.1:27019" , priority:2}
        ]
    }
rs.initiate(config);

    副本集状态

    lugotestrepl:PRIMARY> rs.status();
{
    "set" : "lugotestrepl",
    "date" : ISODate("2020-05-15T06:50:06.639Z"),
    "myState" : 1,
    "term" : NumberLong(2),
    "syncingTo" : "",
    "syncSourceHost" : "",
    "syncSourceId" : -1,
    "heartbeatIntervalMillis" : NumberLong(2000),
    "optimes" : {
        "lastCommittedOpTime" : {
            "ts" : Timestamp(1589525404, 1),
            "t" : NumberLong(2)
        },
        "readConcernMajorityOpTime" : {
            "ts" : Timestamp(1589525404, 1),
            "t" : NumberLong(2)
        },
        "appliedOpTime" : {
            "ts" : Timestamp(1589525404, 1),
            "t" : NumberLong(2)
        },
        "durableOpTime" : {
            "ts" : Timestamp(1589525404, 1),
            "t" : NumberLong(2)
        }
    },
    "members" : [
        {
            "_id" : 0,
            "name" : "127.0.0.1:27017",
            "health" : 1,
            "state" : 1,
            "stateStr" : "PRIMARY",
            "uptime" : 1569,
            "optime" : {
                "ts" : Timestamp(1589525404, 1),
                "t" : NumberLong(2)
            },
            "optimeDate" : ISODate("2020-05-15T06:50:04Z"),
            "syncingTo" : "",
            "syncSourceHost" : "",
            "syncSourceId" : -1,
            "infoMessage" : "",
            "electionTime" : Timestamp(1589524572, 1),
            "electionDate" : ISODate("2020-05-15T06:36:12Z"),
            "configVersion" : 1,
            "self" : true,
            "lastHeartbeatMessage" : ""
        },
        {
            "_id" : 1,
            "name" : "127.0.0.1:27018",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 855,
            "optime" : {
                "ts" : Timestamp(1589525404, 1),
                "t" : NumberLong(2)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1589525404, 1),
                "t" : NumberLong(2)
            },
            "optimeDate" : ISODate("2020-05-15T06:50:04Z"),
            "optimeDurableDate" : ISODate("2020-05-15T06:50:04Z"),
            "lastHeartbeat" : ISODate("2020-05-15T06:50:05.477Z"),
            "lastHeartbeatRecv" : ISODate("2020-05-15T06:50:04.876Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "127.0.0.1:27017",
            "syncSourceHost" : "127.0.0.1:27017",
            "syncSourceId" : 0,
            "infoMessage" : "",
            "configVersion" : 1
        },
        {
            "_id" : 2,
            "name" : "127.0.0.1:27019",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 855,
            "optime" : {
                "ts" : Timestamp(1589525404, 1),
                "t" : NumberLong(2)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1589525404, 1),
                "t" : NumberLong(2)
            },
            "optimeDate" : ISODate("2020-05-15T06:50:04Z"),
            "optimeDurableDate" : ISODate("2020-05-15T06:50:04Z"),
            "lastHeartbeat" : ISODate("2020-05-15T06:50:05.477Z"),
            "lastHeartbeatRecv" : ISODate("2020-05-15T06:50:04.755Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "127.0.0.1:27017",
            "syncSourceHost" : "127.0.0.1:27017",
            "syncSourceId" : 0,
            "infoMessage" : "",
            "configVersion" : 1
        }
    ],
    "ok" : 1
}

    插入数据
    创建用户

    db.createUser({
    user: "admin",
    pwd: "test123",
    roles: ["root"]
});

    插入数据

    lugotestrepl:PRIMARY> db.movie.insert({"moviename":"大侦探福尔摩斯","points":"9.5"})
WriteResult({ "nInserted" : 1 })

    查看数据

    lugotestrepl:PRIMARY> db.movie.find().pretty();
{
    "_id" : ObjectId("5ebe402573a048240cf0e087"),
    "moviename" : "大侦探福尔摩斯",
    "points" : "9.5"
}
{
    "_id" : ObjectId("5ebe404173a048240cf0e088"),
    "moviename" : "掠夺",
    "points" : "9.2"
}
{
    "_id" : ObjectId("5ebe405073a048240cf0e089"),
    "moviename" : "摇滚黑帮",
    "points" : "9.9"
}
{
    "_id" : ObjectId("5ebe405b73a048240cf0e08a"),
    "moviename" : "两杆大烟枪",
    "points" : "9.1"
}
{
    "_id" : ObjectId("5ebe406873a048240cf0e08b"),
    "moviename" : "杀死比尔",
    "points" : "9.0"
}

    至此，mongo27017~27018副本集重构完毕
    架构为一主两从。

    搭建config副本集

    mongodb3.4以后要求配置服务器也创建副本集，不然集群搭建不成功。

    -------------------config21000目录--------------------------
mkdir -p /var/log/mongodbconfig/
mkdir -p /var/lib/mongoconfig/config21000/data
mkdir -p /var/run/mongodbconfig21000/
chown -R mongod:mongod /var/log/mongodbconfig/ &&chmod 0755 /var/log/mongodbconfig/
chown -R mongod:mongod /var/lib/mongoconfig/config21000/data &&chmod 0755 /var/lib/mongoconfig/config21000/data
chown -R mongod:mongod /var/run/mongodbconfig21000/ &&chmod 0755 /var/run/mongodbconfig21000/
-------------------config21001目录--------------------------
mkdir -p /var/lib/mongoconfig/config21001/data
mkdir -p /var/run/mongodbconfig21001/
chown -R mongod:mongod /var/lib/mongoconfig/config21001/data &&chmod 0755 /var/lib/mongoconfig/config21001/data
chown -R mongod:mongod /var/run/mongodbconfig21001/ &&chmod 0755 /var/run/mongodbconfig21001/
-------------------config21002目录--------------------------
mkdir -p /var/lib/mongoconfig/config21002/data
mkdir -p /var/run/mongodbconfig21002/
chown -R mongod:mongod /var/lib/mongoconfig/config21002/data &&chmod 0755 /var/lib/mongoconfig/config21002/data
chown -R mongod:mongod /var/run/mongodbconfig21002/ &&chmod 0755 /var/run/mongodbconfig21002/

    config的副本集文件结构

    • 21000实例的配置文件
    cat >>/etc/mongod/conf.d/config_21000.conf<<EOF
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodbconfig/configsvr21000.log
 
storage:
  dbPath: /var/lib/mongoconfig/config21000/data
  journal:
    enabled: true

processManagement:
  fork: true
  pidFilePath: /var/run/mongodbconfig21000/configsvr.pid

net:
  port: 21000
  bindIp: 0.0.0.0
  maxIncomingConnections: 20000

replication:
  replSetName: lugotestreplconfig

sharding:
  clusterRole: configsvr
security:
    keyFile: /etc/mongokey/mongodb-keyfile
    clusterAuthMode: keyFile
setParameter:
    enableLocalhostAuthBypass: true

EOF
----------------------------------------------------------------------------
cat >>/usr/lib/systemd/system/mongodconfig21000.service<<EOF
[Unit]
Description=MongoDB Database Server
Documentation=https://docs.mongodb.org/manual
After=network.target

[Service]
User=mongod
Group=mongod
Environment="OPTIONS=-f /etc/mongod/conf.d/config_21000.conf"
ExecStart=/usr/bin/mongod $OPTIONS
#ExecStartPre=/usr/bin/mkdir -p /var/run/mongodb
#ExecStartPre=/usr/bin/chown mongod:mongod /var/run/mongodb
#ExecStartPre=/usr/bin/chmod 0755 /var/run/mongodb
PermissionsStartOnly=true
PIDFile=/var/run/mongodbconfig21000/mongod.pid
Type=forking
# file size
LimitFSIZE=infinity
# cpu time
LimitCPU=infinity
# virtual memory size
LimitAS=infinity
# open files
LimitNOFILE=64000
# processes/threads
LimitNPROC=64000
# locked memory
LimitMEMLOCK=infinity
# total threads (user+kernel)
TasksMax=infinity
TasksAccounting=false
# Recommended limits for for mongod as specified in
# http://docs.mongodb.org/manual/reference/ulimit/#recommended-settings

[Install]
WantedBy=multi-user.target
EOF
    • 21001实例的配置文件
    /etc/mongod/conf.d/config_21001.conf
/usr/lib/systemd/system/mongodconfig21001.service
    • 21002实例的配置文件
    /etc/mongod/conf.d/config_21002.conf
/usr/lib/systemd/system/mongodconfig21002.service

    启动config的三个实例

    systemctl restart mongodconfig21001
systemctl restart mongodconfig21002
systemctl restart mongodconfig21000

    进入实例，开始创建config副本集

    mongo 127.0.0.1:21000
> config = {
...          _id : "lugotestreplconfig", 
...          members : [
...            {_id : 0, host : "127.0.0.1:21000" },
...            {_id : 1, host : "127.0.0.1:21001" },
...            {_id : 2, host : "127.0.0.1:21002" }
...          ]
...  }
{
    "_id" : "lugotestreplconfig",
    "members" : [
        {
            "_id" : 0,
            "host" : "127.0.0.1:21000"
        },
        {
            "_id" : 1,
            "host" : "127.0.0.1:21001"
        },
        {
            "_id" : 2,
            "host" : "127.0.0.1:21002"
        }
    ]
}
> rs.initiate(config)
{
    "ok" : 1,
    "$gleStats" : {
        "lastOpTime" : Timestamp(1589527585, 1),
        "electionId" : ObjectId("000000000000000000000000")
    }
}

    至此，config节点副本集搭建完成，这个节点主要存放集群信息

    mongos搭建

    搭建路由节点，这里搭建个单机的测试使用

    • 配置文件
    cat >>/etc/mongod/conf.d/mongos_22222.conf<<EOF
systemLog:
  destination: file
  logAppend: true
  path: /var/log/mongodb/mongos22222.log

processManagement:
  fork: true
  pidFilePath: /var/run/mongodb/mongos22222.pid

net:
  port: 22222
  bindIp: 0.0.0.0
  maxIncomingConnections: 20000

sharding:
  configDB: lugotestreplconfig/172.24.32.201:21000,172.24.32.201:21001,172.24.32.201:21002


security:
    keyFile: /etc/mongokey/mongodb-keyfile
    clusterAuthMode: keyFile
setParameter:
    enableLocalhostAuthBypass: true

EOF
    • 启动文件
    cat >>/usr/lib/systemd/system/mongos22222.service<<EOF
[Unit]
Description=MongoDB Database Server
Documentation=https://docs.mongodb.org/manual
After=network.target

[Service]
User=mongod
Group=mongod
Environment="OPTIONS=-f /etc/mongod/conf.d/mongos_22222.conf"
ExecStart=/usr/bin/mongos $OPTIONS
#ExecStartPre=/usr/bin/mkdir -p /var/run/mongodb
#ExecStartPre=/usr/bin/chown mongod:mongod /var/run/mongodb
#ExecStartPre=/usr/bin/chmod 0755 /var/run/mongodb
PermissionsStartOnly=true
PIDFile=/var/run/mongodb/mongos22222.pid
Type=forking
# file size
LimitFSIZE=infinity
# cpu time
LimitCPU=infinity
# virtual memory size
LimitAS=infinity
# open files
LimitNOFILE=64000
# processes/threads
LimitNPROC=64000
# locked memory
LimitMEMLOCK=infinity
# total threads (user+kernel)
TasksMax=infinity
TasksAccounting=false
# Recommended limits for for mongod as specified in
# http://docs.mongodb.org/manual/reference/ulimit/#recommended-settings

[Install]
WantedBy=multi-user.target
EOF

    启动和开机自启动mongos

    systemctl start mongos22222
systemctl enable mongos22222

    将先前部署的副本集升级为一个分片副本集群中的一个分片

    进入mongos

    mongo 127.0.0.1:22222/admin

    创建账号

    mongos> db.createUser({
...     user: "admin",
...     pwd: "test123",
...     roles: ["root"]
... });
Successfully added user: { "user" : "admin", "roles" : [ "root" ] }
mongos> db.auth('admin','test123')
1

    分片

    sh.addShard("lugotestrepl/127.0.0.1:27017,127.0.0.1:27018,127.0.0.1:27019")

    查看信息

    mongos> db.runCommand({ listshards : 1 });
{
    "shards" : [
        {
            "_id" : "lugotestrepl",
            "host" : "lugotestrepl/127.0.0.1:27017,127.0.0.1:27018,127.0.0.1:27019",
            "state" : 1
        }
    ],
    "ok" : 1,
    "operationTime" : Timestamp(1589528828, 1),
    "$clusterTime" : {
        "clusterTime" : Timestamp(1589528828, 1),
        "signature" : {
            "hash" : BinData(0,"9kplNbREI1p373yIwx9vXICQy1w="),
            "keyId" : NumberLong("6826969049499435034")
        }
    }
}

    在分片副本集中，加入第二个副本集分片，并验证分片集群状态

    创建第二个副本集，并加入分片

    • mongod37017配置文件
      /etc/mongod37017.conf
    • 启动文件
      /usr/lib/systemd/system/mongod37017.service

    mongo37018的信息

    • 配置文件
      /etc/mongod37018.conf
    • 启动文件
      /usr/lib/systemd/system/mongod37019.service

    mongo37019的信息

    • 配置文件
      /etc/mongod37019.conf
    • 启动文件
      usr/lib/systemd/system/mongod37019.service

    启动mongod37017、mongod37018、mongod37019节点

    systemctl start mongod37017
systemctl start mongod37018
systemctl start mongod37019
systemctl enable mongod37017
systemctl enable mongod37018
systemctl enable mongod37019

    进入37017节点，创建副本集

    mongo 127.0.0.1:37017/admin
config = {
       _id : "shard2",
       members : [
            {_id : 0, host : "127.0.0.1:37017" , priority:33},
            {_id : 1, host : "127.0.0.1:37018" , priority:2},
            {_id : 2, host : "127.0.0.1:37019" , priority:2}
        ]
    }

    初始化，并查看状态

    > rs.initiate(config);
{ "ok" : 1 }

    状态

    shard2:PRIMARY> rs.status();
{
    "set" : "shard2",
    "date" : ISODate("2020-05-15T08:25:25.375Z"),
    "myState" : 1,
    "term" : NumberLong(1),
    "syncingTo" : "",
    "syncSourceHost" : "",
    "syncSourceId" : -1,
    "heartbeatIntervalMillis" : NumberLong(2000),
    "optimes" : {
        "lastCommittedOpTime" : {
            "ts" : Timestamp(1589531119, 1),
            "t" : NumberLong(1)
        },
        "readConcernMajorityOpTime" : {
            "ts" : Timestamp(1589531119, 1),
            "t" : NumberLong(1)
        },
        "appliedOpTime" : {
            "ts" : Timestamp(1589531119, 1),
            "t" : NumberLong(1)
        },
        "durableOpTime" : {
            "ts" : Timestamp(1589531119, 1),
            "t" : NumberLong(1)
        }
    },
    "members" : [
        {
            "_id" : 0,
            "name" : "127.0.0.1:37017",
            "health" : 1,
            "state" : 1,
            "stateStr" : "PRIMARY",
            "uptime" : 555,
            "optime" : {
                "ts" : Timestamp(1589531119, 1),
                "t" : NumberLong(1)
            },
            "optimeDate" : ISODate("2020-05-15T08:25:19Z"),
            "syncingTo" : "",
            "syncSourceHost" : "",
            "syncSourceId" : -1,
            "infoMessage" : "could not find member to sync from",
            "electionTime" : Timestamp(1589531097, 1),
            "electionDate" : ISODate("2020-05-15T08:24:57Z"),
            "configVersion" : 1,
            "self" : true,
            "lastHeartbeatMessage" : ""
        },
        {
            "_id" : 1,
            "name" : "127.0.0.1:37018",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 37,
            "optime" : {
                "ts" : Timestamp(1589531119, 1),
                "t" : NumberLong(1)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1589531119, 1),
                "t" : NumberLong(1)
            },
            "optimeDate" : ISODate("2020-05-15T08:25:19Z"),
            "optimeDurableDate" : ISODate("2020-05-15T08:25:19Z"),
            "lastHeartbeat" : ISODate("2020-05-15T08:25:23.540Z"),
            "lastHeartbeatRecv" : ISODate("2020-05-15T08:25:24.791Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "127.0.0.1:37017",
            "syncSourceHost" : "127.0.0.1:37017",
            "syncSourceId" : 0,
            "infoMessage" : "",
            "configVersion" : 1
        },
        {
            "_id" : 2,
            "name" : "127.0.0.1:37019",
            "health" : 1,
            "state" : 2,
            "stateStr" : "SECONDARY",
            "uptime" : 37,
            "optime" : {
                "ts" : Timestamp(1589531119, 1),
                "t" : NumberLong(1)
            },
            "optimeDurable" : {
                "ts" : Timestamp(1589531119, 1),
                "t" : NumberLong(1)
            },
            "optimeDate" : ISODate("2020-05-15T08:25:19Z"),
            "optimeDurableDate" : ISODate("2020-05-15T08:25:19Z"),
            "lastHeartbeat" : ISODate("2020-05-15T08:25:23.540Z"),
            "lastHeartbeatRecv" : ISODate("2020-05-15T08:25:24.754Z"),
            "pingMs" : NumberLong(0),
            "lastHeartbeatMessage" : "",
            "syncingTo" : "127.0.0.1:37017",
            "syncSourceHost" : "127.0.0.1:37017",
            "syncSourceId" : 0,
            "infoMessage" : "",
            "configVersion" : 1
        }
    ],
    "ok" : 1
}

    分片
    进入mongos

    [root@test02 run]# mongo 127.0.0.1:22222/admin
MongoDB shell version v3.6.18
connecting to: mongodb://127.0.0.1:22222/admin?gssapiServiceName=mongodb
Implicit session: session { "id" : UUID("098a5b12-bd06-4812-aa68-e2a0edb19136") }
MongoDB server version: 3.6.18
mongos> db.auth('admin','test123')
1

    分片指令

    sh.addShard("shard2/127.0.0.1:37017,127.0.0.1:37018,127.0.0.1:37019")

    分片成功

    1
mongos> sh.addShard("shard2/127.0.0.1:37017,127.0.0.1:37018,127.0.0.1:37019")
{
    "shardAdded" : "shard2",
    "ok" : 1,
    "operationTime" : Timestamp(1589531264, 7),
    "$clusterTime" : {
        "clusterTime" : Timestamp(1589531264, 7),
        "signature" : {
            "hash" : BinData(0,"Ks/rUayKm+xbS1OLr04B2DAt2g4="),
            "keyId" : NumberLong("6826969049499435034")
        }
    }
}

    查看分片状态

    mongos> db.runCommand({ listshards : 1 });
{
    "shards" : [
        {
            "_id" : "lugotestrepl",
            "host" : "lugotestrepl/127.0.0.1:27017,127.0.0.1:27018,127.0.0.1:27019",
            "state" : 1
        },
        {
            "_id" : "shard2",
            "host" : "shard2/127.0.0.1:37017,127.0.0.1:37018,127.0.0.1:37019",
            "state" : 1
        }
    ],
    "ok" : 1,
    "operationTime" : Timestamp(1589531316, 1),
    "$clusterTime" : {
        "clusterTime" : Timestamp(1589531316, 1),
        "signature" : {
            "hash" : BinData(0,"EoOJLcpnWACjeMa+VNRBmcg2UOE="),
            "keyId" : NumberLong("6826969049499435034")
        }
    }
}

    对先前创建的数据表进行分片操作，并验证数据的分布状态

    指定lugotest这个库分片生效

    db.runCommand( { enablesharding :"lugotest"});

    结果

    mongos> db.runCommand( { enablesharding :"lugotest"});
{
    "ok" : 1,
    "operationTime" : Timestamp(1589532403, 5),
    "$clusterTime" : {
        "clusterTime" : Timestamp(1589532403, 5),
        "signature" : {
            "hash" : BinData(0,"UkLPinHxT7rZ9EOxSNVTB4EHi+Q="),
            "keyId" : NumberLong("6826969049499435034")
        }
    }
}

    指定数据库lugotest里需要分片的集合test和片键id

    db.runCommand( { shardcollection : "lugotest.moive",key : {points: "hashed"} } )

    查看分片状态

    mongos> sh.status();
--- Sharding Status --- 
  sharding version: {
    "_id" : 1,
    "minCompatibleVersion" : 5,
    "currentVersion" : 6,
    "clusterId" : ObjectId("5ebe442e2923573eb3ecbdea")
  }
  shards:
        {  "_id" : "lugotestrepl",  "host" : "lugotestrepl/127.0.0.1:27017,127.0.0.1:27018,127.0.0.1:27019",  "state" : 1 }
        {  "_id" : "shard2",  "host" : "shard2/127.0.0.1:37017,127.0.0.1:37018,127.0.0.1:37019",  "state" : 1 }
  active mongoses:
        "3.6.18" : 1
  autosplit:
        Currently enabled: yes
  balancer:
        Currently enabled:  yes
        Currently running:  no
        Failed balancer rounds in last 5 attempts:  0
        Migration Results for the last 24 hours: 
                1 : Success
  databases:
        {  "_id" : "config",  "primary" : "config",  "partitioned" : true }
                config.system.sessions
                        shard key: { "_id" : 1 }
                        unique: false
                        balancing: true
                        chunks:
                                lugotestrepl    1
                        { "_id" : { "$minKey" : 1 } } -->> { "_id" : { "$maxKey" : 1 } } on : lugotestrepl Timestamp(1, 0) 
        {  "_id" : "lugotest",  "primary" : "lugotestrepl",  "partitioned" : true }
                lugotest.test
                        shard key: { "id" : "hashed" }
                        unique: false
                        balancing: true
                        chunks:
                                lugotestrepl    2
                                shard2  2
                        { "id" : { "$minKey" : 1 } } -->> { "id" : NumberLong("-4611686018427387902") } on : lugotestrepl Timestamp(3, 1) 
                        { "id" : NumberLong("-4611686018427387902") } -->> { "id" : NumberLong(0) } on : lugotestrepl Timestamp(3, 2) 
                        { "id" : NumberLong(0) } -->> { "id" : NumberLong("4611686018427387902") } on : shard2 Timestamp(3, 3) 
                        { "id" : NumberLong("4611686018427387902") } -->> { "id" : { "$maxKey" : 1 } } on : shard2 Timestamp(3, 4)

    插入数据

    mongos> for (var i = 1; i <=20; i++){
... db.test.insert({id: i, username: "U"});
... }
WriteResult({ "nInserted" : 1 })


    mongos> db.test.stats();
{
    "sharded" : true,
    "capped" : false,
    "warning" : "indexes don't all match - ok if ensureIndex is running",
    "ns" : "lugotest.test",
    "count" : 20,
    "size" : 1000,
    "storageSize" : 20480,
    "totalIndexSize" : 24576,
    "indexSizes" : {
        "_id_" : 20480,
        "id_hashed" : 4096
    },
    "avgObjSize" : 50,
    "nindexes" : 2,
    "nchunks" : 4,
    "shards" : {
        "lugotestrepl" : {
            "ns" : "lugotest.test",
            "size" : 300,

"shard2" : {
            "ns" : "lugotest.test",
            "size" : 700,
            "count" : 14,
            "avgObjSize" : 50,
            "storageSize" : 4096,
            "capped" : false,
            "wiredTiger" : {
                "metadata" : {
                    "formatVersion" : 1

    可以看到，一个分片是6条数据，一个分片是14条数据

    关闭第二个分片的所有节点，并验证数据库的可用性。

    [root@test02 run]# systemctl stop mongod37017
[root@test02 run]# systemctl stop mongod37018
[root@test02 run]# systemctl stop mongod37019

    mongos> use lugotest
switched to db lugotest
mongos> db.movie.find();
{ "_id" : ObjectId("5ebe402573a048240cf0e087"), "moviename" : "大侦探福尔摩斯", "points" : "9.5" }
{ "_id" : ObjectId("5ebe404173a048240cf0e088"), "moviename" : "掠夺", "points" : "9.2" }
{ "_id" : ObjectId("5ebe405073a048240cf0e089"), "moviename" : "摇滚黑帮", "points" : "9.9" }
{ "_id" : ObjectId("5ebe405b73a048240cf0e08a"), "moviename" : "两杆大烟枪", "points" : "9.1" }
{ "_id" : ObjectId("5ebe406873a048240cf0e08b"), "moviename" : "杀死比尔", "points" : "9.0" }
mongos> db.test.find();
Error: error: {
    "ok" : 0,
    "errmsg" : "Could not find host matching read preference { mode: \"primary\" } for set shard2",
    "code" : 133,
    "codeName" : "FailedToSatisfyReadPreference",
    "operationTime" : Timestamp(1589534845, 1),
    "$clusterTime" : {
        "clusterTime" : Timestamp(1589534867, 1),
        "signature" : {
            "hash" : BinData(0,"3pklCXoPiE8B7ateFALSmCsDdfM="),
            "keyId" : NumberLong("6826969049499435034")
        }
    }
}

    未分片的集合，且数据在未关闭的分片上，数据能正常使用
    已分片的集合，数据不可查询

    重新启用第二个分片的所有节点，使用 mongodump 备份数据库中的测试数据。

    备份

    mongodump -h 127.0.0.1:22222 -u lugo -p test123 -d lugotest -o /data/mongodb_bak/20200512

    清空lugotest的两个集合

    mongos> show collections;
movie
test
mongos> db.movie.drop()
true
mongos> db.test.drop()
true

    还原数据

    mongorestore -h 127.0.0.1:22222 -u lugo -p test123 --collection movie --db lugotest /data/mongodb_bak/20200512/lugotest/movie.bson
mongorestore -h 127.0.0.1:22222 -u lugo -p test123 --collection test --db lugotest /data/mongodb_bak/20200512/lugotest/test.bson

    检查数据

    mongos> show collections;
movie
test
mongos> db.test.find();
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543c8"), "id" : 2, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d6"), "id" : 16, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d7"), "id" : 17, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543c7"), "id" : 1, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543ca"), "id" : 4, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543cb"), "id" : 5, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543cd"), "id" : 7, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543cf"), "id" : 9, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d0"), "id" : 10, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d3"), "id" : 13, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d4"), "id" : 14, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d5"), "id" : 15, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d8"), "id" : 18, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d9"), "id" : 19, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543c9"), "id" : 3, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543cc"), "id" : 6, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543ce"), "id" : 8, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d1"), "id" : 11, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543d2"), "id" : 12, "username" : "U" }
{ "_id" : ObjectId("5ebe5eb9825f7f2e238543da"), "id" : 20, "username" : "U" }

    全部还原

    相关文章

      网友评论

          本文标题：mongodb3.6副本集升级为分片副本集

          本文链接：https://www.haomeiwen.com/subject/gineahtx.html

          延伸阅读

          深度阅读

          • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

          栏目导航

          热点阅读

          关于我们|服务条款|联系我们|mongodb3.6副本集升级为分片副本集|投稿指南|网站地图|RSS订阅|排版工具|手机版

          提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

          Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

          备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

          本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

          所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！