greenplum_database_4.2_installation_guide

Greenplum®Database4.2InstallationGuideP/N:300-013-162Rev:A01TheDataComputingDivisionofEMCCopyright©2011EMCCorporation.Allrightsreserved.EMCbelievestheinformationinthispublicationisaccurateasofitspublicationdate.Theinformationissubjecttochangewithoutnotice.THEINFORMATIONINTHISPUBLICATIONISPROVIDED“ASIS.”EMCCORPORATIONMAKESNOREPRESENTATIONSORWARRANTIESOFANYKINDWITHRESPECTTOTHEINFORMATIONINTHISPUBLICATION,ANDSPECIFICALLYDISCLAIMSIMPLIEDWARRANTIESOFMERCHANTABILITYORFITNESSFORAPARTICULARPURPOSE.Use,copying,anddistributionofanyEMCsoftwaredescribedinthispublicationrequiresanapplicablesoftwarelicense.Forthemostup-to-datelistingofEMCproductnames,seeEMCCorporationTrademarksonEMC.comAllothertrademarksusedhereinarethepropertyoftheirrespectiveowners.TableofContentsiiiGreenplumDatabaseInstallationGuide4.2—ContentsGreenplumDatabaseInstallationGuide4.2-ContentsPreface...............................................................................................1AboutThisGuide..............................................................................1DocumentConventions....................................................................2TextConventions........................................................................2CommandSyntaxConventions...................................................3GettingSupport...............................................................................3Productinformation....................................................................3Technicalsupport.......................................................................4Chapter1:IntroductiontoGreenplum......................................5TheGreenplumMaster.....................................................................6MasterRedundancy....................................................................6TheSegments..................................................................................7SegmentRedundancy.................................................................7ExampleSegmentHostHardwareStack.....................................8ExampleSegmentDiskLayout..................................................10TheInterconnect.............................................................................10InterconnectRedundancy..........................................................10NetworkInterfaceConfiguration................................................11SwitchConfiguration..................................................................12ETLHostsforDataLoading.............................................................12GreenplumPerformanceMonitor.....................................................14Chapter2:EstimatingStorageCapacity..................................16CalculatingUsableDiskCapacity.....................................................16CalculatingUserDataSize..............................................................16CalculatingSpaceRequirementsforMetadataandLogs..................17Chapter3:ConfiguringYourSystemsandInstallingGreenplum........................................................................................18SystemRequirements.....................................................................18SettingtheGreenplumRecommendedOSParameters....................19LinuxSystemSettings...............................................................19SolarisSystemSettings.............................................................21MacOSXSystemSettings.........................................................22RunningtheGreenplumInstaller.....................................................22InstallingandConfiguringGreenplumonallHosts..........................24ConfirmingYourInstallation......................................................25InstallingOracleCompatibilityFunctions.........................................25InstallingGreenplumDatabaseExtensions......................................26CreatingtheDataStorageAreas.....................................................26SynchronizingSystemClocks..........................................................27NextSteps......................................................................................28Chapter4:ValidatingYourSystems.........................................29ValidatingOSSettings.....................................................................29ValidatingHardwarePerformance...................................................30ValidatingNetworkPerformance................................................30ValidatingDiskI/OandMemoryBandwidth.....................................31TableofContentsivGreenplumDatabaseInstallationGuide4.2—ContentsChapter5:ConfiguringLocalizationSettings.........................33AboutLocaleSupportinGreenplumDatabase.................................33LocaleBehavior.........................................................................34TroubleshootingLocales.............................................................35CharacterSetSupport..................................................