Lero tikudziwitsani za momwe mungagwiritsire ntchito SQL Server 2019 ndi Unity XT yosungirako, ndikuperekanso malingaliro pakusintha SQL Server pogwiritsa ntchito ukadaulo wa VMware, kukhazikitsa ndi kuyang'anira magawo oyambira a Dell EMC.
Mu 2017, Dell EMC ndi VMware adasindikiza zotsatira za kafukufuku wokhudza momwe SQL Server ikusinthira - "SQL Server Transformation: Towards Agility and Resilience" (), yomwe idagwiritsa ntchito zomwe gulu la mamembala a Professional Association of SQL Server (PASS). Zotsatira zikuwonetsa kuti malo a database a SQL Server akukula kukula ndi zovuta, motsogozedwa ndi kuchuluka kwa data ndi zofunikira zatsopano zamabizinesi. Ma database a SQL Server tsopano akugwiritsidwa ntchito m'makampani ambiri, kulimbikitsa ntchito zofunikira kwambiri, ndipo nthawi zambiri ndi maziko a kusintha kwa digito.
Popeza kuti kafukufukuyu adachitidwa, Microsoft yatulutsa mbadwo wotsatira wa DBMS - SQL Server 2019. Kuwonjezera pa kukonza ntchito zoyambira za injini yaubale ndi kusungirako deta, mautumiki atsopano ndi ntchito zawonekera. Mwachitsanzo, SQL Server 2019 imaphatikizanso chithandizo chazochulukira zama data pogwiritsa ntchito Apache Spark ndi Hadoop Distributed File System (HDFS).
Alliance Dell EMC ndi Microsoft
Dell EMC ndi Microsoft ali ndi mgwirizano wanthawi yayitali popanga mayankho a SQL Server. Kugwiritsa ntchito bwino malo osungiramo zinthu monga Microsoft SQL Server kumafuna kugwirizanitsa machitidwe a mapulogalamu ndi maziko a IT. Zomangamangazi zikuphatikiza mphamvu yosinthira purosesa, zothandizira kukumbukira, kusungirako ndi mautumiki apaintaneti. Dell EMC imapereka maziko a nsanja ya SQL Server pamtundu uliwonse wantchito ndi kugwiritsa ntchito.
Dell EMC PowerEdge seva mzere amapereka zosiyanasiyana purosesa ndi kukumbukira kasinthidwe. Zosinthazi ndizoyenera kutengera ntchito zambiri: kuchokera kumakampani ang'onoang'ono kupita ku machitidwe akuluakulu ofunikira kwambiri, monga makonzedwe azinthu zamabizinesi (ERP), malo osungiramo data, ma analytics apamwamba, e-commerce, ndi zina zambiri. kusunga deta yosalongosoka.
Makasitomala omwe amatumiza SQL Server 2019 yokhala ndi zomangamanga za Dell EMC amatha kugwira ntchito ndi data yokhazikika komanso yosasinthika pogwiritsa ntchito SQL Server ndi Apache Spark. SQL Server imathandiziranso kuphatikiza kwa kasitomala, seva-to-server, ndi matekinoloje olumikizirana a seva-to-storage. Masomphenya a Dell EMC adatengera mtundu wogawanika womwe umapereka chilengedwe chotseguka. Mabungwe angasankhe kuchokera kumagulu osiyanasiyana ogwiritsira ntchito makina ochezera a pa Intaneti, machitidwe opangira ntchito ndi nsanja za hardware. Njirayi imakupatsani mphamvu zowongolera matekinoloje ndi zomangamanga, zomwe zimapangitsa kuti pakhale ndalama zambiri komanso kusinthasintha.
VMware imagwiritsa ntchito zida zonse zofunikira zomwe SQL Server ikufunika kuti ikwaniritse magwiridwe antchito komanso kusasinthika kwa magwiridwe antchito. Kuphatikiza pa mtambo wachinsinsi, VMware imaperekanso mitundu yosakanizidwa yolemetsa ntchito, yoyambira pagulu komanso pagulu.
Mabungwe ambiri akutembenukira ku virtualization kuti achepetse ndalama zogwirira ntchito, kupereka kupezeka kwakukulu, komanso kuchepetsa kuchira pakachitika masoka. 94% ya akatswiri a SQL Server omwe adafunsidwa adanenanso zakusintha kwachilengedwe m'malo awo. 70% ya omwe amagwiritsa ntchito virtualization adasankha VMware. 60% ali ndi SQL Server virtualization milingo ya 75% kapena kupitilira apo. Kuonjezera apo, zotsatira za kafukufuku zimasonyeza kuti kupezeka kwakukulu ndi kubwezeretsedwa kwa masoka komwe kumagwiritsidwa ntchito pa virtualization wosanjikiza zakhala zofunikira pa chisankho cha SQL Server databases.
Zatsopano mu SQL Server 2019
Tsamba la database la SQL Server 2019 limaphatikizapo matekinoloje osiyanasiyana, mawonekedwe, ndi ntchito zomwe zimathandizira ntchito zofunika kwambiri monga ma analytics, nkhokwe zamabizinesi, nzeru zamabizinesi (BI), ndi scalable transaction process (OLTP). Pulatifomu ya SQL Server yapeza mphamvu zoyendetsera kuphatikizika kwa data, kusungirako deta, kupereka malipoti ndi kusanthula kwapamwamba, kuthekera kobwerezabwereza, komanso kuyang'anira mitundu ya data yokhazikika. Inde, si makasitomala onse kapena mapulogalamu omwe amafunikira zonsezi. Kuphatikiza apo, nthawi zambiri ndikwabwino kupatutsa mautumiki a SQL Server pogwiritsa ntchito virtualization.
Masiku ano, mabizinesi nthawi zambiri amafunikira kudalira kuchuluka kwa data kuchokera kumagulu osiyanasiyana omwe akuchulukirachulukira. Ndi SQL Server 2019, mutha kudziwa zenizeni zenizeni kuchokera ku data yanu yonse. Magulu a SQL Server 2019 amapereka malo okwanira kuti azigwira ntchito ndi ma data akuluakulu, kuphatikizapo kugwiritsa ntchito makina ophunzirira ndi luntha lochita kupanga. Zatsopano zazikulu ndi zosintha mu SQL Server 2019 zalembedwa .
Dell EMC Unity XT Mid-Range Storage System
Zosungirako za Dell EMC Unity zidakhazikitsidwa pafupifupi zaka zitatu zapitazo, ndipo kuyambira pamenepo makina opitilira 40 agulitsidwa. Makasitomala amayamikira izi zapakatikati chifukwa cha kuphweka kwake, machitidwe ake komanso kutsika mtengo. Dell EMC Unity XT midrange mapulaneti ndi njira zosungiramo zogawana zomwe zimapereka latency yotsika, kutulutsa kwakukulu, ndi kasamalidwe kakang'ono ka ntchito za SQL Server. Machitidwe onse a Unity XT amagwiritsa ntchito zomangamanga zapawiri zosungiramo (SP) kuti zigwirizane ndi I/O ndi ntchito za data zogwira ntchito. Unity XT dual SP imagwiritsa ntchito kulumikizana kwathunthu kwamkati kwa 000Gbps SAS komanso mamangidwe amitundu yambiri kuti agwire bwino ntchito komanso kuchita bwino. Ma Disk arrays amakulolani kuti muwonjezere mphamvu zosungirako pogwiritsa ntchito mashelufu owonjezera.
Dell EMC Unity XT, m'badwo wotsatira wa masanjidwe (wosakanizidwa ndi mawonekedwe onse), amawonjezera magwiridwe antchito, amawongolera magwiridwe antchito, ndikuwonjezera kuthekera kwatsopano ndi ntchito zamitundu yambiri yamtambo.
Zomangamanga za Unity XT zimakupatsani mwayi wokonza deta nthawi imodzi, kuchepetsa kuchuluka kwa data, ndi ntchito zothandizira monga kubwereza popanda kusiya kugwiritsa ntchito pulogalamu. Poyerekeza ndi yankho la mbadwo wakale, ntchito ya Dell EMC Unity XT yosungirako dongosolo imawirikiza kawiri ndipo nthawi yoyankha ndi 75% mofulumira. Ndipo zowonadi, Dell EMC Unity imathandizira mulingo wa NVMe.
Makina osungira omwe ali ndi ma drive a NVMe akuwonetsa momwe amachitira bwino pamapulogalamu omwe amakhudzidwa ndi latency. Mwachitsanzo, m'mapulogalamu monga nkhokwe zazikulu, NVMe imapereka latency yotsika komanso mitengo yapamwamba kwambiri ya data. Kuchepekera kwa latency komanso kuchulukirachulukira kwa ndalama kumawongolera kwambiri kuwerenga / kulemba. Sizongochitika mwangozi kuti, malinga ndi kulosera kwa IDC, pofika 2021, ma flash arrays okhala ndi NVMe ndi NVMe-oF (NVMe-oF (NVMe over Fabric)) adzawerengera pafupifupi theka la ndalama zonse kuchokera ku malonda a makina osungira kunja padziko lapansi.
Ma compression algorithms a data amathandizira kusunga bwino. Dell EMC Unity XT imatha kuchepetsa kuchuluka kwa data mpaka kasanu. Chizindikiro china chofunikira ndi mphamvu yonse ya dongosolo. Dell EMC Unity XT imagwiritsa ntchito 85% mphamvu yamakina. Kuponderezana ndi kuchotsera kumachitika mumayendedwe apakatikati - pamlingo wowongolera. Deta amasungidwa mu wothinikizidwa mawonekedwe. Dongosololi limagwiranso ntchito ndi zithunzi za data.
Zosavuta kugwiritsa ntchito zowunikira za Unity zokhala ndi mwayi wolumikizana (ma block ndi mafayilo) zimapereka nthawi zokhazikika zoyankhira, kuphatikiza ndi ntchito zosungira mitambo, ndikuthandizira kukweza popanda kusamuka kwa data. Pamakonzedwe ake oyambira, makina osungira osunthikawa amakhazikitsa mphindi 30.
Tekinoloje yosungira deta yotchedwa "madamu amphamvu" imakulolani kuti musunthe kuchoka ku static kupita ku kukula kwa kukumbukira kukumbukira, kumapereka kusinthasintha kwakukulu kwa ntchito komanso kumasuka kwa kuwonjezeka kwa dongosolo. Maiwe amphamvu amapulumutsa mphamvu ndi bajeti, ndipo amafunikira nthawi yochepa kuti amangenso. Kukulitsa mphamvu ndi magwiridwe antchito a Dell EMC Unity sikufuna kusamuka kwa data.
Makampani ambiri masiku ano amagwiritsa ntchito ntchito zingapo zamtambo za anthu kuphatikiza ndi zida zawo zapanyumba. Dell EMC Unity XT ikhoza kugwira ntchito ngati gawo la chilengedwe cha Dell Technologies Cloud. Njira yosungirayi ingagwiritsidwe ntchito mumtambo wa anthu ndipo deta ikhoza kusamutsidwa kumtambo wachinsinsi. Kuphatikiza apo, Dell EMC Unity XT yosungirako ikupezeka ngati ntchito. Ichi ndi chimodzi mwazinthu zosungira mitambo za Dell EMC Cloud Storage Services.
Kusungirako mitambo kukuchulukirachulukira chifukwa kumatha kukonza ROI pochepetsa mtengo wa zomangamanga. Cloud Storage Services imakulitsa malo osungira makasitomala kumtambo popereka zosungirako za Dell EMC (zolumikizidwa mwachindunji ndi zida zamtambo wapagulu) ngati ntchito. Othandizira a chipani chachitatu angapereke maulumikizidwe amtambo othamanga kwambiri (otsika latency) mwachindunji ku Dell EMC Unity, PowerMax ndi Isilon machitidwe mu data center ya kasitomala.
Banja la Unity XT limaphatikizapo Unity XT All-Flash, Unity XT Hybrid, UnityVSA ndi machitidwe a Unity Cloud Edition.
Unified Hybrid ndi Flash Arrays
Makina osungira a Intel-based Unity XT Hybrid ndi Unity XT All-Flash amapereka mamangidwe ophatikizika a block access, kupeza mafayilo, ndi VMware VVols mothandizidwa ndi network attached storage (NAS), iSCSI, ndi Fiber Channel (FC). Mapulatifomu a Unity XT Hybrid ndi Unity XT All-Flash ali okonzeka NVMe.
Makina osakanizidwa a Unity XT amathandizira malo okhala ndi mitambo yambiri. Mitambo yambiri imatanthawuza kukulitsa kusungirako kumtambo kapena kutumiza kumtambo ndi njira zosinthira zogwiritsira ntchito zida. Multicloud yosungirako idapangidwa kuti iwonetsetse kuyenda ndi kusuntha kwa data pakati pa nsanja zingapo zamtambo - zachinsinsi komanso zapagulu. Izi sizikukhudza kokha njira zoyendetsera deta, komanso bungwe la kugwiritsa ntchito deta kumitambo yambiri ya anthu.
Ma hybrid arrays awa amapereka izi:
- Scalable to 16 PB yaiwisi mphamvu.
- Kuthekera kwapang'onopang'ono kwa data pama dziwe onse a flash.
- Kukhazikitsa mwachangu ndi kasinthidwe (pafupifupi zimatenga mphindi 25).
Ukadaulo wa SSD ukukula mwachangu, ndipo zatsopano zosintha zidzafika pamsika zaka zikubwerazi. Pakadali pano, mabungwe apitiliza kusintha ma HDD achikhalidwe ndi ma SSD kuti agwire bwino ntchito, kuyendetsa bwino komanso kupulumutsa mphamvu. Mibadwo yatsopano yamitundu yonse yowunikira idzakhala ndi makina osungira otsogola, kuphatikiza mtambo wapagulu, ndi chitetezo chophatikizika cha data.
Makina a Unity XT All-Flash amapereka liwiro, magwiridwe antchito, komanso kuthandizira kwamitundu yambiri. Makhalidwe awo:
- Kuchulukitsa kawiri.
- Kuchepetsa deta mpaka 7: 1.
- Kukhazikitsa mwachangu ndi kasinthidwe (njirayi imatenga mphindi zosakwana 30).
UnityVSA
UnityVSA ndi malo osungiramo mapulogalamu a VMware ESXi omwe amagwiritsa ntchito seva, kugawana, kapena kusungirako mitambo. UnityVSA HA, kasinthidwe ka UnityVSA kosungira kawiri, kumapereka kulolerana kowonjezera. UnityVSA yosungirako imapereka:
- Kufikira 50 TB ya mphamvu yosungira yogwirizana.
- Imagwirizana ndi machitidwe a Unity XT ndi mawonekedwe.
- Thandizo la machitidwe opezeka kwambiri (UnityVSA HA).
- Kulumikizana monga NAS ndi iSCSI.
- Kubwereza kwa data kuchokera kumapulatifomu ena a Unity XT.
Unity Cloud Edition
Pakulumikiza mafayilo ndi ntchito zobwezeretsa masoka ndi mtambo, banja la Unity XT limaphatikizapo Unity Cloud Edition, yomwe imapereka:
- Zokwanira zosungirako zosungidwa pogwiritsa ntchito pulogalamu-defined storage (SDS) zoyikidwa mumtambo.
- Sungani mosavuta chipika ndi kusungira mafayilo ndi VMware Cloud pa AWS.
- Thandizo lobwezeretsa masoka, kuphatikizapo kuyesa ndi kusanthula deta.
Unity XT All Flash ya SQL Server
Lipoti la Unisphere Research la 2017, "SQL Server Transformation: Towards Agility and Resilience" () 22% ya omwe anafunsidwa adanena kuti amagwiritsa ntchito teknoloji yosungiramo zinthu zakale popanga (16%) kapena akukonzekera kutero (6%). 30% amagwiritsa ntchito mitundu yosakanizidwa yomwe imaphatikizapo kukumbukira kwa flash. 13% amagwiritsa ntchito zowunikira molunjika. 13% sungani zosunga zobwezeretsera za SQL Server kuti musunge flash.
Kutengera kofulumira kumeneku kosungirako kung'anima kuti mugwiritse ntchito ndi SQL Server kumatanthauza kuti magulu a Unity XT All-Flash ndi oyenera makamaka kwa opanga ma SQL Server ndi oyang'anira. Machitidwe a Unity XT All-Flash amapatsa opanga ma SQL Server ndi oyang'anira kuthekera ndi magwiridwe antchito omwe amapitilira zomwe ma network osungira malo (SANs) amapereka.
Machitidwe a Unity XT All-Flash, omwe ali okonzeka NVMe (chifukwa chapamwamba kwambiri komanso otsika latency), ali ndi mawonekedwe a 2U, othandizira awiri-core processors, olamulira awiri mumayendedwe ogwira ntchito / ogwira ntchito.
Mitundu ya Unity XT All-Flash
Unity XT
Mapulogalamu
Memory (pa purosesa)
Max. chiwerengero cha magalimoto
Max. "yaiwisi" mphamvu (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 Golide 6130
16c/2.1 GHz
384
1,500
16.0
Tsatanetsatane imapezeka m'magulu osiyanasiyana ().
Maiwe Osungirako
Akatswiri ambiri a SQL Server amadziwa kuti zida zonse zamakono zosungirako zimapereka mwayi wogwirizanitsa ma disks m'magulu akuluakulu osungira omwe ali ndi chitetezo chokhazikika cha RAID. Magulu a disk omwe ali ndi chitetezo cha RAID ndi maiwe osungira achikhalidwe. Ngakhale makina osakanizidwa a Unity XT amathandizira maiwe azikhalidwe, Unity XT All-Flash arrays amaperekanso maiwe osungira osinthika. Ndi maiwe osungira osunthika, chitetezo cha RAID chimagwiritsidwa ntchito ku disk sizes-magawo osungira ang'onoang'ono kuposa disk yonse. Maiwe amphamvu amapereka kusinthasintha kwakukulu pakuwongolera ndi kukulitsa maiwe a disk.
Dell EMC imapereka njira zabwino zowongolera maiwe osungira kuti akwaniritse magwiridwe antchito movutikira. Mwachitsanzo, tikulimbikitsidwa kuchepetsa kuchuluka kwa maiwe osungira a Unity XT kuti muchepetse zovuta ndikuwonjezera kusinthasintha. Komabe, kukhazikitsa maiwe osungirako owonjezera kungakhale kothandiza nthawi zina, kuphatikizapo pamene mukufunikira:
- Thandizani kulemedwa kwa ntchito zosiyanasiyana ndi ma I/O osiyanasiyana.
- Perekani zothandizira kuti mukwaniritse zofunikira zina.
- Perekani zida zosiyana zogwirira ntchito zambiri.
- Pangani madera ang'onoang'ono kuti muteteze ku kulephera
Ma voliyumu osungira (LUNs)
Kodi mumalinganiza bwanji kuwongolera ndi kusinthasintha posankha kuchuluka kwa ma voliyumu pamndandanda? Kuti muzitha kusinthasintha kwambiri mu Unity ndi SQL Server, tikulimbikitsidwa kupanga ma voliyumu pa fayilo iliyonse ya database. M'malo mwake, mabungwe ambiri amatenga njira yocheperako, pomwe ma database ofunikira amapatsidwa kusinthasintha kwakukulu ndipo mafayilo osafunikira kwambiri amasanjidwa m'magulu ochepa, akulu. Tikukulimbikitsani kuunikanso zofunikira zonse za nkhokwe ndi mapulogalamu aliwonse ogwirizana nawo chifukwa chitetezo cha data ndiukadaulo wowunikira zimadalira kuyika mafayilo pawokha komanso kuyika.
Ma voliyumu angapo nthawi zambiri amakhala ovuta kuwongolera, makamaka m'malo enieni. Madera a Virtualized SQL Server ndi chitsanzo chabwino cha komwe kuchititsa mitundu ingapo yamafayilo pa voliyumu imodzi kumatha kukhala komveka. Woyang'anira nkhokwe kapena woyang'anira yosungirako (kapena onse awiri) ayenera kusankha moyenera pakati pa kusinthasintha ndi kusamalitsa pozindikira kuchuluka kwa ma voliyumu kuti apange.
Kusungira mafayilo
Ma seva a NAS amakhala ndi mafayilo amafayilo pa Unity XT yosungirako. Mafayilo amatha kupezeka pogwiritsa ntchito ma protocol a SMB kapena NFS, ndipo ndi ma fayilo amitundu yambiri, mutha kugwiritsa ntchito ma protocol onse nthawi imodzi. Ma seva a NAS amagwiritsa ntchito njira zolumikizirana kuti alumikizitse wolandirayo ku SMB, NFS, ndi ma multiprotocol system system, komanso VMware NFS yosungirako ndi VMware pafupifupi voliyumu. Mafayilo amafayilo ndi mawonekedwe owonekera amakhala okhazikika mkati mwa seva imodzi ya NAS, kulola ma seva angapo a NAS kuti agwiritsidwe ntchito pakupanga zinthu zambiri. Ma seva a NAS amalephera pokhapokha ngati purosesa yosungirayo yalephera. Mafayilo ogwirizana nawo amalepheranso.
SQL Server 2012 (11.x) ndi mitundu ina yamtsogolo imathandizira Server Message Block (SMB) 3.0, yomwe imalola kugawana mafayilo amtundu kuti asungidwe. Pazikhazikiko zonse zamagulu oyimira ndi olephera, mutha kukhazikitsa ma database (master, model, msdb, ndi tempdb) ndi database ya ogwiritsa ntchito Database Engine ndi njira yosungira ya SMB. Kugwiritsa ntchito SMB yosungirako ndi njira yabwino mukamagwiritsa ntchito Magulu Opezeka Nthawi Zonse chifukwa kugawana mafayilo kumafuna mwayi wopezeka pamanetiweki omwe amapezeka kwambiri.
Kupanga magawo amafayilo a SMB kuti atumizidwe ku SQL Server yokhala ndi Unity XT yosungirako ndi njira yosavuta yanjira zitatu: mumapanga seva ya NAS, fayilo yamafayilo, ndi gawo la SMB. Pulogalamu ya Dell EMC Unisphere Storage Management imaphatikizapo wizard yosinthira kukuthandizani kumaliza ntchitoyi. Komabe, mukamachititsa SQL Server zochulukira pamagawo amafayilo a SMB, pali mfundo zina zofunika kuzikumbukira zomwe sizikukhudza kugwiritsa ntchito magawo a fayilo ya SMB. Microsoft yalemba mndandanda wazovuta za kukhazikitsa ndi chitetezo pamodzi ndi zomwe zikudziwika pano; Kuti mudziwe zambiri, onani "Kukhazikitsa SQL Server yokhala ndi SMB File Storage" mu .
Zithunzi za Data
Deta yakhala gwero lofunika kwambiri pakampani, ndipo malo amasiku ano ovuta kwambiri amafunikira zambiri kuposa kungowonjezera. Ndikofunikira kuti mapulogalamu azikhala pa intaneti nthawi zonse, operekedwa ndi ntchito zosasokoneza komanso zosintha. Amafunanso magwiridwe antchito apamwamba komanso kupezeka kwa data kudzera muzosankha monga kubwereza kwachidule chakumaloko komanso kubwereza kwakutali.
Gulu losungiramo la Unity XT limapereka kuthekera kwazithunzi ndi mafayilo omwe amagawana mayendedwe wamba, magwiridwe antchito, ndi zomangamanga. Njira yachidule ya Unity imapereka njira yosavuta komanso yothandiza yotetezera deta. Zojambulajambula zimapangitsa kuti zikhale zosavuta kubwezeretsa deta - bwererani ku chithunzi choyambirira, kapena mukhoza kukopera deta yosankhidwa kuchokera pa chithunzi cham'mbuyo. Gome lotsatirali likuwonetsa nthawi yosungiramo chithunzithunzi cha machitidwe a Unity XT.
Kusungirako kwanuko komanso kutali kwazithunzi za data
Mtundu wa zithunzi
CLI
UI
Bwerani
Manja
Inakonzedwa
Manja
Inakonzedwa
Manja
Inakonzedwa
Local
Chaka cha 1
Chaka cha 1
Zaka 5
Masabata a 4
Zaka 100
Palibe malire
Kutali
Zaka 5
Masabata a 255
Zaka 5
Masabata a 255
Zaka 5
Masabata a 255
Zithunzi sizosintha mwachindunji njira zina zotetezera deta, monga zosunga zobwezeretsera. Amatha kungowonjezera zosunga zobwezeretsera zachikhalidwe ngati njira yoyamba yodzitchinjiriza pazochitika zochepa za RTO.
Chithunzi chachidule cha Dell EMC Unity chimaphatikizapo kuchepetsa deta komanso kuchotseratu kwapamwamba. Ma Snapshots amapindulanso ndi kusungidwa kwa malo komwe kumatheka pachosungira choyambirira. Mukajambula chithunzithunzi cha malo osungira omwe amathandizira kuchepetsa deta, deta yomwe ili pagwero ikhoza kupanikizidwa kapena kuchotsedwa.
Nazi zina zokhuza kubwezeretsedwa kwa database mukamagwiritsa ntchito zithunzi ndi ma database a SQL Server:
- Zigawo zonse za SQL Server database ziyenera kutetezedwa ngati seti ya data. Pamene mafayilo ndi zolemba zili pa LUN zosiyanasiyana, ma LUN amenewo ayenera kukhala m'gulu limodzi. Gulu losasinthika limawonetsetsa kuti chithunzithunzi chikujambulidwa nthawi imodzi pa ma LUN onse pagulu. Mafayilo amtundu wa data ndi logi ali pamafayilo angapo a SMB, magawowo ayenera kukhala pamafayilo omwewo.
- Mukabwezeretsanso database ya SQL Server kuchokera pazithunzi zozikidwa pa block, ngati SQL Server fanizo liyenera kukhala lolumikizidwa, gwiritsani ntchito kujowina kwa Unisphere. Pakuchira kochokera pamafayilo, gawo lowonjezera la SMB limapangidwa pogwiritsa ntchito chithunzithunzi ngati gwero. Ma voliyumuwo atakwezedwa, nkhokweyo imatha kulumikizidwa pansi pa dzina lina kapena database yomwe ilipo ikhoza kusinthidwa ndi yobwezeretsedwa.
- Pamene mukubwezeretsa pogwiritsa ntchito njira ya Snapshot Restore ku Unisphere, tengani chitsanzo cha SQL Server popanda intaneti. SQL Server sadziwa za kubwezeretsa ntchito. Kutenga chitsanzo pa intaneti kumawonetsetsa kuti ma voliyumu sawonongeka ndi nkhokwe yolemba asanabwezeretse. Chitsanzocho chikangoyambiranso, kubwezeretsedwa kwa tsoka la SQL Server kudzabweretsa ma database kukhala ofanana.
- Yambitsani zithunzi za zinthu zingapo zosungira nthawi imodzi, ndiyeno onetsetsani kuti makinawa ali m'njira zovomerezeka musanalowetse zithunzi zina.
Automation ndi ndandanda wa kuwombera
Zithunzi mu Unity XT zitha kukhala zokha. Zosankha zotsatizana zotsatirazi zikupezeka mu Unisphere storage management: chitetezo chosasinthika, chitetezo chachifupi chosungira, komanso chitetezo chosunga nthawi yayitali. Njira iliyonse imatenga zithunzi zatsiku ndi tsiku ndikuzisunga nthawi zosiyanasiyana.
Mutha kusankha imodzi (kapena zonse ziwiri) mwazosankha - ma x aliwonse (kuyambira 1 mpaka 24) ndi tsiku / sabata. Kukonzekera kwazithunzi zatsiku ndi tsiku/sabata kumakupatsani mwayi wofotokozera nthawi ndi masiku enieni oti mujambule. Pachisankho chilichonse chosankhidwa, muyenera kukhazikitsa ndondomeko yosungira, yomwe ingakonzedwe kuti ichotse dziwe kapena kulisunga kwakanthawi.
Zambiri zazithunzi za Unity - pa .
Ma clones woonda
Chojambula chochepa thupi ndi chowerengera chowerengera / cholemba chosungirako chocheperako, monga voliyumu, gulu losasinthika, kapena sitolo ya VMware VMFS, yomwe imagawana midadada ndi gwero la makolo ake. Ma clones owonda ndi njira yabwino yoperekera mwachangu komanso molumikizana makope a database ya SQL Server, zomwe zida zachikhalidwe za SQL Server sizingakwaniritse. Kachilombo kakang'ono kamene kamaperekedwa kwa mwiniwakeyo, mavoliyumu akhoza kubweretsedwa pa intaneti ndipo deta idzaphatikizidwa pogwiritsa ntchito njira ya DB Attach mu SQL Server.
Mukamagwiritsa ntchito mawonekedwe okweza okhala ndi ma clones opyapyala, tengani nkhokwe zonse za clone yopyapyala popanda intaneti. Izi ziyenera kuchitika musanayambe ntchito yowonjezera. Kulephera kutenga nkhokwe zapaintaneti musanayambe kukweza kungayambitse zolakwika za data kapena zotsatira zolakwika pa SQL Server.
Kubwereza kwa data
Replication ndi pulogalamu yomwe imagwirizanitsa deta ndi makina akutali pamalo omwewo kapena malo ena. Zosankha zobwerezabwereza ndi kasinthidwe za Unity zimakulolani kuti musankhe njira yabwino yokwaniritsira zofunikira za RTO/RPO za nkhokwe za SQL Server pomwe mukusanja magwiridwe antchito ndi kutulutsa.
Mukamagwiritsa ntchito Dell EMC Unity Replication kuti muteteze nkhokwe za SQL Server pamavoliyumu angapo, muyenera kuchepetsa ma data onse ndi ma voliyumu amtundu wa database ku gulu limodzi losasinthika kapena mafayilo amafayilo. Kubwereza kumakhazikitsidwa pagulu kapena kachitidwe ka mafayilo ndipo kumatha kuphatikiza ma voliyumu kapena magawo azinthu zingapo. Zosungira zomwe zimafuna njira zobwereza zosiyana ziyenera kukhala pa LUNs zosiyana, magulu osasinthasintha, kapena mafayilo amafayilo.
Ma clones owonda amagwirizana ndi ma synchronous ndi asynchronous replication. Chojambula chopyapyala chikatsatiridwa kumalo komwe akupita, chimakhala buku lonse la voliyumu, gulu losasinthika, kapena kusungidwa kwa VMFS. Pambuyo kubwereza, clone yopyapyala ndi voliyumu yodziyimira yokha yokhala ndi zoikamo zake.
Njira yobwerezabwereza yopyapyala pakati pa magwero ndi machitidwe omwe mukufuna.
Kubwereza kwa database ya tempdb sikofunikira chifukwa fayilo imamangidwanso pamene SQL Server iyambiranso, choncho metadata sikugwirizana ndi njira zina za SQL Server. Kusankha mosamala ma voliyumu kuti abwereze komanso zomwe zili m'mavoliyumuwo kumachotsa kuchuluka kwa magalimoto osafunikira.
Integrated Microsoft SQL Server Data Copy Management
Zosungira zamakono zambiri (kuphatikiza zinthu zonse za Dell EMC) zitha kupanga makope a "operating system" amtundu uliwonse wamafayilo ndi:
- Kukhazikika kwadongosolo lolemba ndi makina ogwiritsira ntchito pamilingo yonse - kuchokera pagulu mpaka pagalimoto.
- Kuyika ma voliyumu m'magulu kuti mafayilo angapo amavoliyumu osiyanasiyana azikhala ndi dongosolo lolembera.
Ndi kufalikira kwa zida zosungirako zowopsa, Microsoft yapanga API yaosungirako. API iyi imalola osungira kuti agwirizane ndi pulogalamu ya database ya SQL Server kuti apange "makope osasinthika" pogwiritsa ntchito Volume Shadow Copy Service (VSS). Makopewa amatsanzira kuyanjana kwapakati pa SQL Server ndi makina ogwiritsira ntchito panthawi yomwe SQL Server yakonzedwa ndikuyimitsa. Ma buffers onse amasinthidwa ndipo zosintha zimayimitsidwa mpaka ma disks onse asinthidwa komanso osasinthasintha panthawi inayake, yomwe imalembedwa mu chipika cha SQL.
Mapulogalamu a Dell EMC AppSync ophatikizidwa ndi zithunzithunzi za Unity XT amathandizira ndikusinthiratu njira yopangira, kugwiritsa ntchito, ndi kuyang'anira makope osagwirizana ndi ntchito. Pulogalamuyi idapangidwa kuti igwiritsidwe ntchito poyang'anira zochitika kuti mubwezeretsenso database ndikugwiritsanso ntchito.
Mapulogalamu a AppSync amangodzipeza okha nkhokwe za pulogalamu, amaphunzira momwe nkhokwe yake imapangidwira, ndikuyika mapu a fayilo kudzera pa hardware kapena zigawo za virtualization kupita ku malo osungira a Unity XT. Imawongolera njira zonse zofunika, kuyambira pakupanga ndi kutsimikizira kopi mpaka kuyika zithunzithunzi pa omwe akutsata ndikuyamba kapena kubwezeretsanso nkhokwe. AppSync imathandizira ndi kufewetsa mayendedwe a SQL Server omwe amaphatikizapo kukonzanso ndi kubwezeretsanso nkhokwe zopangira.
Kuchepetsa deta ndi kuchotsera kwapamwamba
Banja la Dell EMC Unity la makina osungira limapereka zinthu zambiri, zosavuta kugwiritsa ntchito zochepetsera deta. Kusungirako sikumapindula kokha pazosungirako zoyambira zokhazikitsidwa, komanso pazithunzithunzi ndi ma clones oonda azinthu izi. Zithunzi ndi ma clones oonda amatengera kutsitsa kwa data komwe kumasungidwa, komwe kumawonjezera kupulumutsa mphamvu.
Kuchepetsa zidziwitso kumaphatikizapo kuchotsera, kuponderezana, ndi kuzindikira ziro block, zomwe zitha kuwonjezera kuchuluka kwa malo osungira omwe angagwiritsidwe ntchito pazinthu za ogwiritsa ntchito ndikugwiritsa ntchito mkati. Mbali yochepetsera data ya Unity XT ilowa m'malo mwa compression mu Unity OE 4.3 ndi pambuyo pake. Compression ndi njira yochepetsera deta yomwe ingachepetse kugawika kwamphamvu komwe kumafunikira kuti musunge deta.
Machitidwe a Unity XT amaperekanso mawonekedwe apamwamba kwambiri omwe angathe kuthandizidwa ngati kuchepetsa deta kutha. Kuchotsa kwapamwamba kumachepetsa mphamvu yofunikira pa data ya ogwiritsa ntchito posunga makope ochepa chabe (nthawi zambiri kopi imodzi) ya midadada ya data ya Unity. Malo ochotserako ndi LUN imodzi. Ganizirani izi posankha chiwembu chosungira. Ma LUN ocheperako amabweretsa kutsika kwabwinoko, koma ma LUN ambiri amapereka magwiridwe antchito abwino.
Kusungidwa kwa mphamvu kuchokera ku deduplication yapamwamba kungapereke phindu lalikulu m'madera ambiri, komanso kumafunika kugwiritsa ntchito ma processor a Unity array. Mu OE 5.0, kuchotsera kwapamwamba, kukayatsidwa, kumachotsa chipika chilichonse (choponderezedwa kapena chosakanizidwa). Kuti mudziwe zambiri, onani .
Gome lotsatirali likuwonetsa masinthidwe omwe amathandizira kuti achepetse deta ndikuchotsanso patsogolo:
Kuchepetsa kwa data mu Unity (mitundu yonse) komanso kuthandizira kowonjezera
Mtundu wa Unity OE
umisiri
Mtundu wa dziwe lothandizira
Ma Model Othandizira
4.3 / 4.4
Kuchepetsa deta
Flash memory pool - yachikhalidwe kapena yamphamvu
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
4.5
Kuchepetsa deta
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
Kuchepetsa kwa data ndikuchotsa kwapamwamba *
450F, 550F, 650F
5
Kuchepetsa deta
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F, XNUMXF, XNUMXF, XNUMXF
Kuchepetsa deta ndi kuchotsera kwapamwamba
450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F
* Kuchepetsa kwa data kumayimitsidwa mwachisawawa ndipo kuyenera kuyatsidwa kusanatulutsidwe kwapamwamba kusanakhale njira yopezeka. Pambuyo pothandizira kuchepetsa deta, kuchotsedwa kwapamwamba kumapezeka, koma kumayimitsidwa mwachisawawa.
Kuchepetsa kwa data mu Unity ndi compression data mu SQL Server
SQL Server 2008 Enterprise Edition inali yoyamba kumasulidwa kuti ipereke kuthekera kophatikizika kwa data. SQL Server 2008 mzere-level-level-level compression amagwiritsa ntchito chidziwitso cha SQL Server internal database table format kuti achepetse malo omwe amagwiritsidwa ntchito ndi zinthu zapakati. Kuchepetsa malo kumakupatsani mwayi wosunga mizere yambiri patsamba lililonse ndi masamba ochulukirapo muzosungira. Chifukwa deta yosasungidwa mumtundu wa tsamba la data la 8k, monga deta ya kunja kwa mzere monga NVARCHAR(MAX), sidzagwiritsa ntchito njira zopondereza za mizere kapena masamba, Microsoft inayambitsa Transact-SQL COMPRESS ndi DECOMPRESS ntchito.
Ntchitozi zimagwiritsa ntchito njira yachikhalidwe yophatikizira deta (algorithm ya GZIP) yomwe imayenera kuyitanidwa kuti gawo lililonse la data likanikizidwe kapena kuchepetsedwa.
Kuponderezana kwa Unity XT, komwe sikuli kwa SQL Server yokha, kumagwiritsa ntchito pulogalamu ya pulogalamu kuti ifufuze ndi kukakamiza deta yosungirako. Chiyambireni kutulutsidwa kwa Unity OE 4.1, kuponderezana kwa data ya Unity kwakhala kukupezeka kwa ma block block volumes ndi VMFS data store mu flash pool. Kuyambira ndi Unity OE 4.2, compression imapezekanso pamafayilo amafayilo ndi masitolo a data a NFS m'madziwe osungiramo flash.
Kusankha njira yopondereza deta ya SQL Server kumadalira zinthu zingapo. Zinthu izi zikuphatikizanso mtundu wazomwe zili m'dawunilodi, zopezeka za CPU - posungira komanso pa seva ya database, ndi zida za I/O zomwe zimafunikira kusunga SLA. Nthawi zambiri, mutha kuyembekezera kusungidwa kwa malo owonjezera a data yomwe imapanikizidwa pogwiritsa ntchito SQL Server, koma deta yopanikizidwa pogwiritsa ntchito mawonekedwe a TSQL a GZIP sangawone kusungidwa kwamalo owonjezera kuchokera kuzinthu zophatikizika za Unity XT popeza zabwino zambiri zimachokera zakale. algorithm.
Kuponderezana kwa mgwirizano kumapereka malo osungirako malo ngati deta pa chinthu chosungirako ikuphwanyidwa ndi osachepera 25%. Musanayatse kukanikizana pa chinthu chosungira, dziwani ngati chili ndi deta yomwe ingathe kupanikizidwa. Osayambitsa kukanikiza kwa chinthu chosungira pokhapokha ngati kutero kupulumutsa mphamvu.
Mukasankha kugwiritsa ntchito kuchepetsa deta ya Unity, SQL Server database-level compression, kapena zonsezi, ganizirani izi:
- Deta yomwe yalembedwa ku Unity system imatsimikiziridwa ndi wolandirayo atasungidwa mu cache ya dongosolo. Komabe, kukakamiza sikuyambira mpaka posungirayo itachotsedwa.
- Kusungirako kuponderezedwa kumakwaniritsidwa osati pazosungirako za Unity XT zokha, komanso pazithunzi ndi ma clones owonda azinthuzo.
- Panthawi yoponderezedwa, midadada ingapo imaphatikizidwa pogwiritsa ntchito sampling algorithm kuti muwone ngati detayo ingathe kupanikizidwa. Ngati sampling aligorivimu imatsimikizira kuti ndalama zochepa zokha zitha kutheka, ndiye kuti kuponderezana kumadumphidwa ndipo deta imalembedwa ku dziwe.
- Pamene deta ndi wothinikizidwa pamaso kulembedwa zosungirako zosungira, kuchuluka kwa deta akugwira kwambiri yafupika. Chifukwa chake, kuponderezana kumathandizira kuchepetsa kuwonongeka ndi kung'ambika pa kukumbukira kwa flash pochepetsa kuchuluka kwa data yomwe yalembedwa pagalimoto.
Kuti mumve zambiri za kuponderezana kwa mizere ndi masamba mu SQL Server ya matebulo ndi ma index, onani .
Musaiwale kuti psinjika kulikonse kumafuna zida za CPU. Pamene zofunikira za bandwidth ndizokwera, kuponderezana kumatha kukhala ndi vuto lalikulu pakugwira ntchito. Kulemba kwakukulu kwa kuchuluka kwa ntchito za OLAP kungathenso kuchepetsa ubwino wa kuponderezana kwa database ya SQL Server.
Dell EMC adafufuza momwe angasungire ndalama pogwiritsa ntchito mitengo yochepetsera zenizeni padziko lonse lapansi pagulu la Unity. Gululi linasonkhanitsa deta pamakina a VMware, kugawana mafayilo, SQL Server databases, Microsoft Hyper-V makina enieni, etc.
Zotsatira za kafukufukuyu zidawonetsa kuti kuchepetsedwa kwa fayilo ya SQL Server log ndikocheperako nthawi 10 kuposa fayilo ya data:
- Kukula kwa database = 1,49:1 (32,96%)
- Kuchuluka kwa chipika = 12,9:1 (92,25%)
Database ya SQL Server idaperekedwa ndi mavoliyumu awiri. Mafayilo a database amasungidwa pa voliyumu imodzi ndipo zipika zamalonda zimasungidwa pa china. Kugwiritsa ntchito ukadaulo wochepetsera deta wokhala ndi ma voliyumu a database kumatha kupereka ndalama zosungirako; komabe, muyenera kuganizira momwe magwiridwe antchito amagwirira ntchito posankha kuti muchepetse kuchulukitsa pamavoliyumu a database. Ngakhale kuchepetsa kukula kwa database kumatha kusiyanasiyana malinga ndi zomwe zasungidwa, zotsatira za kafukufuku zikuwonetsa kuti malo osungira SQL Server transaction .
Njira zabwino zochepetsera deta
Musanayambe kuyatsa kuchepetsa deta pa chinthu chosungira, ganizirani malangizo awa:
- Gwiritsani ntchito kuyang'anira dongosolo losungiramo zinthu kuti muwonetsetse kuti lili ndi zothandizira zothandizira kuchepetsa deta.
- Yambitsani kuchepetsa deta pazinthu zosungira zingapo nthawi imodzi. Yang'anirani dongosolo kuti muwonetsetse kuti lili m'malo ovomerezeka musanalilowetse pa malo owonjezera osungira.
- Pazitsanzo za Unity XT x80F, kuchepetsa deta kudzapulumutsa mphamvu ngati deta yomwe ili mu malo osungiramo ikanikizidwa ndi 1%.
Kuchepetsa deta pamitundu yam'mbuyomu ya Unity x80F yomwe ikuyenda ndi OE 5.0 idapulumutsa malinga ngati zomwe datayo inali yosachepera 25%.
- Musanayambe kuyatsa kuchepetsa deta pa chinthu chosungira, dziwani ngati chinthucho chili ndi deta yokhazikika. Mitundu ina ya data, monga mavidiyo, zomvera, zithunzi, ndi data yapaintaneti, nthawi zambiri imakhala ndi phindu lochepa pakupanikizana. Musalole kuchepetsa deta pa chinthu chosungira ngati sipadzakhala kupulumutsa malo.
- Ganizirani mosankha kuphatikizira kuchuluka kwa data yamafayilo yomwe nthawi zambiri imatsikira bwino.
VMware Virtualization
VMware vSphere ndi nsanja yothandiza komanso yotetezeka yochitira zinthu mwachiwonetsero komanso malo amtambo. Zigawo zazikulu za vSphere ndi VMware vCenter Server ndi VMware ESXi hypervisor.
vCenter Server ndi nsanja yolumikizana yoyang'anira malo a vSphere. Ndiosavuta kuyika ndikuwongolera bwino zinthu. ESXi ndi lotseguka gwero hypervisor kuti installs mwachindunji pa maseva thupi. ESXi ili ndi mwayi wopita kuzinthu zapakati ndipo ndi yaying'ono mu kukula kwa 150MB, kuchepetsa kukumbukira kukumbukira. Imapereka magwiridwe antchito odalirika pamapulogalamu osiyanasiyana ogwiritsira ntchito ndipo imathandizira masanjidwe amphamvu a makina amphamvu-mpaka ma 128 vCPU, 6 TB ya RAM, ndi zida za 120.
Kuti SQL Server iziyenda bwino pa hardware yamakono, SQL Server operating system (SQLOS) iyenera kumvetsetsa kamangidwe ka hardware. Kubwera kwa makina opangira ma multi-core and multi-node non-uniform memory access (NUMA), kumvetsetsa ubale pakati pa ma cores, mapurosesa omveka, ndi ma processor akuthupi kwakhala kofunika kwambiri.
Mapulogalamu
Virtual Processing Unit (vCPU) ndi gawo lapakati lokonzekera lomwe limaperekedwa ku makina enieni. Chiwerengero chonse cha ma vCPU operekedwa amawerengedwa motere:
Total vCPU = (количество виртуальных сокетов) * (количество виртуальных ядер на сокет)Ngati ntchito mosasinthasintha n'kofunika, VMware akuonetsa kuti chiwerengero chonse cha vCPUs anapatsidwa makina onse pafupifupi sayenera upambana chiwerengero cha mitima mitima likupezeka pa ESXi khamu, koma inu mukhoza kuwonjezera chiwerengero cha vCPUs allocated ngati kuwunika limasonyeza kuti zosagwiritsidwa ntchito CPU chuma. zilipo.
Pamakina omwe ali ndi Intel Hyper-Threading Technology yathandizidwa, kuchuluka kwa ma cores (vCPUs) kumawirikiza kawiri kuchuluka kwa ma cores. Pankhaniyi, musagawire kuchuluka kwa ma vCPU.
Zolemba zotsika za SQL Server sizikhudzidwa kwambiri ndi kusinthasintha kwa latency. Chifukwa chake, zochulukirazi zitha kuyendetsedwa ndi makamu okhala ndi chiŵerengero chachikulu cha ma vCPU ku ma CPU akuthupi. Miyezo yokwanira yogwiritsira ntchito CPU imatha kukulitsa kuchulukira kwamakina, kuchulukitsa ndalama zamalayisensi, ndikusunga magwiridwe antchito mokwanira.
Intel Hyper-Threading nthawi zambiri imathandizira kupitilira kwa olandila ndi 10% mpaka 30%, kutanthauza vCPU ku chiŵerengero cha CPU cha 1,1 mpaka 1,3. VMware amalimbikitsa kuti Hyper-Threading mu UEFI BIOS ngati n'kotheka kuti ESXi akhoza kutenga mwayi luso. VMware imalimbikitsanso kuyezetsa ndi kuyang'anitsitsa mukamagwiritsa ntchito Hyper-Threading kwa SQL Server yolemetsa.
chikumbukiro
Pafupifupi ma seva onse amakono amagwiritsa ntchito zomangamanga zosafanana (NUMA) zolumikizirana pakati pa kukumbukira kwakukulu ndi mapurosesa. NUMA ndi kamangidwe ka zida zamakumbukidwe zomwe zimagawana zomwe zimagwiritsa ntchito kugawa kwa kukumbukira kwakuthupi pakati pa mapurosesa akuthupi. Node ya NUMA ndi socket imodzi kapena zingapo za CPU pamodzi ndi chipika cha kukumbukira komwe adapatsidwa.
NUMA yakhala ikukambidwa kwambiri m’zaka khumi zapitazi. Kuvuta kwa NUMA kumabwera chifukwa cha kukhazikitsidwa kwa mavenda osiyanasiyana. M'malo owoneka bwino, zovuta za NUMA zimatsimikiziridwanso ndi kuchuluka kwa zosintha ndi zigawo-kuchokera pa hardware kudzera pa hypervisor kupita ku makina ogwiritsira ntchito alendo ndipo potsiriza ku SQL Server application. Kumvetsetsa bwino kamangidwe ka zida za NUMA ndikofunikira kwa SQL Server DBA iliyonse yomwe ili ndi mawonekedwe a SQL Server.
Kuti mukwaniritse bwino kwambiri ma seva okhala ndi ma cores ambiri, Microsoft idayambitsa SoftNUMA. Mapulogalamu a SoftNUMA amakulolani kugawaniza zida za CPU zomwe zilipo mkati mwa NUMA imodzi m'magulu angapo a SoftNUMA. Malinga ndi VMware, SoftNUMA imagwirizana ndi VMware's virtual NUMA (vNUMA) topology ndipo imatha kupititsa patsogolo kukhathamiritsa kwa injini ya database ndi magwiridwe antchito ambiri ...
Mukamagwiritsa ntchito VMware ndi SQL Server gwiritsani ntchito:
- Yang'anirani makina owoneka bwino kuti muwone zinthu zotsika zokumbukira za SQL Server Database Engine. Nkhaniyi imayambitsa kuchuluka kwa ntchito za I/O komanso kuchepa kwa magwiridwe antchito.
- Kupititsa patsogolo ntchito, kupewa mikangano kukumbukira pakati makina pafupifupi popewa kukumbukira mochulukira pa ESXi khamu mlingo.
- Ganizirani kuyang'ana pa hardware ya NUMA yogawa kukumbukira kuti mudziwe kuchuluka kwa kukumbukira komwe kungaperekedwe kumakina omwe ali mkati mwa malire a NUMA.
- Ngati kukwaniritsa ntchito yokwanira ndicho cholinga chachikulu, ganizirani kusunga kukumbukira kofanana ndi kukumbukira komwe mwapatsidwa. Kukonzekera kwa parameter uku kumatsimikizira kuti makina enieni amangolandira kukumbukira thupi.
Kusungirako kowoneka bwino
Kukhazikitsa malo osungiramo malo owoneka bwino kumafuna chidziwitso cha zosungirako zosungirako. Monga momwe zilili ndi NUMA, muyenera kumvetsetsa momwe magawo osiyanasiyana a I/O amagwirira ntchito - pakadali pano, kuchokera pakugwiritsa ntchito mu VM, mpaka pakuwerenga ndi kulemba kwachidziwitso pachosungira chokhazikika.
vSphere imapereka njira zingapo zosinthira zosungira, zomwe zili ndi ntchito zothandiza pakukhazikitsa kwa SQL Server ndi gulu la Unity XT. FS VMFS ndiyo njira yomwe imagwiritsidwa ntchito kwambiri posungira deta m'makina osungiramo ma block monga Unity XT. Gulu la Unity XT ndilo gawo la pansi lomwe lili ndi ma drive akuthupi owululidwa ndi vSphere ngati ma disks omveka (ma voliyumu). Ma voliyumu a Unity XT amapangidwa ngati mavoliyumu a VMFS ndi ESXi hypervisor. Olamulira a VMware amapanga diski imodzi kapena zingapo (VMDKs) zomwe zimaperekedwa ku makina ogwiritsira ntchito alendo. RDM imalola makina enieni kuti azitha kulowa mwachindunji ku Unity XT block block (kudzera FC kapena iSCSI) osasintha VMFS. Ma voliyumu a VMFS ndi RDM atha kuperekanso njira zomwezo.
Pakusungirako kochokera ku NFS kwa ESXi, Dell EMC amalimbikitsa kugwiritsa ntchito VMware NFS m'malo mwa mafayilo amtundu wa NFS. Makina enieni omwe akuyenda pa SQL Server ndikugwiritsa ntchito VMDK pa sitolo ya data ya NFS sadziwa za gawo la NFS. Makina ogwiritsira ntchito alendo amachitira makina enieni ngati seva yakuthupi yomwe ikuyenda Windows Server ndi SQL Server. Ma disks omwe amagawana nawo masanjidwe amtundu wa failover cluster pa nkhokwe za NFS sakuthandizidwa.
VMware vSphere Virtual Volumes (VVols) imapereka chiwongolero chochulukirapo pamakina owoneka bwino, osatengera zomwe zimayimira kukumbukira (monga ma voliyumu kapena mafayilo amafayilo). Kubwereza kochokera ku Array ndi VVols kumathandizidwa kuyambira ndi VVol 2.0 (vSphere 6.5). Diski ya VVol itha kugwiritsidwa ntchito m'malo mwa diski ya RDM kuti ipereke gwero la disk ku SQL Failover Cluster chitsanzo kuyambira ndi vSphere 6.7 ndi chithandizo chosunga zosunga zobwezeretsera za SCSI.
Maukonde a Virtualized
Maukonde m'dziko lenileni amatsatira malingaliro ofanana ndi omwe ali padziko lapansi, koma amagwiritsa ntchito mapulogalamu m'malo mwa zingwe zakuthupi ndi masiwichi. Zotsatira za latency network pa SQL Server workloads zimatha kusiyana kwambiri. Kuyang'anira mayendedwe a netiweki pantchito yomwe ilipo kale kapena makina oyeserera oyendetsedwa bwino pakanthawi koyimilira kumathandiza kupanga netiweki yeniyeni.
Mukamagwiritsa ntchito VMware virtualization ndi SQL Server, ganizirani izi:
- Masinthidwe onse okhazikika komanso ogawidwa amapereka magwiridwe antchito ofunikira ndi SQL Server.
- Kuti mulekanitse kasamalidwe koyenera, vSphere vMotion, ndi kuchuluka kwa magalimoto pamaneti, gwiritsani ntchito ma tagging a VLAN ndi magulu osinthira madoko.
- VMware imalimbikitsa kwambiri kuti muzitha kuyatsa mafelemu akulu pa masiwichi enieni pomwe magalimoto a vSphere vMotion kapena traffic ya iSCSI amayatsidwa.
- Nthawi zambiri, tsatirani malangizo ochezera pa intaneti pamakina ogwiritsira ntchito alendo ndi ma hardware.
Pomaliza
Malo a database ya SQL Server akukhala akulu komanso ovuta. Mu SQL Server 2019, Microsoft yasintha mawonekedwe a SQL Server ndikuwonjezera zatsopano, monga kuthandizira kwazolemba zazikulu za data ndi Apache Spark ndi HDFS. Dell EMC, mogwirizana ndi Microsoft, ikupitiriza kupereka zofunikira zofunikira pa chilengedwe cha SQL Server - maseva, kusungirako ndi maukonde.
Tikuwona kuwonjezeka kwakukulu kwa nthawi yowonjezereka ndi kuchepetsa mtengo wa umwini (TCO) pamene akatswiri osungiramo zinthu ndi osungiramo zinthu zakale amagwirira ntchito limodzi kuti apange njira zothetsera SQL Server pazigawo zosungirako zogawana. Dell EMC Unity XT mitundu yonse ya flash ndi njira yapakatikati yoyenera kwa opanga ma SQL Server ndi olamulira omwe amafunikira magwiridwe antchito apamwamba komanso kutsika kochepa. Unity XT All-Flash imapangidwa kuti iziyenda pa ma drive onse, imathandizira ma CPU apawiri, masinthidwe owongolera apawiri, komanso kukhathamiritsa kwamitundu yambiri.
Kuchulukirachulukira, mabungwe akusintha madera awo a SQL Server. Ngakhale kuti virtualization imawonjezera gawo lina la mapangidwe pazomangamanga, imapereka phindu lalikulu. Tikukhulupirira kuti mupeza zina mwazinthu zomwe zimagwiritsidwa ntchito kwambiri ndi VMware ndi zida zomwe zili pamwambapa zothandiza m'malo a SQL Server. Timalimbikitsanso maulalo kuzinthu kuti mumve zambiri.
maulalo othandiza
Dell EMC
- (tsamba lazinthu)
- (YouTube)
VMware
Microsoft
Source: www.habr.com