Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-14512

How to fix bad shard key

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • 2.6.3
    • Sharding
    • 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.

      Attachments

        Activity

          People

            ramon.fernandez@mongodb.com Ramon Fernandez Marina
            eric.bechtel@webjet.com Eric Bechtel
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: