Nā Hōʻailona 5 e hoʻoulu nei i kāu hōkeoʻikepili MySQL

hana mysql

Kūpilikiʻi ka ʻāina hoʻokele ʻikepili a ulu koke. ʻAʻohe mea koʻikoʻi i kēia evolution ma mua o ka puka ʻana o 'super apps' - a i ʻole nā ​​noi e hana ana i miliona o ka launa hoʻohana ʻana i kēlā me kēia kekona. Factor i Big Data a me ke ao, a maopopo leʻa pono nā mea kālepa e-commerce i kahi hanauna hou o ka ʻikepili i hiki ke hana maikaʻi a me ka pālākiō wikiwiki.

ʻO kēlā me kēia ʻoihana pūnaewele me ka ʻole o kahi waihona i hōʻano hou ʻia e holo nei paha MySQL, kahi hōkeoʻikepili i hōʻano hou ʻole ʻia mai kona hoʻomaka ʻana i 1995. Ma hope o nā mea āpau, ʻaʻole i lilo ka huaʻōlelo "NewSQL" i ʻāpana o ka lexicon uila a hiki iā Matt Aslett, kahi mea kālailai no ka 451 Group , i hana ʻia ma 2011.

ʻOiai hiki i ka MySQL ke lawelawe i ka nui o ke kalepa, ʻoiai e ulu mau ana kahi ʻoihana, e hiki paha kāna database i ka hiki i ka hiki i hiki a paʻa kāna pūnaewele me ka hana pono. Inā ʻaʻole maopopo iā ʻoe no ka mākaukau o kāu ʻoihana no kahi database NewSQL, eia nā hōʻailona ʻelima e hoʻonui ana ʻoe i MySQL:

  1. Heluhelu, kākau a hōʻano hou ka paʻakikī paʻakikī - He palena palena ko MySQL. E like me ka nui a me ka nui o nā mea kūʻai aku e hoʻopau i nā hana ma kāu pūnaewele, he manawa wale nō ia o ka manawa ma mua o ka paʻa ʻana o kāu waihona. Eia kekahi, ke hoʻonui nei kāu ukana, a paʻakikī ʻoe i ka mālama ʻana i nā heluhelu hou a kākau, pono paha ʻoe i kahi waihona ʻikepili ʻokoʻa. Hiki i ka MySQL ke unahi i ka heluhelu ma o nā "kauā heluhelu", akā pono e makaʻala nā palapala noi i ka heluhelu ʻana ʻaʻole like ʻole me ka haku kākau. ʻO kahi laʻana, ke hōʻano hou ka mea kūʻai aku i nā huahana i kāna kaʻa e-commerce, pono e heluhelu ʻia mai ka haku kākau. Inā ʻaʻole, pilikia ʻoe i ka hewa i hiki ke loaʻa-i-hoʻohiki ʻia hewa. Inā kū kēlā, loaʻa iā ʻoe kahi ʻōmole i kahi wahi ʻoi loa: ʻo kāu laina kālepa e-ʻoihana. Hiki i kahi ʻōmole ma ke kīʻaha ke hopena i nā kaʻa kaʻa i haʻalele ʻia, a ʻoi aku paha ka maikaʻi ʻole, e kūʻai aku ʻoe i nā waihona i loaʻa ʻole iā ʻoe, a pono e hana pū me nā mea kūʻai aku huhū, a me ka hōʻike ʻole ʻana paha o ka pāpaho maikaʻi ʻole.
  2. kali analytics a me ka hōʻike ʻana - ʻAʻole hāʻawi kaʻuʻikepili base MySQL i kahi manawa maoli analytics hiki ʻole iā lākou ke kākoʻo no nā hana SQL ʻē aʻe. No ka hoʻoponopono ʻana i kēia pilikia, koi ʻia nā Mana Mana Mana Mana Mana Mana Mana Manawa (MVCC) a me Massing Parallel Processing (MPP) no ka hana ʻana i nā hana nui no ka mea ʻae lākou i nā kākau a analytics e hana me ka hoʻoweliweli ʻole ʻia, a hoʻohana i nā pona he nui a me nā kumu nui he nui i kēlā me kēia pona e ʻoi aku ka wikiwiki o nā nīnau analytic.
     
    MySQL-nīnau-pili
  3. ʻO ka manawa pinepine - Kūkulu ʻia nā waihonaʻikepili MySQL me hoʻokahi kiko o ka hoka, ʻo ia hoʻi inā loaʻa kekahi ʻāpana - e like me ka drive, motherboard, a me ka hoʻomanaʻo - e holo pono ʻole ana. A ʻo kahi hopena, ke ʻike pinepine nei paha ʻoe i ka downtime, a hiki i ka hopena o ka lilo o ka loaʻa kālā. Hiki iā ʻoe ke hoʻohana i ka sharding a me nā kauā, akā palupalu kēia a ʻaʻole hiki ke mālama i ka nui o nā kaʻa. Mālama kahi waihona ʻike pālākiō i mau kope he nui o kāu ʻike, hāʻawi i ka hoʻomanawanui hewa i kūkulu ʻia a hoʻomau i nā hana me ka ʻole a / a i ʻole nā ​​kōpaʻa.
     
    ʻAʻole i hāʻawi ʻia kahi kiʻi ʻo Clustrix
  4. ʻO nā kumukūʻai hoʻolālā kiʻekiʻe - Pono nā mea hoʻomohala e hana pū me nā database MySQL e hoʻohana pinepine i kahi hapa nui o kā lākou manawa e hoʻoponopono ana i nā pilikia o ka plumbing a i ʻole ke kamaʻilio ʻana i nā hemahema waihona. ʻAe manuahi nā mea hoʻomohala e hana nei me kahi database unahi i waho e hana i ka hoʻomohala ʻana i nā hiʻohiʻona a me ka wikiwiki ʻana i ka huahana. A ʻo kahi hopena, hoʻemi ka manawa i ka mākeke a hiki i nā ʻoihana e-commerce ke loaʻa kālā me ka wikiwiki.
  5. Hoʻohui pūnaewele kikowaena - Ke hoʻonui aku nei nā kikowaena i ka RAM no nā manawa lōʻihi, a i ʻole pinepine i ka lā, he hōʻailona nui ia ʻaʻole hiki i MySQL ke hoʻomau i ka ulu ʻana o ka ʻoihana. ʻO ka hoʻohui ʻana i nā lakohana ka hoʻoponopono wikiwiki, akā pipiʻi loa ia a ʻaʻole ia he hopena wā lōʻihi. Inā hoʻohana nā ʻoihana i kahi ala hele i waho, hiki ke kope ʻia i ka ʻikepili ma o nā aka, a ke piʻi ka nui o nā hana i ka nui a me ka nui, ua hoʻoneʻe ʻia ka hana i nā piko ʻē aʻe i loko o ka waihona.

Kuhiʻia

Maopopo ia, he palena ko MySQL, a hāʻawi ʻia ka manawa a me ka ulu ʻana o ka pīhaʻu, paʻa paʻa ʻia kahi waihona MySQL i ka hana a me nā pilikia latency. A no nā pūnaewele e-commerce, ʻo ia mau hana hewa e aneane e unuhi i ka loaʻa kālā i hala.

Ma hope o nā mea āpau, ʻaʻole ia he mea e kahaha ai a laila ʻenehana e kūkulu ʻia nei i ʻelua mau makahiki i hala aku nei e hakakā nei e hoʻomau i ka honua kamepiula wikiwiki o kēia lā. E noʻonoʻo e pili ana: pehea e ʻike ai nā mea programme ma 1995 i ka mana e lilo ai ka Pūnaewele?

ʻO ka wā e hiki mai ana o nā waihona

Pehea kou manaʻo?

Ke hoʻohana nei kēia pūnaewele i ka Akismet e ho'ēmi i ka spam. E aʻo pehea e hanaʻia ai kāuʻikeʻikepili.