RIPE Database Operations Update Shane Kerr RIPE NCC

RIPE Database Operations Update Shane Kerr RIPE NCC <shane@ripe. net> Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 1

Outline Statistics Operations Developments Plans Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 2

Facts and Figures • 1. 9 M objects, 42% inetnum, 47% person • 28 q/s on average, spikes of 200 q/s • 2. 3 updates/min, 61% inetnum, 28% person Object counts, query loads, etc. available on-line: http: //www. ripe. net/db/dbconstat http: //www. ripe. net/db/mrtg/whois. html Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 3

Database Contents Historical Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 4

Database Contents Recent “Big Movers” Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 5

Updates by Method Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 6

Synchronous Update Usage Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 7

How Many Queries are There? Number of Queries Shane Kerr Queries/Second . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 8

What are the Queries For? Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 9

What are Queries Returning? Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 10

Where are the Queries From? Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 11

Outline Statistics ✓ Operations Developments Plans Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 12

Database Operations • Smooth sailing – average response time is well below 1 second – load approximately 70% higher than last year • New ARIN mirroring scheme next week – Use difference to generate NRTM, rather than full load – No down-time, includes allocations and assignments • Tertiary (i. e. off-site) server in planning phases – Withstand catastrophic, city-wide failures – Manual failover by updating DNS for whois. ripe. net – Part of larger project to increase critical service reliability Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 13

How Responsive is the Server? Inno. DB table type goes on-line Unoptimised My. SQL Qu ery tim ei ns ls) rra ec on e ref ds vy (lo hea ga g( rith inin mi c) in m ma Do Desktop Upgrade Shane Kerr . RIPE 45, May 2003, Barcelona RIPE NCC DDo. S . http: //www. ripe. net 14

Unreferenced Person Cleanup • Protect privacy of users – Person objects remain undeleted when contacts change • Person objects unreferenced for 90 will be deleted – A modify of the object “resets” the counter • E-mail sent after 60 days – Limit to 2000/day to avoid overwhelming users & server • Deletions begin 29 May 2003 http: //www. ripe. net/db/unref-cleanup-200304. html Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 15

IPv 6 query proxy status • Operational issues resolved – Solaris patches and move to Sun box – DNS update hid AAAA record for 10 days – Moving to standard monitoring and failover • Source code public release made • 90% of queries come from only 7 IP addresses • Still see more 6 bone than RIR addresses Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 16

RIPE Database Administration Tiago Antao Can Bican Engin Gündüz Katie Petrusha Denis Walker Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 17

Recent RIPE DBM Activity • Tickets, tickets – About 90/day • Spam becoming a larger problem – Planning move to Spam. Assassin – Will reply if filtered – no e-mails dropped! • Hostmaster taking over 20% of RIPE DBM – Closer co-ordination between groups • ripe-dbm@ripe. net is an open, general help mailbox Please e-mail Questions or Problems! Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 18

ERX Update • 4 /8’s transferred – 141. 0. 0. 0/8 and 151. 0. 0. 0/8, RIPE NCC-majority – 150. 0/8 and 163. 0. 0. 0/8, APNIC-majority – Multiple transfers, with overlapping start/end dates • One more trial to finalise processing • “Long burn” scheduled to start afterwards – No large issues – Complete ordering, tentative scheduling TBD • Moving to regular RIPE DBM and HM activity Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 19

Outline Statistics ✓ Operations ✓ Developments Plans Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 20

New Update Processing • Improved acknowledgement messages • Software maintenance eased • Presentations at RIPE 45: – Developer POV at Tools Working Group – User POV at Database Working Group http: //www. ripe. net/db/dbupdate/ Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 21

RPSLng • IPv 6 and multicast RPSL objects • Prototype server on-line – Based on last RPSLng draft – Throw-away copy of RIPE Database – Latest draft to be integrated Real Soon Now • IRRTool. Set changes – More complicated than server changes – Coming soon! http: //www. ripe. net/ripencc/pub-services/db/rpslng/ Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 22

Semantic Changes • Lots of mostly minor changes proposed: – – – default to protected inetnum/inet 6 num/domain notification for more-specific removal of cross notifications "reclaim: "-like functionality "mnt-lower: " on set objects • Little discussion • Will be on-line soon Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 23

Outline Statistics ✓ Operations ✓ Developments ✓ Plans Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 24

Future Plans • RPSLng IRRTool. Set support • Update processing semantic changes • “status: ” attribute changes? • Deprecating NONE? Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 25

PKI • Draft RIPE document, Improved Secure Communication System for RIPE NCC Members • LIR-Portal ready, time for Database integration • New features needed: – X. 509 authentication – Proxy authentication • Proposals coming to mailing list Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 26

Outline Statistics ✓ Operations ✓ Developments ✓ Plans ✓ Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 27

Shane Kerr . RIPE 45, May 2003, Barcelona . http: //www. ripe. net 28