1 / 22

New Version of the RIPE Database RPSL implementation and status of RIPE DBv3

New Version of the RIPE Database RPSL implementation and status of RIPE DBv3. Andrei Robachevsky RIPE NCC < andrei@ripe.net >. Outline. Current status of the RIPE Database New database system Database related projects. RIPE Database in figures. Database Growth inetnum  +38,000

Download Presentation

New Version of the RIPE Database RPSL implementation and status of RIPE DBv3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. New Version of the RIPE DatabaseRPSL implementation and status of RIPE DBv3 Andrei Robachevsky RIPE NCC <andrei@ripe.net>

  2. Outline • Current status of the RIPE Database • New database system • Database related projects

  3. RIPE Database in figures Database Growth inetnum +38,000 person  +50,000 route  - 2,000 Database Contents 1,4 M objects Update Rate 2 - 4 upd/min 60% inetnum domain inetnum person Query Rate 15 queries/s avg. 60% IP lookups

  4. Database Contents Before *.demigration June 2000 RIPE-39May 2001 inetnum +38,000 person  +50,000 route  - 2,000 After PN removal Sept. 2001

  5. 60% Query by type (%)

  6. Query by type (q/s)

  7. Update by object type weekly average, upd/min pn removal

  8. Update by type (%)

  9. V3 Database System • Functionality • Architecture • Performance • New features (3.1.0)

  10. New version of the RIPE Database • Supports IR and RR • domain registry support is limited • Supports RPSL (RFC2622) • Extended syntax • New objects and attributes • Supports RPSS (RFC2725) • New authorisation rules • Supports IRRToolSet (RAToolSet) • RtConfig -protocol ripe

  11. Security features • Provides strong security mechanisms • Protection of individual objects • Protection of IP address space • Protection of ASN space • Protection of route space • Protection of set membership • Protection of hierarchical set names • Protection of domain object space • 4 supported authentication schemes • GPG public keys are supported

  12. V3 software • Mainly in C, multithreaded • CPU: 70% idle • RDBMS as a back-end • MySQL, customised transaction support • In-memory radix tree for IP lookups • also more and less specific lookups for reverse delegation domains • MIME and GPG support • correct PGP keys are also accepted • Automatic access control • separate accounting for public and contact data

  13. RDBMS Update FE Core Server Update FE Mirror Server NRTM clients RDBMS Server architecture (I) Queue rules Message queues Syntax checks, acks, notifications queries E-mail

  14. Server architecture (II)

  15. Query Performance (I) 70 Query rate, q/s V3 operational zone V3 V2 operational zone V2 18 # of concurrent clients

  16. Query Performance (II) Responsetime,s V3 operational zone V3 V2 1.4 V2 operational zone 0.2 # of concurrent clients

  17. V3.1.0 New Features • RPSL object library • used by the core and front-end subsystems • replaces inherited RAToolset code • consolidates object and attribute definitions • irt object representing CSIRT • “mnt-irt:” attribute to reference a CSIRT from inet[6]num • -c flag to search for the CSIRT in charge • New status value for inetnum objects • facilitates LIR’s IP address management

  18. Future Plans • Authorisation checks across multiple databases • minimises need to replicate other RR data in the RIPE DB • currently use workaround for such cases • Real-time (Synchronous) updates • simplifies client side scripts • basis for user-friendly update interface • Automatic database cleanup • based on internal data rather than object data/metadata • notifications rather than lookups

  19. Future Plans(II) • Prototyping RPSL extensions (ipv6, multicast) • both whois and IRRToolSet will be affected • Further improvement of server software • error reporting, performance, • configuration flexibility • Documentation • Update of DB Reference Manual • DB User Manual • DB Operation Manual

  20. Other Database Projects • Database Statistics & Consistency Project • extended statistics and reports by subscription • prototype available at http://www.ripe.net/db/dbconstat/ • RRCC project • Activity resumed, RIPE201 published • Prototype at http://www.ripe.net/ripencc/pub-services/db/rrcc/index.html • IRRToolSet support • documentation and bug fixes • your input is very welcome at irrtoolset@ripe.net.

  21. More Information • RIPE-181 to RPSL Migration page • http://www.ripe.net/rpsl • Documentation • RIPE Database Reference Manual http://www.ripe.net/ripe/docs/databaseref-manual.html • RIPE Database User Manual (coming soon) • RIPE Database Operation Manual (coming soon) • Software • New whois client ftp://ftp.ripe.net/tools/ripe-whois-3.0.tar.gz • Server software v3ftp://ftp.ripe.net/ripe/dbase/software/ripe-dbase-latest.tar.gz

  22. Questions?

More Related