Best Performance, Dedicated MySQL or LAMP stack?

Scriptcase 9 General
#1

Im just looking for opinions here, or perhaps someone with experience. Is it generally best from a performance perspective to have Apache, PHP and MySQL on the SAME system… or would a dedicated MySQL server with apache and PHP on another system be better?

For Backup its easier to have all the eggs in one basket… but I just want to know for performance with multiple users what would be best.

Thanks!

P.S. The majority of my applications are for internal usage with about 50 users, not for the open internet with public users.

#2

All on the same machine would be the fastest… theoretically. You don’t have an additional network traffic running. But it depends. If your database load is heavy or you have a lot of other processes on your machine than an external database could be faster. From security perspective there are also some advantages as you can ‘hide’ the database machine for your clients.