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

Sponsored Content

Operating Systems Linux Red Hat Advice on allocating SAN storage to a virtual database server on VMware Post 303027927 by Scrutinizer on Friday 28th of December 2018 09:23:31 AM

12-28-2018

Moderator

For both performance and availability reasons I would keep tend the setup of different luns for different part of the database , data, redo, archive, duplex, unless there are small database and/or only crash recovery is required.. You can create different Volume groups for each set of disks.. Definitely also a different VG for OS data.
It may be beneficial to spread the date over several LUNS in the data VG, with or without a small stripe, that depends on your workload and underlying SAN storage, to overcome bottlenecks due to the sequential nature of SAN connectivity (Fibre Channel, iSCSI). An alternative to the latter may be to enlarge the queuing depth, it all depends. The other Oracle VG's require sequential access, where a single disk (two lun paths) will probably suffice..

If you don't use ASM, you would need to determine if you want to use raw or cooked logical volumes within the VG's.
You need to set multipathing, and then there is the backup and recovery method you need to choose, etc..

Last edited by Scrutinizer; 12-28-2018 at 10:31 AM..

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

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 CENTOS

pmdavmware

PMDAVMWARE(1)						       Performance Co-Pilot						     PMDAVMWARE(1)

NAME

       pmdavmware - VMware performance metrics domain agent (PMDA)

DESCRIPTION

       pmdavmware is a Performance Metrics Domain Agent (PMDA) which exports metric values from a (possibly remote) VMware virtualisation host.

       This implementation uses the VMare Perl API (refer to the online docs at http://www.vmware.com/support/developer/viperltoolkit).  VIPerl is
       a prerequisite for this PMDA, it needs to be installed and configured before attempting to use this agent.  It is highly recommended that
       you test your VIPerl installation using the demo programs that are shipped with VIPerl, before attempting to use this PMDA.

INSTALLATION

       In order to access performance data using the VIPerl API, it is necessary to be able to login to the metrics source.  Hence, a valid VMware
       server name, user name and pass word are needed by the PMDA.  These can be passed in on the command line (via the pmcd.conf file) or via a
       vmware.conf file in the PMDA directory.

	       # cd $PCP_PMDAS_DIR/vmware
	       # [ edit vmware.conf ]

       This file should contain three lines, such as:

	       $server = 'vm.server.net';
	       $username = 'XXXX';
	       $password  = 'YYYY';

       Once this is setup, you can access the names and values for the vmware performance metrics by doing the following as root:

	       # cd $PCP_PMDAS_DIR/vmware
	       # ./Install

       If you want to undo the installation, do the following as root:

	       # cd $PCP_PMDAS_DIR/vmware
	       # ./Remove

       pmdavmware is launched by pmcd(1) and should never be executed directly.  The Install and Remove scripts notify pmcd(1) when the agent is
       installed or removed.

FILES

       $PCP_PMDAS_DIR/vmware/vmware.conf
	   configuration file for the pmdavmware agent

       $PCP_PMDAS_DIR/vmware/Install
	   installation script for the pmdavmware agent

       $PCP_PMDAS_DIR/vmware/Remove
	   undo installation script for the pmdavmware agent

       $PCP_LOG_DIR/pmcd/vmware.log
	   default log file for error messages from pmdavmware

SEE ALSO

       pmcd(1).

3.8.10							       Performance Co-Pilot						     PMDAVMWARE(1)