搜索
在VMware平台上运行数据库的优势与最佳实践1朱明, Architect, VMware Tony Wu, Engineer, VMware CONFIDENTIAL2v 选择VMware数据库平台的优势1. HA2. FT3. DRS／VMOTION4. VSAN5. Continuentv VMware数据库平台的备份⼿手段，数据恢复，与最佳实践经验分享选择VMware平台运⾏行数据库的优势与最佳实践我可选的数据库平台有：1. Unix平台：可靠性高，性能好2. Exadata：一体机3. WindowsCluster：WFSC集群4. VMware平台选择VMware，因为1. 可靠的HA2. DRS/Vmotion3. FT(容错）4. VSAN5. Continuent运行数据库的平台，用户期待：1. 提供绝对的可靠性2. 不改应用，提高性能AIXAIXDB PowerVM Hypervisor AP AIXDB PowerVM Hypervisor HA-CMPPwrHAHA-CMPPwrHAAP AIXSUSE Linux ESXHADB AP SUSELinuxESXHADB AP SUSE 1. 可靠的HAStep1.InstallthePowerHAsoftwareYoucanpurchasethissoftwarefromIBMdirectly(seeResourcesforalink);thefilesetsallstartwiththewordcluster.Usetheinstallpcommandtoinstallthesoftware,muchlikeanyotherlicensedprogrampackage(LPP).Step2.EditsomeflatfilesPutalloftheIPaddressesassociatedwiththecluster—boot,persistent,andservice—intoeach/etc/hostsfileoneachnodeofthecluster.Dothesamewiththe/usr/es/sbin/cluster/etc/rhostsfile.VerifythattheserverhostnamesmatchtheappropriateIPaddresses;theserver'shostnameshouldalsomatchwiththepersistentIPaddress.Step3.ConfigurethebootIPaddressesRunthesmittychinetcommand,andsetthebootIPaddressesforeachnetworkadapter.Makesurethatyouareabletopingandconnectfreelyfromnodetonodeonallrespectivenetworks.Also,double-checktomakesurethatthedefaultrouteisproperlyconfigured.Ifitisn't,runsmittytcpip,gointotheMinimumConfigurationmenu,enterthedefaultroutefortheprimaryadapter,andpressEnter.Step4.MakeapplicationstartandstopscriptsCreatetwosimpleKornshellscripts—onethatstartsanapplicationandonethatstopsanapplication.Keepthesescriptsinidenticaldirectoriesonbothnodes.Step5.DefinetheclusterRunthecommand:smittycm_config_an_hacmp_cluster_menu_dmnThen,definethecluster,includingnamingitappropriately.Step6.DefinethenodesRunthecommand:smittycm_config_hacmp_nodes_menu_dmnDefineeverynodewithintheclusteronbothnodes.Step7.DefinethenetworksRunthecommand:smittycm_config_hacmp_networks_menu_dmnThisdefinesonenetworkperEthernetadapter.IprefertousethePre-definedoptionasopposedtotheDiscoveredpath,butthatisuptoyourdiscretion.Checkthesubnetmasksforconsistency.Step8.DefinethebootIPaddressesRunthecommand:smittycm_config_hacmp_communication_interfaces_devices_menu_dmnThisdefinesthebootIPaddressesontherespectivenetworkadapters.ThisaddressshouldbethesameIPaddressesyouusedinstep3.MakesureyoudefinetheseaddresseswithintheproperrespectivePowerHA-definednetwork.Step9.DefinethepersistentIPaddressesRunthecommand:smittycm_config_hacmp_persistent_node_ip_label_addresses_menu_dmn。ThisdefinesthepersistentIPaddresses,againpayingattentiontopicktheproperrespectivePowerHA-definednetwork.Step10.DefinetheserviceIPaddressesRunthecommand:smittycm_config_hacmp_service_ip_labels_addresses_menu_dmnThisdefinestheserviceIPaddresses.Step11.PerformadiscoveryandrebootBythispoint,thenodesshouldhavetheabilitytocommunicatewitheachotherandkeeptheinformationstoredinthenodes'ObjectDataManagers(ODMs)insync.Makethenodeswithintheclustercommunicatewitheachotherbyrunningthecommand:smittycm_extended_config_menu_dmnSelecttheDiscoverPowerHA-relatedInformationfromConfiguredNodesoption,andcheckforerrorstofix.Generally,rebootingeachnodecanclearupanyminorproblems,andthisisagoodpointtotestrestartingeachserveranyway.Step12.DefinetheresourcegroupRunthecommand:smittycm_hacmp_extended_resource_group_config_menu_dmnDefinetheresourcegroup.Then,performthesesteps:Selectallparticipatingnodesinthecluster.SettheStartupPolicytoOnlineOnFirstAvailableNode.SettheFallbackPolicytoNeverFallback.Thissettingpreventstheresourcesfromgoingbacktotheoriginalserverwhenitisbroughtup,whichisawisethingtodo.Step13.CreateasharedvolumegroupNote:Runthiscommandonlyononenode.Runthesmittycl_vgcommand,andcreateasharedvolumegroup.Whenyoucreateasharedvolumegroup,youonlyneedtoselectoneofthenodes,becausethediskisshared.Step14.CreateaheartbeatdiskFirst,runthesmittycl_convgcommand,andthenselectCreateaConcurrentVolumeGroupwithDataPathDevices.Chooseonenodeandthetargetdisk.Next,runthecommand:smittycm_config_hacmp_communication_interfaces_devices_menu_dmnRepeatstep7,exceptthistime,selecttheDiscoveredoptionandthetargetdisk.Step15.DefineanapplicationserverRunthecommand:smittycm_cfg_app_extendedThisdefinesanapplicationserverforanapplicationthatPowerHAwillmanage.Usethescriptsyoucreatedinstep4.Step16.ConfiguretheresourcegroupNote:Runthiscommandononlyonenode.Runthecommand:smittycm_hacmp_extended_resource_group_config_menu_dmnSelecttheChange/ShowResourcesandAttributesforaResourceGroupoption.Then,performthesesteps:SelecttheappropriateserviceIPaddresses.Selecttheappropriatesharedvolumegroupsandheartbeatdisk.Selecttheappropriateapplicationservers.Step17.PerformasynchronizationSynchronizetheclusterconfiguration.Runthecommand:smittycm_ver_and_syncSetAutomaticallycorrecterrorsfoundduringverification?toInteractive.Correctanyproblemsalongtheway.Step18.StarttheclusterAtthispoint,theclusterisreadytostart.Ononeofthenodes,runthesmittyclstartcommand,andpickthatparticularnode.Mypreferenceisnottohavetheclusterstar