vensali
asked on
OS & DB Recommendation
We have to decide on the OS platform ( Linux or Windows) and DB ( Mysql & MSSql server) for our new HIS roll-out. I need expert recommendations & pros/cons for each of these in terms
1. Performance
2. Maintainability
3. Scalability.
The Hospital information System ( HIS) is web based one developed in java.
1. Performance
2. Maintainability
3. Scalability.
The Hospital information System ( HIS) is web based one developed in java.
I'd second that - generally you should only choose Windows as a server platform if you are compelled by language or platform constraints - which it sounds like you're not. Almost all major web sites are Linux based these days, so for cost, performance and scalability you can effectively lean on the thousands of people who have analyzed this same choice and picked Linux.
Once you go with Linux, then MySQL is the natural choice. Again, it's the database of choice in millions of sites today and so again you have the proof that lots of others have made it work as a cost effective and scalable choice.
Linux + MySQL is a platform that clearly provides any level of performance and scalability you desire (again - the existence proof of all those huge web sites using this combination today). Maintainability is more down to the specific flavor of Linux you choose. Some come with more support (e.g. RedHat) and some less.
Hope that helps,
Doug
P.S. For our sites (which support millions of monthly users) we personally picked CentOS + MySQL and have no regrets. We've used this combo for the last decade.
Once you go with Linux, then MySQL is the natural choice. Again, it's the database of choice in millions of sites today and so again you have the proof that lots of others have made it work as a cost effective and scalable choice.
Linux + MySQL is a platform that clearly provides any level of performance and scalability you desire (again - the existence proof of all those huge web sites using this combination today). Maintainability is more down to the specific flavor of Linux you choose. Some come with more support (e.g. RedHat) and some less.
Hope that helps,
Doug
P.S. For our sites (which support millions of monthly users) we personally picked CentOS + MySQL and have no regrets. We've used this combo for the last decade.
ASKER
how about ubintu + mysql.
or how about having OS as Linux and separate server having windows server + SQL Server DB.
as people at our place are more conversant with sql server DB .
Also How does MY SQL compares with SQL Server in terms of
1. Performance ( around 1000 concurrent users.)
2. Scalability & Maintainability
3. Vendor Support
4. Available tools to monitor Server performance( Performance tuning)
5. Hardware & Memory Configuration
6. Clustering.
or how about having OS as Linux and separate server having windows server + SQL Server DB.
as people at our place are more conversant with sql server DB .
Also How does MY SQL compares with SQL Server in terms of
1. Performance ( around 1000 concurrent users.)
2. Scalability & Maintainability
3. Vendor Support
4. Available tools to monitor Server performance( Performance tuning)
5. Hardware & Memory Configuration
6. Clustering.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Linux + postgres
I don't know many people who still run on windows production servers these days.