Compilation

mod_dbi_pool uses the "configure/make/make install" mechanism common to many Open Source programs. Most of the dirty work is handled by either configure or Apache's apxs utility. If you have built Apache modules before, there shouldn't be any surprises for you.

The interesting options you can pass to configure are:

• --with-apxs=/path/to/apache/dir/bin/apxs

  This option is used to specify the location of the apxs utility that was installed as part of apache. Specify the location of the binary, not the directory it is located in.

• --with-dbi=PREFIX

  Prefix where libdbi is installed.

• --help

  Provides a list of available configure options.

./configure --with-apxs=/usr/sbin/apxs2
make
make install

Integration into Apache

To activate mod_dbi_pool Just add

LoadModule dbi_pool_module modules/mod_dbi_pool.so

to your httpd.conf and restart Apache.

mod_dbi_pool also provides two exported functions for other Apache Modules to use:

dbi_conn *dbipool_open (conn_id id);
void dbipool_close (conn_id id, dbi_conn* conn);

Configuring with Apache

A configuration set is all the parameters that describe one database pool. You can have an unlimited number of configuration sets, and each set can be used concurantly. mod_dbi_pool has the following directives:

• PoolDbiConnHardMax
• PoolDbiConnMin
• PoolDbiConnSoftMax
• PoolDbiConnTTL
• PoolDbiDBName
• PoolDbiDriver
• PoolDbiHost
• PoolDbiPassword
• PoolDbiUsername

Add the following to your httpd.conf for a simple pool:

PoolDbiDriver         Server1  mysql
PoolDbiHost           Server1  10.0.0.20
PoolDbiUsername       Server1  myuser
PoolDbiPassword       Server1  mypass
PoolDbiDBName         Server1  vhost_dbi
PoolDbiConnMin        Server1  1
PoolDbiConnSoftMax    Server1  1
PoolDbiConnHardMax    Server1  5
PoolDbiConnTTL        Server1  30