Namuhla sizokwethula izici zokusebenzisa i-SQL Server 2019 ngohlelo lokugcina lwe-Unity XT, futhi sinikeze izincomo ekwenzeni i-SQL Server ibe ngokoqobo kusetshenziswa ubuchwepheshe be-VMware, ukumisa nokuphatha izingxenye eziyisisekelo zengqalasizinda ye-Dell EMC.
Ngo-2017, uDell EMC kanye ne-VMware bashicilela imiphumela yocwaningo mayelana nezitayela kanye nokuvela kwe-SQL Server - "SQL Server Transformation: Towards Agility and Resilience" (), esebenzise ulwazi lomphakathi wamalungu e-Professional Association of SQL Server (PASS). Imiphumela ibonisa ukuthi izindawo zesizindalwazi se-SQL Server zikhula ngobukhulu nobunkimbinkimbi, ziqhutshwa ukwanda kwamavolumu wedatha kanye nezidingo zebhizinisi ezintsha. Imininingo egciniwe Yeseva ye-SQL manje isisetshenziswa ezinkampanini eziningi, inika amandla izinhlelo zokusebenza ezibucayi, futhi ngokuvamile iyisisekelo soguquko lwedijithali.
Kusukela le nhlolovo yenziwe, i-Microsoft ikhiphe isizukulwane esilandelayo se-DBMS - SQL Server 2019. Ngaphezu kokuthuthukisa imisebenzi eyisisekelo yenjini yokuxhumana nokugcinwa kwedatha, izinsizakalo ezintsha nemisebenzi ivele. Isibonelo, i-SQL Server 2019 ihlanganisa ukusekelwa kwedatha enkulu yomsebenzi usebenzisa i-Apache Spark ne-Hadoop Distributed File System (HDFS).
I-Alliance Dell EMC ne-Microsoft
I-Dell EMC kanye ne-Microsoft banokubambisana okunesikhathi eside ekuthuthukiseni izixazululo ze-SQL Server. Ukuqalisa ngempumelelo inkundla yedatha ebanzi efana ne-Microsoft SQL Server kudinga ukuhlanganiswa kokusebenza kwesofthiwe nengqalasizinda ye-IT eyisisekelo. Le ngqalasizinda ihlanganisa amandla okucubungula iphrosesa, izinsiza zememori, isitoreji kanye nezinsizakalo zenethiwekhi. I-Dell EMC inikezela ngengqalasizinda yesikhulumi se-SQL Server yalo lonke uhlobo lomsebenzi nesicelo.
Ulayini weseva ye-Dell EMC PowerEdge unikeza ukucushwa okuhlukahlukene kweprosesa nememori. Lokhu kulungiselelwa kulungele inqwaba yemithwalo yemisebenzi: kusukela kuzinhlelo zokusebenza zezinkampani ezincane ukuya ezinhlelweni ezinkulu ezibaluleke kakhulu, njengokuhlela kwensiza yebhizinisi (ERP), izindawo zokugcina idatha, ukuhlaziya okuthuthukile, ukuhweba nge-elekthronikhi, njll. ukugcina idatha engahlelekile neyakhekile.
Amakhasimende asebenzisa i-SQL Server 2019 nengqalasizinda ye-Dell EMC angasebenza nedatha ehlelekile nengahlelekile kusetshenziswa i-SQL Server ne-Apache Spark. Iseva ye-SQL iphinde isekele inhlanganisela yokufinyelela kweklayenti, iseva-kuya-iseva, kanye nobuchwepheshe bokuxhumana beseva-kuya-kwisitoreji. Umbono we-Dell EMC usekelwe kumodeli ehlukanisiwe enikeza i-ecosystem evulekile. Izinhlangano zingakhetha ohlwini olubanzi lwezinhlelo zokusebenza zokuxhumana ezijwayelekile, amasistimu okusebenza nezinkundla zehadiwe. Le ndlela ikunikeza ukulawula okuphezulu kubuchwepheshe nezakhiwo, okuholela ekongeni kwezindleko ezinkulu kanye nokuvumelana nezimo.
I-VMware ibona zonke izingxenye zengqalasizinda ezibalulekile ezidingwa yi-SQL Server ukuze kuzuzwe ukusebenza okuphezulu nokungaguquguquki kokusebenza. Ngokungeziwe kumafu ayimfihlo, i-VMware futhi njengamanje inikezela ngamamodeli ayi-hybrid omthwalo wokusebenza, ahlanganisa izakhiwo zamafu ezizimele nezomphakathi.
Izinhlangano eziningi zisebenzisa i-virtualization ukuze kwehliswe izindleko zengqalasizinda, zihlinzeke ngokutholakala okuphezulu, nokwenza lula ukutakula kwezinhlekelele. Ama-94% ochwepheshe be-SQL Server abahloliwe babika izinga elithile lokwenziwa kwezinto ezibonakalayo endaweni yabo. U-70% walabo abasebenzisa i-virtualization bakhethe i-VMware. Ama-60% anamazinga e-SQL Server virtualization angu-75% noma ngaphezulu. Ukwengeza, imiphumela yocwaningo iphakamisa ngokuqinile ukuthi ukutholakala okuphezulu kanye nokubuyiselwa kwezinhlekelele okusetshenziswe kungqimba lwe-virtualization sekube yizici ezibalulekile esinqumweni sokwenza ulwazi lwedatha ye-SQL Server lube ngokoqobo.
Izici ezintsha ku-SQL Server 2019
Inkundla yedatha ye-SQL Server 2019 ihlanganisa ububanzi obubanzi bobuchwepheshe, izici, kanye nezinsizakalo ezisekela izinhlelo zokusebenza ezibucayi njenge-analytics, imininingo egciniwe yebhizinisi, ubuhlakani bebhizinisi (i-BI), kanye nokucubungula okwenziwe nge-scalable transaction (OLTP). Inkundla ye-SQL Server izuze amandla okuphatha ukuhlanganiswa kwedatha, ukugcinwa kwedatha, ukubika nokuhlaziya okuthuthukile, amandla okuphindaphinda, kanye nokuphathwa kwezinhlobo zedatha enesakhiwo esincane. Yebo, akuwona wonke amaklayenti noma izinhlelo zokusebenza ezidinga zonke lezi zici. Ukwengeza, ezimweni eziningi kungcono ukuhlukanisa izinsizakalo ze-SQL Server usebenzisa i-virtualization.
Namuhla, amabhizinisi ngokuvamile adinga ukuthembela kumthamo omkhulu wedatha evela kuhlu olubanzi lwamasethi edatha akhula njalo. Nge-SQL Server 2019, ungathola imininingwane eseduze yesikhathi sangempela kuyo yonke idatha yakho. Amaqoqo e-SQL Server 2019 ahlinzeka ngendawo enesilinganiso esigcwele sokusebenza ngamasethi amakhulu edatha, okuhlanganisa ukusetshenziswa komshini wokufunda namandla obuhlakani bokwenziwa. Izici ezintsha ezinkulu nezibuyekezo ku-SQL Server 2019 zifakwe kuhlu .
I-Dell EMC Unity XT Mid-Range Storage System
Uchungechunge lwesitoreji lwe-Dell EMC Unity lwethulwa cishe eminyakeni emithathu edlule, futhi kusukela lapho sekuthengiswe izinhlelo ezingaphezu kuka-40. Amakhasimende ayalwazisa lolu hlu olumaphakathi nebanga ngobulula balo, ukusebenza kanye nokusebenza ngempumelelo kwezindleko. Amapulatifomu e-Dell EMC Unity XT midrange ayizixazululo zesitoreji okwabelwana ngazo eziletha ukubambezeleka okuphansi, ukuphuma okuphezulu, kanye nokuphathwa okuphansi kwemithwalo yemisebenzi ye-SQL Server. Wonke amasistimu e-Unity XT asebenzisa izakhiwo ze-dual storage processor (SP) ukuze asingathe i-I/O kanye nokusebenza kwedatha esebenzayo/esebenzayo. I-Unity XT dual SP isebenzisa uxhumo olugcwele lwangaphakathi lwe-000Gbps SAS kanye nesakhiwo sobunikazi esinama-multi-core architecture ukusebenza okuphezulu nokusebenza kahle. Izinhlaka zediski zikuvumela ukuthi unwebe umthamo wesitoreji usebenzisa amashalofu engeziwe.
I-Dell EMC Unity XT, isizukulwane esilandelayo samalungu afanayo (i-hybrid kanye ne-flash yonke), inyusa kakhulu ukusebenza, ithuthukisa ukusebenza kahle, futhi yengeza amakhono amasha nezinsizakalo zezindawo ezinamafu amaningi.
I-architecture ye-Unity XT ikuvumela ukuthi ucubungule idatha ngesikhathi esisodwa, wehlise umthamo wedatha, futhi usekele izinsiza ezifana nokuphindaphinda ngaphandle kokudela ukusebenza kohlelo lokusebenza. Uma kuqhathaniswa nesixazululo sesizukulwane sangaphambilini, ukusebenza kwesistimu yokugcina i-Dell EMC Unity XT kuphindwe kabili futhi isikhathi sokuphendula singu-75% ngokushesha. Futhi-ke, i-Dell EMC Unity isekela izinga le-NVMe.
Amasistimu wesitoreji anamadrayivu e-NVMe abonisa ukusebenza kwawo okuhle kakhulu ezinhlelweni ezizwelayo ukubambezeleka. Isibonelo, ezinhlelweni ezifana nesizindalwazi esikhulu, i-NVMe inikeza ukubambezeleka okuphansi kanye namazinga aphezulu aphezulu edatha. Ukubambezeleka okuncishisiwe kanye nokuvumelana okwenyukayo kuthuthukisa kakhulu ukusebenza kokufunda/ukubhala. Akukona nje ukuqondana ukuthi, ngokwesibikezelo se-IDC, ngo-2021, ama-flash arrays anokuxhumana kwe-NVMe kanye ne-NVMe-oF (NVMe over Fabric) azobala cishe ingxenye yayo yonke imali engenayo evela ekuthengisweni kwezinhlelo zokugcina zangaphandle emhlabeni.
Ama-algorithms wokucindezela idatha athuthukisa ukusebenza kahle kwesitoreji. I-Dell EMC Unity XT inganciphisa umthamo wedatha ngokufika izikhathi ezinhlanu. Enye inkomba ebalulekile ukusebenza kahle kohlelo lonke. I-Dell EMC Unity XT isebenzisa umthamo wesistimu ongu-85%. Ukucindezelwa nokuphindaphinda kwenziwa ngemodi engaphakathi komugqa - ezingeni lesilawuli. Idatha igcinwa kwifomu elicindezelwe. Isistimu iphinde izenzele umsebenzi ngezifinyezo zedatha.
Okusebenziseka kalula kwamalungu afanayo e-Unity flash anokufinyelela okuhlanganisiwe (ibhulokhi nefayela) anikeza izikhathi zokuphendula ezizinzile, ahlanganiswe namasevisi okulondoloza amafu, nokuthuthukiswa kosekelo ngaphandle kokuthuthwa kwedatha. Ekucushweni kwayo okuyisisekelo, le sistimu yokugcina izinto ezihlukahlukene ifaka emizuzwini engama-30.
Ubuchwepheshe bokugcina idatha obubizwa ngokuthi "amachibi ashukumisayo" bukuvumela ukuthi usuke ku-static uye ekwandiseni inkumbulo eguquguqukayo, inikeza ukuguquguquka okuphezulu kokusebenza kanye nokulula kokwandisa umthamo wesistimu. Amachibi anamandla onga umthamo kanye nesabelomali, futhi adinga isikhathi esincane ukuze akhe kabusha. Ukwandisa umthamo nokusebenza kwe-Dell EMC Unity akudingi ukuthuthwa kwedatha.
Izinkampani eziningi namuhla zisebenzisa izinsiza eziningi zamafu zomphakathi ngokuhlanganiswa nengqalasizinda yazo esemagcekeni. I-Dell EMC Unity XT ingasebenza njengengxenye yendawo ye-Dell Technologies Cloud. Lolu hlelo lwesitoreji lungasetshenziswa kumafu omphakathi futhi idatha ingadluliselwa kumafu ayimfihlo. Ngaphezu kwalokho, isitoreji se-Dell EMC Unity XT siyatholakala njengesevisi. Lena enye yezinsizakalo zokugcina amafu ze-Dell EMC Cloud Storage Services.
Isitoreji samafu siya ngokuya siduma ngoba singathuthukisa i-ROI ngokunciphisa izindleko zengqalasizinda. I-Cloud Storage Services inweba izikhungo zedatha yamakhasimende emafini ngokuletha isitoreji se-Dell EMC (exhunywe ngokuqondile kuzinsiza zamafu zomphakathi) njengesevisi. Abahlinzeki bezinkampani zangaphandle bangahlinzeka ngoxhumano lwamafu omphakathi olunesivinini esikhulu (ukubambezeleka okuphansi) ngokuqondile kuzinhlelo ze-Dell EMC Unity, PowerMax kanye ne-Isilon esikhungweni sedatha yekhasimende.
Umndeni we-Unity XT uhlanganisa i-Unity XT All-Flash, i-Unity XT Hybrid, i-UnityVSA nezinhlelo ze-Unity Cloud Edition.
I-Hybrid Ehlanganisiwe ne-Flash Arrays
I-Intel-based Unity XT Hybrid kanye ne-Unity XT All-Flash storage systems ihlinzeka ngezakhiwo ezididiyelwe zokufinyelela ibhulokhi, ukufinyelela kwefayela, nama-VMware VVols asekelwa i-network attached storage (NAS), iSCSI, kanye ne-Fiber Channel (FC). Amapulatifomu e-Unity XT Hybrid kanye ne-Unity XT All-Flash aselungile nge-NVMe.
I-Unity XT hybrid systems isekela izindawo ezinamafu amaningi. Amafu amaningi asho ukunweba isitoreji emafini noma ukuthunyelwa emafini ngezinketho eziguquguqukayo zokusetshenziswa kwensiza. Isitoreji se-Multicloud siklanyelwe ukuqinisekisa ukuhamba nokuphatheka kwedatha phakathi kwamapulatifomu amafu amaningana - ayimfihlo nesesidlangalaleni. Lokhu akuthinti kuphela izinqubo zokunyakaza kwedatha, kodwa futhi nenhlangano yokufinyelela kwesicelo kudatha kumafu amaningana omphakathi.
Lawa ma-hybrid arrays ahlinzeka ngamakhono alandelayo:
- Kulinganiswa kumthamo we-PB ongu-16.
- Amandla akhelwe ngaphakathi okunciphisa idatha awo wonke ama-flash pool.
- Ukufakwa okusheshayo nokucushwa (ngokwesilinganiso kuthatha imizuzu engama-25).
Ubuchwepheshe be-SSD buthuthuka ngokushesha, futhi imikhiqizo emisha yoguquko izongena emakethe eminyakeni ezayo. Okwamanje, izinhlangano zizoqhubeka nokufaka ama-SSD esikhundleni sama-HDD endabuko ukuze kwenziwe ngcono ukusebenza, ukuphatha kalula nokonga amandla. Isizukulwane esisha samalungu afanayo e-flash sizofaka isitoreji esizenzakalelayo esithuthuke kakhulu, ukuhlanganiswa kwamafu omphakathi, nokuvikelwa kwedatha okuhlanganisiwe.
Izinhlelo ze-Unity XT All-Flash ziletha isivinini, ukusebenza kahle, nokusekelwa kwamafu amaningi. Izici zabo:
- Ukukhiqiza okuphindwe kabili.
- Ukwehliswa kwedatha kufikela kokungu-7:1.
- Ukufakwa okusheshayo nokucushwa (inqubo ithatha imizuzu engaphansi kwengama-30).
UnityVSA
I-UnityVSA isitoreji esichazwe ngesoftware sezindawo ezibonakalayo ze-VMware ESXi kusetshenziswa iseva, okwabelwana ngayo, noma umthamo wokugcina amafu. I-UnityVSA HA, ukucushwa kwe-UnityVSA yesitoreji esikabili, inikeza ukubekezelela amaphutha okwengeziwe. Ukunikezwa kwesitoreji se-UnityVSA:
- Kufika ku-50 TB womthamo wesitoreji esihlanganisiwe onesici esigcwele.
- Ihambisana nezinhlelo nezici ze-Unity XT.
- Ukusekela amasistimu okutholakala okuphezulu (UnityVSA HA).
- Ukuxhumana njenge-NAS ne-iSCSI.
- Ukuphindaphinda kwedatha kusuka kwezinye izinkundla ze-Unity XT.
I-Unity Cloud Edition
Ngokuvumelanisa ifayela nemisebenzi yokutakula inhlekelele ngefu, umndeni we-Unity XT uhlanganisa i-Unity Cloud Edition, ehlinzeka:
- Amandla okulondoloza afakwe ngokugcwele kusetshenziswa isitoreji esichazwe yisoftware (SDS) esifakwe emafini.
- Khipha kalula ibhulokhi nesitoreji sefayela nge-VMware Cloud ku-AWS.
- Ukwesekwa kokutholwa kwenhlekelele, okuhlanganisa ukuhlola nokuhlaziywa kwedatha.
I-Unity XT Yonke I-Flash Yeseva ye-SQL
Umbiko we-Unisphere Research ka-2017, "I-SQL Server Transformation: Towards Agility and Resilience" () U-22% wabaphenduli babike ukuthi basebenzisa ubuchwepheshe bokugcinwa kwe-flash ekukhiqizeni (16%) noma bahlela ukwenza kanjalo (6%). U-30% usebenzisa ama-hybrid arrays afaka inkumbulo ye-flash. U-13% usebenzisa ama-flash array anamathisele ngqo. I-13% yenza ikhophi yasenqolobaneni yolwazi lwe-SQL Server ukuze ugcine i-flash.
Lokhu kwamukelwa okusheshayo kokugcinwa kwe-flash ukuze kusetshenziswe ne-SQL Server kusho ukuthi i-Unity XT All-Flash yamalungu afanayo ibafaneleke kahle kakhulu abathuthukisi be-SQL Server nabalawuli. Amasistimu e-Unity XT All-Flash ahlinzeka abathuthukisi beseva ye-SQL nabaphathi ngamakhono nokusebenza okudlula lokho okuhlinzekwa ngamanethiwekhi wendawo yokulondoloza (ama-SAN).
Amasistimu we-Unity XT All-Flash, alungele i-NVMe (ngokusebenza okuphezulu nakakhulu nokubambezeleka okuphansi), anefomu le-2U factor, asekela ama-dual-core processors, abalawuli ababili kumodi esebenzayo/esebenzayo.
Amamodeli we-Unity XT All-Flash
Ubunye XT
Amaprosesa
Inkumbulo (ngeprosesa ngayinye)
Ubukhulu. inani lamadrayivu
Ubukhulu. umthamo "oluhlaza" (PB)
380F
1 Intel E5-2603 v4
6c/1.7 GHz
64
500
2.4
480F
2 Intel Xeon Silver
4108 8c/1.8 GHz
96
750
4.0
680F
2 Intel Xeon Silver
4116 12c/2.1 GHz
192
1,000
8.0
880F
2 Intel Xeon Gold 6130
16c/2.1 GHz
384
1,500
16.0
Imininingwane ingatholakala ekucacisweni kohlu ().
Amachibi Okugcina
Ochwepheshe abaningi be-SQL Server bayazi ukuthi zonke izinhlobo zesitoreji zesimanje zinikeza ikhono lokuqoqa amadiski abe amayunithi esitoreji amakhulu anezinga elimisiwe lokuvikelwa kwe-RAID. Amaqembu ediski angawodwana anokuvikelwa kwe-RAID amachibi okugcina endabuko. Nakuba izinhlelo ezihlanganisiwe ze-Unity XT zisekela kuphela amachibi esintu, ama-Unity XT All-Flash array nawo anikezela ngamachibi okulondoloza aguqukayo. Ngamachibi okugcina aguquguqukayo, ukuvikelwa kwe-RAID kusetshenziswa emazingeni ediski—amayunithi okugcina amancane kunediski egcwele. Amachibi anamandla ahlinzeka ngokuguquguquka okukhulu ekuphatheni nasekukhuliseni amachibi ediski.
I-Dell EMC inikeza imikhuba engcono kakhulu yokuphatha amachibi okugcina ukuze kuzuzwe ukusebenza okuphezulu ngobunkimbinkimbi obuncane. Isibonelo, kunconywa ukunciphisa inani lamachibi okugcina e-Unity XT ukuze kwehliswe inkimbinkimbi futhi kwandiswe ukuguquguquka. Kodwa-ke, ukusetha amachibi okugcina engeziwe kungaba usizo kakhulu kwezinye izimo, kufaka phakathi lapho udinga:
- Sekela imithwalo yemisebenzi ehlukene ngamaphrofayili e-I/O ahlukene.
- Nikeza izinsiza ukuze uzuze amapharamitha athile okusebenza.
- Nikela izinsiza ezihlukene zokuqashwa kwabantu abaningi.
- Dala izizinda ezincane ukuze uvikele ekuhlulekeni
Amavolumu esitoreji (LUNs)
Ubhalansisa kanjani ukulawula kanye nokuvumelana nezimo lapho ukhetha inani lamavolumu ohlwini? Ukuze uthole ukuguquguquka okukhulu ku-Unity ne-SQL Server, kuyanconywa ukuthi udale amavolumu wefayela ngalinye lesizindalwazi. Empeleni, izinhlangano eziningi zithatha indlela enezigaba, lapho imininingwane egciniwe ebalulekile inikezwa ukuguquguquka okukhulu futhi amafayela esizindalwazi angabalulekile aqoqwe kumavolumu ambalwa, amakhulu. Sincoma ukuthi ubuyekeze zonke izidingo zolwazi kanye nanoma yiziphi izinhlelo zokusebenza ezihambisanayo ngoba ukuvikelwa kwedatha nobuchwepheshe bokuqapha buncike ekuhlukaniseni amafayela nasekubekweni kwawo.
Amavolumu amaningi ngokuvamile kungaba nzima ukuwaphatha, ikakhulukazi ezindaweni ezibonakalayo. Izimo ze-Virtualized SQL Server ziyisibonelo esihle lapho ukusingathwa kwezinhlobo zamafayela amaningi ngevolumu eyodwa kungenza umqondo. Umqondisi wesizindalwazi noma umqondisi wesitoreji (noma kokubili) kufanele akhethe ibhalansi efanele phakathi kokuguquguquka nokulondolozeka lapho enquma inani lamavolumu azokwakhiwa.
Isitoreji sefayela
Amaseva e-NAS abamba izinhlelo zamafayela kusitoreji se-Unity XT. Amasistimu wamafayela angafinyelelwa kusetshenziswa izivumelwano ze-SMB noma ze-NFS, futhi ngohlelo lwefayela olunamaphrothokholi amaningi, ungasebenzisa zombili izivumelwano kanye kanye. Amaseva e-NAS asebenzisa izixhumanisi ezibonakalayo ukuze axhume umsingathi ku-SMB, NFS, nezinhlelo zefayela le-multiprotocol, kanye nesitoreji se-VMware NFS kanye namavolumu abonakalayo e-VMware. Amasistimu wefayela nezindawo zokusebenzelana ezibonakalayo zihlukaniswa phakathi kweseva eyodwa ye-NAS, okuvumela amaseva amaningi e-NAS ukuthi asetshenziselwe ukuqashwa okuningi. Amaseva e-NAS ahluleka ngokuzenzakalelayo uma iprosesa yesitoreji yehluleka. Amasistimu wabo wefayela ahlobene nawo ahluleka.
I-SQL Server 2012 (11.x) nezinguqulo zakamuva zisekela I-Server Message Block (SMB) 3.0, evumela ukwabelana kwefayela lenethiwekhi ukuze kugcinwe. Kokubili ukufakwa kweqoqo elizimele kanye nele-faillover, ungafaka izizindalwazi zesistimu (okuyinhloko, imodeli, i-msdb, ne-temdb) kanye nemininingo egciniwe yolwazi yabasebenzisi be-Database Engine ngenketho yokugcina ye-SMB. Ukusebenzisa isitoreji se-SMB kuyinketho enhle uma usebenzisa Amaqembu Ahlala Akhona Atholakalayo ngoba ukwabelana kwefayela kudinga ukufinyelela esisetshenziswa senethiwekhi esitholakala kakhulu.
Ukudala amasheya efayela le-SMB ukuze kusetshenziswe i-SQL Server enesitoreji se-Unity XT kuyisinyathelo esilula senqubo ezinyathelo ezintathu: udala iseva ye-NAS, isistimu yefayela, kanye nesabelo se-SMB. Isofthiwe ye-Dell EMC Unisphere Storage Management ihlanganisa isilekeleli sokumisa ukuze sikusize uqedele le nqubo. Nokho, lapho usingatha imithwalo yomsebenzi ye-SQL Server ekwabiweni kwefayela le-SMB, kunokucatshangelwa okubalulekile okufanele kukhunjulwe okungasebenzi ekusetshenzisweni kwamasheya efayela le-SMB. I-Microsoft ihlanganise uhlu lwezinkinga zokufakwa nezokuphepha kanye nezindaba ezaziwayo njengamanje; Ukuze uthole imininingwane, bheka "Ukufaka i-SQL Server Nge-SMB File Storage" ku .
Izifinyezo zedatha
Idatha isiphenduke insiza ebaluleke kakhulu yenkampani, futhi izindawo zanamuhla ezibaluleke kakhulu kumgomo zidinga okungaphezu nje kokungadingeki. Kuyadingeka ukuthi izicelo zihlale ziku-inthanethi, zihlinzekwe ngokusebenza okungaphazamiseki nezibuyekezo. Futhi zidinga ukusebenza okuphezulu nokutholakala kwedatha ngezinketho ezifana nokuphindaphinda kwesifinyezo sendawo nokuphindaphinda okukude.
Uhlu lwesitoreji se-Unity XT lunikeza amandla okuvimba kanye nefayela abelana ngokugeleza komsebenzi okuvamile, ukusebenza, kanye nezakhiwo. Indlela yesifinyezo ye-Unity inikeza indlela elula nesebenzayo yokuvikela idatha. Izifinyezo zikwenza kube lula ukubuyisela idatha - ukubuyisela emuva kusifinyezo sangaphambili, noma ungakopisha idatha ekhethiwe kusifinyezo sangaphambilini. Ithebula elilandelayo libonisa izikhathi zokugcina izifinyezo zamasistimu e-Unity XT.
Isitoreji sasendaweni nesikude sezifinyezo zedatha
Uhlobo lwesithombe
CLI
UI
I-REST
Ngesandla
Kuhlelwe
Ngesandla
Kuhlelwe
Ngesandla
Kuhlelwe
Indawo
Unyaka we-1
Unyaka we-1
Eminyakeni 5
Amaviki angu-4
Eminyakeni 100
Ngaphandle kweMingcele
Ukude
Eminyakeni 5
Amaviki angu-255
Eminyakeni 5
Amaviki angu-255
Eminyakeni 5
Amaviki angu-255
Izifinyezo azithatheli indawo eqondile ezinye izindlela zokuvikela idatha, njengezipele. Bangakwazi ukuhambisana nekhophi yasenqolobaneni evamile kuphela njengomugqa wokuqala wokuzivikela ezimweni eziphansi ze-RTO.
Isici sesifinyezo se-Dell EMC Unity sihlanganisa ukuncishiswa kwedatha kanye nokuphindaphinda okuthuthukisiwe. Izifinyezo nazo ziyazuza ekongeni kwesikhala okutholwa kusisetshenziswa sokugcina soqobo. Uma uthatha isifinyezo sesisetshenziswa sesitoreji esisekela izici zokunciphisa idatha, idatha emthonjeni ingacindezelwa noma iphindwe kabili.
Nawa amanye amanothi amayelana nokutholwa kwedathabheyisi lapho usebenzisa izifinyezo ezinemininingwane yolwazi ye-SQL Server:
- Zonke izingxenye zesizindalwazi Seseva ye-SQL kufanele zivikelwe njengesethi yedatha. Uma idatha namafayela okungena kukuma-LUN ahlukene, lawo ma-LUN kufanele abe yingxenye yeqembu lokufana. Iqembu elingaguquki liqinisekisa ukuthi isifinyezo sithathwa ngesikhathi esisodwa kuwo wonke ama-LUN eqenjini. Uma idatha namafayela okungena ekwabiweni okuningi kwefayela le-SMB, amasheya kufanele abe ohlelweni lwefayela olufanayo.
- Lapho ubuyisela imininingo egciniwe Yeseva ye-SQL kusukela kusifinyezo esisekelwe kubhulokhi, uma isibonelo seseva ye-SQL kufanele sihlale sixhumekile, sebenzisa ukujoyina kosokhaya we-Unisphere. Ukuthola kabusha okusekelwe kufayela, ukwabelana okwengeziwe kwe-SMB kwakhiwa kusetshenziswa isifinyezo njengomthombo. Uma amavolumu esenyusiwe, isizindalwazi singanamathiselwa ngaphansi kwegama elihlukile noma isizindalwazi esikhona singashintshwa kufakwe esibuyiselwe.
- Lapho wenza ukubuyisela usebenzisa indlela ye-Snapshot Restore ku-Unisphere, thatha isenzakalo se-SQL Server ungaxhunyiwe ku-inthanethi. Iseva ye-SQL ayikwazi ukubuyisela ukusebenza. Ukuthatha isibonelo ungaxhunyiwe ku-inthanethi kuqinisekisa ukuthi amavolumu awonakaliswa yi-database ebhala ngaphambi kokuthola. Uma isibonelo sesiqaliswe kabusha, ukutakula kwenhlekelele Yeseva ye-SQL kuzoletha imininingwane egciniwe esimweni esingaguquki.
- Nika amandla izifinyezo zezinto eziningi zesitoreji ngesikhathi esisodwa, bese uqinisekisa ukuthi isistimu ikumodi yokusebenza enconyiwe ngaphambi kokunika amandla izifinyezo ezengeziwe.
Ukuzenzakalela nokuhlela amashothi
Izifinyezo ku-Unity XT zingenziwa ngokuzenzakalelayo. Izinketho ezilandelayo zesifinyezo ezizenzakalelayo ziyatholakala ekuphathweni kwesitoreji se-Unisphere: ukuvikela okuzenzakalelayo, ukuvikela okufushane kokugcinwa, nokuvikela ukugcina isikhathi eside. Inketho ngayinye ithatha izifinyezo zansuku zonke futhi izigcinele izikhathi ezihlukene.
Ungakhetha eyodwa (noma kokubili) yezinketho zokuhlela - njalo ngamahora angu-x (kusuka ku-1 ukuya ku-24) kanye nosuku/ngeviki. Ukuhlela isifinyezo sansuku zonke/kwamaviki onke kukuvumela ukuthi ucacise izikhathi nezinsuku ezithile zokuthi izifinyezo zithathwe. Kunketho ngayinye ekhethiwe, kufanele usethe inqubomgomo yokugcinwa, engalungiselelwa ukuthi isuse ngokuzenzakalela ichibi noma iligcine okwesikhashana.
Ulwazi olwengeziwe mayelana nezifinyezo ze-Unity - at .
Ama-clones azacile
I-clone ezacile ikhophi efundwayo/ebhalwayo yesisetshenziswa sokulondoloza ibhulokhi elincanyana, njengevolumu, iqembu elivumelanayo, noma isitolo sedatha se-VMware VMFS, esabelana ngamabhulokhi nensiza yaso engumzali. Ama-clones azacile ayindlela enhle yokwethula ngokushesha nangokuhlangene amakhophi esizindalwazi se-SQL Server, into amathuluzi endabuko e-SQL Server angeke akwazi ukuyifinyelela. Uma i-clone encane yethulwe kumsingathi, amavolumu angalethwa ku-inthanethi futhi isizindalwazi sizonamathiselwa kusetshenziswa indlela ye-DB Namathisela ku-SQL Server.
Uma usebenzisa isici sokuthuthukisa esinama-clones azacile, thatha zonke izingosi zolwazi ku-clone encane ungaxhunyiwe ku-inthanethi. Lokhu kufanele kwenziwe ngaphambi kokusebenza kokuvuselela. Ukwehluleka ukuthatha isizindalwazi ungaxhunyiwe ku-inthanethi ngaphambi kokwenza ngcono kungase kubangele amaphutha okungahambisani nedatha noma imiphumela yedatha engalungile kuseva ye-SQL.
Ukuphindaphinda idatha
Ukuphindaphinda isici sesofthiwe esivumelanisa idatha nesistimu yesilawuli kude kusayithi efanayo noma kwenye indawo. Izinketho zokuphindaphinda nokumisa ze-Unity zikuvumela ukuthi ukhethe indlela ephumelelayo yokuhlangabezana nezidingo ze-RTO/RPO zolwazi lwesizindalwazi se-SQL Server kuyilapho ubhalansisa ukusebenza kanye nokuphumayo.
Lapho usebenzisa i-Dell EMC Unity Replication ukuze uvikele isizindalwazi Seseva ye-SQL kumavolumu amaningi, kufanele ubeke umkhawulo kuyo yonke idatha namavolumu welogi kusizindalwazi eqenjini elilodwa lokungaguquguquki noma uhlelo lwefayela. Ukuphindaphinda bese kusethwa eqenjini noma kusistimu yefayela futhi kungabandakanya amavolumu noma amasheya esizindalwazi esiningi. Imininingo egciniwe edinga izinketho ezihlukene zokuphindaphinda kufanele ibe kuma-LUN ahlukene, amaqembu afanayo, noma izinhlelo zamafayela.
Ama-clones azacile ahambisana nakho kokubili ukuphindaphinda okuvumelanayo nokungavumelani. Uma i-clone encane iphindaphindwa endaweni okuyiwa kuyo, iba ikhophi egcwele yevolumu, iqembu elivumelanayo, noma isitoreji se-VMFS. Ngemuva kokuphindaphinda, i-clone encane iyivolumu ezimele ngokuphelele enezilungiselelo zayo.
Inqubo yokuphindaphinda ama-clone amancane phakathi komthombo namasistimu okuqondiwe.
Ukuphindwaphindwa kwesizindalwazi se-temdb akudingekile ngenxa yokuthi ifayela lakhiwa kabusha lapho i-SQL Server iqalwa kabusha, ngakho-ke imethadatha ayihambisani nendlela yezinye izimo ze-SQL Server. Ukukhetha ngokucophelela amavolumu azophindaphinda futhi okuqukethwe kulawo mavolumu kususa ithrafikhi ephindaphindayo engenasidingo.
I-Microsoft SQL Server Data Copy Management Edidiyelwe
Imikhiqizo eminingi yesimanje yokugcina (okuhlanganisa yonke imikhiqizo ye-Dell EMC) ingakha amakhophi "ahambisanayo esistimu" anoma yiluphi uhlobo lwefayela ngokuthi:
- Ukuhleleka kokubhala okungaguquki yisistimu yokusebenza kuwo wonke amazinga - ukusuka kumsingathi kuya kudrayivu.
- Ukuqoqa amavolumu ukuze amafayela amaningi kumavolumu ahlukene agcine ukuhleleka kokubhala.
Ngokutholwa okusabalele kwemishini yokugcina izinto, iMicrosoft ithuthukise i-API yabahlinzeki besitoreji. Le API ivumela abahlinzeki besitoreji ukuthi baxhumanise nesofthiwe yesizindalwazi se-SQL Server ukuze bakhe "amakhophi angaguquki kuhlelo lokusebenza" kusetshenziswa i-Volume Shadow Copy Service (VSS). Lawa makhophi alingisa ukusebenzisana phakathi kwe-SQL Server nesistimu yokusebenza phakathi neshejuli kanye nokuvalwa kwe-SQL Server. Wonke amabhafa okubhala ayasuswa futhi okwenziwayo kuyamiswa kuze kube yilapho wonke amadiski ebuyekezwa futhi angaguquguquki ngesikhathi esithile, esirekhodwa kulogi ye-SQL.
Isofthiwe ye-Dell EMC AppSync ehlanganiswe nezifinyezo ze-Unity XT yenza kube lula futhi yenze ngokuzenzakalela inqubo yokudala, ukusebenzisa, nokuphatha amakhophi angaguquguquki ohlelo lokusebenza edatha yomsebenzi. Le softhiwe ihloselwe ukusetshenziswa kuzimo zokulawula ikhophi ukuze kutholakale futhi isetshenziswe kabusha.
Isofthiwe ye-AppSync ithola ngokuzenzakalelayo imininingo egciniwe yohlelo lokusebenza, ifunda ukwakheka kwesizindalwazi, futhi imephu isakhiwo sefayela ngokusebenzisa izingxenyekazi zekhompuyutha noma izendlalelo ze-virtualization kuya kusitoreji esiyisisekelo se-Unity XT. Ihlela zonke izinyathelo ezidingekayo, kusukela ekudaleni nasekuqinisekiseni ikhophi kuya ekukhwezeni izifinyezo kumsingathi oqondiwe kanye nokuqala noma ukubuyisela isizindalwazi. I-AppSync isekela futhi yenze kube lula ukugeleza komsebenzi Weseva ye-SQL okufaka ukubuyekeza nokubuyisela imininingo egciniwe yokukhiqiza.
Ukwehliswa kwedatha kanye nokudonswa okuthuthukile
Umndeni wakwa-Dell EMC Unity wezinhlelo zokugcina unikeza izinsiza ezicebile, okulula ukuzisebenzisa zokunciphisa idatha. Ukonga akufinyelelwa kuphela ezinsizeni zokulondoloza ezimisiwe, kodwa nasezifinyezweni nama-clones azacile alezi zinsiza. Izifinyezo nama-clone azacile njengefa ukulungiselelwa kokunciphisa idatha kusitoreji somthombo, okwandisa ukonga umthamo.
Isici sokunciphisa idatha sihlanganisa ukuphindaphinda, ukuminyanisa, kanye nemisebenzi yokuthola ibhulokhi elinguziro, okungenzeka kukhuliswe inani lesikhala sokulondoloza esisebenzisekayo sezinto zomsebenzisi nokusetshenziswa kwangaphakathi. Isici sokunciphisa idatha ye-Unity XT singena esikhundleni sesici sokucindezela ku-Unity OE 4.3 nakamuva. Ukucindezela kuyi-algorithm yokunciphisa idatha enganciphisa ukunikezwa ngokomzimba komthamo odingekayo ukuze kugcinwe isethi yedatha.
Amasistimu e-Unity XT aphinde anikeze isici esithuthukisiwe sokudonsela phansi esinganikwa amandla uma ukuncishiswa kwedatha kunikwe amandla. Ukudonswa kabili okuthuthukile kunciphisa umthamo odingekayo kudatha yomsebenzisi ngokugcina kuphela inani elincane lamakhophi (ngokuvamile ikhophi eyodwa) yamabhulokhi edatha ye-Unity. Indawo yokukhipha i-LUN eyodwa. Naka lokhu lapho ukhetha uhlelo lokugcina. Ama-LUN ambalwa aphumela ekuncishisweni okungcono, kodwa ama-LUN amaningi ahlinzeka ngokusebenza okungcono.
Ukonga amandla kusuka ekudonselweni okuthuthukile kunganikeza inzuzo enkulu kakhulu ezindaweni eziningi, kodwa futhi kudinga ukusetshenziswa kwamaphrosesa we-Unity array. Ku-OE 5.0, ukudonswa okuthuthukisiwe, uma kunikwe amandla, kukhipha noma iyiphi ibhulokhi (ecindezelwe noma engacindezelwanga). Ukuze uthole ukwaziswa okwengeziwe, bheka .
Ithebula elilandelayo libonisa ukulungiselelwa okusekelwayo kokunciphisa idatha kanye nokuphindaphinda okuthuthukile:
Ukwehliswa kwedatha ku-Unity (wonke amamodeli) nosekelo oluthuthukisiwe lokudonsa
Inguqulo ye-Unity OE
Ubuchwepheshe
Uhlobo lwechibi olusekelwe
Amamodeli Asekelwe
4.3 / 4.4
Ukuncishiswa kwedatha
I-Flash memory pool - yendabuko noma enamandla
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
4.5
Ukuncishiswa kwedatha
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
Ukwehliswa kwedatha nokukhishwa okuthuthukile*
450F, 550F, 650F
5
Ukuncishiswa kwedatha
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F, XNUMXF, XNUMXF
Ukwehliswa kwedatha kanye nokudonswa okuthuthukile
450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F
* Ukwehliswa kwedatha kukhutshaziwe ngokuzenzakalela futhi kufanele kuvulwe ngaphambi kokuthi ukudonswa okuthuthukile kube inketho etholakalayo. Ngemva kokunika amandla ukuncishiswa kwedatha, ukudonswa okuthuthukile kuyatholakala, kodwa kukhutshazwa ngokuzenzakalela.
Ukwehliswa kwedatha ku-Unity kanye nokucindezelwa kwedatha ku-SQL Server
I-SQL Server 2008 Enterprise Edition yaba ukukhululwa kokuqala ukunikeza amakhono omdabu okucindezela idatha. I-SQL Server 2008 izinga lomugqa kanye nokucindezelwa kwezinga lekhasi kusebenzisa ulwazi lwefomethi yethebula lesizindalwazi sangaphakathi se-SQL Server ukuze kuncishiswe isikhala esidliwa izinto zesizindalwazi. Ukunciphisa isikhala kukuvumela ukuthi ugcine imigqa eyengeziwe ngekhasi ngalinye namakhasi engeziwe ku-pool yebhafa. Ngenxa yokuthi idatha engagciniwe ngefomethi yekhasi ledatha engu-8k, njengedatha engaphandle kwerowu njenge-NVARCHAR(MAX), ngeke isebenzise izindlela zokuminyanisa amarowu noma ikhasi, i-Microsoft yethule imisebenzi ye-Transact-SQL COMPRESS kanye ne-DECOMPRESS.
Le misebenzi isebenzisa indlela evamile yokuminyanisa idatha (i-algorithm ye-GZIP) okumele ibizwe ukuze isigaba ngasinye sedatha sicindezelwe noma sicindezelwe.
Ukucindezelwa kwe-Unity XT, okungagcini nje ku-SQL Server, kusebenzisa i-algorithm yesofthiwe ukuhlaziya nokucindezela idatha yesitoreji. Kusukela ekukhululweni kwe-Unity OE 4.1, ukucindezelwa kwedatha ye-Unity bekulokhu kutholakala kumavolumu okugcinwa kwebhulokhi kanye nezitolo zedatha ye-VMFS ku-flash pool. Kusukela nge-Unity OE 4.2, ukucindezela kuyatholakala futhi ezinhlelweni zamafayela kanye nezitolo zedatha ye-NFS kumachibi okugcina ama-flash.
Ukukhethwa kwendlela yokucindezela idatha ye-SQL Server kuncike ezintweni ezimbalwa. Lezi zici zifaka phakathi uhlobo lokuqukethwe kusizindalwazi, izinsiza ezitholakalayo ze-CPU - kukho kokubili isitoreji kanye namaseva esizindalwazi, kanye nezinsiza ze-I/O ezidingekayo ukuze kugcinwe i-SLA. Ngokuvamile, ungalindela ukonga okwengeziwe kwesikhala sedatha ecindezelwe kusetshenziswa i-SQL Server, kodwa idatha ecindezelwe kusetshenziswa isici sokuminyanisa se-TSQL's GZIP mancane amathuba okuba ibone ukonga kwesikhala okungeziwe okuvela ezicini zokuminyanisa ze-Unity XT njengoba izinzuzo eziningi zivela kwedlule. i-algorithm.
Ukucindezelwa kobumbano kunikeza ukonga isikhala uma idatha entweni egciniwe icindezelwa okungenani ngama-25%. Ngaphambi kokunika amandla ukuminyanisa entweni yokugcina, thola ukuthi iqukethe idatha engacindezelwa. Unganiki amandla ukucindezela entweni yokugcina ngaphandle uma ukwenza kanjalo kuzosindisa umthamo.
Lapho unquma ukuthi uzosebenzisa ukuncishiswa kwedatha ye-Unity, ukucindezela kwezinga lesizindalwazi se-SQL Server, noma kokubili, cabangela lokhu okulandelayo:
- Idatha ebhalelwe kusistimu yobumbano iqinisekiswa umsingathi ngemva kokuba igcinwe kunqolobane yesistimu. Kodwa-ke, inqubo yokucindezela ayiqali kuze kube yilapho inqolobane isuliwe.
- Ukonga kokucindezelwa akufinyelelwa kuphela ezinsizeni zokugcina ze-Unity XT, kodwa futhi nezifinyezo nama-clone amancane wensiza.
- Phakathi nenqubo yokuminyanisa, amabhlogo amaningi ahlanganiswa kusetshenziswa i-algorithm yesampula ukuze kunqunywe ukuthi idatha ingacindezelwa yini. Uma i-algorithm yesampula inquma ukuthi ukonga okuncane kuphela okungafinyelelwa, khona-ke ukucindezela kuyeqiwa futhi idatha ibhalwa echibini.
- Uma idatha icindezelwa ngaphambi kokuba ibhalwe kumidiya yokugcina, inani lokuphathwa kwedatha liyancipha kakhulu. Ngakho-ke, ukucindezela kusiza ukunciphisa ukuguga nokudabuka kumemori ye-flash ngokunciphisa inani ledatha elibhalwe kudrayivu.
Ukuze uthole ulwazi olwengeziwe mayelana nokucindezelwa komugqa nekhasi ku-SQL Server yamathebula nezinkomba, bheka .
Ungakhohlwa ukuthi noma yikuphi ukucindezela kudinga izinsiza ze-CPU. Uma izidingo zomkhawulokudonsa ziphezulu, ukucindezela kungaba nomthelela omkhulu ekusebenzeni. Izilinganiso zokubhala eziphezulu zomthwalo wokusebenza we-OLAP nazo zinganciphisa izinzuzo zokucindezelwa kwesizindalwazi se-SQL Server.
I-Dell EMC icwaninge ukonga okungaba khona kusetshenziswa amanani omhlaba wangempela okunciphisa idatha ku-Unity array. Ithimba liqoqe idatha ngemishini ebonakalayo ye-VMware, ukwabelana ngamafayela, imininingwane yolwazi ye-SQL Server, imishini ebonakalayo ye-Microsoft Hyper-V, njll.
Imiphumela yocwaningo ibonise ukuthi ukuncishiswa kosayizi wefayela lokungena le-SQL Server cishe kuncane izikhathi eziyi-10 kunefayela ledatha:
- Usayizi wesizindalwazi = 1,49:1 (32,96%)
- Ivolumu yelogi = 12,9:1 (92,25%)
Isizindalwazi se-SQL Server sinikezwe imiqulu emibili. Amafayela esizindalwazi agcinwa kuvolumu eyodwa futhi amalogi okwenziwayo agcinwa kwenye. Ukusebenzisa ubuchwepheshe bokuncishiswa kwedatha ngamavolumu esizindalwazi kunganikeza ukugcinwa kokulondoloza; kodwa-ke, kufanele ucabangele umthelela wokusebenza lapho unquma ukuthi ungavumela yini ukudonswa kwevolumu kumavolumu esizindalwazi. Nakuba ukuncishiswa kwangempela kosayizi wesizindalwazi kungase kwehluke kuye ngedatha egciniwe, imiphumela yocwaningo ibonise ukuthi indawo yokugcina ilogu ye-SQL Server .
Izinqubo ezihamba phambili zokunciphisa idatha
Ngaphambi kokunika amandla ukuncishiswa kwedatha entweni yesitoreji, cabangela imihlahlandlela elandelayo:
- Sebenzisa ukuqapha kwesistimu yesitoreji ukuze uqinisekise ukuthi inezinsiza ezitholakalayo zokusekela ukuncishiswa kwedatha.
- Nika amandla ukuncishiswa kwedatha ezintweni eziningi zesitoreji ngesikhathi esisodwa. Gada isistimu ukuze uqiniseke ukuthi isesimweni sokusebenza esinconyiwe ngaphambi kokuyivula kumasayithi okugcina engeziwe.
- Kumamodeli e-Unity XT x80F, ukuncishiswa kwedatha kuzonikeza ukonga umthamo uma idatha kuyunithi yokulondoloza icindezelwa okungenani ngo-1%.
Ukwehliswa kwedatha kumamodeli wangaphambilini we-Unity x80F asebenzisa i-OE 5.0 kunikeze ukonga inqobo nje uma idatha ibicindezela okungenani ngo-25%.
- Ngaphambi kokunika amandla ukuncishiswa kwedatha entweni egciniwe, thola ukuthi ingabe into iqukethe idatha ecindezelayo. Izinhlobo ezithile zedatha, njengevidiyo, umsindo, izithombe, nedatha kanambambili, ngokuvamile zinikeza inzuzo encane ngokuminyanisa. Unganiki amandla ukuncishiswa kwedatha entweni yokugcina uma singeke sibe khona ukulondolozwa kwesikhala.
- Cabangela ukukhetha ngokucindezela ivolumu yedatha yefayela elicindezela kahle.
I-VMware Virtualization
I-VMware vSphere iyinkundla esebenza kahle futhi evikelekile yokwenza izinto ezibonakalayo kanye nezindawo zamafu. Izingxenye ezibalulekile ze-vSphere yi-VMware vCenter Server kanye ne-VMware ESXi hypervisor.
I-vCenter Server iyinkundla yokuphatha ehlanganisiwe yezindawo ze-vSphere. Kulula ukuyisebenzisa futhi ithuthukisa ngokuqhubekayo izinsiza. I-ESXi iyi-hypervisor yomthombo ovulekile efaka ngokuqondile kumaseva aphathekayo. I-ESXi inokufinyelela okuqondile kuzinsiza eziyinhloko futhi incane ngosayizi ku-150MB, inciphisa izidingo zememori. Iletha ukusebenza okuthembekile kwezinhlelo zokusebenza ezihlukahlukene futhi isekela ukulungiselelwa komshini onamandla okubonakalayo—kufika kuma-vCPU angu-128, i-6 TB ye-RAM, namadivayisi angu-120.
Ukuze i-SQL Server isebenze ngempumelelo kuhadiwe yesimanje, isistimu yokusebenza ye-SQL Server (SQLOS) kufanele iqonde ukwakheka kwehadiwe. Ngokufika kwezinhlelo ze-multi-core kanye ne-multi-node non-uniform memory access (NUMA), ukuqonda ubudlelwano phakathi kwama-cores, ama-logic processors, nama-processor aphathekayo sekubaluleke kakhulu.
Amaprosesa
I-Virtual Processing Unit (vCPU) iyunithi yokucubungula emaphakathi ebonakalayo eyabelwe umshini we-virtual. Isamba senani lama-vCPU anikeziwe libalwa ngokuthi:
Total vCPU = (количество виртуальных сокетов) * (количество виртуальных ядер на сокет)Uma ukusebenza okungaguquki kubalulekile, i-VMware incoma ukuthi inani eliphelele lama-vCPU abelwe yonke imishini ebonakalayo akufanele lidlule inani lengqikithi yama-cores atholakalayo kumsingathi we-ESXi, kodwa ungakwazi ukwandisa inani lama-vCPU abiwe uma ukuqapha kubonisa ukuthi izinsiza ze-CPU ezingasetshenzisiwe. ayatholakala.
Kumasistimu ane-Intel Hyper-Threading Technology enikwe amandla, inani lama-logical cores (vCPUs) liphinda kabili inani lamacores aphathekayo. Kulokhu, unganikezi inani eliphelele lama-vCPU.
Imithwalo yemisebenzi ye-Lower-tier SQL Server ithintwa kancane ukuhlukahluka kwe-latency. Ngakho, le mithwalo yomsebenzi ingasebenza kubabungazi abanesilinganiso esiphezulu sama-vCPU kuma-CPU aphathekayo. Amazinga okusetshenziswa kwe-CPU anengqondo angakhuphula ukusebenza kwesistimu iyonke, akhulise ukonga amalayisense, futhi alondoloze ukusebenza okwanele.
I-Intel Hyper-Threading ivamise ukuthuthukisa ukudlula kosokhaya kukonke ngo-10% kuya ku-30%, iphakamisa isilinganiso se-vCPU ne-CPU esibonakalayo esingu-1,1 kuya ku-1,3. I-VMware incoma ukunika amandla i-Hyper-Threading ku-UEFI BIOS noma nini lapho kungenzeka khona ukuze i-ESXi ikwazi ukusizakala ngalobu buchwepheshe. I-VMware futhi incoma ukuhlola nokuqapha okuphelele lapho usebenzisa i-Hyper-Threading ye-SQL Server imithwalo yomsebenzi.
inkumbulo
Cishe wonke amaseva esimanje asebenzisa i-architecture ye-non-uniform memory access (NUMA) yokuxhumana phakathi kwenkumbulo eyinhloko namaphrosesa. I-NUMA iyisakhiwo sezingxenyekazi zekhompuyutha zememori eyabiwe esebenzisa ukuhlukaniswa kwamabhulokhi wememori ebonakalayo phakathi kwamaphrosesa aphathekayo. I-NUMA node iyisokhethi ye-CPU eyodwa noma ngaphezulu kanye nebhulokhi yememori enikeziwe.
I-NUMA kube yisihloko okukhulunywa ngaso kakhulu kule minyaka eyishumi edlule. Ukuxaka okuhlobene kwe-NUMA kungenxa yengxenye yokusetshenziswa okuvela kubathengisi abahlukene. Ezimweni ezenziwe nge-virtual, inkimbinkimbi ye-NUMA nayo inqunywa ngenani lezinketho zokumisa nezendlalelo—kusuka ku-hardware ukuya ku-hypervisor kuya ohlelweni lokusebenza lwesivakashi futhi ekugcineni kuye kuhlelo lokusebenza lwe-SQL Server. Ukuqonda kahle i-NUMA hardware architecture kuyadingeka kunoma iyiphi i-SQL Server DBA esebenzisa i-virtualized SQL Server.
Ukuze kuzuzwe ukusebenza kahle okukhulu kumaseva anenani elikhulu lama-cores, iMicrosoft yethule iSoftNUMA. Isofthiwe ye-SoftNUMA ikuvumela ukuthi uhlukanise izinsiza ezitholakalayo ze-CPU ngaphakathi kwe-NUMA eyodwa kuma-node amaningi we-SoftNUMA. Ngokusho kwe-VMware, iSoftNUMA iyahambisana ne-VMware's virtual NUMA (vNUMA) topology futhi ingathuthukisa ukuqina kwenjini yedatha kanye nokusebenza kwemisebenzi eminingi...
Lapho usebenzisa i-VMware ngokusetshenziswa kwe-SQL Server:
- Gada imishini ebonakalayo ukuze uthole izinsiza zememori ephansi ze-SQL Server Database Engine. Le nkinga ibangela ukwanda kwe-I/O nokusebenza okuncishisiwe.
- Ukuze uthuthukise ukusebenza, vimbela ukungqubuzana kwenkumbulo phakathi kwemishini ebonakalayo ngokugwema ukugcwala kwememori ezingeni lokusingatha le-ESXi.
- Cabangela ukuhlola izingxenyekazi zekhompuyutha ze-NUMA zokwabiwa kwememori ebonakalayo ukuze unqume inani eliphakeme lememori elingabelwa umshini obonakalayo ngaphakathi kwemingcele ebonakalayo ye-NUMA.
- Uma ukuzuza ukusebenza okwanele kuwumgomo oyinhloko, cabanga ukugcina inkumbulo elingana nenkumbulo eyabiwe. Lesi silungiselelo sepharamitha siqinisekisa ukuthi umshini we-virtual uthola inkumbulo engokomzimba kuphela.
Isitoreji esibonakalayo
Ukusetha indawo yokulondoloza endaweni engokoqobo kudinga ulwazi lwengqalasizinda yokugcina. Njengaku-NUMA, udinga ukuqonda ukuthi amazinga ahlukene e-I/O asebenza kanjani - kulokhu, kusukela ekusetshenzisweni kwe-VM, ukuya ekufundeni ngokomzimba nokubhala kolwazi endaweni yokugcina eqhubekayo.
I-vSphere ihlinzeka ngenani lezinketho zokumisa isitoreji, ezinezinhlelo zokusebenza eziwusizo ekusetshenzisweni kweseva ye-SQL ngohlelo lwe-Unity XT. I-FS VMFS iyindlela esetshenziswa kakhulu yokugcina idatha ezinhlelweni zokugcina amabhulokhi njenge-Unity XT. Amalungu afanayo e-Unity XT iyisigaba esingezansi esihlanganisa amadrayivu aphathekayo adalulwe yi-vSphere njengamadiski anengqondo (amavolumu). Imiqulu ye-Unity XT ifomethwe njengemiqulu ye-VMFS yi-ESXi hypervisor. Abaphathi be-VMware bakha idiski eyodwa noma ngaphezulu (ama-VMDK) ethulwe ohlelweni lokusebenza lwesihambeli. I-RDM ivumela umshini obonakalayo ukuthi ufinyelele ngokuqondile isitoreji sebhulokhi le-Unity XT (nge-FC noma i-iSCSI) ngaphandle kokufometha i-VMFS. I-VMFS kanye namavolumu e-RDM angahlinzeka ngokusebenza okufanayo kokwenziwayo.
Okokugcina okusekelwe ku-NFS kwe-ESXi, i-Dell EMC incoma ukusebenzisa i-VMware NFS esikhundleni sezinhlelo zefayela le-NFS zenhloso evamile. Umshini obonakalayo osebenza ku-SQL Server futhi osebenzisa i-VMDK esitolo sedatha ye-NFS awuqapheli isendlalelo se-NFS esingaphansi. Isistimu yokusebenza yesivakashi iphatha umshini obonakalayo njengeseva ebonakalayo esebenzisa i-Windows Server ne-SQL Server. Amadiski abiwe okulungiselelwa kwesibonelo seqoqo le-failover kuma-datastores e-NFS awasekelwe.
I-VMware vSphere Virtual Volumes (VVols) inikezela ngokulawula kwembudumbudu okwengeziwe ezingeni lomshini obonakalayo, ngaphandle kokumelwa kwenkumbulo eyisisekelo (njengamavolumu noma amasistimu wefayela). Ukuphindaphinda okusekelwe ku-Array nge-VVols kusekelwa kuqala nge-VVol 2.0 (vSphere 6.5). Idiski ye-VVol ingasetshenziswa esikhundleni sediski ye-RDM ukunikeza insiza yediski kusibonelo se-SQL Failover Cluster eqala nge-vSphere 6.7 ngosekelo lokulondoloza ikhophi ye-SCSI.
Amanethiwekhi enziwe ngendlela ebonakalayo
Inethiwekhi emhlabeni we-virtual ilandela imiqondo enengqondo efanayo nasemhlabeni wenyama, kodwa isebenzisa isofthiwe kunezintambo ezibonakalayo namaswishi. Umthelela wokubambezeleka kwenethiwekhi kumthwalo wokusebenza we-SQL Server ungahluka kakhulu. Ukuqapha amamethrikhi okusebenza kwenethiwekhi kumthwalo okhona womsebenzi noma isistimu yokuhlola esetshenziswe kahle esikhathini esimele kusiza ekudaleni inethiwekhi ebonakalayo.
Uma usebenzisa i-VMware virtualization nge-SQL Server, cabangela lokhu okulandelayo:
- Kokubili amaswishi abonakalayo ajwayelekile nasabalalisiwe ahlinzeka ngokusebenza okudingwa yi-SQL Server.
- Ukuze uhlukanise ngokunengqondo abaphathi, i-vSphere vMotion, nethrafikhi yesitoreji senethiwekhi, sebenzisa ukumaka kwe-VLAN namaqembu embobo yokushintsha ebonakalayo.
- I-VMware incoma ngokuqinile ukunika amandla ozimele abakhulu ekushintsheni okubonakalayo lapho ithrafikhi ye-vSphere vMotion noma ithrafikhi ye-iSCSI inikwe amandla.
- Ngokuvamile, landela imihlahlandlela yokuxhumana yezinhlelo zokusebenza zesivakashi nehadiwe.
isiphetho
Izindawo zesizindalwazi se-SQL Server ziya ziba zinkulu futhi zibe nzima kakhulu. Ku-SQL Server 2019, iMicrosoft ithuthukise izici eziyinhloko ze-SQL Server futhi yengeza ezintsha, njengokusekelwa kwedatha enkulu yokusebenza nge-Apache Spark ne-HDFS. I-Dell EMC, ngokubambisana ne-Microsoft, iyaqhubeka nokuhlinzeka ngezingqalasizinda ezidingekayo zemvelo ye-SQL Server - amaseva, ukugcinwa kanye namanethiwekhi.
Sibona ukwanda okuphawulekayo kwesikhathi kanye nokwehliswa kwenani eliphelele lobunikazi (TCO) lapho ochwepheshe besitoreji kanye nedathabhesi besebenza ndawonye ukuze benze izixazululo zengqalasizinda ze-SQL Server kumapulatifomu esitoreji okwabelwana ngawo. I-Dell EMC Unity XT all-flash array iyisixazululo sebanga eliphakathi elifanele abathuthukisi be-SQL Server nabalawuli abadinga ukusebenza okuphezulu nokubambezeleka okuphansi. Idizayinelwe ukusebenza kuwo wonke ama-flash drive, i-Unity XT All-Flash isekela ama-CPU amabili, ukulungiselelwa kwezilawuli ezimbili, nokwenza kahle okuhlanganisa izinto eziningi.
Ngokukhulayo, izinhlangano zenza ngokweqiniso izindawo zazo ze-SQL Server. Nakuba i-virtualization ingeza esinye isendlalelo sokuklama kusitaki sezakhiwo, inikeza izinzuzo ezibalulekile. Sithemba ukuthi uzothola ezinye izici ezisetshenziswa kakhulu ze-VMware namathuluzi ethulwe ngenhla ewusizo ezindaweni zeseva ye-SQL. Futhi sincoma izixhumanisi ezinsizeni ukuze uthole ulwazi oluningiliziwe.
Izixhumanisi eziwusizo
Dell EMC
- (ikhasi lomkhiqizo)
- (I-YouTube)
VMware
Microsoft
Source: www.habr.com