Solved

using linux for database server

Posted on 2003-10-29
10
245 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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
 
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

1. Introduction As many people are interested in Linux but not as many are interested or knowledgeable (enough) to install Linux on their system, here is a safe way to try out Linux on your existing (Windows) system. The idea is that you insta…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

816 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

12 Experts available now in Live!

Get 1:1 Help Now