Transcript RIPE Database Operations Update Olaf Kolkman RIPE NCC Olaf Kolkman . APNIC 15, February 2003, Taipei . http://www.ripe.net.

RIPE Database
Operations Update
Olaf Kolkman
RIPE NCC
<[email protected]>
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
1
http://www.ripe.net
Outline
• Database statistics
• Database development
• Development plans
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
2
http://www.ripe.net
Facts and Figures
• 1.8 M objects, 41% inetnum, 47% person
• 25 q/s on average, spikes of 100 q/s
• 4 updates/min, 18% inetnum, 75% person
Object counts, query loads, etc. available on-line:
http://www.ripe.net/db/dbconstat
http://www.ripe.net/db/mrtg/whois.html
• 110,000 query users on average
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
3
http://www.ripe.net
Database Contents
2000000
1800000
1600000
1400000
1200000
inetnum  +84,668 (13%)
person  +70,105 (9%)
inet6num  +460 (70%)
1000000
800000
mntner
aut_num
route
person/role
inetnum
domain
600000
400000
200000
0
2001-10-12
Olaf Kolkman
2002-01-04
2002-04-22
.
APNIC 15, February 2003, Taipei
2002-09-02
.
2003-01-29
4
http://www.ripe.net
Query rate and objects returned
7.000.000
40
Number of
objects/day
5,700,000
35
30
25
20
6.000.000
Query
rate,
weekly av
25 q/s
5.000.000
4.000.000
3.000.000
15
2.000.000
10
1.000.000
5
0
0
day
22-jun-01
21-aug-01
Olaf Kolkman
21-okt-01
.
20-dec-01
18-feb-02
19-apr-02
APNIC 15, February 2003, Taipei
19-jun-02
.
18-aug-02
19-okt-02
19-dec-02
5
http://www.ripe.net
Query by Type
10%
8%
IP
Domain
Domain Referral
Other
Denied
8%
3%
71%
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
6
http://www.ripe.net
Update by object type
16
14
12
route
10
person
mntner
8
inetnum
domain
6
aut-num
4
2
0
-29
-29
-29
-29
-29
-28
-29
-29
-29
-29
-29
4
6
8
0
2
2
4
6
8
0
2
0
0
0
1
1
0
0
0
0
1
1
01
01
01
01
01
02
02
02
02
02
02
20
20
20
20
20
20
20
20
20
20
20
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
7
http://www.ripe.net
Database developments:
Whois server
• Improved query processing
– More helpful, consistent results
– Additional server information available, -q types
• Limit number of concurrent connections from IP
– Some protection from DoS (less against DDoS)
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
8
http://www.ripe.net
Database developments:
Webupdates
• Web updates in production
– Allows addition, modification, deletion through WWW
• Built on sync-updates back-end
• No PGP support
– Does not bypass security restrictions
– Secure updates possible in PKI framework…
http://www.ripe.net/webupdates
https://www.ripe.net/webupdates
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
9
http://www.ripe.net
Database developments:
IPv6 query proxy
• IPv6 queries supported
– Proxy server
– Supports queries externally now, while IPv6 monitored
• Client source available
• Full presentation in IPv6 Working Group
– Slides soon to be available from the meeting page
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
10
http://www.ripe.net
Future Plans
• New update processing
– Improved reporting (fuller, clearer reports & error information)
– Input processing revisited
• RPSLng
– Server support for IPv6 and multicast RPSL objects & attributes
– IRRToolSet support
• Unreferenced person/role cleanup process
• Update processing semantic changes
– Mostly for consistency and protection, will go to list soon!
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
11
http://www.ripe.net
Olaf Kolkman
.
APNIC 15, February 2003, Taipei
.
12
http://www.ripe.net