Skip to content

Instantly share code, notes, and snippets.

View FrancescaK's full-sized avatar

Francesca Krihely FrancescaK

16 followers · 15 following
View GitHub Profile
@FrancescaK
FrancescaK / gist:9371048
Last active August 29, 2015 13:57
STEP connect, add tags, insert data, verify sharding status, set up shards,
MongoDB shell version: 2.4.6
connecting to: 127.0.0.1:30004/test
//
mongos> sh.status()
--- Sharding Status ---
sharding version: {
"_id" : 1,
"version" : 3,
"minCompatibleVersion" : 3,
"currentVersion" : 4,
@FrancescaK
FrancescaK / gist:9371062
Last active August 29, 2015 13:57
STEP Add Tags
mongos> sh.addShardTag('shard0000', 'recent')
mongos> sh.addShardTag('shard0001', 'tier 2')
mongos> sh.addShardTag('shard0002', 'tier 2')
@FrancescaK
FrancescaK / gist:9371064
Created March 5, 2014 16:45
STEP insert data
mongorestore ~/courses/m101p/enron/dump/enron/messages.bson
@FrancescaK
FrancescaK / gist:9371078
Created March 5, 2014 16:45
STEP verify sh.status()
mongos> sh.status()
--- Sharding Status ---
sharding version: {
"_id" : 1,
"version" : 3,
"minCompatibleVersion" : 3,
"currentVersion" : 4,
"clusterId" : ObjectId("5314f1487abd6cb2803696d6")
}
shards:
@FrancescaK
FrancescaK / gist:9380603
Created March 6, 2014 01:50
STEP Ensure DB Is There
mongos> show dbs
admin (empty)
config 0.046875GB
enron 1.953125GB
@FrancescaK
FrancescaK / gist:9380612
Created March 6, 2014 01:50
STEP Switch to the DB
mongos> use enron
switched to db enron
mongos> show tables
messages
system.indexes
@FrancescaK
FrancescaK / gist:9380616
Created March 6, 2014 01:50
STEP Enable Sharding on DB
sh.enableSharding('enron')
// { "ok" : 1 }
@FrancescaK
FrancescaK / gist:9380621
Created March 6, 2014 01:51
STEP bring the shard key to the top level
var cursor = db.messages.find({},{_id:1, 'headers.Date':1})
while(cursor.hasNext()){
var doc = cursor.next();
var id = doc._id;
var dt = doc.headers.Date;
db.messages.update({_id:id},{$set:{date:dt},$unset:{'headers.Date':1}})
}
@FrancescaK
FrancescaK / gist:9380629
Last active August 29, 2015 13:57
STEP: Must do a chunk split on the upper bound (exclusive) of the key that denotes current data.
sh.splitAt('enron.messages', {"date" : ISODate("2001-08-01")})
@FrancescaK
FrancescaK / gist:9380632
Last active August 29, 2015 13:57
STEP: Check status to ensure chunks went from 13 to 14
mongos> sh.status()
--- Sharding Status ---
sharding version: {
"_id" : 1,
"version" : 3,
"minCompatibleVersion" : 3,
"currentVersion" : 4,
"clusterId" : ObjectId("5314f1487abd6cb2803696d6")
}
shards: