Solved

using linux for database server

Posted on 2003-10-29
10
243 Views
Last Modified: 2013-11-13
hi there,

i want to use linux for my database server. for this i want to know the mandatory advantages what linux offers me for this.
also pls mention the advantages of using linux over win NT with reasons.

bye,
atul.

 
0
Comment
Question by:atul812
10 Comments
 
LVL 1

Accepted Solution

by:
m1fcj earned 63 total points
ID: 9641748
If you are using any common distribution, you can install two excellent choices: MySQL and PostgreSQL. Both are free and proper RDBMSes. PostgreSQL is the less common but more compliant of the two. MySQL used to not provide some functionality but the latest versions are as good as anything.

Advantages are stability and speed but both of these depend on how you tune your system/database. You can run MySQL and PostgreSQL on your NT/Win2K box if you use Cygwin. The performance suffers, the security is non-existent but it works.

Query if you have any of these installed by typing
 rpm -qi postgresql
or
rpm -qi mysql
on your shell.

For example here's a stock Suse 8.2 with MySQL installed:

titan:~ # rpm -qi mysql
Name        : mysql                        Relocations: (not relocateable)
Version     : 3.23.55                           Vendor: SuSE Linux AG, Nuernberg
, Germany
Release     : 14                            Build Date: Sat Mar 15 19:20:06 2003

Install date: Wed Oct 22 13:58:48 2003      Build Host: butenandt.suse.de
Group       : Productivity/Databases/Servers   Source RPM: mysql-3.23.55-14.src.
rpm
Size        : 16971518                         License: GPL, Other License(s), s
ee package
Packager    : http://www.suse.de/feedback
URL         : http://www.mysql.com
0
 
LVL 20

Assisted Solution

by:Gns
Gns earned 62 total points
ID: 9642791
Most major commercial databases are also supported on linux... Oracle, DB2 ...
The "platform" mostly enjoys the same kind of benefits that any Unix platform would: manageability, performance and stability.
Since at least Oracle have a stupid distribution scheme (they rely on the portability of .o files... and the non-changeing nature of glibc... which changes all the time:-), only a limited set of distributions might be certified, but... most things can be "adjusted" on any distro:-).

There are more freeware/shareware/opensource alternatives than PostgreSQL and MySQL (mind you, MySQL is commercial too;)... But those cover most (if not all) needs.

-- Glenn
0
 
LVL 12

Expert Comment

by:paullamhkg
ID: 9647538
Both of them already gave you very good hints/suggestion, I'm just wanna to suggest if you going to have a very huge database, try to get more RAM as you can, because database like mysql and Oracle with more RAM will perform better :)
0
 
LVL 9

Expert Comment

by:svenkarlsen
ID: 9653733
People seem to be very modest here!

You ask for advantages in using free software compared to e.g. MS SQL Server. I'd say the question is: what disadvantages may there be in choosing OpenSource SW?

Having run MySQL problem-free for several years, I see no disadvantage. If you want to run it up against MS applications, I can safely say that it's quite easy to use e.g. MS Access as user IF if you install the ODBC (also free).

Sometimes I actually use MS Access to create the template Db, and then export it to MySQL (via ODBC) for finetuning.

Why I use MySQL instead of PostgreSQL? Simply because it was the first I installed, and it kept on working without errors, - I'm sure the same would have happened if I had started out with PostgreSQL.
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 1

Expert Comment

by:lamdor
ID: 9654582
Yes ,

 MySQL and postgres are the better one in free ware. I belive there is one more free database if u buy linux exnterprise server that is redhat database. The RH db also is very good.

 But it all boils down to your needs how you want them and what u store in that and how much performance u need.

 for better performance user more RAM with Postgres or MySQL. But some of the best features in RDBMS are not supported in both of them. But I think they are good and gives good result as expected.

 
0
 
LVL 2

Expert Comment

by:jjerome00
ID: 9799414

I just wanted to point out that someone posted that you can only run mySQL in Windows if you use cygwin, and that is not the case.  As far as my knowledge goes, mySQL runs on Windows just fine; I've run it on both Linux and Windows.  

As for which to pick, I have always seen a general trend for people to use mySQL.  Maybe it's just an easier name to pronounce, but most people just tend to gravitate towards it.
0
 
LVL 20

Expert Comment

by:Gns
ID: 10183013
I think m1fcj has the right of this one (since atul812 doesn't indicate that s/he went with a commercial db... Doesn't indicate anything...:-).

-- Glenn
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 10231736
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Split between m1fcj and Gns
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

khkremer
EE Cleanup Volunteer
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now