ããªãã®æ°ã®ãšã³ã¿ãŒãã©ã€ãº ã¢ããªã±ãŒã·ã§ã³ãšä»®æ³åã·ã¹ãã ã«ã¯ããã©ãŒã«ã ãã¬ã©ã³ã ãœãªã¥ãŒã·ã§ã³ãæ§ç¯ããããã®ç¬èªã®ã¡ã«ããºã ããããŸãã å ·äœçã«ã¯ãOracle RAC (Oracle Real Application Cluster) ã¯ãè² è·ãåæ£ãããµãŒããŒ/ã¢ããªã±ãŒã·ã§ã³ ã¬ãã«ã§ãã©ãŒã«ã ãã¬ã©ã³ã¹ãæäŸããããã«é£æºãã XNUMX ã€ä»¥äžã® Oracle ããŒã¿ããŒã¹ ãµãŒããŒã®ã¯ã©ã¹ã¿ãŒã§ãã ãã®ã¢ãŒãã§äœæ¥ããã«ã¯ãå ±æã¹ãã¬ãŒãž (éåžžã¯ã¹ãã¬ãŒãž ã·ã¹ãã ) ãå¿ èŠã§ãã
ãã§ã«ç§ãã¡ã®èšäºã§è°è«ããããã«ã
ãã¡ãããæåã«ãã©ã®ãããªãªã¹ã¯ã«å¯ŸããŠä¿éºããããããšããŠããã®ãã決ããå¿ èŠããããŸãã ãã®èšäºã§ã¯ããéç³ãå°çããããªã©ã®è åšã«å¯Ÿããä¿è·ã«ã€ããŠã¯èæ ®ããŸããã ãããã£ãŠãå°ççã«åæ£ããçœå®³åŸ©æ§ãœãªã¥ãŒã·ã§ã³ã®æ§ç¯ã¯ãä»åŸã次ã®èšäºã®ããããã®ãããã¯ãšããŠæ®ããŸãã ããã§ã¯ãä¿è·ããµãŒã㌠ãã£ãããã ã¬ãã«ã§æ§ç¯ããããããããã¯ãã¹ã©ãã¯çœå®³åŸ©æ§ãœãªã¥ãŒã·ã§ã³ã«ã€ããŠèŠãŠãããŸãã ãã£ããããèªäœã¯åãéšå±ã«é 眮ããããšããå¥ã®éšå±ã«é 眮ããããšãã§ããŸãããéåžžã¯åã建ç©å ã«ãããŸãã
ãããã®ãã£ããããã«ã¯ããé£æ¥ãã®ç¶æ ã«é¢ä¿ãªã Oracle ããŒã¿ããŒã¹ã®æäœãå¯èœã«ããå¿ èŠãªæ©åšãšãœãããŠã§ã¢ã®ã»ããããã¹ãŠå«ãŸããŠããå¿ èŠããããŸãã èšãæããã°ãã¯ãã¹ã©ãã¯çœå®³åŸ©æ§ãœãªã¥ãŒã·ã§ã³ã䜿çšãããšãé害ã®ãªã¹ã¯ãæé€ãããŸãã
- Oracle ã¢ããªã±ãŒã·ã§ã³ ãµãŒããŒ
- ã¹ãã¬ãŒãžã·ã¹ãã
- ã¹ã€ããã³ã°ã·ã¹ãã
- ãã£ããããå
ã®ãã¹ãŠã®æ©åšã®å®å
šãªæ
é:
- é»æºã®æåŠ
- å·åŽã·ã¹ãã ã®æ é
- å€éšèŠå ïŒäººéãèªç¶ãªã©ïŒ
Oracle ãµãŒããŒã®è€è£œã¯ Oracle RAC ã®åäœåçãã®ãã®ãæå³ããã¢ããªã±ãŒã·ã§ã³ãéããŠå®è£ ãããŸãã 亀æèšåã®äºéåãåé¡ãããŸããã ããããã¹ãã¬ãŒãž ã·ã¹ãã ã®äºéåã§ã¯ããã¹ãŠãããã»ã©åçŽã§ã¯ãããŸããã
æãåçŽãªãªãã·ã§ã³ã¯ãã¡ã€ã³ ã¹ãã¬ãŒãž ã·ã¹ãã ããããã¯ã¢ãã ã·ã¹ãã ãžã®ããŒã¿ ã¬ããªã±ãŒã·ã§ã³ã§ãã ã¹ãã¬ãŒãž ã·ã¹ãã ã®æ©èœã«å¿ããŠãåæãŸãã¯éåæã éåæã¬ããªã±ãŒã·ã§ã³ã§ã¯ãOracle ãšã®é¢ä¿ã§ããŒã¿ã®äžè²«æ§ã確ä¿ãããšããåé¡ãããã«çããŸãã ãã ããã¢ããªã±ãŒã·ã§ã³ãšãœãããŠã§ã¢ãçµ±åãããŠããå Žåã§ããã¡ã€ã³ ã¹ãã¬ãŒãž ã·ã¹ãã ã«é害ãçºçããå Žåã¯ãã¯ã©ã¹ã¿ãããã¯ã¢ãã ã¹ãã¬ãŒãžã«åãæ¿ããããã«ç®¡çè ã«ããæåä»å ¥ãå¿ èŠã«ãªããŸãã
ããè€éãªãªãã·ã§ã³ã¯ãäžè²«æ§ã®åé¡ãæåä»å ¥ãæé€ãããœãããŠã§ã¢ããã³/ãŸãã¯ããŒããŠã§ã¢ ã¹ãã¬ãŒãžã®ãããŒãã£ã©ã€ã¶ãŒãã§ãã ããããå±éãšãã®åŸã®ç®¡çã®è€éãããããŠãã®ãããªãœãªã¥ãŒã·ã§ã³ã«ãããéåžžã«æ³å€ãªã³ã¹ãã¯ãå€ãã®äººãæããããŸãã
AccelStor NeoSapphire⢠ãªãŒã« ãã©ãã·ã¥ ã¢ã¬ã€ ãœãªã¥ãŒã·ã§ã³ã¯ãã¯ãã¹ã©ãã¯çœå®³åŸ©æ§ãªã©ã®ã·ããªãªã«æé©ã§ãã
ããããNeoSapphire⢠H710 ã®äž»ãªæ©èœã¯ã100 ã€ã®ããŒããå¥ã ã®ã±ãŒã¹ã®åœ¢åŒã§å®è¡ãããããããããŒã¿ã®ç¬èªã®ã³ããŒãæã£ãŠããããšã§ãã ããŒãã®åæã¯ãå€éš InfiniBand ã€ã³ã¿ãŒãã§ã€ã¹ãéããŠå®è¡ãããŸãã ãã®ã¢ãŒããã¯ãã£ã®ãããã§ãæ倧 710m é¢ããç°ãªãå Žæã«ããŒããåæ£ãããããšãã§ããã¯ãã¹ã©ãã¯ã®çœå®³åŸ©æ§ãœãªã¥ãŒã·ã§ã³ãæäŸã§ããŸãã äž¡æ¹ã®ããŒãã¯å®å šã«åæããŠåäœããŸãã ãã¹ãåŽããèŠããšãHXNUMX ã¯éåžžã®ãã¥ã¢ã« ã³ã³ãããŒã© ã¹ãã¬ãŒãž ã·ã¹ãã ã®ããã«èŠããŸãã ãããã£ãŠãè¿œå ã®ãœãããŠã§ã¢ãŸãã¯ããŒããŠã§ã¢ ãªãã·ã§ã³ãç¹ã«è€éãªèšå®ãå®è¡ããå¿ èŠã¯ãããŸããã
äžèšã®ã¯ãã¹ã©ãã¯çœå®³åŸ©æ§ãœãªã¥ãŒã·ã§ã³ããã¹ãŠæ¯èŒãããšãAccelStor ã®ãªãã·ã§ã³ãä»ã®ãœãªã¥ãŒã·ã§ã³ãããéç«ã£ãŠããŸãã
AccelStor NeoSapphire⢠ã·ã§ã¢ãŒãããã·ã³ã° ã¢ãŒããã¯ãã£
ãœãããŠã§ã¢ãŸãã¯ããŒããŠã§ã¢ã®ãããŒãã£ã©ã€ã¶ãŒãã¹ãã¬ãŒãž ã·ã¹ãã
ã¬ããªã±ãŒã·ã§ã³ããŒã¹ã®ãœãªã¥ãŒã·ã§ã³
å¯çšæ§
ãµãŒããŒé害
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã ãªã
ã¹ã€ããã®æ
é
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã ãªã
ã¹ãã¬ãŒãžã·ã¹ãã ã®é害
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã
ãã£ããããå
šäœã®æ
é
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã ãªã
ããŠã³ã¿ã€ã
ã³ã¹ããšè€éã
ãœãªã¥ãŒã·ã§ã³ã³ã¹ã
äœã*
ãã€
ãã€
å°å
¥ã®è€éã
äœãã§ã
ãã€
ãã€
*AccelStor NeoSapphire⢠ã¯äŸç¶ãšããŠãªãŒã« ãã©ãã·ã¥ ã¢ã¬ã€ã§ãããç¹ã« 3 åã®å®¹éã確ä¿ãããŠãããããå®çŸ©äžãXNUMX ã³ããã¯ãã®ã³ã¹ãã¯ããããŸããã ãã ããããã«åºã¥ããœãªã¥ãŒã·ã§ã³ã®æçµã³ã¹ããä»ã®ãã³ããŒã®åæ§ã®ãœãªã¥ãŒã·ã§ã³ãšæ¯èŒãããšãã³ã¹ãã¯äœããšèããããŸãã
ã¢ããªã±ãŒã·ã§ã³ ãµãŒããŒãšãªãŒã« ãã©ãã·ã¥ ã¢ã¬ã€ ããŒããæ¥ç¶ããããã®ããããžã¯æ¬¡ã®ããã«ãªããŸãã
ããããžãèšç»ãããšãã¯ã管çã¹ã€ãããè€è£œãããµãŒããŒãçžäºæ¥ç¶ããããšã匷ããå§ãããŸãã
ããã§ã¯ããã¡ã€ã ãã£ãã«çµç±ã®æ¥ç¶ã«ã€ããŠããã«èª¬æããŸãã iSCSI ã䜿çšããå Žåã¯ã䜿çšããã¹ã€ããã®çš®é¡ãšè¥å¹²ç°ãªãã¢ã¬ã€èšå®ã調æŽããŠããã¹ãŠãåãã«ãªããŸãã
ã¢ã¬ã€ã®æºåäœæ¥
䜿çšããæ©åšãšãœãããŠã§ã¢
ãµãŒããŒãšã¹ã€ããã®ä»æ§
ã³ã³ããŒãã³ã
説æ
Oracle ããŒã¿ããŒã¹ 11g ãµãŒããŒ
2
ãµãŒããŒãªãã¬ãŒãã£ã³ã°ã·ã¹ãã
Oracle Linux
Oracle ããŒã¿ããŒã¹ã®ããŒãžã§ã³
11g (RAC)
ãµãŒããŒãããã®ããã»ããµæ°
16 ã€ã® 5 ã³ã¢ Intel® Xeon® CPU E2667-2 v3.30 @ XNUMXGHz
ãµãŒããŒãããã®ç©çã¡ã¢ãª
128GB
FCãããã¯ãŒã¯
ãã«ããã¹æ©èœãåãã 16Gb/ç§ FC
FC HBA
ãšã ã¬ãã¯ã¹ Lpe-16002B
ã¯ã©ã¹ã¿ãŒç®¡ççšã®å°çšãããªã㯠1GbE ããŒã
ã€ã³ãã« ã€ãŒãµããã ã¢ããã¿ãŒ RJ45
16Gb/ç§ FC ã¹ã€ãã
ããã±ãŒã 6505
ããŒã¿åæçšã®å°çšãã©ã€ããŒã 10GbE ããŒã
ã€ã³ãã«X520
AccelStor NeoSapphire⢠ãªãŒã« ãã©ãã·ã¥ ã¢ã¬ã€ã®ä»æ§
ã³ã³ããŒãã³ã
説æ
ã¹ãã¬ãŒãžã·ã¹ãã
NeoSapphire⢠é«å¯çšæ§ã¢ãã«: H710
ã€ã¡ãŒãžããŒãžã§ã³
4.0.1
ãã©ã€ãã®ç·æ°
48
ãã©ã€ããµã€ãº
1.92TB
ãã©ã€ãã¿ã€ã
SSD
FCã¿ãŒã²ããããŒã
16x 16Gb ããŒã (ããŒãããã 8 å)
管çããŒã
ã€ãŒãµããã ã¹ã€ããçµç±ã§ãã¹ãã«æ¥ç¶ãã 1GbE ã€ãŒãµããã ã±ãŒãã«
ããŒãããŒãããŒã
1 ã€ã®ã¹ãã¬ãŒãž ããŒãéãæ¥ç¶ãã XNUMXGbE ã€ãŒãµããã ã±ãŒãã«
ããŒã¿åæããŒã
56Gb/s InfiniBand ã±ãŒãã«
é åã䜿çšããåã«ãé åãåæåããå¿ èŠããããŸãã ããã©ã«ãã§ã¯ãäž¡æ¹ã®ããŒãã®å¶åŸ¡ã¢ãã¬ã¹ã¯åã (192.168.1.1) ã§ãã ãããã« XNUMX ã€ãã€æ¥ç¶ããæ°ãã (ãã§ã«ç°ãªã) 管çã¢ãã¬ã¹ãèšå®ããæå»åæãèšå®ããå¿ èŠããããŸãããã®åŸã管çããŒããåäžã®ãããã¯ãŒã¯ã«æ¥ç¶ã§ããããã«ãªããŸãã ãã®åŸãã€ã³ã¿ãŒãªã³ã¯æ¥ç¶çšã®ãµãããããå²ãåœãŠãããšã«ãã£ãŠãããŒãã HA ãã¢ã«çµåãããŸãã
åæåãå®äºãããšãä»»æã®ããŒãããã¢ã¬ã€ã管çã§ããããã«ãªããŸãã
次ã«ãå¿ èŠãªããªã¥ãŒã ãäœæããã¢ããªã±ãŒã·ã§ã³ ãµãŒããŒã«å ¬éããŸãã
Oracle ASMçšã«è€æ°ã®ããªã¥ãŒã ãäœæããããšã匷ããå§ãããŸããããã«ããããµãŒããŒã®ã¿ãŒã²ããæ°ãå¢å ããæçµçã«å
šäœçãªããã©ãŒãã³ã¹ãåäžããŸã(å¥ã®ãã¥ãŒã®ããã©ãŒãã³ã¹ãåäžããŸã)ã
æ§æã®ãã¹ã
ã¹ãã¬ãŒãžããªã¥ãŒã å
ããªã¥ãŒã ãµã€ãº
Data01
200GB
Data02
200GB
Data03
200GB
Data04
200GB
Data05
200GB
Data06
200GB
Data07
200GB
Data08
200GB
Data09
200GB
Data10
200GB
Grid01
1GB
Grid02
1GB
Grid03
1GB
Grid04
1GB
Grid05
1GB
Grid06
1GB
ããçŽã01
100GB
ããçŽã02
100GB
ããçŽã03
100GB
ããçŽã04
100GB
ããçŽã05
100GB
ããçŽã06
100GB
ããçŽã07
100GB
ããçŽã08
100GB
ããçŽã09
100GB
ããçŽã10
100GB
ã¢ã¬ã€ã®åäœã¢ãŒããšç·æ¥æã«çºçããããã»ã¹ã«ã€ããŠã®èª¬æ
åããŒãã®ããŒã¿ã»ããã«ã¯ãããŒãžã§ã³çªå·ããã©ã¡ãŒã¿ããããŸãã åæåæååŸã¯ãåã㧠1 ã«çãããªããŸããäœããã®çç±ã§ããŒãžã§ã³çªå·ãç°ãªãå ŽåãããŒã¿ã¯åžžã«å€ãããŒãžã§ã³ããæ°ããããŒãžã§ã³ã«åæããããã®åŸãæ°ããããŒãžã§ã³ã®çªå·ãæããããŸãã ããã¯ãã³ããŒãåäžã§ããããšãæå³ããŸãã ããŒãžã§ã³ãç°ãªãçç±:
- ããããã®ããŒãã®ã¹ã±ãžã¥ãŒã«ãããåèµ·å
- çªç¶ã®ã·ã£ããããŠã³ (é»æºäŸçµŠãéç±ãªã©) ã«ããããŒãã® XNUMX ã€ã§ã®äºæ ã
- InfiniBand æ¥ç¶ã倱ãããŠåæã§ããªã
- ããŒã¿ç Žæã«ããããŒãã® XNUMX ã€ã§ã®ã¯ã©ãã·ã¥ã ããã§ã¯ãæ°ãã HA ã°ã«ãŒããäœæããããŒã¿ ã»ããã®åæãå®äºããå¿ èŠããããŸãã
ãããã®å Žåãããã¢ãšã®æ¥ç¶ã埩å ãããåŸãããŒã¿ ã»ãããåæããããã«ããªã³ã©ã€ã³ã®ãŸãŸã®ããŒãã¯ããŒãžã§ã³çªå·ã XNUMX ã€å¢ãããŸãã
Ethernet ãªã³ã¯äžã®æ¥ç¶ã倱ãããå ŽåãHeartbeat ã¯äžæçã« InfiniBand ã«åãæ¿ããã埩å ããããš 10 ç§ä»¥å ã«æ»ããŸãã
ãã¹ãã®ã»ããã¢ãã
ãã©ãŒã«ã ãã¬ã©ã³ã¹ã確ä¿ããããã©ãŒãã³ã¹ãåäžãããã«ã¯ãã¢ã¬ã€ã® MPIO ãµããŒããæå¹ã«ããå¿ èŠããããŸãã ãããè¡ãã«ã¯ã/etc/multipath.conf ãã¡ã€ã«ã«è¡ãè¿œå ãããã«ããã¹ ãµãŒãã¹ãåèµ·åããå¿ èŠããããŸãã
é ãããã¹ãããã€ã¹ {
ããã€ã¹ {
ãã³ããŒãAStorã
path_grouping_policy "group_by_prio"
path_selector "ãã¥ãŒé· 0"
ãã¹ãã§ãã«ãŒããã¥ãŒã«ã
ç¹åŸŽã0ã
ããŒããŠã§ã¢ãã³ãã©ãŒ "0"
ããªãªãå®æ°ã
å³æãã§ã€ã«ããã¯
fast_io_fail_tmo 5
éçºæ倱tmo 60
user_friendly_namesã¯ã
æ€åºããªãªã¯ã
rr_min_io_rq 1
no_path_retry 0
}
}
次ã«ãASM ã ASMLib çµç±ã§ MPIO ãšé£æºã§ããããã«ããã«ã¯ã/etc/sysconfig/oracleasm ãã¡ã€ã«ãå€æŽããŠã/etc/init.d/oracleasm scandisks ãå®è¡ããå¿ èŠããããŸãã
é ãããã¹ã
# ORACLEASM_SCANORDER: ãã£ã¹ã¯ ã¹ãã£ã³ãåœä»€ããããã®ãã¿ãŒã³ã®äžèŽ
ORACLEASM_SCANORDER="dm"
# ORACLEASM_SCANEXCLUDE: ã¹ãã£ã³ãããã£ã¹ã¯ãé€å€ããããã®ãã¿ãŒã³ã®äžèŽ
ORACLEASM_SCANEXCLUDE="sd"
泚æ
ASMLib ã䜿çšããããªãå Žåã¯ãASMLib ã®åºç€ãšãªã UDEV ã«ãŒã«ã䜿çšã§ããŸãã
Oracle Databaseã®ããŒãžã§ã³12.1.0.2以éããã®ãªãã·ã§ã³ã¯ASMFDãœãããŠã§ã¢ã®äžéšãšããŠã€ã³ã¹ããŒã«ã§ããããã«ãªããŸããã
Oracle ASMçšã«äœæããããã£ã¹ã¯ããã¢ã¬ã€ãç©ççã«åäœãããããã¯ã»ãµã€ãº(4K)ãšäžèŽããŠããããšã確èªããããšãäžå¯æ¬ ã§ãã ããããªããšãããã©ãŒãã³ã¹ã®åé¡ãçºçããå¯èœæ§ããããŸãã ãããã£ãŠãé©åãªãã©ã¡ãŒã¿ã䜿çšããŠããªã¥ãŒã ãäœæããå¿ èŠããããŸãã
parted /dev/mapper/device-name mklabel gpt mkpart ãã©ã€ã㪠2048s 100% align-check æé© 1
ãã¹ãæ§æçšã«äœæãããããªã¥ãŒã éã§ã®ããŒã¿ããŒã¹ã®åæ£
ã¹ãã¬ãŒãžããªã¥ãŒã å
ããªã¥ãŒã ãµã€ãº
ããªã¥ãŒã LUN ãããã³ã°
ASMããªã¥ãŒã ããã€ã¹ã®è©³çŽ°
ã¢ãã±ãŒã·ã§ã³ãŠããããµã€ãº
Data01
200GB
ãã¹ãŠã®ã¹ãã¬ãŒãž ããªã¥ãŒã ãã¹ãã¬ãŒãž ã·ã¹ãã ã®ãã¹ãŠã®ããŒã¿ ããŒãã«ãããã³ã°ãã
åé·æ§: éåžž
åå:DGDATA
ç®ç:ããŒã¿ãã¡ã€ã«
4MB
Data02
200GB
Data03
200GB
Data04
200GB
Data05
200GB
Data06
200GB
Data07
200GB
Data08
200GB
Data09
200GB
Data10
200GB
Grid01
1GB
åé·æ§: éåžž
åå: DGGRID1
ç®ç:ã°ãªãã: CRS ãšæ祚
4MB
Grid02
1GB
Grid03
1GB
Grid04
1GB
åé·æ§: éåžž
åå: DGGRID2
ç®ç:ã°ãªãã: CRS ãšæ祚
4MB
Grid05
1GB
Grid06
1GB
ããçŽã01
100GB
åé·æ§: éåžž
åå: DGREDO1
ç®ç: ã¹ã¬ãã 1 ã® REDO ãã°
4MB
ããçŽã02
100GB
ããçŽã03
100GB
ããçŽã04
100GB
ããçŽã05
100GB
ããçŽã06
100GB
åé·æ§: éåžž
åå: DGREDO2
ç®ç: ã¹ã¬ãã 2 ã® REDO ãã°
4MB
ããçŽã07
100GB
ããçŽã08
100GB
ããçŽã09
100GB
ããçŽã10
100GB
ããŒã¿ããŒã¹èšå®
- ãããã¯ãµã€ãº = 8K
- ã¹ã¯ããã¹ããŒã¹ = 16GB
- AMM (èªåã¡ã¢ãªç®¡ç) ãç¡å¹ã«ãã
- éæãªãã¥ãŒãž ããŒãžãç¡å¹ã«ãã
ãã®ä»ã®èšå®
# vi /etc/sysctl.conf
â fs.aio-max-nr = 1048576
â fs.file-max = 6815744
â kernel.shmmax 103079215104
â kernel.shmall 31457280
â ã«ãŒãã«.shmmn 4096
â kernel.sem = 250 32000 100 128
â net.ipv4.ip_local_port_range = 9000 65500
â net.core.rmem_default = 262144
â net.core.rmem_max = 4194304
â net.core.wmem_default = 262144
â net.core.wmem_max = 1048586
âvm.swappiness=10
â vm.min_free_kbytes=524288 # Linux x86 ã䜿çšããŠããå Žåã¯ãããèšå®ããªãã§ãã ãã
â vm.vfs_cache_pressure=200
â vm.nr_hugepages = 57000
# vi /etc/security/limits.conf
â ã°ãªãããœãã nproc 2047
â ã°ãªããããŒã nproc 16384
â ã°ãªãã ãœãã nofile 1024
â ã°ãªããããŒãããŒãã¡ã€ã« 65536
â ã°ãªãããœããã¹ã¿ã㯠10240
â ã°ãªããããŒãã¹ã¿ã㯠32768
â Oracle ãœãã nproc 2047
â ãªã©ã¯ã«ããŒã nproc 16384
â Oracle ãœãã nofile 1024
â ãªã©ã¯ã« ããŒã nofile 65536
â ãªã©ã¯ã«ãœããã¹ã¿ã㯠10240
â ãªã©ã¯ã«ããŒãã¹ã¿ã㯠32768
â ãœãã ã¡ã¢ãªãã㯠120795954
â ããŒã ã¡ã¢ãªãã㯠120795954
sqlplus â/as sysdbaâ
ã·ã¹ãã ãå€æŽããŠããã»ã¹ = 2000 ã¹ã³ãŒã = spfile;
ã·ã¹ãã ã»ãã open_cursors=2000 ã¹ã³ãŒã=spfile ãå€æŽããŸãã
ã·ã¹ãã èšå®ãå€æŽããŸã session_cached_cursors=300 ã¹ã³ãŒã=spfile;
ã·ã¹ãã ã»ãããå€æŽ db_files=8192 ã¹ã³ãŒã=spfile;
æ éãã¹ã
ãã¢ã³ã¹ãã¬ãŒã·ã§ã³ã®ç®çã§ãHammerDB ã䜿çšã㊠OLTP ããŒãããšãã¥ã¬ãŒãããŸããã HammerDB ã®æ§æ:
å庫æ°
256
ãŠãŒã¶ãŒããšã®åèšãã©ã³ã¶ã¯ã·ã§ã³æ°
1000000000000
ä»®æ³ãŠãŒã¶ãŒ
256
çµæ㯠2.1 äž TPM ã§ããããããã¯ã¢ã¬ã€ã®ããã©ãŒãã³ã¹éçã«ã¯çšé ããã®ã§ããã
ããããã®ããŒãã®é害ããã¹ããã
ãã¹ãã¯ã¹ãã¬ãŒãžãžã®ãã¹ã®äžéšã倱ããXNUMX çªç®ã®ããŒãã§æ®ãã®ãã¹ã䜿çšããŠäœæ¥ãç¶ããŸããã ãã¹ãåæ§ç¯ããããããããã©ãŒãã³ã¹ãæ°ç§éäœäžããŸãããããã®åŸéåžžã«æ»ããŸããã ãµãŒãã¹ã®äžæã¯ãããŸããã§ããã
ãã¹ãŠã®æ©åšã䜿çšãããã£ããããã®æ éãã¹ã
ãã®å Žåãããã¹ã®åæ§ç¯ã«ããããã©ãŒãã³ã¹ãæ°ç§éäœäžããŸãããããã®åŸãå ã®å€ã®ååã«æ»ããŸããã ã¢ããªã±ãŒã·ã§ã³ãµãŒããŒãXNUMXå°çšŒåããªããªã£ããããçµæã¯åœåã®ååãšãªããŸããã ãµãŒãã¹ã®äžæããããŸããã§ããã
Oracle çšã®ãã©ãŒã«ããã¬ã©ã³ããªã¯ãã¹ã©ãã¯çœå®³åŸ©æ§ãœãªã¥ãŒã·ã§ã³ãåççãªã³ã¹ãã§å°å ¥/管çã®åŽåãã»ãšãã©ãããã«å®è£ ããå¿ èŠãããå Žåã¯ãOracle RAC ãšã¢ãŒããã¯ãã£ãé£æºããŠæ©èœããŸãã
AccelStor ã·ã§ã¢ãŒãããã·ã³ã° æè¯ã®éžæè¢ã®äžã€ãšãªãã ããã Oracle RAC ã®ä»£ããã«ãã¯ã©ã¹ã¿ãªã³ã°ãæäŸããä»ã®ãœãããŠã§ã¢ãããšãã°åã DBMS ãä»®æ³åã·ã¹ãã ã䜿çšããããšãã§ããŸãã ãœãªã¥ãŒã·ã§ã³ãæ§ç¯ããååã¯å€ãããŸããã ãããŠãæçµç㪠RTO ãš RPO ã¯ãŒãã«ãªããŸãã
åºæïŒ habr.com