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

Add a warning to view creation if the collection lives outside the dbPrimary

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • Catalog and Routing

    Description

      View performance is substantially worse on unsharded collections if the unsharded collection lives outside the dbPrimary (since views are located on the dbPrimary).

      SERVER-85230 will prevent the balancer from moving collections that already have views, but this does not prevent the user from creating a view after the collection has been moved off of the primary.

      This ticket is to issue a warning if the user creates a view on an unsharded collection living outside the dbPrimary telling the user about the decreased performance and suggesting using moveCollection to return the collection to the dbPrimary.

      Attachments

        Activity

          People

            backlog-server-catalog-and-routing Backlog - Catalog and Routing
            allison.easton@mongodb.com Allison Easton
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: