- db-wg - mailman.ripe.net

RIPE Database Purposes - Video presentation
by denis walker 23 Nov '21

23 Nov '21

Colleagues In advance of my presentations tomorrow, if you have a spare 15 minutes please watch the pre-recorded presentation: https://ripe83.ripe.net/wp-content/uploads/presentations/DB_WG-Denis_Walker… cheers denis co-chair DSB-WG

1 0

NWI-13: Geofeed Impact Analysis
by Edward Shryane 17 Nov '21

17 Nov '21

2 3

Agenda RIPE83 - Database Working Group
by William Sylvester 15 Nov '21

15 Nov '21

Dear Database Working Group Members, Below is the agenda for the Database Working Group for RIPE83. If you have any questions, comments, or requested changes please let the chairs know. Best regards, William & Denis DB-WG Chairs A. Introduction - 5 min * Welcome * Scribe * Jabber * Agenda B. Operational & Cloud Migration Update– 15 mins Edward Shryane, RIPE NCC C. UI Update – 15 mins Rehan Syed, RIPE NCC D. Database Task Force Update – 15 mins Shane Kerr, Database Task Force E. RIPE Database Purposes – 10 mins Denis Walker, Co-Chair DB-WG Z. AOB (open discussion)

2 1

NRTM v4 Requirements Gathering BoF
by Edward Shryane 01 Nov '21

01 Nov '21

Dear Colleagues, I'd like to hold a BoF meeting next week to gather requirements for NRTM v4 and look for a way forwards to an implementation. For background reading on NRTM v4, please read the NWI-12 Problem Definition: https://www.ripe.net/ripe/mail/archives/db-wg/2020-November/006720.html If you are interested in this discussion, please register your interest using this optional Doodle pool to indicate any convenient time(s) for you: https://doodle.com/poll/bfmcaxuyb5v8iwsu?utm_source=poll&utm_medium=link I will close the poll on this Wednesday evening and reply to the DB-WG with a meeting request. You don't need to register to attend. Regards Ed Shryane RIPE NCC

2 3

RIPE Database Requirements Task Force: Final Draft Published
by Bijal Sanghani 26 Oct '21

26 Oct '21

Dear Colleagues, We have now published the final draft of the RIPE Database Requirements Task Force: https://www.ripe.net/participate/ripe/tf/rdb-requirements-tf/requirements-f… This version takes into account the feedback received from the community on our intermediate draft published in July. Thank you all for providing feedback. Here are the main changes/additions; - Added a word about ENUM and geolocation - Added a section to explain the document structure - Clarified when the historical data was first added to the RIPE Database and when it was made available to users - Rephrased the research purpose and added a separate section Please note that each recommendation will be considered separately by the community and the relevant working groups. Kind regards, Bijal Sanghani For the RIPE Database Requirements Taskforce

3 2

NWI-12 NRTM v4 Solution Definition
by Edward Shryane 19 Oct '21

19 Oct '21

Dear Colleagues, Following the Requirmements Gathering BoF yesterday, I'd like to propose Sasha Romijn's NRTM v4 protocol as a Solution Definition for NWI-12 "NRTM v4". Please see https://github.com/mxsasha/nrtmv4/ for more details and feel free to comment on it. Once this draft proposal is finalised, and if we have consensus from the DB-WG, the RIPE NCC will work on an implementation analysis. Regards Ed Shryane RIPE NCC

1 0

Bogon route object cleanup
by Ronald F. Guilmette 08 Oct '21

08 Oct '21

It seems that we never really settled the question of route objects that make reference to the following reserved IP blocks. 192.31.196.0/24 192.88.99.0/24 2001::/32 2002::/16 2011:4188::/48 Note that route objects referring to these IP blocks are *not* present in the route registries of any RIR other than RIPE. I am in favor of including route objects that reference any of these reserved blocks in the ongoing cleanup. My recollection is that Cynthia Revstr�m also expressed support for including any and all such route objects in the current ongoing route object cleanup. Are there any objections at the present time to including such route objects in the ongoing cleanup? Regards, rfg

6 6

RIPE Database Requirements Task Force – Draft Report Published
by Bijal Sanghani 04 Oct '21

04 Oct '21

Dear colleagues, The RIPE Database Requirements Task Force has just published a draft report for your review: https://www.ripe.net/participate/ripe/tf/rdb-requirements-tf/the-ripe-datab… In this third draft, we’ve added new recommendations and edited our document based on feedback received via emails, survey and during our third BoF in May. Please review this draft and share any comments on the ripe-list before Friday, 13 August 2021. The task force will reconvene in August to discuss the feedback received and work on its final report that will be published ahead of RIPE 83. We look forward to your feedback. Best Regards, Bijal Sanghani

5 9

Two Proposals
by Ronald F. Guilmette 01 Oct '21

01 Oct '21

PROPOSED 1) RIPE NCC shall be tasked to begin updating the following file on a near real-time basis, as number resource assignments are transferred either into or out of the authority of RIPE: ftp://ftp.ripe.net/pub/stats/ripencc/delegated-ripencc-extended-latest 2) RIPE NCC shall be tasked to begin making the above file available for incremental remote update via the rsync protrocol. RATIONALE Background At the present time the most reliable and up-to-the-minute information indicating which RIR any given number resource is being administered by is contained within the so-called "daily stats files" that are generated and published by the five RIRs: ftp://ftp.arin.net/pub/stats/arin/delegated-arin-extended-latest ftp://ftp.ripe.net/pub/stats/ripencc/delegated-ripencc-extended-latest ftp://ftp.apnic.net/public/apnic/stats/apnic/delegated-apnic-extended-latest ftp://ftp.lacnic.net/pub/stats/lacnic/delegated-lacnic-extended-latest ftp://ftp.afrinic.net/stats/afrinic/delegated-afrinic-extended-latest Additionally, a single file representing the union of all of the above five files, along with additional data relating to (some but not all) IANA reserved number resources is also available: https://nro-extended-stats-from-rpki-team-prod.s3.eu-west-1.amazonaws.com/n… Note however that the data in this (NRO stats) file lags behind the contents of the five RIR daily stats files, and the content of this file is therfore often less fresh and up-to-date than the information contained in the five RIR stats files. Problem Statement (Proposal 1) Because the five RIR stats files are only updated once a day, and at different times for each RIR, and because number resources are, with increasing frequency, being transfered between regions, it is nowadays frequently the case that there will be, in effect, instances of "version skew" between the five RIR stats files. Instance of such inter-RIR stats files version skew can render it impossible to know, based on the stats files, which RIR currently administers a given number resource. Instances of internet-RIR stats file version skew can arise, and in practice they actually do arise as follows: *) RIR 'A' transfers a number resource `R' to RIR `B'. *) RIR `B' records its administration of `R' in its stats file which is then published within 1 hour. *) RIR `A' records the fact that it no longer administers `R' by removing the associated line from its stats file, and RIR `A's stats file is then published 23 hours later. Under the above scenario, the union of all five of the daily RIR stats files will indicate that *both* RIR `A" and also RIR `B' are the responsible RIRs for the resource `R' for a period of 22 hours. An actual example: As of approximately 07:13 (-0700 / PDT) on 2021-09-17 the following blocks were listed in *both* the stats file for ARIN and also the stats file for RIPE: 140.228.32.0/19 140.228.64.0/19 (Evidence indicates that these 2 block have just been transferred from administration by the ARIN region to administration by the RIPE region.) The problem of version skew between the various daily stats files that are currently published by the various RIRs could be largely or entirely eliminated if all five RIRs henceforth began to update these files on a near real-time basis. RIPE can and should begin doing this as an example to the other RIRs, which may then follow suit. Problem Statement (Proposal 2) The RIR daily stats files, including the one that is generated and published by RIPE NCC, consist of plain text files which are themselves composed of a sequence of plain text lines. As a general matter, very few of these lines change, even over time scales as long as a month. Changes to these files, if any, are entirely minimal when viewed over even shorter time scales, e.g. a day or less. The rsync protocol and rsync servers and clients are especially adept at keeping remote copies of exactly such plain text files up-to-date and synchronized with a master copy stored elsewhere on the Internet. They do so while minimizing bandwidth usage by transfering only those portions of a given file that have changed since the last time a local mirrored copy of the file was updated. Publishing RIPE's stats file via rsync would thus be beneficial to all concerned by minimizing bandwidth usage on both the sending and receiving end. Ideally, RIPE NCC could and should take the lead in making its stats file available via rsync. Once it has done so, other RIRs can be encouraged to follow suit and do likewise with their own daily stats files. Regards, rfg P.S. On a personal note I find it nearly unfathomable that these "daily" stats files are being updated and published only once a day. This seems to me almost reminicent of technological solutions considered appropriate in the prior century.

3 5

Upcoming Usability improvements to the RIPE Database Web Search page
by Edward Shryane 01 Oct '21

01 Oct '21

Dear colleagues, In the RIPE NCC's Activity Plan 2021, we planned to make usability improvements to the RIPE database, including the web search feature. My colleague Rehan Syed Muhammad has now published a RIPE Labs article detailing some upcoming improvements: https://labs.ripe.net/author/rehan_syed_muhammad/four-ideas-for-quicker-que… We plan to make incremental changes to the search page in the coming months. We will keep the community informed, and we welcome any feedback. Regards Ed Shryane RIPE NCC

1 1