Details
-
Question
-
Resolution: Done
-
Major - P3
-
None
-
2.6.3
-
None
-
All servers are running on OS Ubuntu 12.04, 16Gb RAM, 500Gb HDD, Intel Xeon CPU on each server
Description
Hi,
I have a problem with one of our shards. For some reason I'm getting the next usage
15:38:42 up 4 days, 10:28, 1 user, load average: 3.67, 3.50, 3.56
In the mean time all other shards are ok. Their average load approx:
16:49:58 up 11 days, 56 min, 1 user, load average: 0.03, 0.03, 0.05
I have 3config, 2 query and 7 shards (all of them are primary replicaset. don't ask why). I have 2 databases: 20Gb and 30gb. All servers are the same in their configuration. Also, in each database only 1 collection.
The problem with inapropritae shard key.
Please let me know what will be better:
a) make backups of current 2 databases, destroy them via mongos shell, create new databases with correct shard keys and upload our dumps
b) follow with suggestion on StackExchange from on of your staff and Unshard collection?
Our cluster is working as a test environment.
Thank you.