A yau za mu gabatar muku da fasalulluka na yin amfani da SQL Server 2019 tare da tsarin ajiya na Unity XT, da kuma ba da shawarwari kan sarrafa SQL Server ta amfani da fasahar VMware, kafawa da sarrafa mahimman abubuwan abubuwan more rayuwa na Dell EMC.
A cikin 2017, Dell EMC da VMware sun buga sakamakon binciken kan abubuwan da ke faruwa da juyin halitta na SQL Server - "Canjin SQL Server: Zuwa Ƙarfafawa da Juriya" (), wanda ya yi amfani da kwarewar al'ummar mambobi na Ƙungiyar Ƙwararrun Ƙwararrun SQL (PASS). Sakamakon ya nuna cewa wuraren bayanan SQL Server suna girma a cikin girman duka da rikitarwa, wanda ke motsa su ta hanyar haɓaka kundin bayanai da sabbin buƙatun kasuwanci. SQL Server databases yanzu ana tura su a cikin kamfanoni da yawa, suna ƙarfafa aikace-aikacen manufa mai mahimmanci, kuma galibi su ne tushen canjin dijital.
Tun lokacin da aka gudanar da wannan binciken, Microsoft ya fitar da ƙarni na gaba na DBMS - SQL Server 2019. Baya ga inganta mahimman ayyukan injin alaƙa da ajiyar bayanai, sabbin ayyuka da ayyuka sun bayyana. Misali, SQL Server 2019 ya haɗa da goyan baya don manyan ayyuka na bayanai ta amfani da Apache Spark da Tsarin Fayil Rarraba Hadoop (HDFS).
Alliance Dell EMC da Microsoft
Dell EMC da Microsoft suna da haɗin gwiwa na dogon lokaci don haɓaka mafita don SQL Server. Nasarar aiwatar da ingantaccen dandamalin bayanai kamar Microsoft SQL Server yana buƙatar daidaita ayyukan software tare da tushen kayan aikin IT. Wannan kayan aikin ya haɗa da ikon sarrafa kayan sarrafawa, albarkatun ƙwaƙwalwar ajiya, ajiya da sabis na cibiyar sadarwa. Dell EMC yana ba da kayan aikin dandamali na SQL Server don kowane nau'in nauyin aiki da aikace-aikace.
Layin uwar garken Dell EMC PowerEdge yana ba da nau'ikan na'urori masu sarrafawa da saitunan ƙwaƙwalwar ajiya. Wadannan gyare-gyare sun dace da nau'o'in nauyin aiki: daga ƙananan aikace-aikacen kasuwanci zuwa mafi girman tsarin manufa-mahimmanci, irin su tsarin samar da kayan aiki (ERP), ɗakunan ajiya na bayanai, ƙididdigar ci gaba, kasuwancin e-ciniki, da dai sauransu An tsara layin ajiya don ajiya. adana bayanai marasa tsari da tsari.
Abokan ciniki waɗanda ke tura SQL Server 2019 tare da kayan aikin Dell EMC na iya aiki tare da tsararru da bayanan da ba a tsara su ta amfani da SQL Server da Apache Spark. SQL Server kuma yana goyan bayan haɗakar samun damar abokin ciniki, uwar garken-zuwa uwar garken, da fasahar sadarwa na uwar garken-zuwa-ajiya. hangen nesa Dell EMC ya dogara ne akan ƙirar da aka rarraba wanda ke ba da buɗaɗɗen yanayin muhalli. Ƙungiyoyi za su iya zaɓar daga nau'ikan aikace-aikacen sadarwar daidaitattun masana'antu, tsarin aiki da dandamali na hardware. Wannan tsarin yana ba ku mafi girman iko akan fasahohi da gine-gine, yana haifar da babban tanadin farashi da sassauci.
VMware yana haɓaka duk mahimman abubuwan abubuwan more rayuwa waɗanda SQL Server ke buƙata don cimma babban aiki da daidaiton aiki. Baya ga gajimare masu zaman kansu, VMware kuma a halin yanzu yana ba da samfura masu haɗaɗɗun kayan aiki, wanda ya mamaye gine-gine masu zaman kansu da na jama'a.
Ƙungiyoyi da yawa suna juyowa zuwa ƙirƙira don rage farashin kayayyakin more rayuwa, samar da wadata mai yawa, da sauƙaƙe dawo da bala'i. 94% na ƙwararrun SQL Server da aka bincika sun ba da rahoton wasu matakan haɓakawa a cikin muhallinsu. Kashi 70% na waɗanda ke amfani da haɓakawa sun zaɓi VMware. 60% suna da matakan kama-da-wane na SQL Server na 75% ko fiye. Bugu da ƙari, sakamakon binciken yana ba da shawarar cewa babban samuwa da kuma dawo da bala'i da aka aiwatar a cikin ma'auni mai mahimmanci ya zama muhimman abubuwa a cikin yanke shawara don daidaita bayanan SQL Server.
Sabbin abubuwa a cikin SQL Server 2019
SQL Server 2019 dandali na bayanai ya haɗa da fasahohi da yawa, fasali, da ayyuka waɗanda ke tallafawa aikace-aikace masu mahimmanci kamar nazari, bayanan kasuwanci, bayanan kasuwanci (BI), da sarrafa ma'amala mai ƙima (OLTP). Dandalin SQL Server ya sami damar sarrafa bayanan haɗin kai, ajiyar bayanai, bayar da rahoto da ƙididdiga na ci gaba, damar kwafi, da sarrafa nau'ikan bayanan da aka tsara. Tabbas, ba duk abokan ciniki ko aikace-aikace ke buƙatar duk waɗannan fasalulluka ba. Bugu da ƙari, a lokuta da yawa yana da kyau a raba sabis na SQL Server ta amfani da haɓakawa.
A yau, harkokin kasuwanci galibi suna buƙatar dogaro da ɗimbin bayanai daga ɗimbin kewayon saitin bayanai da ke ƙaruwa koyaushe. Tare da SQL Server 2019, zaku iya samun kusanci na ainihin-lokaci daga duk bayanan ku. SQL Server 2019 gungu suna ba da cikakken yanayi don aiki tare da manyan bayanan bayanai, gami da yin amfani da na'ura koyo da damar bayanan sirri. Manyan sabbin abubuwa da sabuntawa a cikin SQL Server 2019 an jera su a ciki .
Dell EMC Unity XT Tsarin Ma'ajiya na Tsakanin Rage
An ƙaddamar da jerin ɗakunan ajiya na Haɗin kai na Dell EMC kusan shekaru uku da suka gabata, kuma tun daga lokacin an sayar da fiye da tsarin 40. Abokan ciniki suna godiya da wannan tsakiyar kewayon don sauƙi, aiki da ingancin sa. Dell EMC Unity XT matsakaici dandamali shine mafita na ajiya mai raba wanda ke ba da ƙarancin latency, babban kayan aiki, da ƙarancin gudanarwa don ayyukan SQL Server. Duk tsarin Unity XT suna amfani da tsarin gine-gine mai sarrafa dual ajiya (SP) don sarrafa I/O da ayyukan bayanai masu aiki/aiki. Unity XT dual SP yana amfani da cikakken haɗin haɗin 000Gbps SAS na ciki da tsarin gine-ginen multi-core na mallaka don babban aiki da inganci. Tsarin diski yana ba ku damar faɗaɗa ƙarfin ajiya ta amfani da ƙarin ɗakunan ajiya.
Dell EMC Unity XT, tsararraki na gaba na gaba (matasan da duk-flash), yana haɓaka aiki sosai, yana haɓaka aiki, kuma yana ƙara sabbin iyawa da sabis don mahallin girgije da yawa.
Gine-gine na Unity XT yana ba ku damar sarrafa bayanai lokaci guda, rage adadin bayanai, da sabis na tallafi kamar kwafi ba tare da sadaukar da aikin aikace-aikacen ba. Idan aka kwatanta da mafita na ƙarni na baya, aikin Dell EMC Unity XT tsarin ajiya ya ninka kuma lokacin amsawa shine 75% sauri. Kuma ba shakka, Dell EMC Unity yana goyan bayan ma'aunin NVMe.
Tsarin ajiya tare da faifan NVMe suna nuna mafi kyawun aikin su a cikin aikace-aikacen latency. Misali, a cikin aikace-aikace kamar manyan bayanai na bayanai, NVMe yana ba da ƙarancin jinkiri da ƙimar ƙimar bayanai masu girma. Rage jinkirin da ƙara haɓaka haɓaka aikin karantawa/rubutu sosai. Ba daidaituwa ba ne cewa, bisa ga hasashen IDC, ta 2021, tsararraki masu walƙiya tare da haɗin NVMe da NVMe-oF (NVMe akan Fabric) za su ɗauki kusan rabin duk kudaden shiga daga siyar da tsarin ajiya na waje a duniya.
Algorithms na matsawa bayanai suna haɓaka ingancin ajiya. Dell EMC Unity XT na iya rage girman bayanai har sau biyar. Wani muhimmin alamar alama shine gabaɗayan ingantaccen tsarin. Dell EMC Unity XT yana amfani da ƙarfin tsarin 85%. Ana yin matsi da ƙaddamarwa a cikin yanayin layi - a matakin mai sarrafawa. Ana adana bayanan a cikin matsi. Hakanan tsarin yana aiki ta atomatik tare da hotunan hoto.
Tsarukan filasha mai sauƙi don amfani tare da haɗin kai (toshewa da fayil) samun damar samar da kwanciyar hankali lokacin amsawa, haɗawa tare da ayyukan ajiyar girgije, da haɓaka haɓakawa ba tare da ƙaurar bayanai ba. A cikin ƙayyadaddun tsarin sa, wannan tsarin ma'ajiyar kayan aiki yana shigarwa cikin mintuna 30.
Fasahar adana bayanai da ake kira "takardun ruwa mai tsauri" yana ba ku damar matsawa daga tsaye zuwa faɗaɗa ƙwaƙwalwar ajiya mai ƙarfi, yana ba da babban sassaucin aiki da sauƙi na haɓaka ƙarfin tsarin. Tafkunan ruwa masu ƙarfi suna adana ƙarfi da kasafin kuɗi, kuma suna buƙatar ɗan lokaci kaɗan don sake ginawa. Fadada iyawa da aikin Dell EMC Unity baya buƙatar ƙaura bayanai.
Kamfanoni da yawa a yau suna amfani da sabis na gajimare da yawa na jama'a a haɗe tare da kayan aikin su na kan-gida. Dell EMC Unity XT na iya aiki azaman ɓangaren yanayin Dell Technologies Cloud. Ana iya amfani da wannan tsarin ajiya a cikin gajimare na jama'a kuma ana iya canja wurin bayanai zuwa ga girgije mai zaman kansa. Bugu da kari, Dell EMC Unity XT ajiya yana samuwa azaman sabis. Wannan ɗayan sabis ɗin ajiyar girgije ne na Dell EMC Cloud Storage Services.
Ma'ajiyar girgije yana ƙara zama sananne saboda yana iya inganta ROI ta hanyar rage farashin kayan aiki. Sabis na Ajiye Cloud yana faɗaɗa cibiyoyin bayanan abokan ciniki zuwa gajimare ta hanyar isar da ma'ajin Dell EMC (haɗe kai tsaye da albarkatun girgije na jama'a) azaman sabis. Masu ba da sabis na ɓangare na uku na iya samar da haɗin gajimare mai sauri (ƙananan latency) na jama'a kai tsaye zuwa Dell EMC Unity, PowerMax da tsarin Isilon a cikin cibiyar bayanan abokin ciniki.
Iyalin Unity XT sun haɗa da Unity XT All-Flash, Unity XT Hybrid, UnityVSA da Unity Cloud Edition.
Haɗe-haɗe Hybrid da Flash Arrays
Intel-based Unity XT Hybrid da Unity XT All-Flash tsarin ajiya suna ba da haɗin gwiwar gine-gine don toshe damar shiga, samun damar fayil, da VMware VVols tare da goyan bayan ma'ajiyar hanyar sadarwa (NAS), iSCSI, da ka'idojin Fiber Channel (FC). Haɗin kai XT Hybrid da Unity XT All-Flash dandamali suna shirye-shiryen NVMe.
Tsarin matasan Unity XT yana goyan bayan mahalli mai yawan girgije. Multi-girgije yana nufin ƙaddamar da ajiya ga gajimare ko tura zuwa gajimare tare da sassauƙan zaɓuɓɓukan amfani da albarkatu. An tsara ma'ajiyar Multicloud don tabbatar da motsi da ɗaukar bayanai tsakanin dandamali da yawa na girgije - masu zaman kansu da na jama'a. Wannan yana rinjayar ba kawai hanyoyin tafiyar da bayanai ba, har ma da tsarin samun damar aikace-aikacen bayanai a cikin gajimare da yawa.
Waɗannan nau'ikan nau'ikan nau'ikan nau'ikan suna ba da damar masu zuwa:
- Zazzagewa zuwa 16 PB raw iya aiki.
- Gina-in bayanai iyawar rage bayanai ga duk walƙiya wuraren waha.
- Saurin shigarwa da daidaitawa (a matsakaici yana ɗaukar mintuna 25).
Fasahar SSD tana haɓaka da sauri, kuma sabbin samfuran juyin juya hali za su shiga kasuwa a cikin shekaru masu zuwa. A halin yanzu, ƙungiyoyi za su ci gaba da maye gurbin HDDs na gargajiya tare da SSDs don ingantaccen aiki, sauƙi na gudanarwa da tanadin makamashi. Sabbin tsararraki na dukkan tsararraki masu walƙiya za su ƙunshi ƙarin ingantattun kayan aiki na ajiya, haɗaɗɗun girgije na jama'a, da haɗaɗɗen kariyar bayanai.
Unity XT All-Flash tsarin yana ba da sauri, inganci, da tallafin girgije da yawa. Siffofinsu:
- Yawan aiki sau biyu.
- Rage bayanai har zuwa 7:1.
- Saurin shigarwa da daidaitawa (tsarin yana ɗaukar ƙasa da mintuna 30).
UnityVSA
UnityVSA shine ƙayyadaddun ma'auni na software don VMware ESXi mahallin kama-da-wane ta amfani da uwar garken, rabawa, ko ƙarfin ajiyar girgije. UnityVSA HA, saitin UnityVSA mai ajiya biyu, yana ba da ƙarin haƙurin kuskure. UnityVSA ajiya yana ba da:
- Har zuwa TB 50 na cikakken iyawar ma'aji mai haɗe-haɗe.
- Mai jituwa tare da tsarin Unity XT da fasali.
- Taimako don tsarin samuwa mai yawa (UnityVSA HA).
- Haɗin kai azaman NAS da iSCSI.
- Maimaita bayanai daga wasu dandamali na Unity XT.
Unity Cloud Edition
Don aiki tare da fayil da ayyukan dawo da bala'i tare da gajimare, dangin Unity XT sun haɗa da Unity Cloud Edition, wanda ke ba da:
- Ƙarfin ma'auni mai cikakken fasali ta amfani da ma'auni na software (SDS) wanda aka tura cikin gajimare.
- Sauƙaƙe ƙaddamar da toshewa da ajiyar fayil tare da VMware Cloud akan AWS.
- Taimakon dawo da bala'i, gami da gwaji da nazarin bayanai.
Unity XT Duk Flash don SQL Server
Rahoton Binciken Unisphere na 2017, "Canjin SQL Server: Zuwa Ƙarfafawa da Juriya" () 22% na masu amsa sun ba da rahoton cewa suna amfani da fasahar adana walƙiya a samarwa (16%) ko shirin yin haka (6%). 30% suna amfani da tsararrun tsararru waɗanda suka haɗa da ƙwaƙwalwar filasha. 13% suna amfani da tsararrun haɗe-haɗe kai tsaye. 13% yana adana bayanan SQL Server zuwa ma'ajiyar filasha.
Wannan saurin ɗaukar ma'ajiyar filasha don amfani tare da SQL Server yana nufin cewa Unity XT All-Flash arrays sun dace musamman ga masu haɓakawa da masu gudanarwa na SQL Server. Unity XT All-Flash tsarin yana samar da masu haɓakawa da masu gudanarwa na SQL Server tare da iyawa da aikin da ya wuce abin da cibiyoyin sadarwar yankin ajiya (SANs) ke bayarwa.
Unity XT All-Flash tsarin, waɗanda ke shirye-shiryen NVMe (don har ma da babban aiki da ƙarancin latency), suna da nau'in nau'in nau'in 2U, suna tallafawa masu sarrafa dual-core, masu sarrafawa biyu a cikin yanayin aiki / aiki.
Unity XT Duk-Flash Model
Unity XT
Masu sarrafawa
Ƙwaƙwalwar ajiya (kowane processor)
Max. yawan tafiyarwa
Max. "raw" iya aiki (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
Ana iya samun cikakkun bayanai a cikin ƙayyadaddun ƙayyadaddun tsari ().
Tafkunan ajiya
Yawancin masu sana'a na SQL Server sun san cewa duk tsararrun ajiya na zamani suna ba da damar haɗa fayafai zuwa manyan ɗakunan ajiya tare da ƙayyadadden matakin kariya na RAID. Ƙungiyoyin faifai guda ɗaya tare da kariyar RAID sune wuraren ajiya na gargajiya. Yayin da tsarin haɗin gwiwar Unity XT ke tallafawa wuraren waha na gargajiya kawai, Unity XT All-Flash arrays kuma suna ba da wuraren waha mai ƙarfi. Tare da wuraren waha mai ƙarfi, ana amfani da kariyar RAID zuwa iyakar faifai — raka'a na ajiya ƙasa da cikakken diski. Tafkunan ruwa masu ƙarfi suna ba da mafi girman sassauci a sarrafa da faɗaɗa wuraren wahai.
Dell EMC yana ba da mafi kyawun ayyuka don sarrafa wuraren ajiyar ajiya don cimma matsakaicin aiki tare da ƙarancin rikitarwa. Misali, ana ba da shawarar rage adadin wuraren ajiya na Unity XT don rage hadaddun da ƙara sassauci. Koyaya, saita ƙarin wuraren ajiyar ajiya na iya zama da amfani sosai a wasu lokuta, gami da lokacin da kuke buƙatar:
- Goyi bayan nau'ikan ayyuka daban tare da bayanan I/O daban-daban.
- Ware albarkatu don cimma wasu sigogin aiki.
- Ƙaddamar da albarkatu daban-daban don yawan haya.
- Ƙirƙiri ƙananan yankuna don karewa daga gazawa
Adadin ajiya (LUNs)
Ta yaya kuke daidaita sarrafawa da sassauƙa lokacin zabar adadin kundin a cikin tsararru? Don matsakaicin sassauci a cikin Haɗin kai tare da SQL Server, ana ba da shawarar ƙirƙirar kundin bayanai don kowane fayil ɗin bayanai. A aikace, yawancin ƙungiyoyi suna ɗaukar matakin da ya dace, inda aka bai wa mahimman bayanai na bayanai matsakaiciya mafi girma kuma ana haɗa fayilolin bayanai marasa mahimmanci zuwa ƙananan kundila masu girma. Muna ba da shawarar yin bitar duk buƙatun don bayanan bayanai da kowane aikace-aikacen da ke da alaƙa saboda kariyar bayanai da fasahar sa ido sun dogara da keɓewar fayil da jeri.
Littattafai da yawa na iya zama da wahala a sarrafa su sau da yawa, musamman a cikin mahallin kama-da-wane. Wuraren SQL Server mai ƙima shine kyakkyawan misali na inda ɗaukar nau'ikan fayiloli da yawa akan ƙarar guda ɗaya na iya yin ma'ana. Mai gudanar da bayanan bayanai ko mai kula da ajiya (ko duka biyu) dole ne su zaɓi madaidaicin ma'auni tsakanin sassauƙa da kiyayewa lokacin tantance adadin ƙirƙira.
Adana fayil
Sabbin NAS suna karɓar tsarin fayil akan ajiyar Unity XT. Ana iya samun dama ga tsarin fayil ta amfani da ka'idojin SMB ko NFS, kuma tare da tsarin fayil na yarjejeniya da yawa, zaku iya amfani da duk ka'idojin lokaci guda. Sabis na NAS suna amfani da musaya mai kama-da-wane don haɗa mai watsa shiri zuwa SMB, NFS, da tsarin fayiloli masu yawa, da kuma VMware NFS ajiya da VMware kama-da-wane. Ana keɓance tsarin fayil da musaya mai kama-da-wane a cikin sabar NAS guda ɗaya, yana ba da damar amfani da sabar NAS da yawa don hayar da yawa. Sabbin NAS sun gaza ta atomatik idan mai sarrafa kayan ajiya ya gaza. Tsarin fayil ɗin su masu alaƙa shima sun gaza.
SQL Server 2012 (11.x) da daga baya iri suna goyan bayan Saƙon Saƙon Saƙo (SMB) 3.0, wanda ke ba da damar raba fayil ɗin cibiyar sadarwa don ajiya. Domin duka na tsaye da kuma gazawar cluster shigarwa, za ka iya shigar da tsarin bayanai (master, model, msdb, da tempdb) da Database Engine mai amfani da bayanai tare da SMB ajiya zaɓi. Amfani da ma'ajin SMB zaɓi ne mai kyau yayin amfani da Ƙungiyoyin Samar da Koyaushe saboda rabon fayil ɗin yana buƙatar samun dama ga ingantaccen hanyar sadarwa.
Ƙirƙirar hannun jarin fayil ɗin SMB don tura SQL Server tare da ajiyar Unity XT tsari ne mai sauƙi mai matakai uku: kuna ƙirƙirar sabar NAS, tsarin fayil, da rabon SMB. Dell EMC Unisphere Ma'ajiya Software software ya haɗa da madaidaicin maye don taimaka muku kammala wannan tsari. Koyaya, lokacin ɗaukar nauyin aikin SQL Server akan hannun jarin fayil ɗin SMB, akwai wasu mahimman la'akari da yakamata a kiyaye waɗanda ba lallai bane ya shafi amfani da hannun jari na SMB. Microsoft ya tattara jerin abubuwan shigarwa da tsaro tare da abubuwan da aka sani a halin yanzu; Don cikakkun bayanai, duba "Shigar da SQL Server tare da Ma'ajin Fayil na SMB" a ciki .
Bayanin Snapshots
Bayanai sun zama mafi mahimmancin albarkatun kamfani, kuma mahalli masu mahimmanci na yau suna buƙatar fiye da sakewa kawai. Wajibi ne cewa aikace-aikacen koyaushe suna kan layi, ana ba su tare da ayyuka marasa yankewa da sabuntawa. Hakanan suna buƙatar babban aiki da samun bayanai ta hanyar zaɓuɓɓuka kamar kwafin hoto na gida da kwafi mai nisa.
Tsare-tsaren ajiya na Unity XT yana ba da damar toshewa da ikon ɗaukar hoto wanda ke raba ayyukan gama gari, ayyuka, da gine-gine. Hanyar ɗaukar hoto ta Unity tana ba da hanya mai sauƙi kuma mai inganci don kare bayanai. Hoton hoto yana sauƙaƙa maido da bayanai - mirgine zuwa hoton da ya gabata, ko kuma kuna iya kwafin zaɓaɓɓun bayanan daga hoton da ya gabata. Tebur mai zuwa yana nuna lokutan riƙe hoto don tsarin Unity XT.
Ma'ajiyar gida da na nesa na hotunan hotuna
Nau'in hoto
CLI
UI
sauran
Da hannu
Tsara
Da hannu
Tsara
Da hannu
Tsara
Na gida
1 shekara
1 shekara
5 shekaru
4 makonni
100 shekaru
Babu iyaka
Nesa
5 shekaru
255 makonni
5 shekaru
255 makonni
5 shekaru
255 makonni
Snapshots ba maye gurbin kai tsaye ga wasu hanyoyin kariyar bayanai ba, kamar madadin. Za su iya haɗawa da madadin gargajiya kawai azaman layin farko na tsaro don ƙananan yanayin RTO.
Siffar hoton Haɗin kai na Dell EMC ya haɗa da rage bayanai da ƙaddamar da ci gaba. Hotunan daukar hoto kuma suna amfana daga ajiyar sararin samaniya da aka samu akan asalin ma'ajiyar albarkatu. Lokacin da kuka ɗauki hoton kayan ajiya mai goyan bayan fasalulluka na rage bayanai, ana iya matse bayanan da ke tushen ko kwafi.
Anan akwai wasu bayanan kula game da dawo da bayanai lokacin amfani da hotuna tare da bayanan SQL Server:
- Dole ne a kiyaye duk abubuwan da ke cikin bayanan SQL Server azaman saitin bayanai. Lokacin da bayanai da fayilolin log ke kan LUN daban-daban, waɗannan LUNs dole ne su kasance ɓangare na ƙungiyar daidaito. Ƙungiya mai daidaituwa tana tabbatar da cewa an ɗauki hoto lokaci guda akan duk LUNs a cikin ƙungiyar. Lokacin da bayanai da fayilolin log ke kan hannun jarin fayilolin SMB da yawa, hannun jari dole ne su kasance akan tsarin fayil iri ɗaya.
- Lokacin da ake maido da bayanan SQL Server daga hoto mai tushen toshewa, idan misalin SQL Server dole ne ya kasance da haɗin kai, yi amfani da haɗin ƙungiyar Unisphere. Don dawo da tushen fayil, an ƙirƙiri ƙarin rabon SMB ta amfani da hoton hoto azaman tushen. Da zarar an ɗora juzu'in, za a iya haɗa ma'ajin bayanai a ƙarƙashin wani suna daban ko kuma a iya maye gurbin bayanan da ke akwai da maidowa.
- Lokacin aiwatar da maidowa ta amfani da hanyar Mayar da Snapshot a cikin Unisphere, ɗauki misalin SQL Server a layi. SQL Server bai san aikin maidowa ba. Ɗaukar misali a layi yana tabbatar da cewa kundin bayanai bai lalace ba ya rubuta kafin murmurewa. Da zarar an sake kunna misalin, SQL Server dawo da bala'i zai kawo bayanan bayanai cikin daidaiton yanayi.
- Kunna hotunan hotuna don abubuwa da yawa na ajiya lokaci guda, sannan tabbatar da cewa tsarin yana cikin yanayin aiki da aka ba da shawarar kafin kunna ƙarin hotuna.
Automation da tsara shirye-shiryen harbi
Za a iya sarrafa hotuna a cikin Unity XT ta atomatik. Zaɓuɓɓukan hoto na tsoho masu zuwa suna samuwa a cikin sarrafa ma'ajiya ta Unisphere: kariyar tsoho, gajeriyar kariyar riƙewa, da kariya mai tsayi. Kowane zaɓi yana ɗaukar hotuna na yau da kullun kuma yana adana su na lokuta daban-daban.
Kuna iya zaɓar ɗaya (ko duka biyu) na zaɓuɓɓukan tsarawa - kowane sa'o'i x (daga 1 zuwa 24) da kullun/makowa. Tsare-tsare na hoto na yau da kullun/mako-mako yana ba ku damar tantance takamaiman lokuta da ranaku don ɗaukar hotuna. Ga kowane zaɓi da aka zaɓa, dole ne ka saita manufar riƙewa, wanda za'a iya saita shi don share tafkin ta atomatik ko adana shi na ɗan lokaci.
Ƙarin bayani game da hotunan Unity - a .
Ƙananan clones
Klone na bakin ciki shine kwafin karantawa/rubutu na albarkatun toshe bakin bakin ciki, kamar girma, rukunin daidaito, ko VMware VMFS datastore, wanda ke raba tubalan tare da albarkatun iyayensa. Ƙananan clones hanya ce mai kyau don gabatar da kwafin bayanan SQL Server da sauri da sauƙi, wani abu da kayan aikin SQL na gargajiya ba zai iya cimma ba. Da zarar an gabatar da clone na bakin ciki ga mai watsa shiri, za a iya kawo kundin akan layi kuma za a haɗa bayanan ta amfani da hanyar DB Attach a cikin SQL Server.
Lokacin amfani da fasalin haɓakawa tare da ƙananan clones, ɗauki duk bayanan bayanai akan sikirin clone a layi. Dole ne a yi wannan kafin aikin sabuntawa. Rashin ɗaukar bayanan bayanai akan layi kafin yin haɓakawa na iya haifar da kurakuran rashin daidaiton bayanai ko sakamakon bayanan da ba daidai ba akan SQL Server.
Kwafiwar bayanai
Maimaita fasalin software ne wanda ke daidaita bayanai tare da tsarin nesa a wuri ɗaya ko wani wuri. Zaɓuɓɓukan maimaitawa na Unity da daidaitawa suna ba ku damar zaɓar ingantacciyar hanya don biyan buƙatun RTO/RPO don bayanan SQL Server yayin daidaita aiki da kayan aiki.
Lokacin amfani da Dell EMC Unity Replication don kare bayanan SQL Server akan ƙididdiga masu yawa, yakamata ku iyakance duk bayanai da juzu'i a cikin bayanan zuwa ƙungiyar daidaito ɗaya ko tsarin fayil. Ana saita maimaitawa akan tsarin ƙungiya ko tsarin fayil kuma yana iya haɗawa da juzu'i ko hannun jari na bayanan bayanai da yawa. Rukunin bayanan da ke buƙatar zaɓuɓɓukan kwafi daban-daban dole ne su kasance akan LUN daban-daban, ƙungiyoyin daidaito, ko tsarin fayil.
Ƙananan clones suna dacewa da duka biyu na aiki tare da maimaitawa asynchronous. Lokacin da aka kwaikwayi sikirin clone zuwa makoma, zai zama cikakken kwafin ƙara, ƙungiyar daidaito, ko ma'ajin VMFS. Bayan kwafi, clone na bakin ciki shine ƙarar mai zaman kanta gaba ɗaya tare da saitunan sa.
Tsarin kwafi na bakin ciki na clone tsakanin tushen da tsarin manufa.
Ba a buƙatar maimaita bayanan tempdb saboda an sake gina fayil ɗin lokacin da aka sake kunna SQL Server, sabili da haka metadata bai yi daidai da hanyar wasu lokuta na SQL Server ba. Zaɓin ɗimbin ƙididdiga a hankali don yin kwafi da abubuwan da ke cikin waɗancan kundin suna kawar da zirga-zirgar kwafin da ba dole ba.
Haɗe-haɗe Gudanarwar Kwafin Bayanan Sabar SQL ta Microsoft
Yawancin samfuran ajiya na zamani (ciki har da duk samfuran Dell EMC) na iya ƙirƙirar kwafin "tsarin aiki daidai" na kowane nau'in fayil ta:
- Daidaitaccen tsari na rubutu ta tsarin aiki a kowane matakai - daga mai watsa shiri zuwa tuƙi.
- Ƙirƙirar ƙira ta yadda fayiloli da yawa a kan kundila daban-daban su kula da tsarin rubutu.
Tare da yaɗuwar na'urorin ajiya masu ƙima, Microsoft ya haɓaka API don masu samar da ajiya. Wannan API yana ba masu ba da ajiya damar daidaitawa tare da software na SQL Server don ƙirƙirar "kwafi-daidaituwar aikace-aikacen" ta amfani da Sabis ɗin Kwafi na Ƙarfafa Shadow (VSS). Waɗannan kwafin suna kwatanta hulɗar tsakanin SQL Server da tsarin aiki yayin tsarawa da rufewar SQL Server. Ana goge duk abubuwan buffers na rubutu kuma ana dakatar da ma'amaloli har sai an sabunta duk fayafai kuma sun daidaita a wani lokaci na lokaci, wanda aka rubuta a cikin log ɗin SQL.
Dell EMC AppSync software hadedde tare da hotunan Unity XT yana sauƙaƙa da sarrafa sarrafa tsarin ƙirƙira, amfani, da sarrafa kwafin bayanan aiki masu dacewa. An yi nufin wannan software don amfani a yanayin sarrafa kwafi don dawo da bayanai da sake amfani da su.
Software na AppSync yana gano bayanan aikace-aikace ta atomatik, yana koyon tsarin bayanai, kuma yana tsara tsarin fayil ta hanyar kayan masarufi ko yadudduka na gani zuwa ma'ajiyar Unity XT. Yana tsara duk matakan da suka wajaba, daga ƙirƙira da tabbatar da kwafi zuwa ɗora hotuna a kan wanda aka yi niyya da farawa ko maido da bayanan. AppSync yana goyan bayan da sauƙaƙe ayyukan SQL Server wanda ya haɗa da sabuntawa da dawo da bayanan samarwa.
Rage bayanai da ci gaba da cirewa
Iyalin Haɗin kai na Dell EMC na tsarin ajiya yana ba da wadataccen fasali, sabis na rage bayanai masu sauƙin amfani. Ana samun tanadi ba kawai akan ingantaccen albarkatun ajiya na farko ba, har ma a kan hotuna da ƙwanƙwasa na waɗannan albarkatun. Snapshots da ƙananan clones sun gaji saitin raguwar bayanai na ma'ajin tushe, wanda ke ƙara ƙarfin tanadi.
Siffar raguwar bayanai ta haɗa da ƙaddamarwa, matsawa, da ayyukan gano toshe sifili, mai yuwuwar ƙara adadin sararin ajiya mai amfani don abubuwan mai amfani da amfani na ciki. Siffar rage bayanan Unity XT ya maye gurbin fasalin matsawa a cikin Unity OE 4.3 da kuma daga baya. Matsi shine algorithm na rage bayanai wanda zai iya rage rabon jiki na iya aiki da ake buƙata don adana saitin bayanai.
Tsarukan Unity XT kuma suna samar da ingantaccen fasalin cirewa wanda za'a iya kunna shi idan an kunna rage bayanai. Haɓaka haɓakawa yana rage ƙarfin da ake buƙata don bayanan mai amfani ta hanyar adana ƙaramin adadin kwafi (sau da yawa kwafi ɗaya) na tubalan bayanan Unity. Yankin cirewa shine LUN ɗaya. Yi la'akari da wannan lokacin zabar tsarin ajiya. Ƙananan LUNs suna haifar da mafi kyawun ƙaddamarwa, amma ƙarin LUNs suna ba da kyakkyawan aiki.
Adana iyawa daga haɓakawa na ci gaba na iya ba da fa'ida mafi girma a yawancin mahalli, amma kuma yana buƙatar amfani da na'urori masu tsara tsararrun Unity. A cikin OE 5.0, ƙaddamarwa na ci gaba, lokacin da aka kunna, yana ƙaddamar da kowane toshe (matsi ko rashin matsawa). Don ƙarin bayani, duba .
Tebu mai zuwa yana nuna ƙayyadaddun ƙayyadaddun ƙayyadaddun bayanai don rage bayanai da ƙaddamarwa na ci gaba:
Rage bayanai a cikin Haɗin kai (duk samfuri) da ingantaccen tallafi na cirewa
Unity OE
Fasaha
Nau'in waha mai goyan baya
Samfuran Tallafi
4.3 / 4.4
Rage bayanai
Filashin ƙwaƙwalwar ajiya - na gargajiya ko mai ƙarfi
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
4.5
Rage bayanai
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F
Rage bayanai da ci-gaba da kwafi*
450F, 550F, 650F
5
Rage bayanai
300, 400, 500, 600, 300F, 400F, 500F, 600F, 350F, 450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F
Rage bayanai da ci gaba da cirewa
450F, 550F, 650F, 380, 480, 680, 880, 380F, 480F, 680F, 880F
* An kashe raguwar bayanai ta tsohuwa kuma dole ne a kunna kafin ƙaddamar da ci gaba ya zama zaɓi mai samuwa. Bayan ba da damar rage bayanai, ana samun ci gaba na cirewa, amma an kashe shi ta tsohuwa.
Rage bayanai a cikin Haɗin kai da matsawar bayanai a cikin SQL Server
SQL Server 2008 Enterprise Edition shine farkon saki don ba da damar matsawa bayanai na asali. SQL Server 2008 matakin jere da matsawa matakin shafi yana amfani da ilimin tsarin teburin bayanai na ciki na SQL Server don rage sararin da abubuwan bayanai ke cinyewa. Rage sarari yana ba ku damar adana ƙarin layuka a kowane shafi da ƙarin shafuka a cikin tafkin buffer. Saboda bayanan da ba a adana su a cikin tsarin shafin bayanai na 8k, kamar bayanan da ba a layi ba kamar NVARCHAR(MAX), ba za su yi amfani da layi ko hanyoyin matsa shafi ba, Microsoft ya gabatar da ayyukan Transact-SQL COMPRESS da DECOMPRESS.
Waɗannan ayyuka suna amfani da tsarin matsi na bayanai na gargajiya (GZIP algorithm) wanda dole ne a kira kowane sashe na bayanai don matsawa ko ragewa.
Unity XT matsawa, wanda ba keɓanta ga SQL Server ba, yana amfani da algorithm na software don tantancewa da damfara bayanan ajiya. Tun lokacin da aka saki Unity OE 4.1, ana samun matsawar bayanan Unity don toshe kundin ajiya da kuma ajiyar bayanan VMFS a cikin tafki mai walƙiya. An fara tare da Unity OE 4.2, matsawa kuma ana samunsa don tsarin fayil da ma'ajin bayanan NFS a cikin wuraren ajiyar walƙiya.
Zaɓin hanyar matsa bayanai don SQL Server ya dogara da abubuwa da yawa. Waɗannan abubuwan sun haɗa da nau'in abun ciki na bayanai, albarkatun CPU da ake da su - duka akan ajiya da kan sabar bayanai, da albarkatun I/O da ake buƙata don kula da SLA. Gabaɗaya, zaku iya tsammanin ƙarin tanadin sararin samaniya don bayanan da aka matsa ta amfani da SQL Server, amma bayanan da aka matsa ta amfani da fasalin matsawa na TSQL na GZIP ba shi yiwuwa a ga ƙarin ƙarin tanadin sararin samaniya daga fasalin matsawa na Unity XT tunda yawancin fa'idodin sun fito daga tsohon. algorithm.
Haɗin haɗin kai yana ba da ajiyar sararin samaniya idan bayanan da ke kan abin ajiya an matsa su da akalla 25%. Kafin kunna matsewa akan abun ajiya, tantance ko ya ƙunshi bayanai waɗanda za'a iya matsawa. Kar a ba da damar matsawa don abin ajiya sai dai idan yin hakan zai adana iya aiki.
Lokacin yanke shawarar ko za a yi amfani da raguwar bayanan Unity, matsawar matakin bayanan SQL Server, ko duka biyun, la'akari da waɗannan:
- Bayanan da aka rubuta zuwa tsarin Unity yana inganta ta hanyar mai watsa shiri bayan an adana shi a cikin ma'ajin tsarin. Koyaya, tsarin matsawa baya farawa har sai an share cache.
- Ana samun tanadin matsawa ba kawai don albarkatun ajiya na Unity XT ba, har ma don ɗaukar hoto da ƙananan clones na albarkatun.
- A yayin aiwatar da matsawa, ana tara tubalan da yawa ta amfani da samfurin algorithm don tantance ko za a iya matsa bayanan. Idan samfurin algorithm ya ƙayyade cewa kawai za a iya samun tanadi kaɗan kawai, to an tsallake matsawa kuma an rubuta bayanan zuwa tafkin.
- Lokacin da aka matsa bayanai kafin a rubuta su zuwa kafofin watsa labaru, adadin sarrafa bayanai yana raguwa sosai. Don haka, matsawa yana taimakawa wajen rage lalacewa da tsagewa akan ƙwaƙwalwar filasha ta hanyar rage adadin bayanan da aka rubuta a cikin tuƙi.
Don ƙarin bayani game da matsawar layi da shafi a cikin SQL Server don teburi da fihirisa, duba .
Kar a manta cewa duk wani matsawa yana buƙatar albarkatun CPU. Lokacin da buƙatun bandwidth suna da girma, matsawa na iya samun tasiri mai mahimmanci akan aiki. Matsakaicin rubutu mai girma na nauyin aikin OLAP kuma na iya rage fa'idodin matsawa don bayanan SQL Server.
Dell EMC yayi bincike akan yuwuwar tanadi ta amfani da ƙimar rage yawan bayanan duniya akan tsarin haɗin kai. Ƙungiyar ta tattara bayanai akan injunan kama-da-wane na VMware, raba fayil, bayanan SQL Server, injina na Microsoft Hyper-V, da sauransu.
Sakamakon binciken ya nuna cewa raguwar girman fayil ɗin log ɗin SQL Server ya kusan sau 10 ƙasa da fayil ɗin bayanai:
- Girman bayanan bayanai = 1,49:1 (32,96%)
- Girman log = 12,9: 1 (92,25%)
An ba da bayanan SQL Server tare da juzu'i biyu. Ana adana fayilolin bayanan bayanai akan ƙara ɗaya kuma ana adana rajistan ayyukan ma'amala akan wani. Yin amfani da fasahar rage bayanai tare da kundin bayanai na iya samar da ajiyar ajiya; duk da haka, ya kamata ku yi la'akari da tasirin aikin yayin yanke shawarar ko za a ba da damar ƙaddamarwa akan kundin bayanai. Yayin da ainihin raguwar girman bayanai na iya bambanta dangane da bayanan da aka adana, sakamakon binciken ya nuna cewa sararin ajiya na ma'amalar SQL Server zai iya. .
Mafi kyawun ayyuka na rage bayanai
Kafin kunna rage bayanai akan abun ajiya, la'akari da jagororin masu zuwa:
- Yi amfani da saka idanu na tsarin ajiya don tabbatar da cewa yana da wadatattun albarkatu don tallafawa rage bayanai.
- Kunna rage bayanai don abubuwa da yawa na ajiya lokaci guda. Kula da tsarin don tabbatar da yana cikin shawarwarin yanayin aiki kafin kunna shi akan ƙarin wuraren ajiya.
- A kan nau'ikan Unity XT x80F, raguwar bayanai zai samar da tanadin iya aiki idan an matsa bayanan da ke cikin rukunin ajiya da aƙalla 1%.
Rage bayanai akan samfuran Unity x80F da suka gabata waɗanda ke gudana OE 5.0 sun ba da tanadi muddin bayanan sun kasance aƙalla 25% na matsewa.
- Kafin ka ba da damar rage bayanai akan abun ajiya, tantance ko abun ya ƙunshi bayanai masu matsewa. Wasu nau'ikan bayanai, kamar bidiyo, sauti, hotuna, da bayanan binary, yawanci suna ba da fa'ida kaɗan daga matsawa. Kar a ba da damar rage bayanai akan abun ajiya idan ba za a sami ajiyar sarari ba.
- Yi la'akari da zaɓin damfara juzu'in bayanan fayil wanda yawanci yana matsewa da kyau.
VMware Virtualization
VMware vSphere dandamali ne mai inganci kuma amintacce don haɓakawa da yanayin girgije. Babban abubuwan haɗin vSphere sune VMware vCenter Server da VMware ESXi hypervisor.
vCenter uwar garken haɗin kan dandamali ne na gudanarwa don mahallin vSphere. Yana da sauƙin turawa da haɓaka albarkatu cikin himma. ESXi buɗaɗɗen hypervisor ne wanda ke girka kai tsaye akan sabar jiki. ESXi yana da damar kai tsaye zuwa ainihin albarkatu kuma yana da ƙarami a girman 150MB, yana rage buƙatun ƙwaƙwalwar ajiya. Yana ba da ingantaccen aiki don nau'ikan kayan aikin aikace-aikacen kuma yana goyan bayan daidaitawar injin kama-da-wane-har zuwa 128 vCPUs, 6 TB na RAM, da na'urori 120.
Don SQL Server ya yi aiki yadda ya kamata akan kayan aikin zamani, SQL Server tsarin aiki (SQLOS) dole ne ya fahimci ƙirar kayan masarufi. Tare da zuwan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan ƙwaƙwalwar ajiya (NUMA), fahimtar alaƙar da ke tsakanin ƙira, masu sarrafa ma'ana, da na'urori na zahiri sun zama mahimmanci.
Masu sarrafawa
Unit Processing Unit (vCPU) na'ura ce ta tsakiya mai kama-da-wane da aka sanya wa na'ura mai mahimmanci. An ƙididdige jimlar adadin vCPUs da aka keɓance kamar:
Total vCPU = (количество виртуальных сокетов) * (количество виртуальных ядер на сокет)Idan daidaiton aiki yana da mahimmanci, VMware yana ba da shawarar cewa jimlar vCPUs da aka sanya wa duk injunan kama-da-wane kada su wuce adadin adadin abubuwan da ake samu akan mai masaukin ESXi, amma zaku iya ƙara adadin vCPUs da aka ware idan saka idanu ya nuna cewa albarkatun CPU da ba a yi amfani da su ba. suna samuwa.
A kan tsarin da Intel Hyper-Threading Technology aka kunna, adadin ma'ana mai ma'ana (vCPUs) ya ninka adadin muryoyin jiki sau biyu. A wannan yanayin, kar a sanya jimillar adadin vCPUs.
Ƙananan matakan SQL Sabar kayan aikin ba su da tasiri sosai ta hanyar canjin latency. Don haka, waɗannan kayan aikin na iya gudana akan runduna tare da babban rabo na vCPUs zuwa CPUs na zahiri. Matakan amfani da CPU masu ma'ana na iya ƙara yawan kayan aikin tsarin gaba ɗaya, haɓaka tanadin lasisi, da kiyaye ingantaccen aiki.
Intel Hyper-Threading yawanci yana haɓaka kayan aikin rundunar gabaɗaya ta 10% zuwa 30%, yana ba da shawarar vCPU zuwa rabon CPU na zahiri na 1,1 zuwa 1,3. VMware yana ba da shawarar kunna Hyper-Threading a cikin UEFI BIOS a duk lokacin da zai yiwu don ESXi ya iya cin gajiyar wannan fasaha. VMware kuma yana ba da shawarar cikakken gwaji da saka idanu yayin amfani da Hyper-Threading don ayyukan SQL Server.
Waƙwalwa
Kusan duk sabobin zamani suna amfani da tsarin gine-ginen da ba na Uniform memory access (NUMA) don sadarwa tsakanin babban ƙwaƙwalwar ajiya da na'urori masu sarrafawa. NUMA tsarin gine-ginen kayan masarufi ne don ƙwaƙwalwar ajiyar da aka raba wanda ke aiwatar da rarrabuwar tubalan ƙwaƙwalwar jiki tsakanin masu sarrafawa ta zahiri. Kullin NUMA ɗaya ne ko fiye da soket ɗin CPU tare da toshe na ƙayyadaddun ƙwaƙwalwar ajiya.
NUMA ya kasance batun tattaunawa sosai cikin shekaru goma da suka gabata. Matsakaicin dangi na NUMA ya kasance saboda wani ɓangare na aiwatarwa daga masu siyarwa daban-daban. A cikin mahallin da aka yi amfani da su, NUMA maɗaukaki yana ƙaddara ta yawan zaɓuɓɓukan sanyi da yadudduka-daga kayan aiki ta hanyar hypervisor zuwa tsarin aikin baƙo kuma a ƙarshe zuwa aikace-aikacen SQL Server. Kyakkyawan fahimtar gine-ginen kayan masarufi na NUMA dole ne ga kowane SQL Server DBA da ke gudanar da misalan SQL Server.
Don cimma babban inganci akan sabobin tare da adadi mai yawa, Microsoft ya gabatar da SoftNUMA. Software na SoftNUMA yana ba ku damar raba albarkatun CPU da ke samuwa a cikin NUMA ɗaya zuwa nodes SoftNUMA da yawa. A cewar VMware, SoftNUMA ya dace da VMware's NUMA (vNUMA) topology kuma yana iya ƙara haɓaka haɓaka injin bayanai da aiki don yawancin ayyukan aiki ...
Lokacin amfani da VMware tare da SQL Server:
- Saka idanu na inji don gano ƙananan albarkatun ƙwaƙwalwar ajiya don SQL Database Engine. Wannan batu yana haifar da haɓaka ayyukan I/O da rage aiki.
- Don inganta aiki, hana rikice-rikicen ƙwaƙwalwar ajiya tsakanin injuna kama-da-wane ta hanyar guje wa ƙwanƙwasa ƙwaƙwalwar ajiya a matakin ESXi.
- Yi la'akari da duba ƙayyadaddun ƙwaƙwalwar ajiyar jiki na hardware na NUMA don ƙayyade iyakar adadin ƙwaƙwalwar ajiya da za a iya sanyawa zuwa na'ura mai mahimmanci a cikin iyakokin NUMA na zahiri.
- Idan samun isasshen aiki shine manufa ta farko, yi la'akari da tanadin ƙwaƙwalwar ajiya daidai da abin da aka keɓe. Wannan saitin siga yana tabbatar da cewa injin kama-da-wane yana karɓar ƙwaƙwalwar ajiyar jiki kawai.
Ma'ajiyar ƙira
Ƙirƙirar ajiya a cikin yanayi mai ƙima yana buƙatar sanin kayan aikin ajiya. Kamar yadda yake tare da NUMA, kuna buƙatar fahimtar yadda matakan daban-daban na I / O ke aiki - a wannan yanayin, daga aikace-aikacen a cikin VM, zuwa karatun jiki da rubutu na bayanai akan matsakaicin ajiya na dindindin.
vSphere yana ba da zaɓuɓɓuka masu yawa don daidaitawa ajiya, waɗanda ke da aikace-aikace masu amfani a cikin aiwatar da SQL Server tare da tsararrun Unity XT. FS VMFS ita ce hanyar adana bayanai da aka fi amfani da ita a cikin toshe tsarin ajiya irin su Unity XT. Tsarin Unity XT shine matakin ƙasa wanda ya ƙunshi tuƙi na zahiri wanda vSphere ya fallasa azaman faifai masu ma'ana (juzu'i). An tsara kundin Unity XT azaman kundin VMFS ta ESXi hypervisor. Masu gudanar da VMware suna ƙirƙirar fayafai ɗaya ko fiye (VMDKs) waɗanda aka gabatar ga tsarin aiki na baƙo. RDM yana ba da injin kama-da-wane don isa ga ma'ajiyar toshewar Unity XT kai tsaye (ta FC ko iSCSI) ba tare da tsara VMFS ba. Ƙididdigar VMFS da RDM za su iya samar da kayan aikin ma'amala iri ɗaya.
Don ma'ajiyar tushen NFS don ESXi, Dell EMC yana ba da shawarar amfani da VMware NFS maimakon tsarin fayil na NFS gabaɗaya. Na'urar kama-da-wane da ke aiki akan SQL Server kuma ta amfani da VMDK akan ma'ajin bayanai na NFS bai san abin da ke cikin NFS Layer ba. Tsarin aiki na baƙo yana ɗaukar injin kama-da-wane azaman uwar garken jiki wanda ke gudana Windows Server da SQL Server. Rarraba faifai don daidaitawar misali tarin gazawa akan ma'ajin bayanai na NFS ba su da tallafi.
VMware vSphere Virtual Volumes (VVols) yana ba da ƙarin iko mai girma a matakin injin kama-da-wane, mai zaman kansa daga ainihin ma'aunin ƙwaƙwalwar ajiyar jiki (kamar kundin ko tsarin fayil). Maimaita tushen tsararru tare da VVols ana tallafawa farawa da VVol 2.0 (vSphere 6.5). Ana iya amfani da faifan VVol maimakon faifan RDM don samar da albarkatun faifai zuwa misalin SQL Failover Cluster wanda ya fara da vSphere 6.7 tare da goyan bayan SCSI na dindindin.
Rukunin cibiyoyin sadarwa
Sadarwar sadarwa a cikin duniyar kama-da-wane tana bin ra'ayoyi iri ɗaya kamar na zahirin duniyar, amma yana amfani da software maimakon igiyoyi na zahiri da masu sauyawa. Tasirin jinkirin hanyar sadarwa akan ayyukan SQL Server na iya bambanta sosai. Kula da ma'aunin aikin cibiyar sadarwa akan aikin da ake da shi ko tsarin gwaji da aka aiwatar da shi akan lokacin wakilci yana taimakawa wajen ƙirƙirar hanyar sadarwa mai kama-da-wane.
Lokacin amfani da haɓakar VMware tare da SQL Server, la'akari da waɗannan:
- Duka daidaitattun madaidaitan madaidaitan maɓalli da rarrabawa suna ba da aikin da SQL Server ke buƙata.
- Don raba gudanarwa cikin ma'ana, vSphere vMotion, da zirga-zirgar ma'ajiya ta hanyar sadarwa, yi amfani da alamar VLAN da ƙungiyoyin canza tashar tashar jiragen ruwa.
- VMware yana ba da shawarar ba da damar manyan firam ɗin akan maɓalli na kama-da-wane inda aka kunna zirga-zirgar vSphere vMotion ko iSCSI.
- Gabaɗaya, bi jagororin hanyar sadarwa don tsarin aiki na baƙi da kayan masarufi.
ƙarshe
Wuraren bayanai na SQL Server suna ƙara girma kuma sun fi rikitarwa. A cikin SQL Server 2019, Microsoft ya inganta ainihin fasalulluka na SQL Server kuma ya ƙara sababbi, kamar goyan baya ga manyan ayyuka na bayanai tare da Apache Spark da HDFS. Dell EMC, tare da haɗin gwiwar Microsoft, yana ci gaba da samar da abubuwan da suka dace don yanayin SQL Server - sabobin, ajiya da cibiyoyin sadarwa.
Muna ganin haɓakar haɓakawa a cikin lokaci da raguwa a cikin jimlar farashin mallakar (TCO) lokacin da ƙwararrun ma'ajin ajiya da bayanai ke aiki tare don ƙirƙirar hanyoyin samar da ababen more rayuwa don SQL Server akan dandamalin ajiya da aka raba. Dell EMC Unity XT duk-tsarin walƙiya shine matsakaicin matsakaicin matsakaici wanda ya dace da masu haɓaka SQL Server da masu gudanarwa waɗanda ke buƙatar babban aiki da ƙarancin latency. An ƙera shi don aiki akan duk fayafai, Unity XT All-Flash yana goyan bayan CPUs dual, daidaitawar mai sarrafa dual, da haɓakawa da yawa.
Ƙaruwa, ƙungiyoyi suna haɓaka yanayin SQL Server ɗin su. Ko da yake haɓakawa yana ƙara wani ƙirar ƙira zuwa tarin gine-gine, yana ba da fa'idodi masu mahimmanci. Muna fatan ka sami wasu fasalulluka da kayan aikin VMware da aka fi amfani da su a sama masu amfani a mahallin SQL Server. Muna kuma ba da shawarar hanyoyin haɗi zuwa albarkatu don ƙarin cikakkun bayanai.
hanyoyi masu amfani
Dell EMC
- (shafin samfur)
- (Youtube)
VMware
Microsoft
source: www.habr.com