[RFE] Indexable JSON fields

Bug #1525376 reported by Lucas Alvares Gomes
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Ironic
Opinion
Wishlist
Unassigned

Bug Description

Ironic currently store some data as JSON in the database, this was done by design and have served us well until recently where a consensus decision was made for having a way to filter data stored into some of these fields via the Ironic API. In order to be able to filter resources in a performant way Ironic needs the data of those JSON fields to be indexable.

This spec proposes separating the node's properties and driver_info JSON fields into separated database tables. Both fields contains information that would come handy if able to filter to use for scheduling and inspecting purpose.

Tags: needs-spec rfe
tags: added: rfe
Changed in ironic:
assignee: nobody → Lucas Alvares Gomes (lucasagomes)
importance: Undecided → Wishlist
Dmitry Tantsur (divius)
Changed in ironic:
status: New → Confirmed
summary: - Indexable JSON fields
+ [RFE] Indexable JSON fields
Revision history for this message
Jim Rollenhagen (jim-rollenhagen) wrote :
Revision history for this message
Jim Rollenhagen (jim-rollenhagen) wrote :

Spec is abandoned, but we do still want to do this. Someone may propose a new spec if they decide to work on it.

This is related to https://bugs.launchpad.net/ironic/+bug/1421261

tags: added: needs-spec
Changed in ironic:
assignee: Lucas Alvares Gomes (lucasagomes) → nobody
Revision history for this message
Michael Turek (mjturek) wrote :

This wishlist bug has been open more than a year without any activity. I'm going to move it to "Opinion / Wishlist", which is an easily-obtainable queue of older requests that have come on. This bug can be reopened (set back to "New") if someone decides to work on this.

Changed in ironic:
status: Confirmed → Opinion
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Related blueprints

Remote bug watches

Bug watches keep track of this bug in other bug trackers.