I have a sharded MongoDB cluster running 3 different Databases. Currently all 3 databases has the same shard configured as their primary shard (shard000) Is it possible to change the primary shard for one of these databases to something other than shard000?
Just to make things clear, I have no intention of retiring shard000 any time soon, I just want to remove some of the non shared collections load off it.
Thanks, Meny