DBA managed indexes

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

DBA managed indexes

jewzaam
Administrator
Had a thought recently about how we deal with indexes today and I wanted to toss it out for discussion.  We have setup index management to be completely contained in the metadata, at least for the mongo backend.  Meaning, if a DBA were to create an index manually the metadata service would delete that index on a future metadata update if that index was not represented in the metadata.

Is this a problem?  I think our view of a DBA might be different from others, so I wanted to know if we should expect and allow for this use case.  Maybe we could simply have an option for metadata service that would disable deleting of indexes from the software.
Reply | Threaded
Open this post in threaded view
|

Re: DBA managed indexes

bserdar
IIRC, we don't drop indexes. We drop-create them if the flags are
different, or just create them if they don't exist in the db,

On Mon, Oct 27, 2014 at 7:18 AM, jewzaam [via lightblue-dev]
<[hidden email]> wrote:

> Had a thought recently about how we deal with indexes today and I wanted to
> toss it out for discussion.  We have setup index management to be completely
> contained in the metadata, at least for the mongo backend.  Meaning, if a
> DBA were to create an index manually the metadata service would delete that
> index on a future metadata update if that index was not represented in the
> metadata.
>
> Is this a problem?  I think our view of a DBA might be different from
> others, so I wanted to know if we should expect and allow for this use case.
> Maybe we could simply have an option for metadata service that would disable
> deleting of indexes from the software.
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://dev.forum.lightblue.io/DBA-managed-indexes-tp199.html
> To start a new topic under lightblue-dev, email
> [hidden email]
> To unsubscribe from lightblue-dev, click here.
> NAML