[eluser]OverZealous[/eluser] @tomdelonge
I think, without question, DMZ is the wrong place for this functionality. This should be handled transparently using a replication or pooling library.
For example, with PostgreSQL, I've had great luck with PGPOOL-II. This allows connection pooling, master/slave style replication, and more. The best part is that PHP makes normal connections to the DB (sans pconnect), and the only change in the code is changing the port number. The performance increase, even with a single database server, was noticeable (due mostly to the connection pooling).
Either way, DMZ does not support that, and I wouldn't expect it to be possible on a code-level with this style library, or even with CodeIgniter in general.
