Ability to Drop Indexes via API
Allow users to not only add indexes via the API, but also allow them to drop indexes the same way. Also incorporate index creation/deletion into Terraform.
Chad
shared this idea
-
Jacob
commented
> Dropping indexes does not have a comparable operational impact, so you can do those with direct MongoDB wire protocol access to the cluster itself (you can do the same with building indexes where a traditional foreground or background index build suffices).
Not necessarily. Many desired state configurations do not have direct wire protocol access and thus require this type of functionality via the administrative API.
At a bare minimum there should also be a method to read the current state of indexes via the API. An update can be satisfied via a delete and create. These endpoints should exist please revisit.
-
Alex
commented
API index family should come with create, drop, modify, hide !
-
Mario
commented
Hi PM,
So, your support told me to give feedback here.
We are using Cloud Manager to manage 73 MongoDB Clusters. (Yes 73, we do IoT).
Currently, we are able to add indexes using the API. We want to drop indexes in an automated way.
We create it through API in cloud manager and Atlas (we store all data from all the locations) at the same time. So we want to drop indexes in Cloud Manager and Atlas through API.
Best regards,
Mario Pereira -
Chad
commented
What we are really looking for here is a single, consistent process for index management in Atlas. Rather than doing part of the process one way and the rest of the process another way.
-
Chad
commented
Hi Andrew,
Our Change Management procedures require that any new way of implementing a change go through separate scrutiny. (i.e. testing, documentation, approvals, etc.). Since creating an index via the API would be different than creating an index via scripting the change to be run directly connected to the cluster, each process would have to go through separate Change Management approval. The same goes for index deletion. If all the index management can be done via the API, it all only needs to go through approvals once. Plus, we don't have to code something different for managing indexes. It can all be handled in one piece of functionality. -
Hi Chad,
Note that the managed add index capability is specifically in order to do a rolling index build which essentially minimizes the impact of the build on operational performance (similar to a background index build but even more offline by pulling nodes temporarily out of client visibility entirely while building).
Dropping indexes does not have a comparable operational impact, so you can do those with direct MongoDB wire protocol access to the cluster itself (you can do the same with building indexes where a traditional foreground or background index build suffices).
Can you shed any light on what managing this through the Atlas control plane API would do for you that managing it through the cluster directly doesn't?
-Andrew
