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 🙂