In this new post over on cyberlot.net today, there's a bit of talk about improving your PHP application's MySQL security through scalability. How, you ask? Well, read on...

There are articles all over about ways to ensure your PHP application is secure, ways to prevent MySQL injection attacks and about how PHP is a poor lang due to all these exploits out in the world.

Theres a point where a person programming has to give up slight performance here and there to ensure the security of there application and there database, but what if you could increase security while at the same time improving your applications scalability??

He talks about an idea "so simple" that you might have been on a site that used it and not even known it - use two database connections. Yes, by the simple act of using two different connections, you've planned easily for the future of your site - scaling up quickly and easily when the need arises for migration to other servers.

Thankfully, he also presents the downside to this mentod - every single page, even the simplest of ones, will have to load both, taking just a bit longer to load each page. So, you trade off flexibility/limited security improvement for load time...hmm...