|
![]()
I understand that IIS and Apache are web servers. What about databases? Say I have a mySQL database and I want my database to be separate in a three tier model. Will I use a server software like windows 2003 for my mySQL database. Is there special server software only for DBMS like IIS and Apache is for the web?
Database Server Software?
DBMS' are essentially services, just like IIS & Apache. They run on their respective operating systems just the same. MySQL runs on both Windows & Linux.
Database Server Software?
Not that you would use it, but you may want to check out the composition of the Lamp Stack:
http://en.wikipedia.org/wiki/LAMP_(softw...
one of the more common collections of server software to get a understanding of a complete package. Often you will have the Operating System and Middleware (Servers and DB's) described. We use a combination of Linux (Ubuntu) for the OS, Apache/Tomcat (or Geronimo) for the web servers, and Postgres or DB2 for the Data Base with Java as the programming language.
There are numerous combinations with their own pluses and minuses. The good news is now is there is much better cross-platform capability. So, if you start with one collection you can often convert to another.
|
