Alibaba akaburitswa mazuva mashoma apfuura waita sarudzo yekuburitsa sosi kodhi ye yako yakagoverwa dhatabhesi manejimendi system "PolarDB" iyo yakavakirwa paPostgreSQL, kodhi yakavhurwa pasi peApache 2.0 rezinesi.
Kune avo vasingazive nezvePolarDB, iwe unofanirwa kuziva izvo iyi ihukama hwehukama zvichibva pagore rakagadzirwa naAlibaba iro inowedzera PostgreSQL kugona yekuparadzira dhata yekuchengetedza pamwe nekuvimbika uye rutsigiro rwe ACID transaction mune mamiriro eepasi rese dhatabhesi, yakagoverwa munzvimbo dzakasiyana dzemasumbu.
PolarDB futi inotsigira yakaparadzirwa SQL query kugadzirisa, ichipa kushivirira kwekukanganisa uye kusachengetedzwa kwedata zvakanyanya kuti izadzise ruzivo mushure mekunge imwe kana kupfuura node dzakundikana Kana iwe uchida kuwedzera yako yekuchengetedza, ingo wedzera nyowani nyowani kune iyo sumbu.
Polar DB ine zvikamu zviviri: kuwedzererwa uye seti yezvigamba zvePostgreSQL. Iwo maratidziro anowedzera kugona kweiyo PostgreSQL musimboti uye izvo zvinowedzerwa zvinosanganisira zvakaparadzaniswa zvakagadziriswa zvikamu zvePostgreSQL, senge yakagoverwa kutapurirana manejimendi mashandiro, masevhisi epasirese, yakaparadzirwa SQL query processor, yakawedzera metadata, maturusi ekugadzirisa sumbu, kushandisa sumbu, uye kurerutsa kutama kwemaitiro aripo kwariri.
Iwo matinji anowedzera vhezheni yakapihwa yeiyo yakawanda yekushandura concurrency kudzora mashandiro (MVCC) kune iyo PostgreSQL musimboti yematanho akasiyana ekuzvitsaura. Mazhinji ePolarDB mashandiro akaendeswa kune ekuwedzera, ayo anoderedza kutsamira paPostgreSQL uye inorerutsa kusimudzira uye kuendesa kwePolarDB-based mhinduro (inorerutsa shanduko kune idzva vhezheni dzePostgreSQL uye inochengetedza yakazara PostgreSQL kuenderana).
Pane zvinhu zvitatu zvakakosha musumbu: dhatabhesi node (DN), masumbu maneja (CM) uye transaction manejimendi sevhisi (TM), pamusoro pezvo, proxy mutoro balancer inogona kubatanidzwa. Chimwe nechimwe chezvinhu zvacho chiitiko chakaparadzana uye chinogona kumhanya pamaseva akasiyana epanyama. Iyo dhatabhesi node dzinoshandira mutengi SQL mibvunzo uye panguva imwechete kuita sevamiririri vekuitwa kwemibvunzo yakaparadzirwa nekutora chikamu kweimwe dhatabhesi node.
Iyo cluster maneja inoongorora mamiriro eimwe neimwe dhatabhesi node, inochengetera masumbu kumisikidzwa uye inopa maturusi ekugadzirisa, kutsigira kumusoro, kuenzanisa mutoro, kugadzirisa, kutanga, uye kumisa node. Iyo yekutengesa manejimendi sevhisi inoitisa kuchengetedza kwakazara kutendeseka mukati memasumbu.
PolarDB yakavakirwa pane Yakagovaniswa-isina chakagoverwa komputa dhizaini zvinoenderana nedhata iro rinogovaniswa panguva yekuchengeterwa kune akasiyana maodhi, pasina kushandisa yakajairika yekuchengetera ese maodhi uye node yega yega inoitisa chidimbu che data rakabatanidzwa kwariri uye rinoita rakabatana data remubvunzo.
Tafura yega yega yakatsemurwa uchishandisa yekutanga kiyi hashes. Kana iyo chikumbiro ichivhara data iri pane akasiyana node, iyo yakaparadzirwa transaction yekumisikidza injini uye mutengesi wekutengesa zvakabatana kuti zvive nechokwadi cheatomicity, kusachinja, kuzviparadzanisa, uye kuvimbika (ACID)
Kuona kushivirira kwekukanganisa, chidimbu chimwe nechimwe chinodzokororwa pamatanho matatu. Kuti uchengetedze zviwanikwa, iyo yakazara data inosanganisira mbiri chete replicas uye imwe inogumira kuchengetedza iyo yekunyora-kumashure kwegiyo (WAL). Imwe yeaya maviri akazara maficha akasarudzwa semutungamiriri uye anotora chikamu mukugadzirisa chikumbiro, nepo iyo yechipiri node ichiita sechipenga chechikamu chedata chiri kutariswa, uye chechitatu chinotora chikamu mukusarudzwa kwenzvimbo yekutanga uye inogona kushandiswa kudzorera ruzivo kana zvikaitika kukundikana kwemaviri maviri ane yakazara replicas.
Kudzokororwa kwedata pakati pemasumbu emasumbu akarongeka uchishandisa iyo Paxos algorithm, iyo inovimbisa kuwiririrana kwekubvumirana kutsunga mune network ine zvingangove zvisina kuvimbika node. Izvo zvinofanirwa kucherechedzwa kuti kuzere mashandiro ePolarDB DBMS inorongwa kuburitswa mumatatu shanduro.
Chekupedzisira, kana iwe uchifarira kuziva zvakawanda nezvazvo, unogona kubvunza ruzivo mune inotevera chinongedzo.