Click to See Complete Forum and Search --> : What kind of database I need to use in Linux?
lubiel2
10-15-2003, 05:05 PM
Hello,
I have a Linux 2.4 Machine, someone can help me
in which kind of database and version & Site Download
I need to install in order to store records aprox 60 thousand
daily ??? And How read that records from Windows 2K Server OS ???
Any help is greatly appreciated.
bwilliam79
10-15-2003, 05:15 PM
www.mysql.com
www.postgresql.com
lubiel2
10-15-2003, 05:20 PM
How know what version is my Linux please...
I used:
uname --> Linux
kernelversion --> 2.4
so, I have a CDs which says 7.3, so, I dont know ???
Linux is the kernel, the core of the system.
uname -a to check the kernel version.
7.1 would be the version of your distro.. (i.e: Red Hat, Mandrake, etc).
louiscypher
10-16-2003, 07:08 PM
If you have RedHat, try this from the command line:
#rpm -q redhat-release
redhat-release-9-3
If it's not RedHat, what is it?
As for what types of DB? Every major DataBase except MS's proprietary DB's have been ported to Linux. You have a lot of options. Much depends on what you need to do with it. Does it need to be RDBMS? Does it just need transaction logging?
RDBMS: PostGres.
Fast and Furious: MySQL %70 of the time, this is going to be your easiest choice.
You can get pretty solid MySQL for Win2K now as well. You can also go free versions of SAP, Oracle, Firebird, etc., on Linux, and though 60k record adds is a lot, if it can be handled on an i686 platform, then Linux is by far your best choice. If this is really mission critical, and you need to hold onto the data for extended periods ( > a Terabytes worth), the better option would be Sun E4500 on a stack of T3's with fiber.
So, what type of hardware / OS / network? What are the demands of your situation, i.e. is the DB going to be 'hot' 24 X 7, and will you need to manipulate the data after input? How often will you backup, flush the tables, merge records / tables?
Additionally, what type of interface can you make? Open Source has all the libraries open for accessing any database in existence if you can write C or C++ code, but that's probably too much data for a reliable scritping hack.
Good luck in advance.
lubiel2
10-17-2003, 04:32 PM
Hello,
My idea is moving a log file aprox 80 MB per day from Linux
to Windows 2K Server.
someones says use Samba, but I dont know how?
I am trying to use a MySQL to read log file, use a script
in order to read each row and insert into MySQL.
I am newbie in Linux.
I need help with this please.