config sh1 sh2 sh3

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongod --configsvr --port 27020 --dbpath=data\config --replSet confSet

config server:
C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongo --port 27020

> rs.initiate({_id:"confSet", configsvr:true, members:[{_id:0, host:"127.0.0.1:27020"}]})

-----

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongod --shardsvr --replSet shard1Set --dbpath=data\sh1 --port 27021

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongo port --port 27021

> rs.initiate({_id:"shard1Set", members:[{_id:0, host:"127.0.0.1:27021"}]})

------

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongod --shardsvr --replSet shard2Set --dbpath=data\sh2 --port 27022

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongo port --port 27022

> rs.initiate({_id:"shard2Set", members:[{_id:0, host:"127.0.0.1:27022"}]})

-------

router:

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongos --configdb confSet/127.0.0.1:27020 --port 27017

-------
cmd > mongo

sh.addShard("shard1Set/127.0.0.1:27021")
sh.addShard("shard2Set/127.0.0.1:27022")

sh.enableSharding("ourBase")
use ourBase

db.col1.insert({a:"aaa", b:"bbb", d:5})
db.col1.insert({a:"eee", b:"fff", d:5})
db.col1.insert({a:"iii", b:"jjj", d:"z"})
db.col1.insert({a:"eee", b:"fff"})
db.col1.insert({a:"nnn", b:"ooo"})

db.col2.insert({a:"nnn", b:"ooo"})
db.col2.insert({sdf:"dasdsa", g:3})
db.col2.insert({jsj:"eeee", g:[3]})
db.col2.insert({fff:"awq", g:[[3]]})

--------
p21

use ourBase
db.col1.find()
db.col2.find() //nic nie ma

--------- router
mongos> sh.status({verbose:true})

sh.shardCollection("ourBase.col1",{a:1, b:1}) // nie zadziala


db.col1.createIndex({a:1, b:1})
db.col2.createIndex({g:1})

sh.splitAt("ourBase.col1", {a:"eee", b:"fff"})

mongos> sh.shardCollection("ourBase.col3",{pole:"hashed"})

db.col3.insert({p:3})
db.col3.insert({pole:"a"})
db.col3.insert({pole:"b"})
db.col3.insert({pole:"c"})
db.col3.insert({pole:"d"})
db.col3.insert({pole:"e"})
db.col3.insert({pole:"f"})
db.col3.insert({pole:"g"})
db.col3.insert({pole:"h"})
db.col3.insert({pole:"i"})
db.col3.insert({pole:"j"})
db.col3.insert({pole:"k"})
db.col3.insert({pole:"l"})
db.col3.insert({pole:"m"})
db.col3.insert({pole:"n"})
db.col3.insert({pole:"o"})
db.col3.insert({pole:"u"})
db.col3.insert({pole:"p"})

sh.status()

//na shardach
switched to db ourBase
db.col3.find()

//mongos

db.col1.update({a:"iii"},{$set{d:3}}) //zle

db.col3.update({pole:"a"},{pole:"aa"}) //nie zadziala bez transakcji

----------- nowy shard

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongod --shardsvr --replSet shard3Set --dbpath=data\sh3 --port 27023

C:\Users\student.NMKZLLAB\Documents\djuc\NBD\mongodb-win32-x86_64-2012plus-4.2.1\bin>mongo port --port 27023
rs.initiate() ( conf.members[0].host="127.0.0.1:27023" )

---mongos
sh.addShard("shard3Set/127.0.0.1:27023")


sh.addShardToZone("shard3Set", "Zone1")

sh.updateZoneKeyRange("ourBase.col1", {a:"g"},{a:"l"},"Zone1")

po dodaniu w shardach wartosci, nie sa one widoczne w routerze


// ZADANIE DLA NAS

base with 3 shards
2 replication set members
1 arbiter

3 collections
	1 unsharded
	1 distributed only between non primary
	1 with hash sharding

commands for creating


how to force shard to be primary:
add only one shard into shard database then enable sharding