News Feed
Jobs Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Oracle Technology Network:
Scaling a PHP MySQL Web Application, Part 2
April 12, 2011 @ 13:28:05

On the Oracle Technology Network today, the part two of "Scaling PHP MySQL Web Applications" (from Eli White) has been published. Part one can be found here.

In Part 1 of this article, I explained the basic steps to move your application from a single server to a scalable solution for both PHP and MySQL. While most Web applications will never need to expand beyond the concepts presented in that article, eventually you may find yourself in a situation where the basic steps aren't enough. Here are some more advanced topics on how you might change your setup to support additional throughput, isolate "concerns" better, and take your scalability to the next level.

He starts with a look at database pooling and how it can not only help you on load balancing your application's resources but also in the caching of the requests. Different resources give different cache results and grouping those together makes life simpler (and faster) for your application. He also talks a a bit about sharding - vertical, manual horizontal and application level techniques.

0 comments voice your opinion now!
scaling application mysql database sharding pooling performance


Chris Jones' Blog:
PHP OCI8 and Oracle 11g DRCP Connection Pooling in Pictures
February 22, 2011 @ 10:44:46

Chris Jones has posted some "pictures" of the performance that an Oracle database sees when it uses the connection pooling versus the normal connect/allocate sort of connection with the Oracle OCI8 driver for PHP. As you can see, the differences in memory consumption are huge.

Here is a screen shot from a PHP OCI8 connection pooling demo that I like to run. It graphically shows how little database host memory is needed when using DRCP connection pooling with Oracle Database 11g. Migrating to DRCP can be as simple as starting the pool and changing the connection string in your PHP application.

He also describes the differences between the pooled and non-pooled connections (to the developer it's as easy as putting ":pooled" in the connect string) in his graphs, and notes that using the pooling doesn't just have to be for large site - smaller sites can benefit too.

0 comments voice your opinion now!
oci8 oracle connection pooling performance graph result


Brian Swan's Blog:
SQL Server Driver for PHP Connection Options Connection Pooling
November 18, 2010 @ 10:17:17

Brian Swan has another post in his series looking at using the SQL Server driver in PHP applications. This part of the series looks specifically at using the connection pooling option to help improve overall performance of the application.

One topic that came up yesterday [during Jump In! Camp] was connection pooling and how much difference using pooled connections makes in app performance, so that's what I'll look at in this post.

He starts by defining (from Wikipedia) what connection pooling is and then puts it in the context of SQL Server by talking about the handling of connections returned to the pool. He shows how to enable and disable the feature via a parameter in the connection options and shows how to configure the number of seconds a connection stays active in the pool.

0 comments voice your opinion now!
sqlserver connection pooling database microsoft tutorial


Christopher Jones' Blog:
Oracle at PHPSC - Grupo de Usuarios de PHP do Estado de Santa Catarina
June 18, 2008 @ 09:32:14

Christopher Jones has a quick post with some information about a user group meeting happening in Brazil where the upcoming topic will cover the powerful combination of PHP and Oracle.

Elton Luís Minetto wrote to tell me that "PHPSC - a PHP user group of Santa Catarina in Brazil - is organizing an event dedicated to PHP that will take place at Chapeco on June 20." [...] He's presenting a session on PHP and Oracle, and will show some great results of using PHP's OCI8 with Oracle 11g connection pooling (DRCP).

The schedule for the event can be found here with details on which talks will be given when (including Elton's at 8am on the 21st.

0 comments voice your opinion now!
phpsc2008 conference brazil event oracle talk oci8 connection pooling


Christopher Jones' Blog:
PHP Connection Pooling Whitepaper with Benchmark Available
April 25, 2008 @ 10:23:47

Christopher Jones has pointed out a new whitepaper that's been published by oracle about the scalability the connection pooling affords for current versions of PHP.

The whitepaper talks about the changes in the PHP OCI8 1.3 extension, explains some of the concepts behind DRCP and FAN, and gives best practices and tuning tips. It includes a new PHP benchmark which shows up to 20,000 connections being handled by Oracle on commodity hardware using only 2G RAM.

The paper also talks about the FAN support that's built in - the ability for PHP to use the Oracle RAC cluster functionality to make for high availability (switching between nodes). The latest beta with all of this functionality in it can be grabbed from its page on the PECL site.

1 comment voice your opinion now!
connection pooling whitepaper benchmark rac cluster oracle


Christopher Jones' Blog:
PHP PECL OCI8 1.3.2 Beta Available
April 18, 2008 @ 09:32:00

Christopher Jones has posted an announcement about the latest release of the PECL OCI8 package (version 1.3.2 Beta) hitting the streets:

I've released PECL OCI8 1.3.2 Beta - the latest release of PHP's OCI8 extension with support for Connection Pooling and Fast Application Notification. The release is based on the current PHP 5.3 development branch.

He notes another change in this release - a "session release" bit of functionality persistent connections will do when nothing is referencing them anymore, mking them work a bit more like normal connections. Issues that could be caused by this can be corrected with a new setting (oci8.old_oci_close_semantics) in your php.ini.

0 comments voice your opinion now!
oracle oci8 pecl beta release connection pooling fast application notification


Christopher Jones' Blog:
Customer Interview on PHP & Oracle 11g Connection Pooling (DRCP) in Oracle
April 17, 2008 @ 07:58:16

Christopher Jones has pointed out a new customer interview that was done covering PHP and the connection pooling in Oracle 11g for Oracle Magazine.

Oracle Magazine's May/June 2008 issue contains a "Developer Nation" article. In it, David Kelly interviews Levi Dixon from Community Connect about using PHP and Oracle.

The article references the Oracle/PHP "strange combination" that used to exist and how it's evolved into a vital, living part of Oracle's stack (like with the OCI8 extension).

0 comments voice your opinion now!
oracle interview connection pooling drcp magazine


Christopher Jones' Blog:
Updated connection pooling in PHP's OCI8 extension
February 01, 2008 @ 10:16:00

In this new post to his Oracle blog, Christopher Jones mentions some updates he's made to the OCI8 extension for PHP:

I've merged connection pooling (DRCP) and Fast Application Notification (FAN) support to PHP 5.3's OCI8 extension. The PHP 5.3 OCI8 code is Beta - in fact, PHP 5.3 itself is still really "Development". (It would be handy to have problems reported before PHP 5.3 goes Production).

He also includes instructions on how to get this new version installed inside of the latest PHP 5.3 snapshot (http://snaps.php.net) to build the new support in.

0 comments voice your opinion now!
oci8 extension update connection pooling install instruction php5


Christopher Jones' Blog:
Oracle & PHP Users don't miss the Zend Conference
September 21, 2007 @ 09:31:00

In a new post to his blog, Christopher Jones mentions some of the talks that he's going to give at the upcoming Zend/PHP Conference & Expo:

Oracle & PHP users: make sure you check out the Zend Conference. I'll be given a couple of sessions, "Connection Pooling & Other Features for Data Scaling" and "Performance Tuning for PHP with Oracle Databases". There are plenty of other great talks, too.

There's tons of other sessions happening during the conference including talks on:

  • best practices
  • enterprise PHP
  • the Zend Framework
  • API design

Check out the official conference page for information on location, other sessions and registration.

0 comments voice your opinion now!
zendcon2007 oracle presentation connection pooling performance tuning zendcon2007 oracle presentation connection pooling performance tuning


Christopher Jones' Blog:
Highly Scalable Connection Pooling in PHP
January 03, 2007 @ 15:27:07

On his blog today, Christopher Jones hands the floor off to Luxi Chidambaran to talk some about "Highly Scalable Connection Pooling in PHP".

Oracle Database Resident Connection Pooling - a connection pooling feature in the next version of the Oracle DB that will allow very high traffic web sites to scale better. We announced this feature at Oracle OpenWorld in 2006. One cool thing about the feature is that it is not just limited to PHP - any database client could use it.

Luxi talks about pooling in general, pooling database connections specifically, how Oracle handles it and the three views around it - DBA, Client side, and the PHP user views.

0 comments voice your opinion now!
scalable connection pooling oracle database scalable connection pooling oracle database



Community Events











Don't see your event here?
Let us know!


hhvm opinion unittest symfony2 release introduction hack framework code application overview component install example package language facebook security composer podcast

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework