110 likes | 268 Views
Exploiting Database Patterns in Dynamic Pages to Improve Replication Locality in Content Delivery Networks. Quoc Le. Research Question. Increase Replication Locality
E N D
Exploiting Database Patterns in Dynamic Pages to Improve Replication Locality in Content Delivery Networks Quoc Le
Research Question • Increase Replication Locality • Improve Latency of Database Application in Content Delivery Networks (CDN) • Relevant: Dynamic pages makes up a large part of Internet Content.
CDN • Improve Latency & Throughput • Complexity • Expensive to Operate/Lease
Collaborative CDN • User contribute their web server resource to maintain a CDN • Relevant for small biz/school/non-profit • Globule • Apache Server Module - Easy to install • Supports latency estimation, dynamic scripts, redirection algorithms.
Replica 1 Replica 2 Replica 3 Internet Origin/DB Server Partial Replication Approaches Replica 1 Replica 2 Replica 3 Internet Origin/DB Server One Centralized DB Server
Experiment • LAMP (Linux, Apache, MySQL, and PHP) • Globule – CCDN (C codes) • VMWare – Run multiple servers on 1 machine • NISTNet – Simulate Internet Traffic • TPCW – Industry standard ecommerce benchmark w/ Remote Browser Emulator (Java) Shopping Cart (PHP) • IPtables (Router Forwarding) • Bind 9 (DNS Resolution)
Experiment Router Configuration Iptables –A FORWARD –d 192.168.20.131 –j ACCEPT Iptables –A FORWARD –d 192.168.21.132 –j ACCEPT Iptables –A FORWARD –d 192.168.22.133 –j ACCEPT Iptables –A FORWARD –d 192.168.23.134 –j ACCEPT Vmware Node Debian Sarge 256 MB RAM 192.168.19.128 Vmware Node Ubuntu Linux 256MB RAM 192.168.21.131 Vmware Node Debian Sarge 256MB RAM 192.168.22.132 Vmware Node Debian Sarge 256MB RAM Vmware Node Debian Sarge 256MB RAM 192.168.19.128 192.168.20.128 192.168.21.128 192.168.22.128 192.168.23.128 192.168.20.133 192.168.23.133
Initial Setup • Used tpcw toolset to generate initial Database • 28,800 Customers • 1000 Items • 250,000 Orders • NistNet Delay • 30 ms delay • 5% drop • RBE • 10 minutes benchmark test
Results Database Read Only
Future Work • Lots of problem with buggy codes. • There is more work to be done: • Experiment with different Read/Write Distribution • Throughput Test