SVM RAID5: Can an app access raw partitions? Post: 302959265

Sponsored Content

Operating Systems Solaris SVM RAID5: Can an app access raw partitions? Post 302959265 by DavidC_SysEngr on Friday 30th of October 2015 04:51:42 PM

10-30-2015

Registered User

SVM RAID5: Can an app access raw partitions?

I am using Solaris 9 (Sparc based) with Sybase and a proprietary DB application that works with Sybase. In the past we have not used SVM or any RAID config. The DBs were configured such that each DB had its own partition.

Now I would like to setup a new machine with the DBs on a RAID5 config using SVM. This will be my first time using RAID5 or SVM.

I think that my proprietary app references raw partitions because its installer asks what raw partition each of the DBs resides on.

So my questions are:
1) Can each DB still be on its own raw partition (such as something like c0t0d0s3) with RAID5? Or does RAID5 inherently preclude this?
2) Can an application still reference raw partitions with RAID5? Maybe my app will accept soft partitions, I'm not sure. But first, I would like to understand if I am approaching this issue correctly.

I've read some things that imply this is not possible, that a file system or soft partitions have to be used. But I haven't found anything that sufficiently explains everything so that I can understand what the issues and problems are. I'm thinking that lots of people must use Sybase DBs with RAID5, so there must be an explanation that I'm just missing.

I've also read posts on various forums where it was said that I shouldn't even consider using Solaris 9 SVM RAID5, but no one ever explained why they had that opinion. I would be interested in any comments on that.

DavidC_SysEngr

View Public Profile for DavidC_SysEngr

Find all posts by DavidC_SysEngr

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

App for internet access on unix terminals

I am trying to find out what I should install to provide internet access and browsing possibilities on multiple unix terminals. Can anybody help? TNXS

2. Filesystems, Disks and Memory

raw partitions

i want to know, how do i to create a rwa partttions in unixware 7 wit raid 5 best regards felix arteaga

3. SCO

Raid5 Failure

Forgive me, I do not know much about RAID so I'm going to be as detailed as possible. This morning, our server's alarm was going. I found that one of our drives have failed. (we have 3) It is an Adaptec ATA RAID 2400A controller I'm purchasing a new SCSI drive today. My questions: ...

4. Filesystems, Disks and Memory

Problem setting up raw partitions on SUSE v8.0 using LVM on Oracle 8.1.7.URGENT!!!!!!

Hi all! Working on Oracle v8.1.7.0.0 with OS �as Suse v8.0 Linux. I had created LVM,linked raw devices to LVM as below: # for binding raw devices raw /dev/raw/raw1 /dev/oracle/sam_raw_system_251m raw /dev/raw/raw2 /dev/oracle/sam_raw_users_26m raw /dev/raw/raw3...

5. Solaris

How to create new partitions in solaris,from the raw disk?

Hi all, I would like to know how to make new partitions.... I currently have allocated 60G for various slices (I have totally used 4 out of 7 available slices... I am running only solaris on my box. My plan is to have entire disk dedicated to solaris and run other OS from within...

6. Solaris

SVM Soft partitions in a metaset- how to migrate ?

Hi Friends, I need your assistance, could someone assist.... Scenario:- Solaris 10, with zones and mounted file systems, using SAN. SVM with metasets on it configured soft partitions on the meta device. These soft partitions are mounted and file systems are being accessed. We are now trying...

7. SuSE

Raid5

Hi all, I am currently using opensuse 12.1, We have Raid 5 array of 8 disks. A friend of mine accidently removed a drive & place it back and also added a new disk to it(making it 9 disks). now the output of mdadm --detail is as shown below si64:/dev # mdadm --detail /dev/md3 /dev/md3:...

8. Programming

Wuhan Coronavirus Status App for China - Rapid Prototype using MQTT and the IoT OnOff IOS App

With a little bit of work, was able to build a nice "Wuhan Coronavirus Status" app using MQTT and the IoT-OnOff app. More on this technique here: ESP32 (ESP-WROOM-32) as an MQTT Client Subscribed to Linux Server Load Average Messages The result turned out nice, I think. I like the look and...

LEARN ABOUT DEBIAN

dbix::class::storage::dbi::sybase::ase::nobindvars

DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3pm) User Contributed Perl DocumentationDBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3pm)

NAME

       DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars - Storage::DBI subclass for Sybase ASE without placeholder support

DESCRIPTION

       If you're using this driver then your version of Sybase or the libraries you use to connect to it do not support placeholders.

       You can also enable this driver explicitly using:

	 my $schema = SchemaClass->clone;
	 $schema->storage_type('::DBI::Sybase::ASE::NoBindVars');
	 $schema->connect($dsn, $user, $pass, \%opts);

       See the discussion in "Using ? Placeholders & bind parameters to $sth->execute" in DBD::Sybase for details on the pros and cons of using
       placeholders.

       One advantage of not using placeholders is that "select @@identity" will work for obtaining the last insert id of an "IDENTITY" column,
       instead of having to do "select max(col)" in a transaction as the base Sybase driver does.

       When using this driver, bind variables will be interpolated (properly quoted of course) into the SQL query itself, without using
       placeholders.

       The caching of prepared statements is also explicitly disabled, as the interpolation renders it useless.

AUTHORS

       See "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.14.2							    2010-06-03		   DBIx::Class::Storage::DBI::Sybase::ASE::NoBindVars(3pm)