This post is more than 5 years old
1 Rookie
•
121 Posts
0
882
April 12th, 2007 11:00
How would data be spread on a meta volume
If a server needs 4 drives (16 GB, 40 GB, 40 GB and 104 GB), is it better to create 1 200 GB meta and divide it logically on the server or 4 metas of the appropriate sizes?
0 events found
No Events found!


dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
0
April 12th, 2007 17:00
presented 1 meta to the server and a logical volume
of 16 GB was created, that it would be spread across
the many hypers and not allocated on the first 2 8
GB hypers.
If you create a striped meta ..then it will be spread out on 25 hypers. I don't know what OS you are using for Oracle ..but also think about future expansion. If you are running Oracle on some flavor of Unix ..it would be much easier to expand in the future by utilizing some sort of volume manager (veritas, LVM ..etc). I would definitely not mix Oracle Database and Application on the same meta, but i would actually take it a step further and use different meta's for Oracle. I would create separate meta's for my logs, separate metas for my database. Access patterns are so different, if you have 2-way mirrors ..i would use those for logs ..and maybe RAID-5 for database. Let's say if you run Oracle on windows ...if you use striped meta and have to expand it ...big pain in the a$$, it involves saving data to BCV first, then adding another member to your meta which restripes all the data and then restore data from BCV. Of course you could use concatenated meta for easy of expansion ..but there goes your performance.
MrTS2Symm
113 Posts
0
April 12th, 2007 12:00
Dynamox is correct.
For performance and data layout, you would want to spread out your workload. It sounds like from your question, there will be 4 different applications or uses for the 4 drives and this supports your original needs.
dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
0
April 12th, 2007 12:00
Danne-Murphy
1 Rookie
•
121 Posts
0
April 12th, 2007 12:00
dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
0
April 12th, 2007 13:00
Danne-Murphy
1 Rookie
•
121 Posts
0
April 13th, 2007 04:00
dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
0
April 13th, 2007 10:00
i thought i said hypers
sysmgr1
2 Intern
•
128 Posts
0
April 13th, 2007 10:00
I do agree with 4 smaller metas is better though for the reasons everyone listed. Also, you potentially can gain additional cache areas along the IO path in various places. (ie. filesystem cache.)
dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
1
April 14th, 2007 05:00
same number of spindles whether you make one big meta
or 4 smaller ones that equal the same size. You use
the same number of hypers either way.
you bring up a good point ..if you use 25 unique hypers, that does not quarantee that you will end up on 25 unique physical spindles. If we take a 146G drive and slice it into ~8.6G hypers ..that will be a about 16 hypers per physical disk. So it's going wrap around at some point and you might select hypes for your meta on the same disk. When my CE builds the bin file, Symmwin spreads hypers as random as possible. So when i run symdev list, hypers are listed in very random way, different DAs, different interfaces. If i am building a 34G meta, i just pick the first 4 8.6G hypers. Knowing that everything in DMX goes thru cache and there is no direct read/write to disk ..i am not as picky building my meta, Clariion would be a different story of course.