Nutanix 超融合最佳实践指南之-Oracle数据库

1、Nutanix 超融合最佳实践指南之- Oracle数据库关键应用系统的HA设计NX-8235 G4NX-3360 G4AHVAHVAHVAHVAHVVMRAC1VMRAC2VMOracleVMOracleVMOracleTier-1 Oracle databaseTier-2/3 Oracle databaseOracle标准版RTO 3-10 minutes Oracle 企业版 RACRTO 1minutes Oracle RAC 1 & RAC2 using AHV DRS Affinity lock in NX-8235-G4AHV HATier-2/3 Oracle using A

2、HV DRS Affinity lock in NX-3360-G4Oracle License Model Named User PlusStandard Edition One requires a minimum of 5 Named User or the total number of actual users, whichever is greaterStandard Edition requires a minimum of 5 Named User or the total number of actual users, whichever is greaterThe Ente

3、rprise Edition requires a minimum of 25 Named User Plus per Processor licenses or the total number of actual users, whichever is greaterProcessor We will introduction in following slide Oracle licenses with Hard and Soft partitioning of physical systemsHard = “fixed” allows sub-system licensing (Ora

4、cle)Soft = “fluid” requires full-system licensing (Virtualization)Oracle counts VMware as a soft partition technology Must license “entire server”Core Factor Table http:/us/corporate/contracts/processor-core-factor-table-070634.pdfOracle Database Licensing CPU-Based SKU ConsiderationsStandard Editio

5、n One-Licensed by socket-Limited to two sockets-Must license full machineStandard Edition-Licensed by socket-Limited to four sockets-Must license full machine(s)Enterprise Edition-Licensed by core-Apply x86 factor of 0.5 to cores-Must license full machineEx: 3360-G4 , E5-2630v3 (16core)5.8 K x2 sock

6、et x3 hosts = 34.8 K17.5 K x2 socket x3 hosts = 105 K47.5 K x16 core x3 hosts x0.5 core factor = 1140 KOracle have “Number of User license “ we do not introduce here, one core license about 25 name users http:/us/corporate/pricing/technology-price-list-070617.pdf (Oracle Price Book)https:/cd/B28359_

7、01/license.111/b28287/editions.htm#DBLIC116 (edition compare)Oracle License on VirtualizationVM(Oracle)VM(Oracle)VM(Oracle)vMotion vMotion Oracle treat virtualization as soft partition , we need entitle all the license of physical boxVM can vMotion between our Nutanix Cluster , so we need entitle al

8、l the cluster Using DRS affinity to limit VM vMotion hosts, that can save for Oracle license When entitle all box or cluster , you can run as much VM (Oracle) as you can Oracle License ExampleIf you have 8 nodes Nutanix cluster, 6 nodes we run VDI solution and we just have two nodes that running Ora

9、cle database guest VM. We just need pay for two nodes license fee. In this two nodes , you can run unlimited Oracle database guest VM VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)Oracle used nodesVDI nodesNutanix ClusterOracle License DesignNX-8235G4 or NX-3260G4 NX-6235COne cluster c

10、ompose by four nodes Two are Compute Nodes, the other two are Storage NodesSo we just pay for the two Compute Nodes licenses , because Oracle Guest VM never running on Storage Nodes.VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)VM(Oracle)Oracle RAC(xx物理机)数据在xx现有的2台物

11、理服务器上（IBM 3850，4*10 core CPU,128G内存，3PAR共享存储）运行了RAC的性能测试，通过Swingbench模拟550用户并发在线的情况下，得出的TPS每秒交易数为6667，应用响应时间为8ms。第二次换硬件环境测得约TPS每秒交易数约为7200。9Oracle RAC-Nutanix虚拟机数据通过Swingbench加压550用户时，8块SSD，TPS每秒的交易量可以达到6531（与物理服务器相差每秒130笔交易），应用的平均响应时间在12毫秒（与物理机相差4毫秒）以内，与物理服务器的RAC性能数据微有差别。注：虚拟化层的资源损耗以及虚拟机的配置与物理服务器并不

12、一致（物理服务器为4颗CPU，内存为128G，而Nutanix提供的为双CPU服务器，RAC虚拟机配置为64G内存）。10虚拟机配置Oracle RAC虚拟机硬件配置（2节点）：每虚拟机配置为20 vCPU,64G内存，每虚拟机创建7块磁盘，用于分别存放OS（1块）/DATA（4块）/REDO（1块）/TMP文件（1块）。Oracle单机版虚拟机硬件配置（20个）：每虚拟机配置为4 vCPU,16G内存，每虚拟机创建10块磁盘，用于分别存放OS（1块）/DATA（4块）/REDO（3块）/TMP文件（1块）。11物理机/虚拟机性能对比12物理机环境Nutanix虚拟化环境Nutanix运行RA

13、C压力测试时的CPU/内存影响在运行RAC 虚拟化的情况下（单机版Oracle虚拟机均已经关机），主机的性能情况下图，CPU约为25%，两个运行RAC虚拟机的节点的内存负载为44.7%。13Nutanix Oracle单机测试20个Oracle单机数据库虚拟机上各自独立运行Swingbench软件，模拟100用户不间歇的进行并发测试时的性能情况。在虚拟机运行数据库及Swingbench时，虚拟机的CPU占用率为75-85%，读IOPS为1000左右，写IOPS在600左右，控制器带宽为25M左右。第二次使用了24块SSD，平均TPS可以达到约24000。14批量克隆Oracle虚拟机1520个虚拟机并发测试时的性能情况16从Nuta