Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // 1. Set Profiling to Off in the UI hours in advance
- // Name: appboy_prod_users_2
- // Connection: iad-mongos0.objectrocket.com:15165
- // 2. Prerequisite : Jon confirmed the names and results below.
- db.getSiblingDB("zedge_users").getCollectionNames();
- db.getSiblingDB("metro_user").getCollectionNames();
- db.getSiblingDB("tinder_users").getCollectionNames();
- db.getSiblingDB("thrillist_users").getCollectionNames();
- db.getSiblingDB("mdbfoo").getCollectionNames();
- db.getSiblingDB("glide_users").getCollectionNames();
- db.getSiblingDB("bing_users").getCollectionNames();
- db.getSiblingDB("samsunghq_uses").getCollectionNames();
- db.getSiblingDB("lifelock_users").getCollectionNames();
- db.getSiblingDB("qik_users").getCollectionNames();
- db.getSiblingDB("perfstats").getCollectionNames();
- db.getSiblingDB("letsbonus_users").getCollectionNames();
- db.getSiblingDB("test").getCollectionNames();
- // 3. vim tkt80044.js <- Create the Script Below, fix user/pass
- user='xxx';
- password='xxx';
- dbs = [ "zedge_users", "metro_user", "tinder_users", "thrillist_users", "mdbfoo", "glide_users", "bing_users","samsunghq_uses", "lifelock_users", "qik_users", "perfstats", "letsbonus_users", "test"
- ];
- dbs.forEach(function(database){
- db.getSiblingDB(database).dropDatabase()
- })
- db.getSiblingDB('config').shards.find().forEach(function(shard){
- x = new Mongo (shard.host);
- x.getDB('admin').auth(user,password);
- dbs.forEach(function(database){
- try{
- x.getDB(database).dropDatabase()
- }catch(err){
- print("Failed to drop "+database+" from "+shard.host.split("/")[0])
- }
- });
- });
- db.getSiblingDB('config').mongos.find({ ping : {$gte: new Date(ISODate().getTime() - 1000 * 60 * 2)}}).forEach(function(mongos_host){
- x = new Mongo (mongos_host._id);
- x.getDB('admin').auth(user,password);
- x.adminCommand('flushRouterConfig');
- dbs.forEach(function(database){
- try{
- x.getDB(database).dropDatabase()
- }
- catch(err){
- print("Failed to drop "+database+" from mongos!")
- }
- });
- x.adminCommand('flushRouterConfig');
- x.adminCommand('flushRouterConfig');
- });
- // 4. Drop : Run repeatedly until "show databases" doesn't list the databases above
- // mongo ....
- // load("tkt80044.js");
- //
- // Note, you will see output about mongo setting up connections to shards.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement