yahoo-eng-team team mailing list archive

[OpenStack Infra <1718605@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.openstack.org/521683
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=5c601bebeb01876f1ea744e0ae95f83d1c30120d
Submitter: Zuul
Branch:    master

commit 5c601bebeb01876f1ea744e0ae95f83d1c30120d
Author: Hongbin Lu <hongbin.lu@xxxxxxxxxx>
Date:   Mon Nov 20 23:19:31 2017 +0000

    Support filtering port with IP address substring
    
    Neutron currently supports filtering ports by matching the exact
    IP address. This patch adds support for substring matching using
    "LIKE" SQL operator.
    
    This patch also added a new API extension to show whether or not
    the substring matching capability is available.
    
    APIImpact add IP address substring filtering on listing ports
    API-ref: I97259b85a2dce5a54bb6ea2cb9d9779ec0a25504
    
    Co-Authored-By: Zhenyu Zheng <zhengzhenyu@xxxxxxxxxx>
    
    Change-Id: I9549b2ba676e1bad0812682c3f3f3c97de15f5f6
    Closes-Bug: #1718605


** Changed in: neutron
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1718605

Title:
  [RFE] Support sub-string matching when filtering port with IP address

Status in neutron:
  Fix Released

Bug description:
  Problem
  =======
  The GET /ports API only support exact matching when filtering by IP address.
  Providing support for more powerful regex matching filtering could be very
  useful.

  Usecase
  =======
  Nova allows filtering instance by IP address and it is in regex matching
  manner, but it now has serious performance issue [1]. How to enhance the
  performance of this filter has been discussed in Queens PTG [2]. When
  filtering instance by IP addresses, first calling Neutron port list API
  with IP address filtering, and then retrieve the instance UUID in Nova
  side could be a possible solution to improve the performance.

  As Nova allows regex manner filtering, it could be better to make Neutron
  also support regex matching.

  
  Proposal
  ========
  Adding regex matching support in DB layer using "LIKE" SQL phrase.

  References
  ==========
  [1] https://bugs.launchpad.net/nova/+bug/1711303
  [2] http://lists.openstack.org/pipermail/openstack-dev/2017-September/122258.html

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1718605/+subscriptions