Connection Pooling in PHP available in OCI8

I'm sitting in the first talk at the Zend Conference and listening to Terry Chay's talk about Art in Software Architecture.  He's speaking about the connection pooling solution that Tagged.com use with their Oracle DB infrastructure.

I can tell he skipped the morning keynote to polish his talk because he spoke only about current issues with huge websites (tens of millions of registered users) and connection management.

Well, those issues are in the past, and if Terry hadn't skipped the keynote to work on his talk, he would have heard the announcement that Oracle in collaboration from Zend have released a Beta update to the PHP OCI8 extension (download source for 1.3.0 Beta from PECL) that supports Oracle Database 11g "Database Resident Connection Pooling" (DRCP).  It also has "Fast Application Notification" (FAN) support that helps applications detect and recover from machine/network/database failures.  Oracle Database 11g (production for Linux 32 bit only at time of writing) itself can be downloaded from www.oracle.com.

The key things I want to point out about DRCP are that even on commodity hardware you can scale dramatically - you don't need to wait until you have a big site to reap the benefits of pooling. The second thing is that the pool is on the DB side, so it works regardless of the number of web servers you have.

There is a technical White Paper: Database Resident Connection Pooling in Oracle Database 11g; a PHP specific whitepaper will be forthcoming. The README in the beta OCI8 release from PECL has some useful information on using the extension.  Here are some links to specific Oracle documents on DRCP for bedtime reading:

  OCI Manual description
  Database Concepts description
  DBA Guide  
  List of Data Dictionary Views for DRCP

For this beta release,  use the OTN PHP Forum for comments and issues.

Comments:

Yes, you told me about this at php|works, so I already know about it. :-)

Posted by terry chay on October 09, 2007 at 10:07 AM PDT #

Hi Chris, Nice to see the Beta version of PHP OCI8 is released. I read the DRCP technical white paper a few days back, it looks nice! Your posts keep me updated on "PHP and Oracle news". Thanks... Rgds Amogh

Posted by Amogh on October 19, 2007 at 06:26 AM PDT #

Post a Comment:
Comments are closed for this entry.
About

Tourists looking out over an Opal mine
I'm a Product Manager in Server Technologies, working on scripting languages and developer-access.
Email: christopher.jones@oracle.com
Twitter: http://twitter.com/ghrd
Book: Free PHP Oracle book
Download: PHP Linux RPMs with the OCI8 extension
Links: OTN PHP Developer Center

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today