SQL Server + フラッシュ・ストレージによる高速HA 折紙付構成

SQL Server + 䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆䛻䜘䜛㧗㏿HA ᢡ⣬௜ᵓᡂ
㻰㼍㼠㼍㻷㼑㼑㼜㼑㼞䛸㧗㏿䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆䜢౑䛳䛶䚸㧗㏿䞉㧗ྍ⏝䛺㻿㻽㻸㻌㻿㼑㼞㼢㼑㼞䜢ᵓ⠏ྍ⬟䟿
㻿㻽㻸㻌㻿㼑㼞㼢㼑㼞㻌㻞㻜㻝㻞㻌㻿㼠㼍㼚㼐㼍㼞㼐㻌㻱㼐㼕㼠㼕㼛㼚䛾䝷䜲䝉䞁䝇䛜౑䛘䜛䛾䛷䝷䜲䝉䞁䝇䞉䝁䝇䝖䜒๐ῶ䟿䟿
Active Directory
ኒዙክዙ
1Gbps
10Gbps
䝋䞊䝇䞉䝃䞊䝞䞊
䠄Hostname: dk2䠅
(g
䝕䞊䝍䞉䝺䝥䝸䜿䞊䝅䝵䞁
HDD
)g
(g
HDD
䝕䞊䝍䞉䝺䝥䝸䜿䞊䝅䝵䞁
ioDrive
䝍䞊䝀䝑䝖䞉䝃䞊䝞䞊
䠄Hostname: dk2䠅
)g
ioDrive
Windows Server 䝣䜵䞊䝹䜸䞊䝞䞊䞉䜽䝷䝇䝍䝸䞁䜾䠄WSFC䠅䜽䝷䝇䝍䞊
䝋䝸䝳䞊䝅䝵䞁ᴫせ
䛂SQL Server + 䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆䛻䜘䜛㧗㏿HA ᢡ⣬௜ᵓᡂ䛃䛿䚸SQL Server䛾ᛶ⬟䜔䝷䜲䝉䞁䝇䛾ၥ
㢟䛷䛚ᝎ䜏䛾䛚ᐈᵝ䜔䚸䝕䞊䝍ศᯒ䜢᳨ウ䛧䛶䛔䜛䛚ᐈᵝ䛾䛯䜑䛻䚸High-IOPS PCIe䜰䝎䝥䝍䞊䛾NAND䝣
䝷䝑䝅䝳ᢏ⾡䜢⏕䛛䛧䚸㧗㏿䛺䝖䝷䞁䝄䜽䝅䝵䞁ฎ⌮ᛶ⬟䛸DataKeeper䛻䜘䜛㧗ྍ⏝ᛶ䜢䛤ᥦ౪䛩䜛䚸஦๓᳨
ド῭䜏䝋䝸䝳䞊䝅䝵䞁䛷䛩䚹
RDBMS䛸䛧䛶ᗈ䛟฼⏝䛥䜜䛶䛔䜛 Microsoft SQL Server 2012䛾䝥䝷䝑䝖䝣䜷䞊䝮䛸䛧䛶䚸㧗ᛶ⬟䛷㧗䛔ᣑᙇ
ᛶ䜢㄂䜛System x3650 M4/System x3650 M5䛻䚸㧗㏿䛺High-IOPS PCIe䜰䝎䝥䝍䞊䛸䚸DataKeeper䜢⤌
䜏ྜ䜟䛫䚸䛥䜙䛻ప䝁䝇䝖䛷䛾䛤ᥦ౪䜢ྍ⬟䛻䛧䛯䛚䛩䛩䜑䛾ᵓᡂ䛷䛩䚹
䛣䜣䛺ၥ㢟䛷䛚ᝎ䜏䛷䛿䛒䜚䜎䛫䜣䛛䠛
• 䜰䝥䝸䜿䞊䝅䝵䞁䛾䝺䝇䝫䞁䝇䛜ᝏ䛔
• 䝕䞊䝍䝧䞊䝇䞉䝃䞊䝞䞊䛾ྍ⏝ᛶ䜢㧗䜑䛯䛔
• 䝞䝑䝏ฎ⌮䛜᫬㛫ෆ䛻⤊䜟䜙䛺䛟䛺䛳䛶䛝䛯
• ෆⶶ䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆䛷䛿WSFCᵓᡂ䛜
స䜜䛺䛔
• Always On Availability Group䛾฼⏝䛻䝁䝇䝖
䛜䛛䛛䜛
• ศᩓ䛧䛯ከᩘ䛾SQL Server䜢⤫ྜ䛧䛯䛔
• ఍♫䛾⤒Ⴀ≧ែ䜢ศᯒ䛧䛶䚸䝡䝆䝛䝇䛻ᙺ❧䛶
䛯䛔
䛂SQL Server + 䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆䛻䜘䜛㧗㏿HA ᢡ⣬௜ᵓᡂ䛃䛷䛿䚸᭱᪂䛾NAND䝣䝷䝑䝅䝳ᢏ⾡䛜䜒䛯䜙
䛩㧗㏿ฎ⌮䛻䜘䜚䚸SQL Server䛻䛚䛡䜛䛣䜜䜙䛾ၥ㢟䜢ゎỴ䛧䜎䛩䚹
䜎䛯䚸Windows Server䝣䜵䞊䝹䜸䞊䝞䞊䞉䜽䝷䝇䝍䝸䞁䜾
䠄WSFC䠅䛸㐃ᦠ䛧䛶✌ാ䛩䜛DataKeeper䜢౑䛖䛣䛸䛷䚸ෆ
ⶶ䝣䝷䝑䝅䝳䛾㧗㏿ᛶ䛸ప䝁䝇䝖䜢୧❧䛧䛯HA⎔ቃ䜢ᐇ⌧
䛷䛝䜎䛩䚹
䝋䝸䝳䞊䝅䝵䞁ᵓᡂ౛
SQL Server + 䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆䛻䜘䜛㧗㏿HA ᢡ⣬௜ᵓᡂ䛾䝝䞊䝗䜴䜵䜰/䝋䝣䝖䜴䜵䜰䛾ᶆ‽ⓗ䛺䝃䞁䝥
䝹ᵓᡂ䛿䚸ḟ䛾䛸䛚䜚䛷䛩䚹
䝃䞊䝞䞊
System x3650 M4 䜎䛯䛿 System x3650 M5䠖2ྎ
• 䝥䝻䝉䝑䝃䞊䠖䜲䞁䝔䝹 Xeon 䝥䝻䝉䝑䝃䞊 E5-2600 v3 〇ရ䝣䜯䝭䝸䞊 䜎䛯䛿 E5-2600 v2 〇ရ䝣䜯䝭䝸䞊 䠄ྜィ24䝁䜰䜎䛷䠅
• 䝯䝰䝸䞊䝃䜲䝈䠖32GB 䠄⏝㏵䛻ᛂ䛨䛶ቑᙉ䜒ྍ⬟䠅
• 䝛䝑䝖䝽䞊䜽䠖10Gbps Ethernet䜰䝎䝥䝍䞊 䠄Heartbeat⏝䠖ᚲ㡲䠅
䝣䝷䝑䝅䝳䞉䝇䝖䝺䞊䝆
High-IOPS 䜰䝎䝥䝍䞊 䜎䛯䛿 Enterprise io3 䜰䝎䝥䝍䞊
䠄ᐜ㔞䚸ᯛᩘ䛿ᚲせ䛻ᛂ䛨䛶㑅ᢥྍ⬟䠅
DataKeeper for Windows Cluster Edition
SQL Server 2012 Standard Edition
Windows Server 2012 R2 Standard Edition
䝋䝣䝖䜴䜵䜰
㧗ྍ⏝ᛶ䜢ᐇ⌧䛩䜛DataKeeper Cluster Edition
• Windows Server 䝣䜵䞊䝹䜸䞊䝞䞊䞉䜽䝷䝇䝍䝸䞁䜾䛸䛾㐃
ᦠ䛷䚸ඹ᭷䝕䜱䝇䜽䛺䛧䛷㧗ྍ⏝ᛶ䜢ᐇ⌧ྍ⬟
SQL Server 2012 SE
DataKeeper Cluster Edition
DataKeeper Cluster Edition
Windows Server 2012 R2
Standard Edition
Windows Server 2012 R2
Standard Edition
1.2TB High-IOPS
MLC Mono 䜰䝎䝥䝍䞊
Heartbeat
DataKeeper䛻䜘䜛䝺䝥䝸䜿䞊䝅䝵䞁
㧗㏿䞉ప㐜ᘏ䜢ᐇ⌧䛩䜛High-IOPS PCIe 䜰䝎䝥䝍䞊
• PCI Express䝞䝇䛻┤⤖䛥䜜䛯NAND䝣䝷䝑䝅䝳䛸䝕䝞䜲䝇䞉䝗䝷䜲
䝞䞊䛾䝁䞁䝡䝛䞊䝅䝵䞁䛷䚸㧗㏿䛺䝖䝷䞁䝄䜽䝅䝵䞁ฎ⌮䜢ᐇ⌧ྍ⬟
䕔System x3650 M4 ᶆ‽ᵓᡂ䠄䝃䞁䝥䝹ᵓᡂ䠅
〇ရ␒ྕ
〇ရྡ⛠
7915-M3J
System x3650 M4 䝰䝕䝹 M3J
ͤSystem x3650 M5 䛾ᶆ‽ᵓᡂ䛿䚸Enterprise io3䜰䝎䝥䝍䞊䛾䝃䝫䞊䝖䛜☜ㄆ䛥䜜ḟ➨ᥖ㍕䛧䜎䛩䚹
ᩘ㔞
2
2.5ᆺ䝩䝑䝖䝇䝽䝑䝥HDD䝰䝕䝹䚸䝥䝻䝉䝑䝃䞊䠖䜲䞁䝔䝹 Xeon䝥䝻䝉䝑䝃䞊 E5-2690 v2䠄3.0GHz/L3:25MB/10䝁䜰䠅㽢1䚸䝯䝰䝸䞊䠖8GB
䠄8GB PC3-14900 RDIMM㽢1䠅䚸HDD䠖䜸䞊䝥䞁䚸RAID䠖RAID 0/1/10ᑐᛂ䠄ServeRAID-M5110e䠅䚸900W෕㛗㟁※䠄80PLUS
Platinum䠅㽢1䚸3ᖺಖド䠄24h㽢㐌7᪥䜎䛯䛿CRU䠅
00D5032
81Y9670
90Y3901
49Y7980
81Y4559
00AE983
46M0901
46C3447
94Y6667
46M2593
90Y9427
00FF244
22
4
2
2
2
2
2
2
2
4
1
2
8GB 1R PC3-14900 RDIMM CK
300GB 15K 6Gbps SAS 2.5ᆺ SFF HS HDD
㸦FoD㸧Integrated Management Module㸦IMM㸧Advanced UPG
䜲䞁䝔䝹 X520 䝕䝳䜰䝹䝫䞊䝖 10GbE SFP+ Embedded Adapter
ServeRAID-M5100⏝ 1GB Flash/RAID5 UPG
1250GB Enterprise Value io3 Flash 䜰䝎䝥䝍䞊
䜴䝹䝖䝷䝇䝸䝮 SATA DVD-ROM
BNT SFP+ SR 䝖䝷䞁䝅䞊䝞䞊
900W㧗ຠ⋡ᆺ䝩䝑䝖䝇䝽䝑䝥㟁※ᶵᵓ
NEMA5-15P to IEC C13 㟁※䜿䞊䝤䝹䠄2.8m㸧
1m Passive DAC䜿䞊䝤䝹
Windows Server 2012 R2 Standard IBM∧㸦1-2CPU/2VM㸧
㛵㐃᝟ሗ
䛚ၥ䛔ྜ䜟䛫
䝃䜲䜸䝇䝔䜽䝜䝻䝆䞊ᰴᘧ఍♫
ʊ DataKeeper㐃ᦠ䝋䝸䝳䞊䝅䝵䞁䝨䞊䝆
౯᱁䜔ᵓᡂ䛾䛤㉁ၥ䜔䛤┦ㄯ䚸䛚ぢ✚䜒䜚䛾䛤౫㢗
䛺䛹䚸䛤㉎ධ䛻㛵䛩䜛䛚ၥ䛔ྜ䜟䛫䜢䛿䛨䜑䚸䛚ᐈ
ᵝ䛜ᢪ䛘䜛IT䛻㛵䛩䜛䛚ᝎ䜏䜒䛚⪺䛛䛫䛟䛰䛥䛔䚹
http://www.sios.com/products/bcp/lkdk/product/h_les_dkce-sql.html
䝃䜲䜸䝇䝔䜽䝜䝻䝆䞊ᰴᘧ఍♫
ʊ ᳨ド⤖ᯝ䝩䝽䜲䝖䝨䞊䝟䞊䝨䞊䝆
http://www.sios.com/products/bcp/lkdk/product/pdf/les_dkce-sql-server.html
䝃䜲䜸䝇䝔䜽䝜䝻䝆䞊ᰴᘧ఍♫
䝟䞊䝖䝘䞊Ⴀᴗ㒊
http://www.sios.com/products/bcp/lkdk/contact/
䖲 03-6401-5222
䠄ཷ௜᫬㛫䠖ᖹ᪥ 9᫬00ศ䡚17᫬00ศ䠅