Scaling for Write
Queuing​
Write scaling mate sharding set karya pehla, vadhare parellel write ne support karva mate aapde queuing ne consider karvu jaruri 6e.
Aa case ma aapde jose k su badho data real time ma database ma persist karvo jaruri hoi 6e? Jo answer hoi nahi, to aapde aa request ne queue ma ek proper timeframe sathe set kari sakie 6ie.
Aa solution short write traffic na spike thi bachave 6e and saru ane proper steady write operations perform kari sakie 6ie.
Joke aa solution bau vadhare consistent write traffic hoi to kam nathi karto. ae case ma aapde parallel write support mate data spliting vise vicharva nu start kari devu joie.
Partitioning​
Partitioning ek table ne multiple tables ma devide kare 6e. aa partition ae rite karva ma aave 6e k aapdi application j database ne access kare 6e aene koi prakar nu khyaal na aave.
Partitioning ni madad thi queries ne bau o66a records and indexes ne scan karvu pade 6e.
Paritioning ae sharding karta ghanu sehlu solution 6e.
Partitioning na case ma data same database server ma store thai 6e jyare sharding na case ma aa splitting alag alag server ma thai 6e, jethi sharding ma distributed system ni complexities bau vadhare jova made 6e.
Sharding​
Write heavy traffic mate scaling karva mate last solution 6e sharding.
Aapda data ne alag alag server ma spread/split karya pehla ae check karvu jaruri 6e k aa sharding karva mate jarur 6e bhi k nahi. aa decide karva mate niche aapel thoda checklist jevu joi sako.
Tamare sharding karvu jaruri 6e jo tamare niche mujab load rehto hoi.
- 100 milions row written per day
- 10 milions transactions per day
- 100 milions queries per day
Ek vakhat aapde horizontal scaling ne choose kari lidhu hoi pa6i aapde tables ne joi ne decide karvu joie k kya table ne distribute karva ni jarur 6e.
Ae decide karva mate k table ne distribute karvu k nahi, niche mujab criteria check karo.
- 10 milions karta vadhare rows 6e.
- roj na 1 milion karta vadhare write thai 6e.
- 10 GB karta vadhare table motu 6e.