Unshard a sharded collection in MongoDB

 

Yesterday in one of our mongodb databases developer asked for unshard a sharded collection.

Yes it is possible to unshard a sharded collection but it is not a cute process 🙂   As the data has propagated between 3 servers, at first we need to take all data into primary server.

In addition to this, this process needs down time.

Before moving data to the primary shard we need to shutdown all shards and all mongos except one.

After finishing the changes at that mongos instance, wee need to restart the mongos, too.

 

Here we can start shards and other mongos.

 

As this process has many manual steps it is a little challenging process.

The size of the collection to make unsharded is not  big so we used another method.

First we create a copy collection by insert.

 

After the insert process finishes, we dropped the collection named ‘Collection’.

While Dropping a sharded collection, it is important to validate the dropping process is succeeded in all the shards and in config database.

Dropping a Collection in a Sharded Cluster

1- Drop the collection using a mongos

2- Connect to each shard’s primary and verify the namespace has been dropped. If it has not, please drop it.

3- Connect to a mongos, switch to the config database and remove any reference to the removed namespace from the collections chunks, locks collections:

 

Connect to each mongos and run flushRouterConfig

After dropping is succeeded, we can change the name of the copy collection:

 

As a note : rename collection is not supported in sharded collections.

After rename we can create new index on this unsharded collection.

As you know we need a little down time in this process too, because no new data must be come to existing collection and during drop and rename operations the appliacation can not find the collection. So during these operations we stopped the application.

It is a challenging operation if your collection size is big so it is always important to decide sharding status and the right shard key before your data grows.