- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- EVA and Oracle Databases.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-25-2009 09:15 PM
тАО02-25-2009 09:15 PM
-if it's a OK to assign a single big LUN , say of 280G ,create a single Vg , and create LVs to contain all Database FS ( indexes , redolog , archive ,datafiles ..etc).We are using Vraid 1 , and EVA 8K is configured in 2C2D configuration.Some ppl. will suggest that in vraid striping and mirroring are taken care of and we need not worry about db block size etc .
-could you please share you experience with database(Oracle on EVA).
-we are expecting good number of hits to Database.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2009 01:18 AM
тАО02-26-2009 01:18 AM
Re: EVA and Oracle Databases.
the general best practices is using the EVA LUNs/LVM as follows:
redo logs RAID1, each as a separate EVA LUN
archive logs RAID1, each as a separate EVA LUN
redo log/archive logs mirrors on a separate EVA Luns
datafiles RAID5 nicely balanced according to the number of the front ports/host hbas, etc.,
e.g. 4 smaller LUNs, 8 smaller LUNs for LVM,...
Also it is a good practice in HPUX before 11.31 to evenly set preferred path to controller a,b (failover, failback) on the eva controllers during the vdisk presentation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2009 01:41 AM
тАО02-26-2009 01:41 AM
Re: EVA and Oracle Databases.
hp os is 11.31 , setting up multipathing manually is ruled out,Oracle version will be
10.2.0.7.expecting more views!! thanks once agian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2009 11:51 AM
тАО02-26-2009 11:51 AM
Re: EVA and Oracle Databases.
I don't know if 11.31 understands ALUA (asymmetrical logical unit access) - if not, you better DO manual optimizations or all virtual disks can end up on one EVA controller over time.
Oh, I just see you have a 2C2D - well, it should not be that bad on such a small box...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2009 12:18 AM
тАО02-27-2009 12:18 AM
Re: EVA and Oracle Databases.
@IBaltay
is it best practise according ORACLE or HP?
I have configured LUNs for my databases almost just the same way (just archived redologs I've put on R5 - log switch once in 20min or so can R5 handle pretty fine, I think) but unfortunately time to time I'm reaching throughput capacity limits on EVA8k controler's internal mirror ports. storage vendor (after discussion with HP) tries to persuade me to change R5 to R10 because R10, allegedly, should generate less internal traffic.
I do not incline to such a change due to several reasons.
Do you have a link to any officially released best practice document (preferably from HP) according topic? If you could share it I would appreciate it.
thanks.
emha.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2009 01:33 AM
тАО02-27-2009 01:33 AM
Solution... but unfortunately time to time I'm reaching throughput capacity limits on EVA8k controler's internal mirror ports. storage vendor (after discussion with HP) tries to persuade me to change R5 to R10 because R10, allegedly, should generate less internal traffic.
EVA general perf best practices:
ftp://ftp.compaq.com/pub/products/storageworks/whitepapers/5982-9140EN.pdf
HPUX 11.31 Multipathing:
HPUX11.31 - MPIO Native (ALUA/ALBA)
http://docs.hp.com/en/native-multi-pathing/native_multipathing_wp_AR0803.pdf
Evaperf for the VDISK perf analysis:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1239472
RESUME/Notes
a) LVM on UX/Linux to nicely loadbalance the front end
b) the more physical disk in the DG the more backend distribution of each VDISK
c) Multipathin solution, either manual (PVlinks) or automatic (Native MPIO)
Few words on EVA Active/Active and loadbalancing:
a) all writes are being written into both controllers via the mirror ports
b) all reads are driven directly via the managing controller, undirectly via the mirror port
Host MPIO ALUA optimizes this and communicates directly with EVA managing controller which then reduces the mirror port based reads by the second (proxy) controller
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2009 03:29 AM
тАО03-02-2009 03:29 AM