cyberlot has posted the second part in his "Using scalability to improve your PHP applications MySQL security" series today on his blog.

In this edition, he gives an example of extending PDO to use two seperate database connections.

Here is a quick example I threw together to extend PDO so you can use 2 seperate database connections.

This extends PDO and only connects to the database when the first query is run. This way if you never use the database connection no time is wasted trying to connect.

It's a pretty simple script, and even those that haven't gotten to mess much with PDO can give it a shot. Basically, you just don't call __construct when creating things. You have to create it with another function that's more configurable...