http and db connection pooling through PHP

After having the meeting with jpuga and jruiz to talk a bit about ILIAS installation on the university servers, two main issues should be looked into for a successful deploy:

1) kernel TCP/IP connection limit should be greater than the default 1024 value.
2) A connection pooling mechanism must exist to support a lot of users at the same time.

So, i’m starting to learn some about the second point. Here, some debate:

– The pconnect() method that php provides isn’t the right solution for scalability.

– An aproach could be looking into SRM(Script Running Machine), designed to solve some of the problems often encountered within web scripting languages (i.e. PHP) that are a result of the stateless nature of the HTTP protocol.

– Another could be looking into SQL Relay, a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, Oracle, MySQL, mSQL, PostgreSQL, Sybase, MS SQL Server, IBM DB2, Interbase, Lago and SQLite with APIs for C, C++, Perl, Perl-DBI, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBI, TCL and Java, command line clients, a GUI configuration tool and extensive documentation. The APIs support advanced database operations such as bind variables, multi-row fetches, client side result set caching and suspended transactions. It is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated databases and throttling database access.

So, time to read 🙂

7 comentarios en “http and db connection pooling through PHP

  1. Hola Arturo. A partir de ahora leeré con más detenimiento tus parrafadas sobre PHP, porque en mi nuevo curro voy a usarlo MUCHÍSIMO. Me tendrás que recomendar algún libro para empezar, listas de correo, depuradores… En fin, cualquier consejo será bienvenido.

  2. Ara, no sabía que ya te han dado un currele! ¿el de Valencia? Bueno…capto la indirecta de las «parrafadas»…ok. Yo no he usado nunca ningun libro de PHP, aunque supongo que es una buena idea para empezar comprarse el «Programming PHP» y el «PHP Cookbook», los dos de O’reilly: aqui.
    Listas de correo y documentacion variada aquí. Como herramienta te aconsejo que consigas el Zend Studio 3, que incorpora un depurador por HTTP… no es excesivamente caro, y en el emule está.

  3. Life experience teaches that we generally get back what we put out. If we don’t like what we are getting back, we should examine what we are putting out.

Deja un comentario