Scaling Databases for the Web
COMS E6125 Web-enhanced Information Management (WHIM) Spring 2008 by Amoghavarsha Ramappa
Apache
Open source Key role in the initial growth of the World Wide Web Cross Platform Most popular web server for the past decade Apache 2.2.8 Module Support
PHP
Widely-used Scripting Language Suited for Web development Can be embedded into HTML Large web base of PHP users Drivers for major databases: DB2, PostgreSQL, Oracle .. PHP-Apache – Most Popular
Basic Apache User Handling
Apache Web Server
U S E R S
Apache Child
Processes
Oracle Connection Pooling
Multiple users share Apache children Apache child processes multiplex users with fewer database connections Made possible through database connection pools Connection pools exists on the client What is the drawback ?
Client Connection Pooling
Apache Children Connection Pools
C1
Oracle
U S E R S Client
C2
C3
C4
Database Resident Connection Pool
Apache Children Connection Pool
Oracle U S E R S
Database Server
Throughput
Available In
Apache 2.2.8 Oracle Database 11g PHP PECL Extension