【MongoDB】只有一个分片、一个路由节点分片集群最小化实现方案

最新推荐文章于 2024-10-05 21:22:05 发布

戒掉贪嗔痴(薛双奇)

最新推荐文章于 2024-10-05 21:22:05 发布

阅读量159

点赞数 3

分类专栏：数据库运维-MongoDB 文章标签： mongodb 数据库

本文链接：https://blog.csdn.net/weixin_43346403/article/details/139691989

版权

数据库运维-MongoDB 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

1.分片集群配置

--分片集群配置。
分片控制器      mongos             27021   ---
配置服务器      mongod             27022     /mysql/mongodb/db1/config/data 
shard0          mongod             27023    /mysql/mongodb/db1/shard1/data 
shard1          mongod             27024    /mysql/mongodb/db1/shard2/data 
shard2          mongod             27024    /mysql/mongodb/db1/shard3/data

步骤如下；
1.设置一个分片集群。
2.创建一个数据库和集合，并在集合上启用分片
3.使用导入命令在分片集合中加载数据。
4.在分片之间分发数据。，
5.从集群添加和移除分片，并且检查数据是如何自动分发的。

2.设置分片集群。

配置服务器。
mongod --port 27022 --bind_ip  192.168.1.51,127.0.0.1 --dbpath  /mysql/mongodb/db1/config/data --configsvr --replSet=cfgshard


--初始化配置服务器的副本集。这里只使用了一个节点
config={_id:"cfgshard",members:[{_id:0,host:"192.168.1.51:27022"}]}
rs.initiate(config)

> config={_id:"cfgshard",members:[{_id:0,host:"192.168.1.51:27022"}]}
{
	"_id" : "cfgshard",
	"members" : [
		{
			"_id" : 0,
			"host" : "192.168.1.51:27022"
		}
	]
}
> rs.initiate(config)
{
	"ok" : 1,
	"operationTime" : Timestamp(1718405476, 1),
	"$gleStats" : {
		"lastOpTime" : Timestamp(1718405476, 1),
		"electionId" : ObjectId("000000000000000000000000")
	},
	"lastCommittedOpTime" : Timestamp(0, 0),
	"$clusterTime" : {
		"clusterTime" : Timestamp(1718405476, 1),
		"signature" : {
			"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
			"keyId" : NumberLong(0)
		}
	}
}

mongod@itpuxdb1 ~]$ mongo --port 27022
cfgshard:PRIMARY>

配置服务器是一个独立的副本集。cfgshard

3.开启路由器

mongos --configdb cfgshard/192.168.1.51:27022 --port 27021 &

路由器端口是:27021

4.启用分片

mongod --bind_ip 192.168.1.51,127.0.0.1 --port 27023 --dbpath /mysql/mongodb/db1/shard1/data -shardsvr --replSet=shard1
mongod --bind_ip 192.168.1.51,127.0.0.1 --port 27024 --dbpath /mysql/mongodb/db1/shard2/data -shardsvr --replSet=shard1
mongod --bind_ip 192.168.1.51,127.0.0.1 --port 27025 --dbpath /mysql/mongodb/db1/shard3/data -shardsvr --replSet=shard1

分片集群，针对每个分片都是一个独立的副本集群。当前第一个分片集群，复制名称:shard1

5.配置分片集群。

--登陆任意一个副本集节点进行初始化。
--当前一个分片shard1 有三个节点。一主两备。
mongo --port 27023 
use admin
config={_id:"shard1",members:[
{_id:0,host:"192.168.1.51:27023",priority:1},
{_id:1,host:"192.168.1.51:27024",arbiterOnly:true},
{_id:2,host:"192.168.1.51:27025",priority:2}
]}
rs.initiate(config)
rs.status()


shard1:SECONDARY> rs.isMaster()
{
	"hosts" : [
		"192.168.1.51:27023",
		"192.168.1.51:27025"
	],
	"arbiters" : [
		"192.168.1.51:27024"
	],
	"setName" : "shard1",
	"setVersion" : 1,
	"ismaster" : false,
	"secondary" : true,
	"primary" : "192.168.1.51:27025",
	"me" : "192.168.1.51:27023",
	"lastWrite" : {
		"opTime" : {
			"ts" : Timestamp(1718402279, 1),
			"t" : NumberLong(2)
		},
		"lastWriteDate" : ISODate("2024-06-14T21:57:59Z"),
		"majorityOpTime" : {
			"ts" : Timestamp(1718402279, 1),
			"t" : NumberLong(2)
		},
		"majorityWriteDate" : ISODate("2024-06-14T21:57:59Z")
	},
	"maxBsonObjectSize" : 16777216,
	"maxMessageSizeBytes" : 48000000,
	"maxWriteBatchSize" : 100000,
	"localTime" : ISODate("2024-06-14T21:58:00.741Z"),
	"logicalSessionTimeoutMinutes" : 30,
	"minWireVersion" : 0,
	"maxWireVersion" : 7,
	"readOnly" : false,
	"ok" : 1,
	"operationTime" : Timestamp(1718402279, 1),
	"$clusterTime" : {
		"clusterTime" : Timestamp(1718402279, 1),
		"signature" : {
			"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
			"keyId" : NumberLong(0)
		}
	}
}
shard1:SECONDARY> rs.status()
{
	"set" : "shard1",
	"date" : ISODate("2024-06-14T21:58:38.524Z"),
	"myState" : 2,
	"term" : NumberLong(2),
	"syncingTo" : "192.168.1.51:27025",
	"syncSourceHost" : "192.168.1.51:27025",
	"syncSourceId" : 2,
	"heartbeatIntervalMillis" : NumberLong(2000),
	"optimes" : {
		"lastCommittedOpTime" : {
			"ts" : Timestamp(1718402309, 1),
			"t" : NumberLong(2)
		},
		"readConcernMajorityOpTime" : {
			"ts" : Timestamp(1718402309, 1),
			"t" : NumberLong(2)
		},
		"appliedOpTime" : {
			"ts" : Timestamp(1718402309, 1),
			"t" : NumberLong(2)
		},
		"durableOpTime" : {
			"ts" : Timestamp(1718402309, 1),
			"t" : NumberLong(2)
		}
	},
	"lastStableCheckpointTimestamp" : Timestamp(1718402269, 1),
	"members" : [
		{
			"_id" : 0,
			"name" : "192.168.1.51:27023",
			"health" : 1,
			"state" : 2,
			"stateStr" : "SECONDARY",
			"uptime" : 599,
			"optime" : {
				"ts" : Timestamp(1718402309, 1),
				"t" : NumberLong(2)
			},
			"optimeDate" : ISODate("2024-06-14T21:58:29Z"),
			"syncingTo" : "192.168.1.51:27025",
			"syncSourceHost" : "192.168.1.51:27025",
			"syncSourceId" : 2,
			"infoMessage" : "",
			"configVersion" : 1,
			"self" : true,
			"lastHeartbeatMessage" : ""
		},
		{
			"_id" : 1,
			"name" : "192.168.1.51:27024",
			"health" : 1,
			"state" : 7,
			"stateStr" : "ARBITER",
			"uptime" : 180,
			"lastHeartbeat" : ISODate("2024-06-14T21:58:37.184Z"),
			"lastHeartbeatRecv" : ISODate("2024-06-14T21:58:37.876Z"),
			"pingMs" : NumberLong(0),
			"lastHeartbeatMessage" : "",
			"syncingTo" : "",
			"syncSourceHost" : "",
			"syncSourceId" : -1,
			"infoMessage" : "",
			"configVersion" : 1
		},
		{
			"_id" : 2,
			"name" : "192.168.1.51:27025",
			"health" : 1,
			"state" : 1,
			"stateStr" : "PRIMARY",
			"uptime" : 180,
			"optime" : {
				"ts" : Timestamp(1718402309, 1),
				"t" : NumberLong(2)
			},
			"optimeDurable" : {
				"ts" : Timestamp(1718402309, 1),
				"t" : NumberLong(2)
			},
			"optimeDate" : ISODate("2024-06-14T21:58:29Z"),
			"optimeDurableDate" : ISODate("2024-06-14T21:58:29Z"),
			"lastHeartbeat" : ISODate("2024-06-14T21:58:37.184Z"),
			"lastHeartbeatRecv" : ISODate("2024-06-14T21:58:36.912Z"),
			"pingMs" : NumberLong(0),
			"lastHeartbeatMessage" : "",
			"syncingTo" : "",
			"syncSourceHost" : "",
			"syncSourceId" : -1,
			"infoMessage" : "",
			"electionTime" : Timestamp(1718402158, 1),
			"electionDate" : ISODate("2024-06-14T21:55:58Z"),
			"configVersion" : 1
		}
	],
	"ok" : 1,
	"operationTime" : Timestamp(1718402309, 1),
	"$clusterTime" : {
		"clusterTime" : Timestamp(1718402309, 1),
		"signature" : {
			"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
			"keyId" : NumberLong(0)
		}
	}
}

6.将分片集群加入配置服务器集群

mongos --configdb testset/192.168.1.51:27022  --port 27021

[mongod@itpuxdb1 ~]$ mongo --port 27021
mongos> show dbs; 
admin   0.000GB
config  0.000GB
mongos> use admin 
switched to db admin
--分配控制器27017(路由器上添加分片)
sh.addShard("shard1/192.168.1.51:27023,192.168.1.51:27024,192.168.1.51:27025")
mongos> sh.addShard("shard1/192.168.1.51:27023,192.168.1.51:27024,192.168.1.51:27025")
{
	"shardAdded" : "shard1",
	"ok" : 1,
	"operationTime" : Timestamp(1718408436, 7),
	"$clusterTime" : {
		"clusterTime" : Timestamp(1718408436, 7),
		"signature" : {
			"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
			"keyId" : NumberLong(0)
		}
	}
}

mongos> sh.status()
--- Sharding Status --- 
  sharding version: {
  	"_id" : 1,
  	"minCompatibleVersion" : 5,
  	"currentVersion" : 6,
  	"clusterId" : ObjectId("666cc96736506823d13a932c")
  }
  shards:
        {  "_id" : "shard1",  "host" : "shard1/192.168.1.51:27023,192.168.1.51:27025",  "state" : 1 }
  active mongoses:
        "4.0.2" : 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: 
                No recent migrations
  databases:
        {  "_id" : "config",  "primary" : "config",  "partitioned" : true }

7.总结

(1)配置服务器是一个独立的副本集集群。

(2)可以配置任意个分片集群。

(3)路由器启动时和配置服务器进行绑定。

(4)路由器登陆使用:27021端口，然后添加分片集群到配置服务器中。