Namhlanje siza kukwazisa kwiimpawu zokusebenzisa i-SQL Server 2019 kunye nenkqubo yokugcina i-Unity XT, kwaye sinike iingcebiso malunga ne-virtualizing SQL Server usebenzisa iteknoloji ye-VMware, ukuseka nokulawula amacandelo asisiseko se-Dell EMC yeziseko.
Kwi-2017, i-Dell EMC kunye ne-VMware yapapasha iziphumo zophando malunga neendlela kunye nokuziphendukela kwe-SQL Server - "I-SQL Server Transformation: Towards Agility and Resilience" (), eyayisebenzisa amava oluntu lwamalungu oMbutho woBuchule be-SQL Server (PASS). Iziphumo zibonisa ukuba i-SQL Server ye-database ye-database ikhula kuzo zombini ubungakanani kunye nobunzima, iqhutywe kukunyusa umthamo wedatha kunye neemfuno ezintsha zoshishino. I-database ye-SQL Server ngoku isasazwe kwiinkampani ezininzi, inika amandla izicelo ezibaluleke kakhulu, kwaye zihlala zisisiseko sokuguqulwa kwedijithali.
Ekubeni olu phando lwenziwe, iMicrosoft ikhuphe isizukulwana esilandelayo se-DBMS - i-SQL Server 2019. Ukongeza ekuphuculeni imisebenzi eyisiseko ye-injini yobudlelwane kunye nokugcinwa kwedatha, iinkonzo ezintsha kunye nemisebenzi ibonakala. Ngokomzekelo, i-SQL Server 2019 ibandakanya inkxaso yomthwalo omkhulu wedatha usebenzisa i-Apache Spark kunye ne-Hadoop Distributed File System (HDFS).
I-Alliance Dell EMC kunye neMicrosoft
I-Dell EMC kunye neMicrosoft zinentsebenziswano ehlala ixesha elide ekuphuhliseni izisombululo ze-SQL Server. Ukuphumeza ngempumelelo iqonga ledatha elibanzi elifana neSeva ye-Microsoft SQL kufuna ulungelelwaniso lokusebenza kwesoftware kunye nesiseko se-IT esisisiseko. Esi sibonelelo sibandakanya amandla okusebenza kweprosesa, izixhobo zememori, ukugcinwa kunye neenkonzo zenethiwekhi. I-Dell EMC inikezela ngesiseko seqonga se-SQL Server kulo lonke uhlobo lomsebenzi kunye nesicelo.
Umgca we-Dell EMC PowerEdge unikezela ngeendlela ezahlukeneyo zeprosesa kunye nememori. Olu lungelelwaniso lufanelekile kuluhlu olubanzi lwemisebenzi: ukusuka kwizicelo zamashishini amancinci ukuya kwiinkqubo ezinkulu ze-mission-critical, ezifana nokucwangciswa kwezixhobo zeshishini (ERP), iindawo zokugcina idatha, i-analytics ephezulu, i-e-commerce, njl. Ukugcina idatha engacwangciswanga kunye neyakhiwe.
Abathengi abasebenzisa i-SQL Server 2019 kunye ne-Dell EMC yeziseko zophuhliso banokusebenza kunye neenkcukacha ezicwangcisiweyo nezingacwangciswanga usebenzisa i-SQL Server kunye ne-Apache Spark. Iseva ye-SQL ikwaxhasa indibaniselwano yofikelelo lwabaxhasi, iseva-kwiseva, kunye ne-server-to-ugcino lwetekhnoloji yonxibelelwano. Umbono we-Dell EMC usekwe kwimodeli eyahluliweyo ebonelela ngenkqubo yendalo evulekileyo. Imibutho ingakhetha kuluhlu olubanzi lwezicelo zenethiwekhi ezisemgangathweni, iinkqubo zokusebenza kunye namaqonga e-hardware. Le ndlela ikunika ulawulo oluphezulu kwitekhnoloji kunye nezakhiwo, okukhokelela ekongeni kweendleko kunye nokuguquguquka.
I-VMware yenza ngokubonakalayo zonke iinxalenye ezibalulekileyo zeziseko ezingundoqo ezifunwa yi-SQL Server ukuphumeza ukusebenza okuphezulu kunye nokungaguquguquki kokusebenza. Ukongeza kwilifu labucala, i-VMware ikwabonelela ngoku iimodeli ezixubileyo zomthwalo onzima, othatha indawo yolwakhiwo lwamafu abucala kunye noluntu.
Imibutho emininzi iguqukela kwi-virtualization ukunciphisa iindleko zeziseko zophuhliso, ukubonelela ngokufumaneka okuphezulu, kunye nokwenza lula ukubuyiswa kweentlekele. I-94% yeengcali ze-SQL Server eziphononongiweyo zibika inqanaba elithile le-virtualization kwindawo yabo. I-70% yabo basebenzisa i-virtualization bakhetha i-VMware. I-60% inamanqanaba e-SQL Server virtualization ye-75% okanye ngaphezulu. Ukongeza, iziphumo zesaveyi zicebisa ngamandla ukuba ukufumaneka okuphezulu kunye nokubuyiswa kweentlekele kuphunyezwe kwinqanaba le-virtualization kuye kwaba yimiba ebalulekileyo kwisigqibo sokwenza idatha ye-SQL Server.
Iimpawu ezintsha kwi-SQL Server 2019
I-platform ye-SQL Server 2019 ye-database iquka uluhlu olubanzi lwezobuchwepheshe, iimpawu, kunye neenkonzo ezixhasa izicelo ezibaluleke kakhulu ze-mission ezifana ne-analytics, i-database ye-enterprise, i-intelligence yezoshishino (BI), kunye ne-scalable transaction process (OLTP). I-platform ye-SQL Server ifumene amandla okulawula ukuhlanganiswa kwedatha, ukugcinwa kwedatha, ukunika ingxelo kunye nohlalutyo oluphambili, ukukwazi ukuphindaphinda, kunye nokulawulwa kweentlobo zedatha eziqingqiweyo. Ewe, ayingabo bonke abathengi okanye izicelo ezifuna zonke ezi mpawu. Ukongeza, kwiimeko ezininzi kukhethwa ukwahlula iinkonzo ze-SQL Server usebenzisa i-virtualization.
Namhlanje, amashishini ahlala efuna ukuthembela kumthamo omkhulu wedatha ukusuka kuluhlu olubanzi lweeseti zedatha ezihlala zikhula. Nge-SQL Server 2019, unokufumana ulwazi lwexesha lokwenyani kuyo yonke idatha yakho. Amaqela e-SQL Server 2019 abonelela ngendawo epheleleyo yokusebenza ngeeseti ezinkulu zedatha, kubandakanywa nokusetyenziswa komatshini wokufunda kunye nobuchule bobukrelekrele bokwenziwa. Iimpawu eziphambili ezintsha kunye nohlaziyo kwi-SQL Server 2019 zidweliswe kuyo .
Dell EMC Unity XT Mid-Range Storage System
Uluhlu lokugcina lwe-Dell EMC Unity lwasungulwa phantse kwiminyaka emithathu edlulileyo, kwaye ukususela ngoko ngaphezu kweenkqubo ze-40 zithengisiwe. Abathengi bayaluxabisa olu luhlu oluphakathi ngenxa yokulula, ukusebenza kunye nokusebenza kakuhle kweendleko. I-Dell EMC Unity XT i-midrange platforms zizisombululo zokugcinwa okwabelwana ngazo ezihambisa i-latency ephantsi, i-throughput ephezulu, kunye nolawulo oluphantsi lwe-SQL yomthwalo womsebenzi. Zonke iinkqubo ze-Unity XT zisebenzisa iprosesa yokugcina ezimbini (SP) i-architecture yokusingatha i-I / O kunye nokusebenza kwedatha esebenzayo / esebenzayo. I-Unity XT i-SP ye-SP isebenzisa uqhagamshelwano olupheleleyo lwangaphakathi lwe-000Gbps ye-SAS kunye ne-proprietary multi-core architecture yokusebenza okuphezulu kunye nokusebenza kakuhle. Uluhlu lweDiski lukuvumela ukuba ukwandise umthamo wokugcina usebenzisa iishelufu ezongezelelweyo.
I-Dell EMC Unity XT, isizukulwana esilandelayo se-arrays (i-hybrid kunye ne-flash-flash), yandisa kakhulu ukusebenza, iphucula ukusebenza kakuhle, kwaye yongeza amandla amatsha kunye neenkonzo kwiindawo ezininzi zamafu.
I-architecture ye-Unity XT ikuvumela ukuba usebenze idatha ngaxeshanye, unciphise umthamo wedatha, kunye neenkonzo zenkxaso ezifana nokuphindaphinda ngaphandle kokuncama ukusebenza kwesicelo. Xa kuthelekiswa nesisombululo sesizukulwana sangaphambili, ukusebenza kwe-Dell EMC Unity XT inkqubo yokugcina iphindwe kabini kwaye ixesha lokuphendula liyi-75% ngokukhawuleza. Kwaye kunjalo, iDell EMC Unity ixhasa umgangatho weNVMe.
Iinkqubo zokugcina ezine-NVMe drives zibonisa ukusebenza kwazo okuhle kakhulu kwi-latency-sensitive applications. Ngokomzekelo, kwizicelo ezinje ngogcino-lwazi olukhulu, i-NVMe ibonelela nge-latency ephantsi kunye namazinga aphezulu aphezulu edatha. Ukuncitshiswa kwe-latency kunye nokunyuka kwe-concurrency kuphucula kakhulu ukusebenza kokufunda / ukubhala. Akunakwenzeka ukuba, ngokwe-IDC ye-forecast, ngo-2021, i-flash arrays kunye ne-NVMe kunye ne-NVMe-oF (i-NVMe phezu kweFabric) uxhulumaniso luya kwenza malunga nesiqingatha sayo yonke ingeniso evela kwiintengiso zeenkqubo zokugcina zangaphandle kwihlabathi.
I-algorithms yoxinzelelo lwedatha iphucula ukusebenza kakuhle kogcino. I-Dell EMC Unity XT inokunciphisa umthamo wedatha ukuya kuthi ga kahlanu. Esinye isalathisi esibalulekileyo kukusebenza kakuhle kwenkqubo. I-Dell EMC Unity XT isebenzisa i-85% umthamo wenkqubo. Ukunyanzeliswa kunye nokunciphisa kwenziwa kwimodi engaphakathi - kwinqanaba lomlawuli. Idatha igcinwa kwifom ecinezelweyo. Inkqubo iphinda izenzele umsebenzi kunye ne-data snapshots.
Ukusetyenziswa ngokulula kwe-Unity flash arrays kunye nokufikelela okudibeneyo (ibhloko kunye nefayile) kubonelela ngamaxesha okuphendula okuzinzile, ukudibanisa neenkonzo zokugcina ifu, kunye nokuxhaswa kwenkxaso ngaphandle kokufuduka kwedatha. Kuqwalaselo lwayo olusisiseko, le nkqubo yokugcina izinto ezininzi ifaka kwimizuzu engama-30.
Itekhnoloji yokugcinwa kwedatha ebizwa ngokuba yi "dynamic pools" ikuvumela ukuba uhambe ukusuka kwi-static ukuya kwimemori yokwandisa imemori, inikezela ukuguquguquka okuphezulu kokusebenza kunye nokulula kokunyusa umthamo wenkqubo. Amadama ashukumisayo agcina umthamo kunye nohlahlo lwabiwo-mali, kwaye afuna ixesha elincinci lokwakha kwakhona. Ukwandisa umthamo kunye nokusebenza kweDell EMC Unity ayifuni ukufuduka kwedatha.
Iinkampani ezininzi namhlanje zisebenzisa iinkonzo ezininzi zamafu zikawonke-wonke ngokudityaniswa neziseko zazo ezikwindawo. I-Dell EMC Unity XT inokusebenza njengecandelo le-Dell Technologies Cloud environment. Le nkqubo yokugcina ingasetyenziselwa kwifu likawonkewonke kwaye idatha ingadluliselwa kwifu yangasese. Ukongeza, i-Dell EMC Unity XT yokugcina iyafumaneka njengenkonzo. Le yenye yeenkonzo zokugcina ifu zeDell EMC Iinkonzo zokuGcinwa kwamafu.
Ukugcinwa kwamafu kuya kuthandwa kakhulu kuba kunokuphucula i-ROI ngokunciphisa iindleko zeziseko. Iinkonzo zokuGcinwa kwamafu zandisa amaziko edatha yabathengi kwilifu ngokuhambisa i-Dell EMC yokugcina (iqhagamshelwe ngokuthe ngqo kwizixhobo zamafu oluntu) njengenkonzo. Ababoneleli beqela lesithathu banokubonelela ngesantya esiphezulu (i-latency ephantsi) uxhulumaniso lwamafu oluntu ngokuthe ngqo kwi-Dell EMC Unity, i-PowerMax kunye ne-Isilon iinkqubo kwiziko ledatha yomthengi.
Usapho lwe-Unity XT lubandakanya i-Unity XT All-Flash, i-Unity XT Hybrid, i-UnityVSA kunye neenkqubo ze-Unity Cloud Edition.
I-Hybrid edibeneyo kunye ne-Flash Arrays
I-Intel-based Unity XT Hybrid kunye ne-Unity XT All-Flash yokugcina iinkqubo zibonelela ngezakhiwo ezidibeneyo zokufikelela kwibhloko, ukufikelela kweefayile, kunye ne-VMware VVols kunye nenkxaso yokugcinwa kwenethiwekhi eqhotyoshelweyo (NAS), iSCSI, kunye neeprotocol zeFiber Channel (FC). I-Unity XT Hybrid kunye ne-Unity XT All-Flash platforms zi-NVMe-ready.
Iinkqubo ezixubileyo ze-XT zixhasa iindawo ezinamafu amaninzi. Iifu ezininzi zithetha ukwandisa ukugcinwa kwilifu okanye ukuthunyelwa efini ngeendlela eziguquguqukayo zokusetyenziswa kwezixhobo. Ukugcinwa kwe-Multicloud yenzelwe ukuqinisekisa ukuhamba kunye nokuphatheka kwedatha phakathi kwamaqonga amafu amaninzi - abucala kunye noluntu. Oku akuchaphazeli kuphela iinkqubo zokuhamba kwedatha, kodwa kunye nombutho wokufikelela kwisicelo kwidatha kumafu amaninzi oluntu.
Ezi ntlobo zemixube zibonelela ngezakhono zilandelayo:
- Scalable ukuya 16 PB umthamo ekrwada.
- Izakhono zokunciphisa idatha eyakhelwe-ngaphakathi kuzo zonke ii-flash pools.
- Ukufakwa ngokukhawuleza kunye nokucwangciswa (ngokomndilili kuthatha imizuzu engama-25).
Itekhnoloji ye-SSD iphucuka ngokukhawuleza, kwaye iimveliso ezintsha zoguqulo ziya kubetha kwimarike kwiminyaka ezayo. Okwangoku, imibutho iya kuqhubeka ithatha indawo ye-HDD yendabuko kunye nee-SSD zokuphucula ukusebenza, ukukhululeka kolawulo kunye nokugcinwa kwamandla. Izizukulwana ezitsha ze-flash-arrays ziya kuba ne-automation yokugcina i-automation, ukuhlanganiswa kwamafu kawonkewonke, kunye nokukhusela idatha edibeneyo.
Iinkqubo zeUnity XT All-Flash zihambisa isantya, ukusebenza kakuhle, kunye nenkxaso yamafu amaninzi. Iimpawu zabo:
- Imveliso ephindwe kabini.
- Ukwehliswa kwedatha ukuya kuthi ga kwi-7:1.
- Ukufakwa ngokukhawuleza kunye nokucwangciswa (inkqubo ithatha ngaphantsi kwemizuzu engama-30).
UbunyeVSA
I-UnityVSA yindawo yokugcina echazwe kwisoftware yeVMware ESXi kusetyenziswa iseva, ekwabelwana ngayo, okanye indawo yokugcina ilifu. I-UnityVSA HA, i-dual-storage ye-UnityVSA uqwalaselo, inika ukunyamezela iimpazamo ezongezelelweyo. UnityVSA inikezela ngogcino:
- Ukuya kuthi ga kwi-50 TB yogcino olugcweleyo olugcweleyo.
- Iyahambelana ne-Unity XT iinkqubo kunye neempawu.
- Inkxaso yeenkqubo zokufumaneka okuphezulu (UnityVSA HA).
- Uqhagamshelwano njenge-NAS kunye ne-iSCSI.
- Ukuphindaphindwa kwedatha evela kwamanye amaqonga e-Unity XT.
Ubunye Cloud Edition
Ukulungelelaniswa kwefayile kunye nemisebenzi yokubuyisela intlekele ngelifu, usapho lwe-Unity XT lubandakanya uHlelo lweLifu loBumbano, olubonelela:
- Amandla okugcina abonakaliswe ngokupheleleyo usebenzisa i-software-defined storage (SDS) efakwe efini.
- Beka ngokulula ibhloko kunye nokugcinwa kwefayile ngeVMware Cloud kwi-AWS.
- Inkxaso yokubuyisela intlekele, kubandakanywa uvavanyo kunye nohlalutyo lwedatha.
Umanyano XT Yonke iFlash ye-SQL Server
Ingxelo ye-Unisphere ye-Unisphere ye-2017 ingxelo, "Inguqu ye-SQL Server: Ukujonga i-Agility kunye nokuqina" () I-22% yabaphenduli babika ukuba basebenzisa iteknoloji yokugcina i-flash kwimveliso (16%) okanye baceba ukwenza oko (6%). I-30% isebenzisa uluhlu oluxubileyo olubandakanya imemori ye-flash. I-13% isebenzisa ii-flash arrays ezithe ngqo. I-13% igcina isiseko sedatha ye-SQL Server kugcino oludanyazayo.
Oku kwamkelwa ngokukhawuleza kokugcinwa kwe-flash ukuze kusetyenziswe ne-SQL Server kuthetha ukuba i-Unity XT All-Flash arrays ifaneleke ngokukodwa abaphuhlisi be-SQL Server kunye nabalawuli. Iinkqubo ze-Unity XT All-Flash zibonelela abaphuhlisi be-SQL Server kunye nabalawuli ngezakhono kunye nokusebenza okuhamba ngaphaya kokunikezelwa kweenethiwekhi zendawo yokugcina (SANs).
Iinkqubo ze-Unity XT All-Flash, ezilungele i-NVMe (ngenxa yokusebenza okuphezulu okuphezulu kunye ne-latency ephantsi), zinefom yefom ye-2U, ixhasa iiprosesa ezimbini-core, abalawuli ababini kwimodi esebenzayo / esebenzayo.
Umanyano XT Iimodeli zonke zeFlash
Umanyano XT
Iiprosesa
Imemori (ngeprosesa nganye)
Max. inani drives
Max. umthamo "ekrwada" (PB)
380F
1 Intel E5-2603 v4
6c/1.7 GHz
64
500
2.4
480F
2 Intel Xeon yesilivere
4108 8c/1.8 GHz
96
750
4.0
680F
2 Intel Xeon yesilivere
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
Iinkcukacha zingafunyanwa kuluhlu lweenkcukacha ().
Amachibi okugcina
Iingcali ezininzi ze-SQL Server ziyazi ukuba zonke ii-arrays zokugcina zanamhlanje zibonelela ngokukwazi ukuhlanganisa iidiski kwiiyunithi ezinkulu zokugcina ezinomgangatho osisigxina wokukhusela i-RAID. Amaqela edisk ngamnye anokhuseleko lwe-RAID ngamadama okugcina emveli. Ngelixa iinkqubo ezixubileyo ze-Unity XT zixhasa kuphela amachibi esintu, i-Unity XT All-Flash arrays ikwabonelela ngamachibi okugcina aguqukayo. Ngamachibi okugcina aguquguqukayo, ukukhuselwa kwe-RAID kusetyenziswe kwidisk extents-iiyunithi zokugcina ezincinci kunediski epheleleyo. Amadama ashukumisayo abonelela ngokuguquguquka okukhulu ekulawuleni nasekukhuliseni iidisk pools.
I-Dell EMC ibonelela ngeendlela ezilungileyo zokulawula amachibi okugcina ukuphumeza ukusebenza okuphezulu kunye nobunzima obuncinci. Ngokomzekelo, kucetyiswa ukunciphisa inani le-Unity XT yokugcina amachibi ukunciphisa ubunzima kunye nokwandisa ukuguquguquka. Nangona kunjalo, ukuseta iiphuli ezongezelelweyo zokugcina kunokuba luncedo kakhulu kwezinye iimeko, kubandakanywa xa ufuna:
- Ukuxhasa imithwalo yemisebenzi eyahlukeneyo kunye neeprofayili ze-I / O ezahlukeneyo.
- Yabela izibonelelo ukuphumeza iiparamitha ezithile zokusebenza.
- Nikela izixhobo ezahlukeneyo zokuqesha abantu abaninzi.
- Yenza imimandla emincinci ukukhusela ngokuchasene nokusilela
Imiqulu yokugcina (LUNs)
Ulinganisa njani ulawulo kunye nokuguquguquka xa ukhetha inani lemiqulu kuluhlu? Ukuguquguquka okuphezulu kuManyano kunye ne-SQL Server, kuyacetyiswa ukuba wenze imiqulu yefayile yedatha nganye. Enyanisweni, imibutho emininzi isebenzisa indlela edibeneyo, apho i-database ebalulekileyo inikwe ukuguquguquka okuphezulu kunye neefayile zesiseko sedatha ezingabalulekanga zidityaniswe kwimiqulu embalwa, emikhulu. Sincoma ukuphonononga zonke iimfuno zogcino-lwazi kunye nazo naziphi na izicelo ezinxulumeneyo kuba ukhuseleko lwedatha kunye nokuhlola itekhnoloji kuxhomekeke ekubekweni bucala kwefayile kunye nokubekwa.
Imiqulu emininzi inokuba nzima ukuyilawula, ngakumbi kwiindawo ezingqongileyo. Iimekobume zeSeva ye-SQL eQhelekileyo ngumzekelo omhle apho ukusingathwa kweentlobo ezininzi zeefayile kumthamo omnye kunokuba nentsingiselo. Umlawuli wedatha okanye umlawuli wokugcina (okanye zombini) kufuneka akhethe ibhalansi echanekileyo phakathi kokuguquguquka kunye nokugcinwa xa umisela inani lemiqulu yokuyidala.
Ugcino lwefayile
Iiseva zeNAS zibamba iinkqubo zefayile kwi-Unity XT yokugcina. Iisistim zefayile zinokufikelelwa kusetyenziswa iSMB okanye iNFS yemithetho elandelwayo, kwaye ngenkqubo yefayile yeprotocol eninzi, ungasebenzisa zombini iiprothokholi ngaxeshanye. Iiseva ze-NAS zisebenzisa ujongano olubonakalayo ukudibanisa inginginya kwi-SMB, i-NFS, kunye neenkqubo zeefayile ezininzi zeprotocol, kunye nokugcinwa kwe-VMware NFS kunye neVMware imithamo yenyani. Iinkqubo zefayile kunye nojongano olubonakalayo zibekwe zodwa ngaphakathi kweseva enye ye-NAS, evumela iiseva ezininzi ze-NAS ukuba zisetyenziselwe ukuqesha okuninzi. Iiseva zeNAS ziyasilela ngokuzenzekelayo ukuba iprosesa yokugcina iyasilela. Iinkqubo zabo zeefayile ezinxulumene nazo ziyasilela.
SQL Server 2012 (11.x) kunye neenguqulelo zamva ixhasa Server Message Block (SMB) 3.0, evumela ifayile yothungelwano ifayile ukwabelana yokugcina. Kuzo zombini ii-standalone kunye nofakelo lweqela le-faillover, ungafaka i-database yenkqubo (inkosi, imodeli, i-msdb, kunye ne-temdb) kunye ne-Database Engine yogcino lwabasebenzisi kunye nenketho yokugcina ye-SMB. Ukusebenzisa ugcino lwe-SMB lukhetho olulungileyo xa usebenzisa iSoloko ekuFumaneni Amaqela kuba ulwabiwo lwefayile lufuna ufikelelo kuvimba wothungelwano ofumaneka kakhulu.
Ukudala izabelo zefayile ze-SMB kwi-SQL Server deployment kunye nokugcinwa kwe-Unity XT yinkqubo elula yamanyathelo amathathu: udala iseva ye-NAS, inkqubo yefayile, kunye nesabelo se-SMB. Dell EMC Unisphere Storage Management software ibandakanya uqwalaselo wizard ukukunceda ugqibezele le nkqubo. Nangona kunjalo, xa ubamba imithwalo yemisebenzi ye-SQL Server kwizabelo zefayile ye-SMB, kukho iingqwalasela ezibalulekileyo ekufuneka uzigcine engqondweni ezingabhekiseli ekusebenziseni izabelo zefayile ye-SMB. IMicrosoft iqulunqe uluhlu lwemiba yokuhlohla kunye nokhuseleko kunye nemiba eyaziwayo ngoku; Ngeenkcukacha, jonga "Ukufaka i-SQL Server kunye noGcino lweFayile ye-SMB" kwi .
Izifinyezo zeDatha
Idatha ibe yeyona nto ibalulekileyo yenkampani, kwaye iimeko zanamhlanje ezibaluleke kakhulu kubuthunywa zifuna okungaphezulu nje kokungafuneki. Kuyimfuneko ukuba izicelo zihlale zikwi-intanethi, zibonelelwe ngemisebenzi engaphazamisekiyo kunye nohlaziyo. Bakwafuna ukusebenza okuphezulu kunye nokufumaneka kwedatha ngokusebenzisa iinketho ezifana nokuphindaphinda kwe-snapshot yendawo kunye nokuphindaphinda okude.
Uluhlu lokugcina lwe-Unity XT lunikeza ibhloko kunye nefayile ye-snapshot yamandla abelana ngokuhamba komsebenzi okuqhelekileyo, ukusebenza, kunye nezakhiwo. Imethodi ye-snapshot ye-Unity ibonelela ngendlela elula nesebenzayo yokukhusela idatha. Izifinyezo zenza kube lula ukubuyisela idatha - buyela umva kwi-snapshot yangaphambili, okanye unokukopa idatha ekhethiweyo kwi-snapshot yangaphambili. Le theyibhile ilandelayo ibonisa amaxesha ogcino olukhawulezayo lweenkqubo ze Unity XT.
Ukugcinwa kwendawo kunye nokude kwedatha ye-snapshots
Uhlobo lwefoto
CLI
UI
ABANYE
Ngendlela
Okucwangcisiweyo
Ngendlela
Okucwangcisiweyo
Ngendlela
Okucwangcisiweyo
Indawo
1 ngonyaka
1 ngonyaka
5 iminyaka
Iiveki ze-4
100 iminyaka
Ngaphandle kweMida
Ukude
5 iminyaka
Iiveki ze255
5 iminyaka
Iiveki ze255
5 iminyaka
Iiveki ze255
Izifinyezo aziyondawo ethe ngqo yezinye iindlela zokhuseleko lwedatha, ezinje ngogcino. Banokuncedisana kuphela ne-backup yendabuko njengomgca wokuqala wokukhusela kwiimeko ze-RTO eziphantsi.
I-Dell EMC Unity snapshot feature ibandakanya ukunciphisa idatha kunye nokudityaniswa okuphezulu. Izifinyezo zikwaxhamla kugcino lwendawo oluphunyeziweyo kwisixhobo sokugcina soqobo. Xa uthatha i-snapshot yesixhobo sogcino esixhasa iimpawu zokunciphisa idatha, idatha kumthombo inokucinezelwa okanye iphindwe.
Nanga amanye amanqaku malunga nokufunyanwa kwedathabheyisi xa usebenzisa izifinyezo ezinogcino lwedatha ye-SQL:
- Onke amacandelo esiseko sedatha ye-SQL Server kufuneka akhuselwe njengeseti yedatha. Xa idatha kunye neefayile zelogi zikwi-LUN ezahlukeneyo, ezo LUNs kufuneka zibe yinxalenye yeqela elihambelanayo. Iqela elingaguqukiyo liqinisekisa ukuba i-snapshot ithathwa ngaxeshanye kuzo zonke ii-LUN zeqela. Xa idatha kunye neefayile zelog zikwizabelo ezininzi zeefayile ze-SMB, izabelo kufuneka zibe kwisistim seefayile ezifanayo.
- Xa ubuyisela isiseko sedatha yeseva ye-SQL kwi-block-based snapshot, ukuba umzekelo we-SQL Server kufuneka ihlale iqhagamshelwe, sebenzisa i-unisphere host join. Ukufumana kwakhona okusekwe kwifayile, isabelo esongezelelweyo se-SMB senziwe kusetyenziswa umfanekiso okhawulezayo njengomthombo. Emva kokuba imiqulu iphakanyisiwe, i-database inokudibaniswa phantsi kwegama elahlukileyo okanye i-database ekhoyo inokutshintshwa ngokubuyiselwa.
- Xa usenza ukubuyisela usebenzisa i-Snapshot Restore kwi-Unisphere, thatha umzekelo we-SQL Server ngaphandle kweintanethi. Umncedisi we-SQL akayazi imisebenzi yokubuyisela. Ukuthatha umzekelo ngaphandle kwe-intanethi kuqinisekisa ukuba imiqulu ayonakaliswa yi-database ibhala ngaphambi kokubuyisela. Nje ukuba umzekelo uqaliswe kwakhona, i-SQL Server yokubuyisela kwakhona intlekele iya kuzisa i-database ibe kwimeko engaguqukiyo.
- Yenza i-snapshots kwizinto ezininzi zokugcina ngexesha elinye, kwaye ke uqinisekise ukuba isixokelelwano sikwiimo zokusebenza ezicetyiswayo phambi kokuvumela iifoto ezongezelelweyo.
Ukuzenzekela kunye nokucwangciswa kokudubula
Izifinyezo kwi-Unity XT zinokuzenzekela. Ezi zikhetho zilandelayo ze-snapshot ezikhethiweyo ziyafumaneka kulawulo lokugcinwa kwe-Unisphere: ukhuseleko olungagqibekanga, ukhuseleko olufutshane lokugcinwa, kunye nokhuseleko lokugcinwa ixesha elide. Inketho nganye ithatha i-snapshots yemihla ngemihla kwaye igcinwe ngamaxesha ahlukeneyo.
Unokukhetha enye (okanye zombini) yeenketho zokucwangcisa - nganye iiyure ze-x (ukusuka kwi-1 ukuya kwi-24) kunye nemihla ngemihla / ngeveki. Ukucwangcisa umfanekiso okhawulezayo wemihla ngemihla/weveki kukuvumela ukuba uchaze amaxesha kunye neentsuku ezithile zokuthathwa kwesnapshots. Kukhetho ngalunye olukhethiweyo, kufuneka usete umgaqo-nkqubo wogcino, onokuthi uqwalaselwe ukucima ngokuzenzekelayo ichibi okanye ukuligcina okwexeshana.
Ulwazi oluthe kratya malunga ne-Unity snapshots - kwi .
Iikloni ezibhityileyo
I-clone ebhityileyo yikopi yokufunda/yokubhala yesixhobo sokugcina ibhloko ecekethekileyo, efana nomthamo, iqela elihambelanayo, okanye ugcino lwedatha lweVMware VMFS, olwabelana ngeebhloko kunye nesixhobo somzali wayo. Ii-clones ezibhityileyo ziyindlela entle yokubonisa ngokukhawuleza nangokudityanisiweyo iikopi zesiseko sedatha se-SQL Server, into leyo izixhobo zesiqhelo ze-SQL Server zingenako ukuyifumana. Nje ukuba i-clone ebhityileyo inikezelwe kumsingathi, imiqulu ingaziswa kwi-intanethi kwaye i-database iya kuqhotyoshelwa kusetyenziswa indlela ye-DB Namathisela kwi-SQL Server.
Xa usebenzisa uhlaziyo olunee-clones ezibhityileyo, thatha zonke ii-database kwi-clone encinci ngaphandle kweintanethi. Oku kufuneka kwenziwe phambi komsebenzi wohlaziyo. Ukungaphumeleli ukuthatha i-database engaxhunyiwe kwi-intanethi ngaphambi kokwenza uhlaziyo kunokubangela iimpazamo zokungahambelani kwedatha okanye iziphumo zedatha ezingachanekanga kwi-SQL Server.
Ukuphindaphindwa kwedatha
Ukuphindaphinda luphawu lwesoftware olungqamanisa idatha kunye nenkqubo ekude kwindawo enye okanye kwenye indawo. Iinketho zokuphindaphinda kunye noqwalaselo lweUnity zikuvumela ukuba ukhethe indlela esebenzayo yokuhlangabezana neemfuno ze-RTO/RPO kugcino lwedatha ye-SQL ngelixa ulungelelanisa ukusebenza kunye nokuphuma.
Xa usebenzisa i-Dell EMC Unity Replication ukukhusela i-SQL Server database kwimiqulu emininzi, kufuneka unciphise yonke idatha kunye ne-log logs kwi-database kwiqela elilodwa lokuhambelana okanye inkqubo yefayile. Ukuphindaphinda ke ngoko kusekwa kwiqela okanye inkqubo yefayile kwaye inokubandakanya imiqulu okanye izabelo zedatabase ezininzi. Ugcino lwedatha olufuna iindlela ezahlukeneyo zokuphindaphinda kufuneka zibe kwii-LUN ezahlukeneyo, amaqela ahambelanayo, okanye iinkqubo zeefayile.
Iiclones ezibhityileyo ziyahambelana nokuphindaphindana okuhambelanayo kunye ne-asynchronous. Xa i-clone ebhityileyo iphindaphindwa kwindawo ekuyiwa kuyo, iba yikopi epheleleyo yevolyum, iqela elihambelanayo, okanye ugcino lweVMFS. Emva kokuphindaphinda, i-clone encinci yivolumu ezimeleyo ngokupheleleyo kunye nezicwangciso zayo.
Inkqubo yokuphindaphinda kwe-clone phakathi komthombo kunye neenkqubo ekujoliswe kuzo.
Ukuphindaphindwa kwesiseko sedatha ye-temdb akufuneki kuba ifayile yakhiwe kwakhona xa i-SQL Server iqalwa kwakhona, kwaye ke imetadata ayihambelani nendlela yezinye iimeko ze-SQL Server. Ukukhetha ngononophelo imiqulu yokuphindaphinda kunye nemixholo yaloo miqulu kuphelisa ukuphindaphinda okungeyomfuneko.
Ulawulo lweeKopi yeDatha eDityanisiweyo yeMicrosoft SQL
Uninzi lweemveliso zogcino lwangoku (kubandakanywa zonke iimveliso ze-Dell EMC) zinokwenza "inkqubo yokusebenza ehambelanayo" iikopi zalo naluphi na uhlobo lwefayile:
- Umyalelo wokubhala ohambelanayo yinkqubo yokusebenza kuwo onke amanqanaba - ukusuka kumamkeli ukuya kwi-drive.
- Ukwahlulahlula imiqulu ukuze iifayile ezininzi kwimiqulu eyahlukeneyo zigcine ulandelelwano lokubhala.
Ngokwamkelwa okuxhaphakileyo kwezixhobo zokugcina ezinobungozi, iMicrosoft iphuhlise iAPI yababoneleli bogcino. Le API ivumela ababoneleli bokugcina ukuba balungelelanise kunye ne-SQL Server software yesiseko sedatha ukwenza "iikopi ezihambelana nesicelo" usebenzisa i-Volume Shadow Copy Service (VSS). Ezi kopi zilinganisa intsebenziswano phakathi kwe-SQL Server kunye nenkqubo yokusebenza ngexesha elicwangcisiweyo kunye nokuvalwa kwe-SQL Server. Zonke ii-buffers zokubhala ziyagungxulwa kwaye iitransekshini zinqunyanyiswe de zonke iidiski zihlaziywe kwaye zihambelane kwindawo ethile ngexesha, elirekhodwa kwilog yeSQL.
Isoftware yeDell EMC ye-AppSync edityaniswe ne-Unity XT snapshots yenza lula kwaye izenzele inkqubo yokuyila, ukusebenzisa, nokulawula iikopi ezingaguquguqukiyo zedatha yomsebenzi. Le software yenzelwe ukusetyenziswa kwiimeko zolawulo lokukopisha ukubuyiswa kwesiseko sedata kwaye isetyenziswe kwakhona.
Isoftware ye-AppSync ifumana ngokuzenzekelayo i-database yesicelo, ifunda ubume besiseko sedatha, kwaye imephu yesakhiwo sefayile ngehardware okanye iileya ze-virtualization ukuya kugcino olusisiseko lwe-Unity XT. Iququzelela onke amanyathelo ayimfuneko, ukusuka ekudaleni nasekuqinisekiseni ikopi ukuya kwi-snapshots enyukayo kwinginginya ekujoliswe kuyo kunye nokuqala okanye ukubuyisela isiseko sedatha. I-AppSync ixhasa kwaye yenza lula ukuhamba komsebenzi we-SQL Server equka ukuhlaziywa nokubuyisela isiseko sedatha yemveliso.
Ukuncitshiswa kwedatha kunye nokudityaniswa okuphezulu
Usapho lweDell EMC Unity lweenkqubo zokugcina lubonelela ngezinto ezityebileyo, ezilula ukuzisebenzisa iinkonzo zokunciphisa idatha. Ugcino alufezekiswanga kuphela kwimithombo yogcino olusisiseko olucwangcisiweyo, kodwa nakwizifinyezo kunye neeclones ezibhityileyo zezi zixhobo. I-Snapshots kunye neeclones ezibhityileyo zizuza ilifa lokunciphisa idatha yogcino lomthombo, okwandisa ukonga umthamo.
Isici sokunciphisa idatha sibandakanya ukuchithwa, ukunyanzeliswa, kunye nemisebenzi yokukhangela ibhloko ye-zero, enokunyusa ubuninzi bendawo yokugcina esebenzisekayo yezinto zomsebenzisi kunye nokusetyenziswa kwangaphakathi. Indawo yokunciphisa idatha ye-Unity XT ithatha indawo yoxinzelelo kwi-Unity OE 4.3 kwaye kamva. Ukunyanzeliswa yi-algorithm yokunciphisa idatha enokunciphisa ulwabiwo lomzimba lomthamo ofunekayo ukugcina isethi yedatha.
Iisistim ze-Unity XT zikwabonelela ngophawu oluphambili lokudityaniswa olunokwenziwa ukuba unciphiso lwedatha luvuliwe. Ukugqithiswa okuphezulu kunciphisa umthamo ofunekayo kwidatha yomsebenzisi ngokugcina kuphela inani elincinci leekopi (ngokuqhelekileyo ikopi enye) yeebhloko zedatha ye-Unity. Indawo yokutsalwa yiLUN enye. Yithathele ingqalelo oku xa ukhetha inkqubo yokugcina. Ii-LUN ezimbalwa zikhokelela ekutsalweni ngcono, kodwa ii-LUN ezininzi zibonelela ngokusebenza ngcono.
Ugcino lwesakhono olusuka kunikezelo oluphambili lunokubonelela ngenzuzo enkulu kwiindawo ezininzi, kodwa lukwafuna ukusetyenziswa kweeprosesa ze-Unity. Kwi-OE 5.0, ukutsalwa okuhambele phambili, xa kunikwe amandla, kukhupha nayiphi na ibhloko (ecinezelweyo okanye engaxinzelelwanga). Ukuze ufumane inkcazelo engakumbi, bona .
Le theyibhile ilandelayo ibonisa ulungelelwaniso oluxhaswayo locutho lwedatha kunye nokudityaniswa okuphezulu:
Ukuncitshiswa kwedatha kuManyano (yonke imifuziselo) kunye nenkxaso eyongeziweyo yokudityaniswa
Ubumbano OE inguqulelo
Te knoloji
Uhlobo lwamachibi oluxhaswayo
Iimodeli ezixhaswayo
4.3 / 4.4
Ukunciphisa idatha
I-Flash memory pool - yemveli okanye eguquguqukayo
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
4.5
Ukunciphisa idatha
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
Unciphiso lwedatha kunye nokudityaniswa okuphezulu *
450F, 550F, 650F
5
Ukunciphisa idatha
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F, XNUMXF, XNUMXF, XNUMXF
Ukuncitshiswa kwedatha kunye nokudityaniswa okuphezulu
450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F
* Unciphiso lwedatha luvaliwe ngokungagqibekanga kwaye kufuneka luvulwe phambi kokuba udityaniso oluphezulu lube lukhetho olukhoyo. Emva kokuvumela ukucuthwa kwedatha, ukutsalwa kwedatha okuphambili kuyafumaneka, kodwa kuvaliwe ngokungagqibekanga.
Ukunciphisa idatha kwi-Unity kunye noxinzelelo lwedatha kwi-SQL Server
I-SQL Server 2008 Enterprise Edition yaba lukhupho lokuqala olunikezela ngezakhono zoxinzelelo lwedatha yemveli. I-SQL Server 2008 ye-row-level kunye ne-page-level compression isebenzisa ulwazi lwe-SQL Server yangaphakathi yefomathi yetafile yedatha ukunciphisa indawo edliwayo zizinto zesiseko sedatha. Ukunciphisa isithuba kukuvumela ukuba ugcine imiqolo emininzi ngephepha ngalinye kunye namaphepha amaninzi kwi-buffer pool. Ngenxa yokuba idatha engagcinwanga kwifomati yephepha ledatha ye-8k, njengedatha engaphandle kwe-row efana ne-NVARCHAR (MAX), ayiyi kusebenzisa iindlela zokucinezela umqolo okanye iphepha, iMicrosoft yazisa iTransact-SQL COMPRESS kunye neDECOMPRESS imisebenzi.
Le misebenzi isebenzisa indlela yoxinzelelo lwedatha yemveli (i-algorithm ye-GZIP) ekufuneka ibizwe kwicandelo ngalinye ledatha ukuba icinezelwe okanye ithotywe.
Ukunyanzeliswa kwe-Unity XT, engekho kuphela kwi-SQL Server, isebenzisa i-algorithm yesofthiwe ukuhlalutya kunye nokucinezela idatha yokugcina. Ukususela ekukhutshweni kwe-Unity OE 4.1, ukunyanzeliswa kwedatha ye-Unity kuye kwafumaneka kwimiqulu yokugcina ibhloko kunye ne-VMFS yokugcina idatha kwi-flash pool. Ukuqala ngoBumbano lwe-OE 4.2, ukunyanzeliswa kukwafumaneka kwiinkqubo zefayile kunye neevenkile zedatha ye-NFS kwiidama zokugcina ukukhanya.
Ukhetho lwendlela yocinezelo lwedatha ye-SQL Server ixhomekeke kwizinto ezininzi. Ezi zinto zibandakanya uhlobo lomxholo wedatha, izibonelelo ze-CPU ezikhoyo - zombini kwindawo yokugcina kunye nakwiiseva zedatha, kunye nezixhobo ze-I / O ezifunekayo ukugcina i-SLA. Ngokubanzi, unokulindela ukongiwa kwendawo eyongezelelweyo yedatha ecinezelweyo kusetyenziswa iSeva yeSQL, kodwa idatha ecinezelweyo kusetyenziswa uphawu locinezelo lwe-TSQL ye-GZIP akunakwenzeka ukuba ibone ugcino olubalulekileyo lwesithuba oluvela kwiifitsha zocinezelo ze-Unity XT kuba uninzi lwezibonelelo zivela kweyokuqala. ialgorithm.
Ukunyanzeliswa kobumbano kunika ukugcinwa kwendawo ukuba idatha kwindawo yokugcina igxininiswe ubuncinane kwi-25%. Phambi kokuba wenze ucinezelo kwinto yokugcina, qaphela ukuba iqulethe idatha enokucinezelwa. Musa ukwenza ucinezelo lwento yokugcina ngaphandle kokuba ukwenza njalo kuya kugcina umthamo.
Xa usenza isigqibo sokusebenzisa unciphiso lwedatha ye-Unity, i-SQL Server yoxinzelelo lwenqanaba lesiseko sedatha, okanye zombini, qwalasela oku kulandelayo:
- Idatha ebhalwe kwinkqubo yoManyano iqinisekiswa ngumamkeli emva kokuba igcinwe kugcino lwenkqubo. Nangona kunjalo, inkqubo yoxinzelelo ayiqali de i-cache isuswe.
- Ukugcinwa koxinzelelo akufezeki kuphela kwimithombo yogcino lwe-Unity XT, kodwa nakwii-snapshots kunye neeclones ezincinci zesixhobo.
- Ngethuba lenkqubo yokunyanzeliswa, iibhloko ezininzi ziyadityaniswa kusetyenziswa i-algorithm yesampulu ukugqiba ukuba ingaba idatha inokucinezelwa. Ukuba i-algorithm yesampulu inquma ukuba ukugcinwa okuncinci kuphela kunokufezekiswa, ngoko ukunyanzeliswa kugqithwa kwaye idatha ibhalwa kwi-pool.
- Xa idatha ixinzelelwe ngaphambi kokuba ibhalwe kwimidiya yokugcina, inani lokuphatha idatha liyancipha kakhulu. Ke ngoko, ukucinezelwa kunceda ukunciphisa ukunxiba kunye nokukrazula kwimemori ye-flash ngokunciphisa inani ledatha ebhaliweyo kwi-drive.
Ngolwazi oluthe kratya malunga nomgca kunye noxinzelelo lwephepha kwi-SQL Server yeetafile kunye nezalathisi, bona .
Musa ukulibala ukuba nayiphi na ingcinezelo ifuna izixhobo ze-CPU. Xa iimfuno ze-bandwidth ziphezulu, ukunyanzeliswa kunokuba nefuthe elibalulekileyo ekusebenzeni. Imilinganiselo yokubhala ephezulu yomthwalo we-OLAP inokunciphisa izibonelelo zoxinzelelo lwesiseko sedatha ye-SQL Server.
UDell EMC uphande ugcino olunokubakho usebenzisa amazinga okunciphisa idatha yehlabathi lokwenyani kwi-Unity array. Iqela liqokelele idatha kumatshini we-VMware virtual, ukwabelana ngefayile, i-SQL Server databases, iMicrosoft Hyper-V imishini ebonakalayo, njl.
Iziphumo zophononongo zibonise ukuba ukuncitshiswa kwefayile ye-log ye-SQL Server kuphantse kube ngama-10 amancinci kunefayile yedatha:
- Ubungakanani bedatha = 1,49: 1 (32,96%)
- Umthamo welog = 12,9:1 (92,25%)
Isiseko sedatha ye-SQL Server sanikezelwa ngemiqulu emibini. Iifayile zedatabase zigcinwa kumqulu omnye kwaye iilogi zentengiselwano zigcinwa kwenye. Ukusebenzisa iteknoloji yokunciphisa idatha kunye nemiqulu yedatha yedatha inokubonelela ngokugcinwa kokugcina; nangona kunjalo, kufuneka uthathele ingqalelo ifuthe lomsebenzi xa usenza isigqibo sokuba kwenziwe uxhuzulo kwimithamo yedatabase. Ngelixa ubungakanani bokwenyani bokunciphisa ubungakanani bedatha bunokwahluka ngokuxhomekeke kwidatha egciniweyo, iziphumo zophononongo zibonise ukuba indawo yogcino lwedatha yeSQL Server inako. .
Iindlela ezingcono zokunciphisa idatha
Ngaphambi kokuba wenze ukunciphisa idatha kwinto yokugcina, qwalasela ezi zikhokelo zilandelayo:
- Sebenzisa inkqubo yokugcina esweni ukuqinisekisa ukuba inezixhobo ezikhoyo zokuxhasa ukunciphisa idatha.
- Yenza ukunciphisa idatha kwizinto ezininzi zokugcina ngexesha elinye. Beka esweni inkqubo ukuqinisekisa ukuba ikwiimeko zokusebenza ezicetyiswayo phambi kokuba uyivumele kwiindawo zokugcina ezongezelelweyo.
- Kwiimodeli ze-Unity XT x80F, ukuncitshiswa kwedatha kuya kunika ukugcinwa kwamandla ukuba idatha kwiyunithi yokugcina ixinzelelwe ubuncinane nge-1%.
Ukuncitshiswa kwedatha kwiimodeli zangaphambili ze-Unity x80F eziqhuba i-OE 5.0 zibonelele ngolondolozo nje ukuba idatha yayinokucinezeleka ngama-25%.
- Ngaphambi kokuba wenze ukunciphisa idatha kwinto yokugcina, qaphela ukuba into iqulethe idatha ecinezelayo. Ezinye iintlobo zedatha, ezinje ngevidiyo, isandi, imifanekiso, kunye nedatha yokubini, zibonelela ngenzuzo encinci kuxinzelelo. Musa ukwenza ukunciphisa idatha kwinto yokugcina ukuba akuyi kubakho kugcinwa kwendawo.
- Cinga ngokukhetha ukucinezela umthamo wedatha yefayile ecinezela kakuhle.
VMware Virtualization
I-VMware vSphere liqonga elisebenzayo nelikhuselekileyo le-virtualization kunye neendawo zamafu. Amacandelo angundoqo e-vSphere yi-VMware vCenter Server kunye ne-VMware ESXi hypervisor.
Iseva ye-vCenter liqonga elidityanisiweyo lolawulo lweemekobume zevSphere. Kulula ukuyithumela kwaye ilungiselela ngokuqhubekayo izixhobo. I-ESXi yi-hypervisor yemvelaphi evulekileyo efakela ngokuthe ngqo kwiiseva ezibonakalayo. I-ESXi inokufikelela ngokuthe ngqo kwimithombo engundoqo kwaye incinci ngobukhulu kwi-150MB, ukunciphisa iimfuno zememori. Ihambisa ukusebenza okuthembekileyo kwemisebenzi eyahlukeneyo yesicelo kunye nokuxhasa ukucwangciswa komatshini onamandla we-virtual-ukuya kwi-128 vCPU, i-6 TB ye-RAM, kunye nezixhobo ze-120.
Ukuze i-SQL Server isebenze ngokufanelekileyo kwihardware yanamhlanje, inkqubo yokusebenza ye-SQL Server (SQLOS) kufuneka iqonde uyilo lwehardware. Ngokufika kweenkqubo ezininzi ze-multi-core kunye ne-multi-node non-uniform memory access (NUMA), ukuqonda ubudlelwane phakathi kwee-cores, iiprosesa ezinengqiqo, kunye neeprosesa zenyama kubaluleke kakhulu.
Iiprosesa
IYunithi yoLungiso lweVirtual (vCPU) yiyunithi esembindini yenyani eyabelwe umatshini wenyani. Itotali yenani le-vCPUs eyabelweyo ibalwa ngolu hlobo:
Total vCPU = (ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ Π²ΠΈΡΡΡΠ°Π»ΡΠ½ΡΡ
ΡΠΎΠΊΠ΅ΡΠΎΠ²) * (ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ Π²ΠΈΡΡΡΠ°Π»ΡΠ½ΡΡ
ΡΠ΄Π΅Ρ Π½Π° ΡΠΎΠΊΠ΅Ρ)Ukuba intsebenzo ehambelanayo ibalulekile, i-VMware icebisa ukuba inani elipheleleyo le-vCPU elinikezelwe kubo bonke oomatshini benyani kufuneka lingagqithi inani elipheleleyo leentsimbi zomzimba ezifumanekayo kwinginginya ye-ESXi, kodwa unokwandisa inani lee-vCPU ezinikezelweyo ukuba iliso libonisa ukuba izixhobo ze-CPU ezingasetyenziswanga. ziyafumaneka.
Kwiinkqubo ezine-Intel Hyper-Threading Technology enikwe amandla, inani lee-core cores (vCPUs) liphindwe kabini inani leentsimbi zomzimba. Kule meko, musa ukwabela inani lilonke lee-vCPU.
I-Lower-tier SQL Server imithwalo yomsebenzi ayichatshazelwa kancinci kukuguquguquka kwe-latency. Ke, le mithwalo yemisebenzi inokuqhutywa kwiinginginya ezinomlinganiselo ophezulu wee-vCPU ukuya kwii-CPU zomzimba. Amanqanaba okusetyenziswa kwe-CPU afanelekileyo anokunyusa ukusebenza kwenkqubo iyonke, ukwandisa ukonga iilayisensi, kunye nokugcina ukusebenza okwaneleyo.
I-Intel Hyper-Threading ngokuqhelekileyo iphucula i-hostput yonke ye-host nge-10% ukuya kwi-30%, iphakamisa i-vCPU kumlinganiselo we-CPU womzimba we-1,1 ukuya kwi-1,3. I-VMware incoma ukwenza i-Hyper-Threading kwi-UEFI BIOS nanini na kunokwenzeka ukuze ESXi ithathe ithuba lobu bugcisa. I-VMware ikwacebisa uvavanyo olucokisekileyo kunye nokubeka iliso xa usebenzisa i-Hyper-Threading ye-SQL yomthwalo womsebenzi.
Imemori
Phantse zonke iiseva zanamhlanje zisebenzisa i-non-uniform memory access (NUMA) i-architecture yonxibelelwano phakathi kwememori ephambili kunye nabaqhubekisi. I-NUMA luyilo lwehardware yenkumbulo ekwabelwanayo ngayo esebenzisa ulwahlulo lweebhloko zenkumbulo yomzimba phakathi kweeprosesa ezibonakalayo. I-NUMA node yi-CPU enye okanye iisokethi ezininzi kunye nebhloko yememori eyabiweyo.
I-NUMA ibingumxholo ekuxoxwa ngawo kakhulu kule minyaka ilishumi idlulileyo. Ukuntsonkotha okunxulumene ne-NUMA kubangelwa ngokuyinxenye kumiliselo oluvela kubathengisi abohlukeneyo. Kwiindawo ezibonakalayo, ubunzima be-NUMA bukwamiselwa ngenani leenketho zokucwangcisa kunye neengqimba-ukusuka kwi-hardware ngokusebenzisa i-hypervisor ukuya kwinkqubo yokusebenza kweendwendwe kwaye ekugqibeleni kwisicelo se-SQL Server. Ukuqonda kakuhle ulwakhiwo lwezixhobo ze-NUMA yimfuneko kuyo nayiphi na i-SQL Server DBA eqhuba i-virtualized SQL Server.
Ukufezekisa ukusebenza kakuhle kwiiseva ezinenani elikhulu lee-cores, iMicrosoft yazisa iSoftNUMA. Isoftware yeSoftNUMA ikuvumela ukuba uhlukanise izixhobo ezifumanekayo ze-CPU ngaphakathi kwe-NUMA enye kwiinode ezininzi zeSoftNUMA. Ngokuka-VMware, iSoftNUMA iyahambelana ne-VMware's virtual NUMA (vNUMA) topology kwaye inokwandisa ngakumbi ubungakanani benjini yedatha kunye nokusebenza kobuninzi bomsebenzi...
Xa ujonga iVMware ngokusetyenziswa kweseva yeSQL:
- Beka iliso koomatshini benyani ukubona imithombo yememori ephantsi ye-SQL Server Database Engine. Lo mbandela ubangela ukwanda kwemisebenzi ye-I/O kunye nokunciphisa ukusebenza.
- Ukuphucula ukusebenza, thintela ingxabano yememori phakathi koomatshini benyani ngokuphepha ukugcwala kwememori kwinqanaba lamamkeli ESXi.
- Cinga ngokujonga i-hardware ye-NUMA yolwabiwo lwememori ebonakalayo ukumisela ubuninzi bememori enokwabelwa umatshini wenyani ngaphakathi kwemida ebonakalayo ye-NUMA.
- Ukuba ukufezekisa ukusebenza okwaneleyo kuyinjongo ephambili, cinga ukugcina imemori elingana nememori eyabelweyo. Olu cwangciso lweparameter luqinisekisa ukuba umatshini wenyani ufumana kuphela inkumbulo yomzimba.
Ugcino olwenziweyo
Ukumisela indawo yokugcina kwindawo ebonakalayo kufuna ulwazi lweziseko zokugcina. Njengokuba kunjalo nge-NUMA, kufuneka uqonde indlela amanqanaba ahlukeneyo e-I/O asebenza ngayo - kule meko, ukusuka kwisicelo kwi-VM, ukuya ekufundeni ngokomzimba kunye nokubhalwa kolwazi kwi-medium yokugcina eqhubekayo.
I-vSphere ibonelela ngenani leenketho zokuqwalasela ugcino, olunezicelo eziluncedo ekuphunyezweni koMncedisi weSQL kunye noluhlu lwe-Unity XT. I-FS VMFS yeyona ndlela isetyenziswa kakhulu yokugcina idatha kwiinkqubo zokugcina iibhloko ezifana ne-Unity XT. Ubumbano lwe-XT luluhlu olusezantsi oluquka iidrive ezibonakalayo ezivezwe yi-vSphere njengeediski zengqiqo (imiqulu). Imiqulu ye-Unity XT ifomathwe njengemiqulu yeVMFS yi-ESXi hypervisor. Abalawuli beVMware benza enye okanye ngaphezulu iidiski ezinenyani (VMDKs) ezithiwe thaca kwindlela yokusebenza yeendwendwe. I-RDM ivumela umatshini wenyani ukufikelela ngokuthe ngqo kwi-Unity XT yokugcina ibhloko (nge-FC okanye i-iSCSI) ngaphandle kokufomatha i-VMFS. I-VMFS kunye nemiqulu ye-RDM inokubonelela ngokugqithiswa kwentengiselwano efanayo.
Kugcino olusekwe kwi-NFS lwe-ESXi, i-Dell EMC icebisa ukuba kusetyenziswe i-VMware NFS endaweni yenjongo ngokubanzi yeenkqubo zefayile ye-NFS. Umatshini wenyani osebenza kwi-SQL Server kwaye usebenzisa i-VMDK kwivenkile yedatha ye-NFS awuqapheli umaleko we-NFS ongaphantsi. Inkqubo yokusebenza yeendwendwe iphatha umatshini wenyani njengomncedisi obonakalayo osebenzisa iWindows Server kunye neSQL Server. Iidiski ekwabelwana ngazo azixhaswa kuqwalaselo lomzekelo weqela le-faillover koovimba bedata be-NFS.
I-VMware vSphere Virtual Volumes (i-VVols) inikezela ngolawulo lwegranular ngakumbi kwinqanaba lomatshini wenyani, ozimeleyo kumelo olusezantsi lwememori yomzimba (njengemiqulu okanye iinkqubo zefayile). Ukuphindaphinda okusekwe kwi-Array kunye ne-VVols kuyaxhaswa ukuqala nge-VVol 2.0 (vSphere 6.5). Idiski ye-VVol ingasetyenziswa endaweni yediski ye-RDM ukubonelela ngesixhobo sediski kumzekelo we-SQL Failover Cluster eqala nge-vSphere 6.7 ngenkxaso yogcino lwe-SCSI oluqhubekayo.
Uthungelwano olubonakalayo
Uthungelwano kwihlabathi lenyani lulandela iikhonsepthi ezinengqiqo ezifanayo nasemhlabeni, kodwa isebenzisa isoftware endaweni yeentambo zomzimba kunye nokutshintsha. Impembelelo ye-network latency kwi-SQL Server imithwalo yomsebenzi ingahluka kakhulu. Ukubeka iliso kwiimetriki zokusebenza kwenethiwekhi kumthwalo okhoyo womsebenzi okanye inkqubo yovavanyo ephunyezwe kakuhle ngexesha lommeli inceda ekudaleni inethiwekhi yenyani.
Xa usebenzisa iVMware virtualization ngeSQL Server, qwalasela oku kulandelayo:
- Zombini iiswitshi ezisemgangathweni nezisasaziweyo zibonelela ngokusebenza okufunwa yi-SQL Server.
- Ukwahlula ngokwengqiqo ulawulo, i-vSphere vMotion, kunye netrafikhi yokugcina inethiwekhi, sebenzisa ukuthegiswa kweVLAN kunye namaqela okutshintsha okubonakalayo.
- I-VMware icebisa ngamandla ukwenza izakhelo ezinkulu kutshintsho olubonakalayo apho itrafikhi ye-vSphere vMotion okanye i-iSCSI traffic yenziwe yasebenza.
- Ngokubanzi, landela izikhokelo zothungelwano kwiinkqubo zokusebenza zeendwendwe kunye nehardware.
isiphelo
Imo yedatabase yomncedisi we SQL iya isiba nkulu kwaye intsonkothe ββngakumbi. Kwi-SQL Server 2019, iMicrosoft iphucule i-core SQL Server features kwaye yongeza ezintsha, ezifana nenkxaso yomthwalo omkhulu wedatha nge-Apache Spark kunye ne-HDFS. I-Dell EMC, ibambisene ne-Microsoft, iyaqhubeka nokubonelela ngamacandelo asisiseko ayimfuneko kwimo engqongileyo ye-SQL Server - iiseva, ukugcinwa kunye nothungelwano.
Sibona ukunyuka okuphawulekayo kwi-uptime kunye nokunciphisa iindleko ezipheleleyo zobunini (TCO) xa iingcali zokugcina kunye nedatha yedatha zisebenzisana kunye nokudala izisombululo zeziseko ze-SQL Server kwiiplatifomu zokugcina ezabelwana ngazo. I-Dell EMC Unity XT yonke i-flash-array sisisombululo esiphakathi esifanelekileyo kubaphuhlisi be-SQL Server kunye nabalawuli abafuna ukusebenza okuphezulu kunye ne-latency ephantsi. Idizayinelwe ukuba isebenze kuzo zonke ii-flash drives, i-Unity XT All-Flash ixhasa ii-CPU ezimbini, ulungelelwaniso lolawulo olumbini, kunye nosetyenziso olungundoqo oluninzi.
Ngokunyukayo, imibutho ijonga imeko-bume ye-SQL Server yayo. Nangona i-virtualization yongeza enye umaleko woyilo kwisitaki soyilo, ibonelela ngeenzuzo ezibalulekileyo. Siyathemba ukuba uya kufumana ezinye zezona mpawu zisetyenziswa kakhulu zeVMware kunye nezixhobo ezinikezelwe ngasentla ziluncedo kwiimekobume zeSeva yeSQL. Sikwacebisa amakhonkco kwizibonelelo ngolwazi oluthe vetshe.
amakhonkco aluncedo
Dell EMC
- (iphepha lemveliso)
- (YouTube)
VMware
Microsoft
umthombo: www.habr.com