Advice on allocating SAN storage to a virtual database server on VMware Post: 303027949

Sponsored Content

Operating Systems Linux Red Hat Advice on allocating SAN storage to a virtual database server on VMware Post 303027949 by Peasant on Friday 28th of December 2018 12:37:11 PM

12-28-2018

Moderator

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.

Peasant

View Public Profile for Peasant

Find all posts by Peasant

5 More Discussions You Might Find Interesting

1. 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...

2. 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 ...

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...

4. 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.

5. 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 ...

LEARN ABOUT SUSE

ocf_heartbeat_vmware

OCF_HEARTBEAT_VMWARE(7) 					OCF resource agents					   OCF_HEARTBEAT_VMWARE(7)

NAME

       ocf_heartbeat_vmware - Manages VMWare Server 2.0 virtual machines

SYNOPSIS

       vmware [start | stop | monitor | meta-data]

DESCRIPTION

       OCF compliant script to control vmware server 2.0 virtual machines.

SUPPORTED PARAMETERS

       vmxpath
	   VMX configuration file path (required, string, no default)

       vimshbin
	   vmware-vim-cmd executable path (optional, string, default /usr/bin/vmware-vim-cmd)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 600.

       stop
	   Stops the resource. Suggested minimum timeout: 600.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 300.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.

EXAMPLE

       The following is an example configuration for a vmware resource using the crm(8) shell:

	   primitive example_vmware ocf:heartbeat:vmware 
	     params 
	       vmxpath=string 
	     op monitor timeout="30" interval="300" depth="0"

SEE ALSO

       http://www.linux-ha.org/wiki/vmware_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents 1.0.3						    07/05/2010						   OCF_HEARTBEAT_VMWARE(7)