Advice on allocating SAN storage to a virtual database server on VMware


 
Thread Tools Search this Thread
Operating Systems Linux Red Hat Advice on allocating SAN storage to a virtual database server on VMware
# 8  
Old 12-28-2018
I want to make sure I'm understanding the configuration advice I've been given. Create one large LUN. Say 1 tb, for example, on the SAN side. Map that lun to the VMhost. Allocate say 600 gb to my oracle db server. The linux server should now see a /dev/sda at 600 gb?
Take that /dev/sda and partition it out into separate drives /dev/sda1 /dev/sda2.... Once that is complete I create separate volume groups and assign as many of the disks as needed per volume group?
# 9  
Old 12-28-2018
Hi dkmartin,

I'll reiterate, there is a dependency on the backend configuration.

If you have a requirement to slice and dice a 1Tb LUN, you'll end up (from your comments) /dev/sda1, /dev/sda2, /dev/sda3 etc....... These would then be used for the "rootvg", the "appvg" the "dbvg" or any other way that you decide to apportion the disk.

If you decide to go for individual LUN's then you would have effectively a "ROOT_LUN", an "APP_LUN" and a number of "ORACLE_LUNS" for things like redo, archive, table space and all the other bits of an Oracle Instance - basically whatever your standard build is.

Without knowing what the backend storage is and how it is configured, how the storage is managed and how it is tiered are the arrays intelligent along with a miriad of other requirements it isn't possible to be any clearer with the information.

At the back end this could be all on one physical disk (You don't want that) or it could be spread over many physical disks.

For simplicity of management a single LUN is good, if the I/O on the VM will allow you to do that without impacting performance.

As to this being "configuration advice" it is not, there is no way that any advice could be given based on what you have told me - the sum total of the knowledge inparted by yourself is that "It's currently AIX and it's moving to Linux on VMware - the LUN mentioned is 1Tb and you use Oracle".

Oh! and it won't be using ASM.

Regards

Gull04

Last edited by gull04; 12-28-2018 at 11:25 AM.. Reason: Minor addition.
# 10  
Old 12-28-2018
On VMWARE i would recommend using RDM, multiples of, in SAN environments.

Inside the guest, use ASM and minimize filesystem caching via kernel parameters, since you will not need it.
If filesystems are used, go XFS and limit the filesystem caching considering the size of SGA / PGA from Oracle side.
Check out the tuning docs regarding from Oracle side.

In either case, using ASM or XFS with volume manager, be sure to separate REDO, DATA and archive logs do use different RDMs.

On storage side, set new page assignment on REDO LUN to hit the fastest you have.
DATA then comes second disk performance wise, while archive logs can be slowest rust.

Use storage to provide snapshots, cloning and stuff.
One monster lun then datastore then guest database sure sounds like a nightmare from my perspective.

Hope that helps
Regards
Peasant.
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

How to mount a 79TB SAN storage to another server?

Hi Team, How do i mount or connect the SAN storage to a specific folder. I have tried to mount it but each time i can only mount 900GB of the storage to the folder: ipmi1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-root_vol ... (0 Replies)
Discussion started by: ElVista
0 Replies

2. UNIX for Dummies Questions & Answers

Allocating Unallocated Drive Space from a SAN to a filesystem

Good Morning everyone, I want to know how to allocate unallocated drive space from a SAN to a file system that desperately needs the drive space. Does anyone have any documentation or tips on how to accomplish this? I am running on AIX version 6.1. (2 Replies)
Discussion started by: ryanco
2 Replies

3. SuSE

Hot-add memory to SuSE / VMware virtual server

Hi, Here is the issue. Some more memory has been added from vCenter to the virtual machine. From the virtual machine running SuSE 11 SP3. # modprobe acpiphp # modprobe acpi-memhotplug # grep -v online /sys/devices/system/memory/*/state # It looks like there is no offline memory, but free... (1 Reply)
Discussion started by: aixlover
1 Replies

4. Solaris

SAN Storage to solaris 10 server

Hi, I have configured our SAN Storage to be connected to our new SUN T5220. On the SAn it looks all fine on the server I do not see any connection: cfgadm -al Ap_Id Type Receptacle Occupant Condition c1 scsi-bus connected ... (4 Replies)
Discussion started by: manni2
4 Replies

5. Solaris

Using San storage - advice needed

Thinking of using our San for network backups.. Have a Netra 240 being installed and planning to get some space on our San. Do you know what software is used to access the San from my server or what I would need to do? I know how to connect to local storage, disk arrays etc but not sure what... (1 Reply)
Discussion started by: frustrated1
1 Replies
Login or Register to Ask a Question