oracle real application clusters (rac) 12c rel. 2 - what's next?
TRANSCRIPT
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleRealApplicationClusters(RAC)12cRelease2–What’sNext?
MarkusMichalewiczSeniorDirectorofProductManagement,OracleRACDevelopmentDecember4,2017
[email protected]@OracleRACpmhttp://www.linkedin.com/in/markusmichalewiczhttp://www.slideshare.net/MarkusMichalewicz
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
ProgramAgenda
OracleRAC–TheStatusQuo
What’sNextforOracleRAC?
1
2
3
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
ProgramAgenda
OracleRAC– TheStatusQuo
What’sNextforOracleRAC?
1
2
4
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDatabase10gRAC(*2004)
Oracle9iRel.1Oracle9iRel.2RAC(*2001)
OracleDatabase11gRel.1withRAC
(*2007)
OracleDatabase11gRel.2withRAC
(*2009)
OracleDatabase12cRel.1withRAC
(*2013)
Memory Memory
SALES SALESRow
FormatColumnFormat
OracleDatabase12cRel.2withRAC
(*2016)
OracleRACEvolution
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleDatabase10gRAC(*2004)
Oracle9iRel.1Oracle9iRel.2RAC(*2001)
OracleDatabase11gRel.1withRAC
(*2007)
OracleDatabase11gRel.2withRAC
(*2009)
OracleDatabase12cRel.1withRAC
(*2013)
Memory Memory
SALES SALESRow
FormatColumnFormat
OracleDatabase12cRel.2withRAC
(*2016)
OracleRACEvolution
Internet Grid/PrivateCloud Cloud
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Scalability
7
HighAvailability EfficientManagement
OracleRACBenefits
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OnPremises/PrivateDatabaseCloud
8
BareMetal/Virtualized
OracleCloudcombinesalldeployments
OracleRACDeployments
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Self-Driving -Userdefinesservicelevels,databasemakesthemhappen
Self-Tuning -Continuousadaptiveperformancetuning
Self-Scaling -Instantlyresizecomputeandstoragewithoutdowntime
Self-Securing -Protectionfrombothexternalattacksandinternalusers
Self-Repairing -Automatedprotectionfromalldowntime
LessLabor,LowerCost,FewerErrors,MoreSecure,MoreReliable
RACisNowPartofTheWorld’sFirstAutonomousDatabase
9
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 10
OracleRestartNotacluster,
butbackforgood!
SeeupdatesinMOSNote1584742.1
StandaloneClusterDedicatedclusterforOLTP,DWHormixed-WLsystems.
ClusterDomainDomainServicesCluster(DSC)&MemberClustersforlargeclusterestatesandstorageconsolidation.
ExtendedClusterStandaloneClusterorDSC
maintainingtwoindependentstoragearrays(overdistance).
ArchitectureChoicesOn-Premises
SiteA SiteB
DomainServicesCluster
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 11
OracleRestartNotacluster,
butbackforgood!
SeeupdatesinMOSNote1584742.1
StandaloneClusterDedicatedclusterforOLTP,DWHormixed-WLsystems.
ClusterDomainDomainServicesCluster(DSC)&MemberClustersforlargeclusterestatesandstorageconsolidation.
ExtendedClusterStandaloneClusterorDSC
maintainingtwoindependentstoragearrays(overdistance).
ArchitectureChoicesOn-Premises
SiteA SiteB
DomainServicesCluster
DOAGConference2016:https://www.slideshare.net/MarkusMichalewicz/oracle-
extended-clusters-for-oracle-rac
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 12
OracleRestartNotacluster,
butbackforgood!
SeeupdatesinMOSNote1584742.1
StandaloneClusterDedicatedclusterforOLTP,DWHormixed-WLsystems.
ClusterDomainDomainServicesCluster(DSC)&MemberClustersforlargeclusterestatesandstorageconsolidation.
ExtendedClusterStandaloneClusterorDSC
maintainingtwoindependentstoragearrays(overdistance).
ArchitectureChoicesintheOracleCloud(Currently)
SiteA SiteB
DomainServicesCluster
Standardizedonè
Planning Unplanned
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 13
SharedStorage Network/Interconnect
Virtualization/Container Cloud
OracleRACRequirementsandConsiderations
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 14
SharedStorage Network/Interconnect
Virtualization/Container Cloud
OracleRACRequirementsandConsiderations
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
SharedStorageRequirement
• SharedstorageisthetoprequirementforOracleRAC.• BlockstoragethatissupportedassharedstorageforRACbythestoragevendorandtheservervendorissupportedforRAC.https://www.slideshare.net/MarkusMichalewicz/how-to-use-oracle-rac-in-a-cloud-a-support-question
• Exceptionsprovetherule.– SharedFileSystemrequirecertification.– Storagesolutionsmaybesubjectto“specialruling”.
• Currently,No3rdPartyPublicCloudsupportssharedstorageforOracleRACnatively.• OracleASMandACFSarebyfarthepreferredstoragemanagementsolutionsforOracleRAC.
15
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Network/InterconnectRequirement
• TheinterconnectiscrucialtotheoperationofOracleRAC.– ThinkofitasaRDMAaccesspathratherthananetwork.– 1GigEandredundancyshouldbethebareminimum.– 10GigEandredundancyarestronglyrecommended.
• Convergednetworksandswitchesaresupported.Routingisnot.– I.E.combiningpublic/privatenetworkcommunication.• Infuture,communicationoninterconnectisplannedtobesecuredbydefault.
– VLANsarealogicalseparation,notaphysicalone.• E.g.theydonotprotectfrominterferenceonthesamephysicalnetwork.
– Whennetworkandstoragecommunicationarecombined,storagecommunicationshouldgetprioritized.
16
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 17
SharedStorage Network/Interconnect
Virtualization/Container Cloud
OracleRACRequirementsandConsiderations
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Virtualization/ContainerConsiderations
• Choosingavirtualizationsolutionoracontainer-basedinfrastructureisadatabase-independentdecision.• WhetheranOracleRACdatabasecanbeoperatedinaparticularvirtualizationsolution/containeristhequestion.• Manyofthemcanbesupported.Moreinformation:
https://www.slideshare.net/MarkusMichalewicz/how-to-use-oracle-rac-in-a-cloud-a-support-question
– OpenStack,Docker(soon&fortestpurposes),etc.– OracleVMisacertifiedvirtualizationsolutionforOracleRAC.
• WiththeexceptionofOracleRACinOracleVM,thereiscurrentlynobestpracticesrecommendationforanyvirtualizationorcontainer-basedsolutionfromOracle.– Forcontainers,Oracledocumentationisprovided.
18
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
CloudConsiderations
• ChoosingaThirdPartyPublicCloudforOracleRACismainlyalicensingquestionatthispointintime.Discussedhere:https://www.slideshare.net/MarkusMichalewicz/how-to-use-oracle-rac-in-a-cloud-a-support-question
– Forlicense-restricted3rdPartyPublicCloudsnosupportstatementsareissued.
• ForanInfrastructureCloud(IaaS)thesamerulesasforvirtualizationsolutions/containersapplyinprinciple.– MostIaaS/3rdPartyPublicCloudsaresubjectto“specialruling”(seeabove).
• ThreeOracleRACofferingsintheOracleCloud:
1. IntheOracleCloudInfrastructureComputeClassicService2. IntheOracleCloudInfrastructureDatabaseService3. AspartoftheEngineeredSystemCloudServices
19
PaaS
Infrastructure
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• VirtualMachines• Test,Development,DepartmentalApplications
• OracleAppsUnlimited,PaaS• ComputeShapes–byOCPU,StandardorHighRAM,2nodes
• BlockStorage–bytheGB• Upto7.8TBdatabase
• BareMetal• IntensiveTest,Development,DepartmentalApplications
• CustomApplications• BareMetalComputeShape–2-nodeRACDBSystem
• SSDdrivesasstorage• Upto8.6TBdatabase
20
• MissionCritical,IntensiveOLTPandDecisionSupport
• OracleandCustomApps• ¼,½andFullRackShapes• 2/4/8-nodeExadataDBSystem• FixedStorage&RAMbyShape• Upto168TBdatabase
OracleRACintheOracleCloudInfrastructure(OCI)OCI-ComputeClassic OCI–DatabaseService EngineeredSystems
RetiredeffectiveDec1,2017
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
ProgramAgenda
OracleRAC–TheStatusQuo
What’sNextforOracleRAC?
1
2
21
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
SafeHarborStatementThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.
22
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OnPremises/PrivateDatabaseCloud
23
BareMetal/Virtualized
OracleCloudcombinesalldeployments
OracleRACWillContinuetoSupportTheseDeployments
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
On-Premises/PrivateDatabaseCloud
24
OracleCloud
OptimizationsWillFocusOntheCloud
Ascloudoptimizationsbenefitothers
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Scalability
25
HighAvailability EfficientManagement
OracleRACWillContinuetoProvideTheseBenefits
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 26
ThereisneveraperfectsizeScalabilityIsImportant(Again)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Self-Driving -Userdefinesservicelevels,databasemakesthemhappen
Self-Tuning -Continuousadaptiveperformancetuning
Self-Scaling -Instantlyresizecomputeandstoragewithoutdowntime
Self-Securing -Protectionfrombothexternalattacksandinternalusers
Self-Repairing -Automatedprotectionfromalldowntime
https://www.linkedin.com/pulse/unboxing-cloud-oracle-markus-michalewicz/
RACIsPartofTheWorld’sFirstAutonomousDatabase
27
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 28
https://www.linkedin.com/pulse/you-know-ibms-watson-salesforces-einstein-now-meet-michalewicz/ContinueAppliedMachineLearningEfforts
SubjectMatterExpert
ASH
MLKnowledgeExtraction
ModelGeneration
HumanSupervision
ApplicationOptimizedModels
Feedback
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Better(Fleet)ManagementNoDowntimeScaling,PatchingandUpgradewithRapidHomeProvisioning(RHP)+
• ZeroImpactPatching• ZeroDowntimeUpgrade(ZDU)
RHPServer
11.2.0.4.2
11.2.0.4.1
12.1.0.2
11.2.0.4.1
11.2.0.4.2
12.2.0.1 12.1.0.2
12.2.0.1
11.2.0.4.2
11.2.0.4.1
12.1.0.2
RemoteRHPServer
• GlaaS(GoldImageasaService)
https://www.slideshare.net/MarkusMichalewicz/new-in-oracle-universal-installer-oui
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 30
Storage Network/Interconnect
Virtualization/Container Cloud
AreasofAdvancementstobeExpected
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 31
Storage Network/Interconnect
Virtualization/Container Cloud
AreasofAdvancementstobeExpected
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleRACAlwaysChoosesthe“RightPath”
32
• RACdeterminestheoptimalpathtoserveblocks–networkordisk
• SSDsandNVMestoragetechnologycontinuetodrivedownlatency• e.g.flashstoragemayprovidebetter
accesstimestodatathantheprivatenetworkunderhighload
• RACtakesthosestatisticsintoaccount
Query
BlockBlock
Networkcongestion
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleRAC11.2 OracleRAC12.1/12.2 FurtherdowntheRoad
LocalStorageaccess MultiClusterSharedStorage VirtualSharedStoragePool
CrossClustersharingtoocumbersome SingleDomainServiceCluster SingleCommonNameSpace
RemoteASMRemoteACFS
Crossapp/dbshareddata
33
DataMobility
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• NUSAvirtualizesphysicalstoragefrommanyintegratedserversintoasinglecommonNameSpace.
• Alldatabasesandapplicationsintheintegratedmulti-clustershareaccesstoaVirtualSharedStoragepool.
• Availablepost12.2.
34
Non-UniformStorageArchitecture(NUSA)Model
O/S
RACStorageServices
DBInstance
APPS DBInstance
APPS
O/S
RACStorageServices
DBInstance
APPSDBInstance
APPS
Cluster
O/S
RACStorageServices
DBInstance
APPS DBInstance
APPS
O/S
RACStorageServices
DBInstance
APPSDBInstance
APPS
Cluster
Virtual Shared Storage
O/S
RACStorageServices
DBInstance
APPS DBInstance
APPS
O/S
RACStorageServices
DBInstance
APPSDBInstance
APPS
Cluster
ASM SVC
ACFS SVC
ASM SVC
ACFS SVC
O/S
RACStorageServices
DBInstance
APPS DBInstance
APPS
O/S
RACStorageServices
DBInstance
APPSDBInstance
APPS
Cluster
ASM SVC
ACFS SVC
ASM SVC
ACFS SVC
Storage
ASM SVC
ACFS SVC
ASM SVC
ACFS SVC
Storage
ASM SVC
ACFS SVC
ASM SVC
ACFS SVC
Storage Storage
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 35
Storage Network/Interconnect
Virtualization/Container Cloud
AreasofAdvancementstobeExpected
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Network/InterconnectAdaptations
• TheinterconnectiscrucialtotheoperationofOracleRAC.– ThinkofitasaRDMAaccesspathratherthananetwork.– 10GigEandredundancywillbethenewstandard.– RDSoverIBwillbeEngineeredSystemspecific.– RDMAoverConvergedEthernet(RoCE)isupcoming.
• Convergednetworksandswitchesaresupported.– Communicationoninterconnectisplannedtobesecuredbydefault.– Protectionfrominterferenceonthesamephysicalnetworkremainsopen.– Lookingintosupportingroutingandflatnetworksifpossible.
36
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
On-Premises/PrivateDatabaseCloud
37
OracleCloud
Conclusion–OracleRACisPreparedfortheFuture
✔