[openstack-dev] [nova][neutron] How do you use the instance IP filter?

Tony Breeds tony at bakeyournoodle.com
Fri Oct 27 02:54:20 UTC 2017

On Thu, Oct 26, 2017 at 09:23:50PM -0500, Matt Riedemann wrote:
> Nova has had this long-standing known performance issue if you're filtering
> a large number of instances by IP. The instance IPs are stored in a JSON
> blob in the database so we don't do filtering in SQL. We pull the instances
> out of the database, deserialize the JSON and then apply a regex filter
> match in the nova-api python code.
> At the Queens PTG we talked about possible ways to fix this and came up with
> this nova spec:
> https://specs.openstack.org/openstack/nova-specs/specs/queens/approved/improve-filter-instances-by-ip-performance.html
> The idea is to have nova get ports from neutron and apply the IP filter in
> neutron to whittle down the ports, then from that list of ports get the
> instances to pull out of the nova database.
> One issue that has come up with this is neutron does not currently support
> regex filters when listing ports. There is an RFE for adding that:
> https://bugs.launchpad.net/neutron/+bug/1718605
> The proposed neutron implementation is to just do SQL LIKE substring
> matching in the database.

Can you use RLIKE/REGEX? or is that too MySQL specific ?

Yours Tony.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20171027/885fa9e5/attachment.sig>

More information about the OpenStack-dev mailing list