Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


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

Rep: Reputation: 119Reputation: 119
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
LQ Guru
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,130
Blog Entries: 14

Rep: Reputation: 1264Reputation: 1264Reputation: 1264Reputation: 1264Reputation: 1264Reputation: 1264Reputation: 1264Reputation: 1264Reputation: 1264
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 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
Senior Member
Registered: May 2009
Location: WV, USA
Distribution: Slackware, Ubuntu, Amazon Linux
Posts: 1,849
Blog Entries: 21

Original Poster
Rep: Reputation: 119Reputation: 119
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.


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 > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 06:01 PM.

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