MongoDB 샤딩 클러스터 구성 - MongoDB 올인 9일차

MongoDB Sharded Cluster Configuration - All-in Day 9

mkdir -p ~/mongodb/sharding/configsvr/csrs1/data ~/mongodb/sharding/configsvr/csrs1/log
mkdir -p ~/mongodb/sharding/configsvr/csrs2/data ~/mongodb/sharding/configsvr/csrs2/log
mkdir -p ~/mongodb/sharding/configsvr/csrs3/data ~/mongodb/sharding/configsvr/csrs3/log

mkdir C:\mongodb\sharding\configsvr\csrs1\data
mkdir C:\mongodb\sharding\configsvr\csrs1\log
mkdir C:\mongodb\sharding\configsvr\csrs2\data
mkdir C:\mongodb\sharding\configsvr\csrs2\log
mkdir C:\mongodb\sharding\configsvr\csrs3\data
mkdir C:\mongodb\sharding\configsvr\csrs3\log

 # 스토리지 설정
storage:
  dbPath: <각 OS에 맞는 csrs1 데이터 디렉토리 절대 경로> 
  # macOS/Linux 예: /Users/your_username/mongodb/sharding/configsvr/csrs1/data
  # Windows 예: C:\mongodb\sharding\configsvr\csrs1\data
 
 # 시스템 로그 설정
systemLog:
  destination: file
  path: <각 OS에 맞는 csrs1 로그 파일 절대 경로>
  # macOS/Linux 예: /Users/your_username/mongodb/sharding/configsvr/csrs1/log/mongod.log
  # Windows 예: C:\mongodb\sharding\configsvr\csrs1\log\mongod.log
  logAppend: true
 
 # 네트워크 설정
net:
  port: 27019 # 컨피그 서버 포트 1
  bindIp: 127.0.0.1
 
 # 복제 설정
replication:
  replSetName: "myConfigRS" # 컨피그 서버 복제 세트 이름
 
 # 샤딩 설정 (MongoDB 4.2+ 권장)
sharding:
  clusterRole: configsvr

storage:
  dbPath: /Users/your_username/mongodb/sharding/configsvr/csrs2/data
systemLog:
  destination: file
  path: /Users/your_username/mongodb/sharding/configsvr/csrs2/log/mongod.log
  logAppend: true
net:
  port: 27020
  bindIp: 127.0.0.1
replication:
  replSetName: "myConfigRS"
sharding:
  clusterRole: configsvr

storage:
  dbPath: /Users/your_username/mongodb/sharding/configsvr/csrs3/data
systemLog:
  destination: file
  path: /Users/your_username/mongodb/sharding/configsvr/csrs3/log/mongod.log
  logAppend: true
net:
  port: 27021
  bindIp: 127.0.0.1
replication:
  replSetName: "myConfigRS"
sharding:
  clusterRole: configsvr

 # 터미널 1: 컨피그 서버 1 실행
mongod --config ~/mongodb/sharding/configsvr/csrs1/mongod.conf
 
 # 터미널 2: 컨피그 서버 2 실행
mongod --config ~/mongodb/sharding/configsvr/csrs2/mongod.conf
 
 # 터미널 3: 컨피그 서버 3 실행
mongod --config ~/mongodb/sharding/configsvr/csrs3/mongod.conf

 # 창 1: 컨피그 서버 1 실행
mongod --config C:/mongodb/sharding/configsvr/csrs1/mongod.cfg
 
 # 창 2: 컨피그 서버 2 실행
mongod --config C:/mongodb/sharding/configsvr/csrs2/mongod.cfg
 
 # 창 3: 컨피그 서버 3 실행
mongod --config C:/mongodb/sharding/configsvr/csrs3/mongod.cfg

mongosh --port 27019

config = {
  _id: "myConfigRS",
  members: [
    { _id: 0, host: "127.0.0.1:27019" },
    { _id: 1, host: "127.0.0.1:27020" },
    { _id: 2, host: "127.0.0.1:27021" }
  ]
}
rs.initiate(config)

mkdir -p ~/mongodb/sharding/shard1/s1rs1/data ~/mongodb/sharding/shard1/s1rs1/log
mkdir -p ~/mongodb/sharding/shard1/s1rs2/data ~/mongodb/sharding/shard1/s1rs2/log
mkdir -p ~/mongodb/sharding/shard1/s1rs3/data ~/mongodb/sharding/shard1/s1rs3/log

mkdir C:\mongodb\sharding\shard1\s1rs1\data
mkdir C:\mongodb\sharding\shard1\s1rs1\log
mkdir C:\mongodb\sharding\shard1\s1rs2\data
mkdir C:\mongodb\sharding\shard1\s1rs2\log
mkdir C:\mongodb\sharding\shard1\s1rs3\data
mkdir C:\mongodb\sharding\shard1\s1rs3\log

storage:
  dbPath: <각 OS에 맞는 shard1-s1rs1 데이터 디렉토리 절대 경로>
  # macOS/Linux 예: /Users/your_username/mongodb/sharding/shard1/s1rs1/data
  # windows 예: C:\mongodb\sharding\shard1\s1rs1\data
systemLog:
  destination: file
  path: <각 OS에 맞는 shard1-s1rs1 로그 파일 절대 경로>
  # macOS/Linux 예: /Users/your_username/mongodb/sharding/shard1/s1rs1/log/mongod.log
  # windows 예: C:\mongodb\sharding\shard1\s1rs1\log\mongod.log
  logAppend: true
net:
  port: 27061 # 샤드1-멤버1 포트
  bindIp: 127.0.0.1
replication:
  replSetName: "shard1RS" # 샤드1 복제 세트 이름
sharding:
  clusterRole: shardsvr # 샤드 서버 역할(중요!)

 # 터미널 1: 샤드 1 멤버 1 실행
mongod --config ~/mongodb/sharding/shard1/s1rs1/mongod.conf
 
 # 터미널 2: 샤드 1 멤버 2 실행
mongod --config ~/mongodb/sharding/shard1/s1rs2/mongod.conf
 
 # 터미널 3: 샤드 1 멤버 3 실행
mongod --config ~/mongodb/sharding/shard1/s1rs3/mongod.conf

 
 # 창 1: 샤드 1 멤버 1 실행
mongod --config C:/mongodb/sharding/shard1/s1rs1/mongod.cfg
 
 # 창 2: 샤드 1 멤버 2 실행
mongod --config C:/mongodb/sharding/shard1/s1rs2/mongod.cfg
 
 # 창 3: 샤드 1 멤버 3 실행
mongod --config C:/mongodb/sharding/shard1/s1rs3/mongod.cfg

mongosh --port 27061

config_s1 = {
  _id: "shard1RS",
  members: [
    { _id: 0, host: "127.0.0.1:27061" },
    { _id: 1, host: "127.0.0.1:27062" },
    { _id: 2, host: "127.0.0.1:27063" }
  ]
}
rs.initiate(config_s1)

lsof -i :27017

kill $(lsof -t -i:27017)

mkdir -p ~/mongodb/logs
mongos --configdb myConfigRS/127.0.0.1:27019,127.0.0.1:27020,127.0.0.1:27021 --logpath ~/mongodb/logs/mongod.log --port 27017

mkdir C:\mongodb\logs
mongos --configdb myConfigRS/127.0.0.1:27019,127.0.0.1:27020,127.0.0.1:27021 --logpath C:/mongodb/logs/mongod.log --port 27017

sh.addShard("replicaSetName/seedMemberHost:port,...", { name: "optionalShardName" })

mongosh --port 27017

sh.addShard("shard1RS/127.0.0.1:27061", { name: "primaryDataShard" })
sh.addShard("shard2RS/127.0.0.1:27071")

sh.enableSharding("myShardedDB")

sh.shardCollection("myShardedDB.myCollection", { userId: "hashed" })
sh.shardCollection("myShardedDB.events", { timestamp: 1 })

sh.status()