LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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
 
LinkBack Search this Thread
Old 02-10-2013, 01:53 PM   #1
Skaperen
Senior Member
 
Registered: May 2009
Location: WV, USA
Distribution: Slackware, CentOS, Ubuntu, Fedora, Timesys, Linux From Scratch
Posts: 1,777
Blog Entries: 20

Rep: Reputation: 115Reputation: 115
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, 05:01 PM   #2
MensaWater
Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 5,770
Blog Entries: 4

Rep: Reputation: 697Reputation: 697Reputation: 697Reputation: 697Reputation: 697Reputation: 697
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, 09:46 PM   #3
Skaperen
Senior Member
 
Registered: May 2009
Location: WV, USA
Distribution: Slackware, CentOS, Ubuntu, Fedora, Timesys, Linux From Scratch
Posts: 1,777
Blog Entries: 20

Original Poster
Rep: Reputation: 115Reputation: 115
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
Trackbacks are Off
Pingbacks are On
Refbacks are 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 05:45 AM
Raw access to devices RichardS Programming 8 07-19-2007 10:27 AM
what is the different btw raw devices and block devices yenonn Linux - General 2 02-10-2006 09:34 PM
Raw devices gauol Linux - General 2 09-23-2004 02:01 PM
Raw Devices rajar11 Linux - Newbie 4 06-16-2004 01:36 PM


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

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