SQL Sharding yog dab tsi?
SQL Sharding yog dab tsi?

Video: SQL Sharding yog dab tsi?

Video: SQL Sharding yog dab tsi?
Video: Summer School 2019/Anatoly Klypin 1 2024, Tej zaum
Anonim

Sharding a SQL ntawv Server database. Sharding , ntawm nws cov tub ntxhais, tab tom rhuav tshem ib qho, cov ntaub ntawv loj rau hauv ntau qhov me me, muaj tus kheej. Qhov no feem ntau yog ua los ntawm cov tuam txhab uas xav tau kom muaj kev sib tsoo cov ntaub ntawv, piv txwv li SaaS tus kws kho mob cais cov neeg siv cov ntaub ntawv.

Yog li ntawd, sharding txhais li cas?

Sharding yog ib hom database partitioning uas cais cov databases loj heev rau hauv me me, sai dua, yooj yim tswj qhov chaw hu ua cov ntaub ntawv shards. Lo lus shard txhais ib feem me me ntawm tag nrho.

Tsis tas li ntawd, qhov sib txawv ntawm partitioning thiab sharding yog dab tsi? “ kev sib faib yog faib los yog muab faib ntawm cov ntaub ntawv nyob rau hauv ntau yam txawv machines ntawd muab faib yog kev faib cov ntaub ntawv ntawm tib lub tshuab."

Xav txog qhov no, database sharding ua haujlwm li cas?

Sharding yog ib txoj kev ntawm kev faib thiab khaws cia ib lub logical dataset nyob rau hauv ntau yam databases . Los ntawm kev faib cov ntaub ntawv ntawm ntau lub tshuab, ib pawg ntawm database tshuab ua tau khaws cov ntaub ntawv loj dua thiab tuav cov lus thov ntxiv. Sharding tso cai a database pawg los ntsuas nrog nws cov ntaub ntawv thiab kev loj hlob ntawm cov tsheb.

Qhov twg Azure SQL Database feature siv sharding?

Kom yooj yim scale tawm databases ntawm SQL Azure , siv a shard map manager. Cov shard map manager yog ib tug tshwj xeeb database uas tuav cov ntaub ntawv qhia thoob ntiaj teb txog txhua qhov shards ( databases ) hauv a shard teeb.

Pom zoo: