where should database be installed?

[manofwax]

Hi, everyone. I'm wondering if the database should be installed on a separate partition from the application that is using the database, because i heard from somewhere that for Mircrosoft server, we should put the web server separate from the database.

but now, i'm not using MS SQL, i'm using MySQL instead, which is installed in linux enviroment. Should i separate the database as well for security reason? thanks.

[digitalv]

SQL databases should be installed on separate COMPUTERS from your web server or other functions, not just separate partitions.

Any flavor of SQL is a resource hog by design - the more resources it can take up the better it runs. When SQL has to share those resources its performance capabilities are decreased significantly.

[shri]

Having said that, if you have one server then the best strategy is to try and get two SCSI drives on that server and keep the database on one drive and your web files on another.

We deliver about 30 queries per second without any hiccups on a dual xeon which also runs the Apache server.

If you've got your DB and Web files on one server, do look at setting some off-server backup.

[manofwax]

thanks digitalv
thanks shri
=)