LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 02-10-2013, 02:53 PM   #1
Skaperen
Senior Member
 
Registered: May 2009
Location: WV, USA
Distribution: Slackware, Ubuntu, Amazon Linux
Posts: 1,778
Blog Entries: 20

Rep: Reputation: 116Reputation: 116
Database that can access raw partitions/devices?


Is there an open source database that can directly make use of raw partitions or devices to store data, rather than files in a filesystem? I'm looking at setting up a database that will be particularly large (planning to give it at least 16TB to be sure it has room for growth over the next year or so).

I'd like to avoid using files as the data basis to avoid the extra layer of location mapping, as well as allowing the database engine (if it can ... it should if it can do this) to optimize data location itself for minimized seeking time.
 
Old 02-10-2013, 06:01 PM   #2
MensaWater
Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 6,028
Blog Entries: 5

Rep: Reputation: 791Reputation: 791Reputation: 791Reputation: 791Reputation: 791Reputation: 791Reputation: 791
raw on Linux was at one time going to be removed in favor of O_DIRECT but hasn't quite gone away yet because some things don't support O_DIRECT.

However, most things don't use raw. On doing some quick searches on both MySQL and Postgresql the two main open source DBs it seems that there isn't really raw space support for the latter. (FYI: MariaDB is a drop in replacement for MySQL for folks that don't want Oracle's ...um... stewardship of MySQL.)

Note that ext4 (filesystem) takes one way beyond the 16 TB limit of ext3.

One could look at btrfs but on a quick search I saw mention that it isn't really ready for MySQL so likely isn't for Postgres either.
 
Old 02-12-2013, 10:46 PM   #3
Skaperen
Senior Member
 
Registered: May 2009
Location: WV, USA
Distribution: Slackware, Ubuntu, Amazon Linux
Posts: 1,778
Blog Entries: 20

Original Poster
Rep: Reputation: 116Reputation: 116
By "raw" I mean just access to the partitions or devices w/o going through a filesystem ... not the BSD notion of raw. Sad that neither of these can do it.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] partitions within raw image; how to access those? Ramurd Slackware 4 05-13-2011 06:45 AM
Raw access to devices RichardS Programming 8 07-19-2007 11:27 AM
what is the different btw raw devices and block devices yenonn Linux - General 2 02-10-2006 10:34 PM
Raw devices gauol Linux - General 2 09-23-2004 03:01 PM
Raw Devices rajar11 Linux - Newbie 4 06-16-2004 02:36 PM


All times are GMT -5. The time now is 02:23 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration