POWERSOLUTIONSNovember200392BuildingaHighlyScalableandAvailableDataEnvironmentforOracle9iRACToprovideahighlyscalableandavailabledatabaseenvironmentforOracle9iRealApplicationClusters(RAC),administratorsmustestablishahighlyavailablestorageinfrastructure.
Astorageareanetwork(SAN)canprovideredundantpathstostorage,andrunningEMCPowerPathcanleveragethisredundancybyprovidingamechanismforpathfailoverinanOracle9iRACinfrastructure.
Intoday'sbusinessenvironment,highavailabilityisrequiredformission-criticalapplications.
TheOracle9irelationaldatabasemanagementsystem(RDBMS)ishighlyavailableandscalable.
TheOracle9iRealApplicationClusters(RAC)optionenablestheOracle9iRDBMStobeconfiguredinaclusterdatabasearchitecturewheremul-tiplenodessharethesamestorage.
Oracle9iRACprovideshighavailability;ifonenodefails,theotherstakeoverandprovideuninterruptedaccesstothedatabase.
However,ifonlyoneI/Opathexistsfromeachnodetothesharedstor-ageinsuchanenvironment,thisI/Opathpotentiallybecomesasinglepointoffailure.
AtypicalOracle9iconfigurationincludesastorageareanetwork(SAN),whichcanhelpprovideahighlyavailabledatainfrastructurebyusingredundantcompo-nentstoensurethatnocomponentbecomesasinglepointoffailure.
AFibreChannel–basedSANfabricsupportsmultipathroutingbetweenSANswitches.
Inatypicaltopology,anodehasmultipleFibreChannelhostbusadapters(HBAs),eachofwhichareconnectedtothesameSAN,resultinginmultiplepathstothesamedevice(seeFigure1).
SANstoragedevicescanalsoacceptmultipleFibreChannelconnections.
RedundantpathsinaSANprovidefailovercapabilitywhenanycomponentinthedatapathfails.
Multiplepathsalsoenhanceefficiency,allowingadministratorstoloadbalanceSANtrafficbyconsideringI/Oacrossallavailablepaths.
Indoingso,theSANtakesadvantageoftheaddi-tionalbandwidthprovidedbyeachphysicalconnection.
AlthoughredundantI/Opathsarebeneficialforloadbalancingandlinkfailover,theycancreatecomplications.
BecauseeachdeviceonaSANappearsasaSCSIIDoneachHBAthatisconnectedtotheSAN,asystemwithmultipleHBAsconnectedtotheSANwillbehaveasifeachdeviceoneachpathisaseparateSCSIdevice.
Thus,theoperatingsystembehavesasthoughmultipleENTERPRISECLUSTERENVIRONMENTBYZAFARMAHMOOD,PAULRAD,ANDROBERTNADONstorageresourcesexistwheninfactthereareonlymultiplepathstothesameresource.
Pointingtothesamestoragedevicealongdifferentpathscouldpotentiallycausedatacorruptionandsystemcrashes.
Topreventsuchproblems,administratorscaninstallpathmanagementsoftware,suchasEMCPowerPath,oneachnodeintheSAN.
PowerPathenablesmultipleI/Opathstothesharedstoragebymaskingthepaths,andpresentstheoperatingsystemwiththeappearanceofasingleSCSIconnection.
ThismaskingensuresthatthenodereceivesasingleviewofthestoragedevicesacrossmultipleHBAs.
PowerPathalsoautomaticallydetectsavailablepaths,restoresfailedpaths,andloadbalancesI/Oacrossallpaths.
WhenintegratedinanOracle9iRACenvironment,PowerPathprovideshighlyavailable,scalable,andfault-tolerantsharedstorage.
UsingPowerPathforpathfailuredetectionEMCPowerPathhelpsprovidehighavailabilitybyautomaticallydetectingandrestoringfailedpathswhilestoragearrays,nodes,andapplicationsremainavailable.
ShouldanHBA,astorageproces-sor,oracablefail,PowerPathcompletesanI/Orequestthroughanotheravailablechannel,helpingpreventtheinterruptionofdatatoanapplication.
PowerPathalsoprovidesautomaticonlinepathrecoveryafterthepathisrepaired,whichcanreduceplannedout-agestorestoreservices.
PowerPathvirtualdevicesmappathstostoragePowerPathresidesonanodeasasoftwarecomponentbetweenOracle9iRAC,theOracleclusterfilesystem(OCFS),andtheHBAdevicedriverlayer(seeFigure2).
PowerPathoperatesindependentlyofapplications,theRDBMS,managementutilities,andfilesystems,allowingadministratorstoinstallandconfigurePowerPathwithoutmodifyingexistingsoftware.
ThePowerPathdriverresidesonthenode,abovetheHBAdriver.
ThenodehasmultipleHBAssothatitcanprovidepathfailoverthroughthePowerPathdriver.
ThePowerPathdriverenablesvirtualdevices,whichprovidefailure-resistantandload-balancedpathstotheDell|EMCstoragearray.
AnapplicationreferencesaPowerPathvirtualdevice;inturn,thePowerPathdrivermanagespathallocationtothestoragearray.
Inthefollowingexample,fourlogicalunitnumbers(LUNs)areconfiguredonaDell|EMCstoragearray,whichusestwostorageprocessorstoconnect—throughtwoseparateFibreChannelswitches—toanodecontainingtwoHBAs.
TheresultingpathsandtheirmappingstothePowerPathvirtualdevicesprovideatotalof16pathsfromanodetostorage.
Having16pathstostoragewouldordinarilyresultin16logicaldevicesbeingvisibletothenode.
However,thePowerPathdrivercreatesfourPowerPathvirtualdevices,andeachofthesevirtualdevicesmapsfourpathstoalogicaldeviceonthestoragearray,asindicatedinFigure3.
PowermtmanagementutilityfacilitatespathmanagementForautomaticfailuredetectionandrecovery,PowerPathprovidesanadministrationutilitycalledPowermt,whichprovidesacommandENTERPRISECLUSTERENVIRONMENTwww.
dell.
com/powersolutionsPOWERSOLUTIONS93HBAHBAHBAHBAHBAHBAHBAHBAFibreChannelswitchFibreChannelswitchLogicallayerPhysicallayerStorageprocessor1Storageprocessor2ServerServerServerServerDiskDiskDiskDiskDiskDiskDiskDiskDiskDiskLUNLUNLUNFigure1.
AhighlyavailablestorageinfrastructurePowerPathOracleclusterfilesystemOracle9iRACDatabasemanagementutilitiesHBAdriverHBAcontrollerHBAdriverHBAcontrollerFigure2.
PowerPathinOracle9iRACsoftwarelayerPowerPathvirtualdevices(4)Paths(16)/dev/emcpowera/dev/sdb/dev/sdf/dev/sdj/dev/sdn/dev/emcpowerb/dev/sdc/dev/sdg/dev/sdk/dev/sdo/dev/emcpowerc/dev/sdd/dev/sdh/dev/sdl/dev/sdp/dev/emcpowerd/dev/sde/dev/sdi/dev/sdm/dev/sdqFigure3.
PathstologicaldevicesforPowerPathvirtualdeviceslineinterfacetothePowerPathenvironment.
PowerPathperiodi-callyteststhepathsforfailuredetectionaccordingtoabuilt-inalgorithm.
UsingthePowermtutility,administratorscansetupahostnodetoperformautorecoveryonfailedpathsbyusingthefollowingcommand-lineinstructiontothePowerPathdriver:powermtsetperiodic_autorestore=on|offForconvenientmanagementofaUNIXorLinuxnodeconfiguredwithPowerPath,thePowermtutilityprovidesseveralfeatures,including:CheckingaPowerPathconfiguration:Thepowermtcheckcommandchecksthespecifiedpathsand,ifdesired,removesfromthePowerPathconfigurationanypathsmarkeddead.
Configuringpathstologicaldevices:ThepowermtconfigcommandconfiguresalldetectedlogicaldevicesasPowerPathdevicesandaddsthesedevicestothePowerPathconfigura-tion,creatingdevicesasrequired.
RemovingpathsfromPowerPathmanagement:Thepowermtremovecommanddeletesthespecifiedpath(orpaths)fromPowerPath'slistofconfiguredpaths.
Itdoesnotdeletethelogicaldevicetowhichthepathsrefer.
IntegratingPowerPathinanOracle9iRACenvironmentToperformI/O,Oracle9iRACusesPowerPathvirtualdevices(suchas/dev/emcpoweraand/dev/emcpowerb,showninFigure3)insteadofLUNs,orlogicaldevices(suchas/dev/sdband/dev/sdc).
Ifanactualdevicepathfails,thePowerPathdriverroutesI/OtoanalternativepathwithoutcausinganyinterruptiontotheRDBMSfunctionality.
IntegrationofPowerPathwithOracle9iRACisasimpleprocess.
PowerPathmaybedeployedineitheraneworexistingOracle9iRACimplementation,asexplainedinthefollowingsections.
IntegratingPowerPathwithanewOracle9iRACimplementationOracle9iRACusessharedstorageontheSANforitsdatabase,redolog,andcontrolfiles.
TheRDBMSenginefromeachnodeintheclustermusthavedirectaccesstothisstoragetocreateorupdateanyofthesefiles.
WithoutPowerPath,theRDBMSenginewoulddirectlyaccesstheLUNsonthesharedstoragetocreatetherequiredfiles.
WithPowerPathintegrated,theprocedureisthesame,withoneimportantexception.
ThepartitionsandOCFSarecreatedonthePowerPathvirtualdevicesratherthanonthepartitionedLUNs:1.
PartitionthePowerPathvirtualdevicesonthesharedstoragearrayaccordingtothedatabasesizingrequirements:fdisk/dev/emcpowerafdisk/dev/emcpowerbfdisk/dev/emcpowercfdisk/dev/emcpowerd2.
CreatetheOCFSonthenewpartitionsandmountthefilesystem:mkfs.
ocfs-F-b128-Lu01-m/u01-u200-g300-p0775/dev/emcpowera1mkfs.
ocfs-F-b128-Lu02-m/u02-u200-g300-p0775/dev/emcpowerb1mkfs.
ocfs-F-b128-Lu03-m/u03-u200-g300-p0775/dev/emcpowerc1mkfs.
ocfs-F-b128-Lu04-m/u04-u200-g300-p0775dev/emcpowerd13.
SetuptheclusterwareontheOCFS,andcreatetheOracle9iRACdatabaseonthesharedSANstorage.
TheintegrationofPowerPathistransparenttotheOracle9iRACdatabaseengine,asisthefactthateachPowerPathvirtualdevicepointstomultiplephysicalI/Opaths.
IntegratingPowerPathwithanexistingOracle9iRACimplementationInanexistingOracle9iRACdatabasethatissetupwithoutPowerPath,thedatabaseengineusestheLUNsonthesharedSANstoragetocreateandupdatethedatabasefiles.
IntegratingPowerPathisastraight-forwardprocessusingthefollowingsteps:1.
ShutdownallOracleservicesinthecluster,includingdatabaselisteners,OracleIntelligentAgents,andOracleClusterManager.
2.
Shutdownthedatabaseonallclusternodes.
3.
UsetheumountcommandtounmountallOCFSvolumes.
4.
ConfiguretheDell|EMCstoragearraytosupportPowerPath,andinstallthePowerPathsoftwareonallclusternodes.
Oneachnode,thePowerPathsoftwarewillautomaticallycreatePowerPathdevicesthatpointtotheexistingLUNs.
5.
Modifythe/etc/fstabconfigurationfileandreplacethedevicenamesofeachLUN(forexample,/dev/sdb,/dev/sdf,dev/sdj,/dev/sdn)onthestoragearraywiththePowerPathvirtualdevicename(forexample,/dev/emcpowera,/dev/emcpowerb,/dev/emcpowerc,/dev/emcpowerd).
www.
dell.
com/powersolutionsSANsprovidecentralizeddatastorage,andEMCPowerPathcomplementsSANarchitecturebyhelp-ingmanageredundantSANpathstoprovideahigh-availabilityenviron-mentforOracle9iRAC.
ENTERPRISECLUSTERENVIRONMENTPOWERSOLUTIONSNovember2003966.
RestarttheOCFSandusethemountcommandtomountthefilesystem.
7.
StartupOracleservices,clusterware,andOracle9iRACdatabaseinstancesonallclusternodes.
UsingPowerPathtomaintainavailabilityAsreliableaccesstoinformationbecomesacriticalmissionfortoday'sdatacenters,ITarchitectsandadministratorsmustusecentralized,scalablestoragetohelpcreateahighlyavailabledatainfrastructureacrosstheenterprise.
SANsprovidecentralizeddatastorage,andEMCPowerPathcomplementsSANarchitecturebyhelpingmanageredundantSANpathstoprovideahigh-availabilityenvironmentforOracle9iRAC.
FactorssuchasI/Oload,effectofdowntime,andavailabilityofadministratormaintenancetimecanhelpdeterminewhetheranorganization'snetworkedDell|EMCstoragewouldbenefitfromPowerPath.
PowerPathoffersfaulttolerancetohelpeliminatedown-time,loadbalancingtoenablemoreefficientI/Otraffic,andauto-maticdetectionandrepairofpathsthathavefailed,therebyhelpingtoreduceadministrativeoverhead.
ByintegratingPowerPathwithOracle9iRAC,administratorscanimproveSANuptimeandprovideastableinfrastructureformission-criticaldata.
ZafarMahmood(zafar_mahmood@dell.
com)isasoftwareengineerintheDellDatabaseandApplicationEngineeringDeploymentDepartmentoftheDellProductGroup.
Hehasbeeninvolvedindatabaseperformanceoptimization,databasesystems,anddatabaseclusteringformorethansixyears.
HeiscurrentlyworkingonOracle9iRACimplementationsatDell.
ZafarhasanM.
S.
inElectricalEngineeringwithaspecializationinComputerCommunica-tionsfromtheCityUniversityofNewYork.
PaulRad(paul_rad@dell.
com)isaseniorsoftwareengineerintheDellDatabaseandApplicationEngineeringDepartmentoftheDellProductGroup.
Paulhasmaster'sdegreesinbothComputerScienceandComputerEngineeringfromtheUniversityofTexasatSanAntonio.
RobertNadon(robert_nadon@dell.
com)isasoftwareengineeringconsultantintheFactoryInstallationDevelopmentGroupoftheDellProductGroup.
HefocusesonfactoryinstallationforUNIX-based(LinuxandBSDi)operatingsystemsandfortheOracle9idatabase.
AnotherareaofinterestisDellsoftwareRAIDofferings.
RoberthasaB.
S.
inComputerEngineeringfromTexasA&MUniversity.
HeisaRedHatCertifiedEngineer(RHCE)forRedHatLinux6.
2and7.
0.
FORMOREINFORMATIONDell|EMCstorage:http://www.
dell.
com/emcDellandOracle:http://www.
dell.
com/oracleOracledatabase:http://www.
oracle.
com/oracle9i
这两天在站长群里看到不少有使用DEDECMS织梦程序的朋友比较着急,因为前两天有看到来自DEDECMS,我们熟悉的织梦程序官方发布的公告,将会在10月25日开始全面商业用途的使用DEDECMS内容管理程序的会采用授权收费模式,如果我们有在个人或者企业商业用途的,需要联系且得到授权才可以使用,否则后面会通过维权的方式。对于这个事情,我们可能有些站长经历过,比如字体、图片的版权。以及有一些国内的CMS...
CheapWindowsVPS是一家成立于2007年的老牌国外主机商,顾名思义,一个提供便宜的Windows系统VPS主机(同样也支持安装Linux系列的哈)的商家,可选数据中心包括美国洛杉矶、达拉斯、芝加哥、纽约、英国伦敦、法国、新加坡等等,目前商家针对VPS主机推出5折优惠码,优惠后最低4GB内存套餐月付仅4.5美元。下面列出几款VPS主机配置信息。CPU:2cores内存:4GB硬盘:60G...
在刚才更新Vultr 新年福利文章的时候突然想到前几天有网友问到自己有在Vultr 注册账户的时候无法用支付宝付款的问题,当时有帮助他给予解决,这里正好顺带一并介绍整理出来。毕竟对于来说,虽然使用的服务器不多,但是至少是见过世面的,大大小小商家的一些特性特征还是比较清楚的。在这篇文章中,和大家分享如果我们有在Vultr新注册账户或者充值购买云服务器的时候,不支持支付宝付款的原因。毕竟我们是知道的,...
clusterware为你推荐
空间邮箱什么邮箱存储空间最大??安徽汽车网在安徽那个市的二手车最好?www.kkk.com谁有免费的电影网站,越多越好?www.yahoo.com.hk香港的常用网站网站检测请问论文检测网站好的有那些?125xx.comwww.free.com 是官方网站吗?www.niuav.com在那能找到免费高清电影网站呢 ?www.5any.com重庆哪里有不是全日制的大学?www.bbb551.comHUNTA551第一个第二个妹子是谁呀??partnersonline电脑内一切浏览器无法打开
windows虚机 vps优惠码 息壤备案 uk2 美国主机论坛 debian源 促正网秒杀 四核服务器 台湾google 注册阿里云邮箱 徐州电信 黑科云 广州服务器托管 中国电信宽带测速 nnt 认证机构 美国达拉斯 卡巴斯基免费版 压力测试工具 paypal兑换 更多