Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

ื”ืขืœื, ื›ืึทื‘ืจืึธื•ื•ื™ื˜ืขืก. ื˜ืจืึทื“ื™ืฉืึทื ืึทืœื™, ืžื™ืจ ืคืึธืจื–ืขืฆืŸ ืฆื• ื˜ื™ื™ืœืŸ ื˜ืฉื™ืงืึทื•ื•ืข ืžืึทื˜ืขืจื™ืึทืœ ืื•ื™ืฃ ื“ื™ ืขืจืขื•ื• ืคื•ืŸ ื“ื™ ืึธื ื”ื™ื™ื‘ ืคื•ืŸ ื ื™ื™ึทืข ืงืึธืจืกืึทื–. ื”ื™ื™ึทื ื˜, ืกืคึผืขืฆื™ืขืœ ืคึฟืึทืจ ืื™ืจ, ืžื™ืจ ื”ืึธื‘ืŸ ืื™ื‘ืขืจื’ืขื–ืขืฆื˜ ืึทืŸ ืึทืจื˜ื™ืงืœ ื•ื•ืขื’ืŸ Google Cloud Spanner, ื˜ื™ื™ืžื“ ืฆื• ืฆื•ื ื•ื™ืคืคืึทืœืŸ ืžื™ื˜ ื“ื™ ืงืึทื˜ืขืจ ืคื•ืŸ ื“ืขื ืงื•ืจืก "AWS ืคึฟืึทืจ ื“ืขื•ื•ืขืœืึธืคึผืขืจืก".

Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

ืขืจื™ื“ื–ืฉื ืึทืœื™ ืืจื•ื™ืก ืื™ืŸ Lightspeed HQ ื‘ืœืึธื’.

ื•ื•ื™ ืึท ืคื™ืจืžืข ื•ื•ืึธืก ืึธืคืคืขืจืก ืึท ืคืึทืจืฉื™ื™ื“ื ืงื™ื™ึทื˜ ืคื•ืŸ ื•ื•ืึธืœืงืŸ-ื‘ืื–ื™ืจื˜ POS ืกืึทืœื•ืฉืึทื ื– ืคึฟืึทืจ ืจืขื˜ืึทื™ืœืขืจืก, ืจืขืกื˜ืจืึทื ืฅ ืื•ืŸ ืึธื ืœื™ื™ืŸ ืกื•ื—ืจื™ื ืึทืจื•ื ื“ื™ ื•ื•ืขืœื˜, Lightspeed ื ื™ืฆื˜ ืขื˜ืœืขื›ืข ืคืึทืจืฉื™ื“ืขื ืข ื˜ื™ื™ืคึผืก ืคื•ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก ืคึผืœืึทื˜ืคืึธืจืžืก ืคึฟืึทืจ ืคืึทืจืฉื™ื“ืŸ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธื ืึทืœ, ืึทื ืึทืœื™ื˜ื™ืงืก ืื•ืŸ ื–ื•ื›ืŸ ื ื•ืฆืŸ ืงืึทืกืขืก. ื™ืขื“ืขืจ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืคึผืœืึทื˜ืคืึธืจืžืก ื”ืื˜ ื–ื™ื™ืŸ ืื™ื™ื’ืขื ืข ืกื˜ืจืขื ื’ืงื˜ืก ืื•ืŸ ื•ื•ื™ืงื ืึทืกืึทื–. ื“ืขืจื™ื‘ืขืจ, ื•ื•ืขืŸ Google ื™ื ื˜ืจืึธื•ื“ื•ืกื˜ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืฆื• ื“ื™ ืžืึทืจืง - ืคึผืจืึทืžืึทืกื™ื ื’ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ื•ื•ืึธืก ื–ืขื ืขืŸ ื ื™ืฉื˜ ื’ืขื–ืขืŸ ืื™ืŸ ื“ืขืจ ื•ื•ืขืœื˜ ืคื•ืŸ ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ืึทื–ืึท ื•ื•ื™ ื›ืžืขื˜ ืึทื ืœื™ืžืึทื˜ืึทื“ ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืกืงืึทืœืึทื‘ื™ืœื™ื˜ื™ ืื•ืŸ ืึท 99,999% ืกืขืจื•ื•ื™ืก ืžื“ืจื’ื” ื”ืขืกืงืขื (SLA) , ืžื™ ืจ ื”ืื‘ ืŸ ื ื™ืฉ ื˜ ื’ืขืงืขื  ื˜ ืคืืจืœืื– ืŸ ื“ ื™ ื’ืขืœืขื’ื ื”ืฒ ื˜ ื–ื™ ื™ ื”ืื‘ ืŸ ืื™ ืŸ ืื•ื ื“ื–ืขืจ ืข ื”ืขื ื˜ !

ืฆื• ื’ืขื‘ืŸ ืึท ืคื•ืœืฉื˜ืขื ื“ื™ืง ืื™ื‘ืขืจื‘ืœื™ืง ืคื•ืŸ ืื•ื ื“ื–ืขืจ ื“ืขืจืคืึทืจื•ื ื’ ืžื™ื˜ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื“ื™ ืืคืฉืืฆื•ื ื’ ืงืจื™ื™ื˜ื™ืจื™ืึท ื•ื•ืึธืก ืžื™ืจ ื’ืขื•ื•ื™ื™ื ื˜, ืžื™ืจ ื•ื•ืขืœืŸ ื“ืขืงืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ื˜ืขืžืขืก:

  1. ืื•ื ื“ื–ืขืจ ืืคืฉืืฆื•ื ื’ ืงืจื™ื™ื˜ื™ืจื™ืึท
  2. ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื™ืŸ ืึท ื ืึทื˜ืฉืขืœ
  3. ืื•ื ื“ื–ืขืจ ืึทืกืขืกืžืึทื ื˜
  4. ืื•ื ื“ื–ืขืจ ืคื™ื™ื ื“ื™ื ื’ื–

Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

1. ืื•ื ื“ื–ืขืจ ืืคืฉืืฆื•ื ื’ ืงืจื™ื™ื˜ื™ืจื™ืึท

ืื™ื™ื“ืขืจ ืžื™ืจ ื•ื ื˜ืขืจื˜ื•ืงื  ื–ื™ืš ื“ื™ ืกืคึผื™ืกื™ืคื™ืงืก ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ, ื“ื™ ืกื™ืžืึทืœืขืจืึทื˜ื™ื– ืื•ืŸ ื“ื™ืคืขืจืึทื ืกื™ื– ืžื™ื˜ ืื ื“ืขืจืข ืกืึทืœื•ืฉืึทื ื– ืื•ื™ืฃ ื“ืขื ืžืึทืจืง, ืœืึธื–ืŸ ืื•ื ื“ื– ืขืจืฉื˜ืขืจ ืจืขื“ืŸ ื•ื•ืขื’ืŸ ื“ื™ ื”ื•ื™ืคึผื˜ ื ื•ืฆืŸ ืงืึทืกืขืก ื•ื•ืึธืก ืžื™ืจ ื”ืึธื‘ืŸ ืื™ืŸ ื–ื™ื ืขืŸ ื•ื•ืขืŸ ืžื™ืจ ื‘ืึทื˜ืจืึทื›ื˜ืŸ ื•ื•ื• ืฆื• ื ื•ืฆืŸ Cloud Spanner ืื™ืŸ ืื•ื ื“ื–ืขืจ ื™ื ืคืจืึทืกื˜ืจืึทืงื˜ืฉืขืจ:

  • ื•ื•ื™ ืึท ืคืึทืจื‘ื™ื™ึทื˜ ืคึฟืึทืจ ื“ื™ (ืคึผืจื™ื•ื•ื™ื™ืœื™ื ื’) ื˜ืจืื“ื™ืฆื™ืื ืขืœืŸ ืกืงืœ ื“ืึทื˜ืึทื‘ื™ื™ืก ืœื™ื™ื–ื•ื ื’
  • ื•ื•ื™ ืึทืŸ OLAP-ืขื ื™ื™ื‘ืึทืœื“ OLTP ืœื™ื™ื–ื•ื ื’

ื‘ืึทืžืขืจืงื•ื ื’: ืคึฟืึทืจ ื™ื– ืคื•ืŸ ืคืึทืจื’ืœื™ื™ึทืš, ื“ืขืจ ืึทืจื˜ื™ืงืœ ืงืึทืžืคึผืขืจื– ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืžื™ื˜ ื“ื™ MySQL ื•ื•ืขืจื™ืึทื ืฅ ืคื•ืŸ ื“ื™ GCP Cloud SQL ืื•ืŸ Amazon AWS RDS ืœื™ื™ื–ื•ื ื’ ืคืึทืžื™ืœื™ืขืก.

ื ื™ืฆืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื•ื•ื™ ืึท ืคืึทืจื‘ื™ื™ึทื˜ ืคึฟืึทืจ ืึท ื˜ืจืื“ื™ืฆื™ืื ืขืœืŸ SQL ื“ืึทื˜ืึทื‘ื™ื™ืก ืœื™ื™ื–ื•ื ื’

ืื™ืŸ ื“ืขืจ ืกื‘ื™ื‘ื” ื‘ืขืงืึทื‘ืึธืœืขื“ื™ืง ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ื•ื•ืขืŸ ื“ื™ ืขื ื˜ืคืขืจ ืฆื™ื™ื˜ ืคึฟืึทืจ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ืึธื ืคึฟืจืขื’ ืึทืคึผืจืึธื•ื˜ืฉื™ื– ืึธื“ืขืจ ืืคื™ืœื• ื™ืงืกื™ื“ื– ืคึผืจืขื“ืขืคื™ื ืขื“ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ื˜ืจืขืฉื›ืึธื•ืœื“ื– (ื‘ืคึฟืจื˜ ืจืขื›ื˜ ืฆื• ืึท ืคืึทืจื’ืจืขืกืขืจืŸ ืื™ืŸ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ื ื™ืฆืขืจืก ืื•ืŸ / ืึธื“ืขืจ ืจื™ืงื•ื•ืขืก), ืขืก ื–ืขื ืขืŸ ืขื˜ืœืขื›ืข ื•ื•ืขื’ืŸ ืฆื• ืจืขื“ื•ืฆื™ืจืŸ ื“ื™ ืขื ื˜ืคืขืจ ืฆื™ื™ื˜ ืฆื• ืคึผืึทืกื™ืง ืœืขื•ื•ืขืœืก. ืึธื‘ืขืจ, ืจื•ื‘ึฟ ืคื•ืŸ ื“ื™ ืกืึทืœื•ืฉืึทื ื– ืึทืจื™ื™ึทื ืฆื™ืขืŸ ืžืึทื ื•ืึทืœ ื™ื ื˜ืขืจื•ื•ืขื ื˜ื™ืึธืŸ.

ืฆื•ื ื‘ื™ื™ืฉืคึผื™ืœ, ื“ืขืจ ืขืจืฉื˜ืขืจ ืฉืจื™ื˜ ืฆื• ื ืขืžืขืŸ ืื™ื– ืฆื• ืงื•ืงืŸ ืื™ืŸ ื“ื™ ืคืึทืจืฉื™ื“ืŸ ืคืึธืจืฉื˜ืขืœื•ื ื’-ืคึฟืึทืจื‘ื•ื ื“ืขื ืข ื“ืึทื˜ืึทื‘ื™ื™ืก ืกืขื˜ื˜ื™ื ื’ืก ืื•ืŸ ื ื™ื’ืŸ ื–ื™ื™ ืฆื• ื‘ืขืกื˜ืขืจ ื’ืœื™ื™ึทื›ืŸ ื“ื™ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ื‘ืึทื ื™ืฅ ืกืฆืขื ืึทืจ ืคึผืึทื˜ืขืจื ื–. ืื•ื™ื‘ ื“ืึธืก ืื™ื– ื ื™ืฉื˜ ื’ืขื ื•ื’, ืื™ืจ ืงืขื ืขืŸ ืงืœื™ื™ึทื‘ืŸ ืฆื• ื•ื•ืึธื’ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ืขืจื˜ื™ืงืœื™ ืึธื“ืขืจ ื›ืึธืจื™ื–ืึทื ื˜ืึทืœื™.

ืกืงื™ื™ืœื™ื ื’ ืึท ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ื™ื ื˜ื™ื™ืœื– ืึทืคึผื“ื™ื™ื˜ื™ื ื’ ื“ื™ ืกืขืจื•ื•ืขืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, ื˜ื™ืคึผื™ืงืœื™ ื“ื•ืจืš ืึทื“ื™ื ื’ ืžืขืจ ืคึผืจืึทืกืขืกืขืจื– / ืงืึธืจืขืก, ืžืขืจ ื‘ืึทืจืึทืŸ, ืคืึทืกื˜ืขืจ ืกื˜ืึธืจื™ื“ื–ืฉ, ืืื–"ื• ื•. ืึทื“ื™ื ื’ ืžืขืจ ื™ื™ึทื–ื ื•ื•ืึทืจื’ ืจืขืกื•ืจืกืŸ ืจืขื–ื•ืœื˜ืื˜ืŸ ืื™ืŸ ื’ืขื•ื•ืืงืกืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก ืคืึธืจืฉื˜ืขืœื•ื ื’, ื’ืขืžืืกื˜ืŸ ื‘ืคึฟืจื˜ ืื™ืŸ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– ืคึผืขืจ ืกืขืงื•ื ื“ืข, ืื•ืŸ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืœื™ื™ื˜ืึทื ืกื™ ืคึฟืึทืจ ืึธืœื˜ืคึผ ืกื™ืกื˜ืขืžืขืŸ. ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืก ืกื™ืกื˜ืขืžืขืŸ (ื•ื•ืึธืก ื ื•ืฆืŸ ืึท ืžื•ืœื˜ื™-ื˜ืจืขื“ื™ื“ ืฆื•ื’ืึทื ื’) ืึทื–ืึท ื•ื•ื™ MySQL ื•ื•ืึธื’ ื•ื•ืขืจื˜ื™ืงืœื™.

ืขืก ื–ืขื ืขืŸ ืขื˜ืœืขื›ืข ื“ื™ืกืึทื“ื•ื•ืึทื ื˜ื™ื“ื–ืฉื™ื– ืฆื• ื“ืขื ืฆื•ื’ืึทื ื’, ืึธื‘ืขืจ ื“ื™ ืžืขืจืกื˜ ืงืœืึธืจ ื•ื•ื™ ื“ืขืจ ื˜ืึธื’ ืื™ื– ื“ื™ ืžืึทืงืกื™ืžื•ื ืกืขืจื•ื•ืขืจ ื’ืจื™ื™ืก ืื•ื™ืฃ ื“ืขื ืžืึทืจืง. ืึทืžืึธืœ ื“ืขืจ ื’ืจืขืกื˜ืขืจ ืกืขืจื•ื•ื™ืจืขืจ ื™ื ืกื˜ืึทื ืกืข ืœื™ืžื™ื˜ ืื™ื– ืจื™ื˜ืฉื˜, ืขืก ืื™ื– ื‘ืœื•ื™ื– ืื™ื™ืŸ ื•ื•ืขื’ ืœื™ื ืงืก: ื•ื•ืึธื’ ืื•ื™ืก.

ืกืงืึทืœืข-ืื•ื™ืก ืื™ื– ืึท ืฆื•ื’ืึทื ื’ ื•ื•ืึธืก ืžื•ืกื™ืฃ ืžืขืจ ืกืขืจื•ื•ืขืจืก ืฆื• ืึท ืงื ื•ื™ืœ ืฆื• ื™ื™ื“ื™ืœื™ ืคืึทืจื’ืจืขืกืขืจืŸ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืœื™ื ืขืึทืจืœื™ ื•ื•ื™ ืžืขืจ ืกืขืจื•ื•ืขืจืก ื–ืขื ืขืŸ ืžื•ืกื™ืฃ. ืžืขืจื”ื™ื™ื˜ ื‘ืขืงืึทื‘ืึธืœืขื“ื™ืง ื“ืึทื˜ืึทื‘ื™ื™ืก ืกื™ืกื˜ืขืžืขืŸ ื˜ืึธืŸ ื ื™ื˜ ื•ื•ืึธื’ ื’ืขื–ื•ื ื˜ ืึธื“ืขืจ ื˜ืึธืŸ ื ื™ื˜ ื•ื•ืึธื’ ืื™ืŸ ืึทืœืข. ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, MySQL ืงืขื ืขืŸ ื•ื•ืึธื’ ืื•ื™ืก ืคึฟืึทืจ ืœื™ื™ืขื ืขืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ื“ื•ืจืš ืึทื“ื™ื ื’ ืฉืงืœืึทืฃ ืœื™ื™ืขื ืขืจ, ืึธื‘ืขืจ ืงืขื ืขืŸ ื ื™ืฉื˜ ื•ื•ืึธื’ ืื•ื™ืก ืคึฟืึทืจ ืฉืจื™ื™ึทื‘ืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื–.

ืื•ื™ืฃ ื“ื™ ืื ื“ืขืจืข ื”ืึทื ื˜, ืจืขื›ื˜ ืฆื• ื–ื™ื™ืŸ ื ืึทื˜ื•ืจ, ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืงืขื ืขืŸ ืœื™ื™ื›ื˜ ื•ื•ืึธื’ ื›ืึธืจื™ื–ืึทื ื˜ืึทืœื™ ืžื™ื˜ ืžื™ื ื™ืžืึทืœ ื™ื ื˜ืขืจื•ื•ืขื ื˜ื™ืึธืŸ.

ื’ืึทื ืฅ ืคื™ื˜ืฉืขืจื“ DBMS ื•ื•ื™ ืึท ื“ื™ื ืกื˜ ืžื•ื–ืŸ ื–ื™ื™ืŸ ืขื•ื•ืึทืœื•ืึทื˜ืขื“ ืคื•ืŸ ืคืึทืจืฉื™ื“ืขื ืข ืคึผืขืจืกืคึผืขืงื˜ื™ื•ื•ื–. ื•ื•ื™ ืึท ื™ืงืขืจ, ืžื™ืจ ื’ืขื ื•ืžืขืŸ ื“ื™ ืžืขืจืกื˜ ืคืึธืœืงืก ื“ื‘ืžืก ืื™ืŸ ื“ื™ ื•ื•ืึธืœืงืŸ - ืคึฟืึทืจ Google, GCP Cloud SQL ืื•ืŸ ืคึฟืึทืจ Amazon, AWS RDS. ืื™ืŸ ืื•ื ื“ื–ืขืจ ืึธืคึผืฉืึทืฆื•ื ื’, ืžื™ืจ ืคืึธื•ืงื™ืกื˜ ืื•ื™ืฃ ื“ื™ ืคืืœื’ืขื ื“ืข ืงืึทื˜ืขื’ืึธืจื™ืขืก:

  • ืฉื˜ืจื™ืš ืžืึทืคึผื™ื ื’: ืกืงืœ ืžืึธืก, ื“ื“ืœ, ื“ืžืœ; ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืœื™ื™ื‘ืจืขืจื™ื– / ืงืึทื ืขืงื˜ืขืจื–, ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืฉื˜ื™ืฆืŸ, ืื•ืŸ ืึทื–ื•ื™ ืื•ื™ืฃ.
  • ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืฉื˜ื™ืฆืŸ: ื™ื– ืคื•ืŸ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืื•ืŸ ื˜ืขืกื˜ื™ื ื’.
  • ืึทื“ืžื™ื ื™ืกื˜ืจืึทืฆื™ืข ืกื•ืคึผืคึผืึธืจื˜: ื™ื ืกื˜ืึทื ืกืข ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’ ืึทื–ืึท ื•ื•ื™ ืกืงื™ื™ืœื™ื ื’ ืึทืจื•ื™ืฃ / ืึทืจืึธืคึผ ืื•ืŸ ืึทืคึผื’ืจื™ื™ื“ื™ื ื’ ื™ื ืกื˜ืึทื ืกื™ื–; SLA, ื‘ืึทืงืึทืคึผ ืื•ืŸ ืึธืคึผื–ื•ืš; ื–ื™ื›ืขืจื”ื™ื™ึทื˜ / โ€‹โ€‹ืฆื•ื˜ืจื™ื˜ ืงืึธื ื˜ืจืึธืœ.

ื ื™ืฆืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื•ื•ื™ ืึทืŸ OLAP-Enabled OLTP ืœื™ื™ื–ื•ื ื’

ื›ืึธื˜ืฉ Google ืงืขืŸ ื ื™ืฉื˜ ื‘ืคื™ืจื•ืฉ ื–ืึธื’ืŸ ืึทื– ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื™ื– ืคึฟืึทืจ ืึทื ืึทืœื™ื˜ื™ืงืก, ืขืก ื™ื™ึทื ื˜ื™ื™ืœืŸ ืขื˜ืœืขื›ืข ืึทื˜ืจื™ื‘ื™ื•ืฅ ืžื™ื˜ ืื ื“ืขืจืข ืขื ื“ื–ืฉืึทื ื– ืึทื–ืึท ื•ื•ื™ Apache Impala & Kudu ืื•ืŸ YugaByte ื•ื•ืึธืก ื–ืขื ืขืŸ ื“ื™ื–ื™ื™ื ื“ ืคึฟืึทืจ OLAP ื•ื•ืขืจืงืœืึธื•ื“ื–.

ืืคื™ืœื• ืื•ื™ื‘ ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ ื‘ืœื•ื™ื– ืึท ืงืœื™ื™ืŸ ื’ืขืœืขื’ื ื”ื™ื™ึทื˜ ืึทื– ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื™ื ืงืœื•ื“ืขื“ ืึท ืงืึธื ืกื™ืกื˜ืขื ื˜ ื•ื•ืึธื’-ืื•ื™ืก HTAP (Hybrid Transactional / Analytic Processing) ืžืึธื˜ืึธืจ ืžื™ื˜ ืึท (ืžืขืจ ืึธื“ืขืจ ื•ื•ื™ื™ื ื™ืงืขืจ) ื ื™ืฆืœืขืš OLAP ืฉื˜ืจื™ืš ืฉื˜ืขืœืŸ, ืžื™ืจ ื˜ืจืึทื›ื˜ืŸ ืขืก ื•ื•ืึธืœื˜ ืคืึทืจื“ื™ื ืขืŸ ืื•ื ื“ื–ืขืจ ื•ืคืžืขืจืงื–ืึทืžืงื™ื™ื˜.

ืžื™ื˜ ื“ืขื ืื™ืŸ ื–ื™ื ืขืŸ, ืžื™ืจ ื’ืขืงื•ืงื˜ ืื™ืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ืงืึทื˜ืขื’ืึธืจื™ืขืก:

  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ืึทื˜ืŸ ืœืึธื•ื“ื™ื ื’, ื™ื ื“ืขืงืกื™ื– ืื•ืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’
  • ืึธื ืคึฟืจืขื’ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืื•ืŸ DML

2. ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื™ืŸ ืึท ื ืึทื˜ืฉืขืœ

Google Spanner ืื™ื– ืึท ืงืœืึทืกื˜ืขืจื“ ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืก ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’ ืกื™ืกื˜ืขื (RDBMS) ื•ื•ืึธืก Google ื ื™ืฆื˜ ืคึฟืึทืจ ืขื˜ืœืขื›ืข ืคื•ืŸ โ€‹โ€‹ื–ื™ื™ืŸ ืื™ื™ื’ืขื ืข ื‘ืึทื“ื™ื ื•ื ื’ืก. Google ื’ืขืžืื›ื˜ ืขืก ืขืคื ื˜ืœืขืš ื‘ื ื™ืžืฆื ืฆื• Google ืงืœืึธื•ื“ ืคึผืœืึทื˜ืคืึธืจื ื™ื•ื–ืขืจื– ืื™ืŸ ืคืจื™ 2017.

ื“ืึธ ื–ืขื ืขืŸ ืขื˜ืœืขื›ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื“ื™ Cloud Spanner ืึทื˜ืจื™ื‘ื™ื•ืฅ:

  • ื”ืขื›ืกื˜ ืงืึธื ืกื™ืกื˜ืขื ื˜, ืกืงืึทืœืึทื‘ืœืข RDBMS ืงืœืึทืกื˜ืขืจ: ื ื™ืฆื˜ ื™ื™ึทื–ื ื•ื•ืึทืจื’ ืฆื™ื™ื˜ ืกื™ื ื’ืงืจืึทื ืึทื–ื™ื™ืฉืึทืŸ ืฆื• ืขื ืฉื•ืจ ื“ืึทื˜ืŸ ืงืึธื ืกื™ืกื˜ืขื ืกื™.
  • ืงืจื™ื™ึทื–-ื˜ื™ืฉ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืฉื˜ื™ืฆืŸ: ื˜ืจืึทื ืกืึทืงื˜ื™ืึธื ืก ืงืขื ืขืŸ ืฉืคึผืึทืŸ ืงื™ื™ืคืœ ื˜ื™ืฉืŸ - ื ื™ื˜ ื“ืึทื•ื•ืงืข ืœื™ืžื™ื˜ืขื“ ืฆื• ืึท ืื™ื™ืŸ ื˜ื™ืฉ (ื ื™ื˜ ืขื ืœืขืš Apache HBase ืึธื“ืขืจ Apache Kudu).
  • ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ-ื‘ืื–ื™ืจื˜ ื˜ืึทื‘ืœืขืก: ืึทืœืข ื˜ื™ืฉืŸ ืžื•ื–ืŸ ื”ืึธื‘ืŸ ืึท ื“ืขืจืงืœืขืจื˜ ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ (ืคึผื™ืกื™), ื•ื•ืึธืก ืงืขื ืขืŸ ืฆื•ื ื•ื™ืคืฉื˜ืขืœื  ื–ื™ืš ืคื•ืŸ ืงื™ื™ืคืœ ื˜ื™ืฉ ืฉืคืืœื˜ืŸ. ื˜ืึทื‘ื•ืœืึทืจ ื“ืึทื˜ืŸ ื–ืขื ืขืŸ ืกื˜ืึธืจื“ ืื™ืŸ ืคึผื™ืกื™ ืกื“ืจ, ื•ื•ืึธืก ืžืื›ื˜ ืขืก ื–ื™ื™ืขืจ ืขืคืขืงื˜ื™ื•ื• ืื•ืŸ ืฉื ืขืœ ืคึฟืึทืจ ืคึผื™ืกื™ ืึธื ืคึฟืจืขื’ืŸ. ื•ื•ื™ ืžื™ื˜ ืื ื“ืขืจืข ืคึผื™ืกื™-ื‘ืื–ื™ืจื˜ ืกื™ืกื˜ืขืžืขืŸ, ื“ื™ ื™ืžืคึผืœืึทืžืขื ื˜ื™ื™ืฉืึทืŸ ืžื•ื–ืŸ ื–ื™ื™ืŸ ืžืึธื“ืขืœืขื“ ืงืขื’ืŸ ืคึผืจื™ืงืึทื ืกื™ื•ื•ื“ ื ื•ืฆืŸ ืงืึทืกืขืก ืฆื• ื“ืขืจื’ืจื™ื™ื›ืŸ ื‘ืขืกื˜ืขืจ ืคืึธืจืฉื˜ืขืœื•ื ื’.
  • ืกื˜ืจื™ื™ืคึผื˜ ื˜ื™ืฉืŸ: ื˜ื™ืฉืŸ ืงืขื ืขืŸ ื”ืึธื‘ืŸ ื’ืฉืžื™ื•ืช ื“ื™ืคึผืขื ื“ืึทื ืกื™ื– ืื•ื™ืฃ ื™ืขื“ืขืจ ืื ื“ืขืจืขืจ. ื“ื™ ืจืึธื•ื– ืคื•ืŸ ื“ื™ ืงื™ื ื“ ื˜ื™ืฉ ืงืขื ืขืŸ ื–ื™ื™ืŸ ืžืึทื˜ืฉื˜ ืžื™ื˜ ื“ื™ ืจืึธื•ื– ืคื•ืŸ ื“ื™ ืคืึธื˜ืขืจ ื˜ื™ืฉ. ื“ืขืจ ืฆื•ื’ืึทื ื’ ืกืคึผื™ื“ื– ื“ื™ ื–ื•ื›ืŸ ืคึฟืึทืจ ื‘ืืฆื™ื•ื ื’ืขืŸ ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื‘ืืฉืœืืกืŸ ืื™ืŸ ื“ื™ ื“ืึทื˜ืŸ ืžืึธื“ืขืœื™ื ื’ ื‘ื™ื ืข, ืœืžืฉืœ, ื•ื•ืขืŸ ืคึผืœื™ื™ืกื™ื ื’ ืงืึทืกื˜ืึทืžืขืจื– ืื•ืŸ ื–ื™ื™ืขืจ ื™ื ื•ื•ื•ื™ืกื™ื– ืฆื•ื–ืึทืžืขืŸ.
  • ื™ื ื“ืขืงืกื™ื–: ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืฉื˜ื™ืฆื˜ ืฆื•ื•ื™ื™ื˜ื™ืง ื™ื ื“ืขืงืกื™ื–. ืึทืŸ ืื™ื ื“ืขืงืก ื‘ืืฉื˜ื™ื™ื˜ ืคื•ืŸ ื™ื ื“ืขืงืกื˜ ืฉืคืืœื˜ืŸ ืื•ืŸ ืึทืœืข ืคึผื™ืกื™ ืฉืคืืœื˜ืŸ. ืึธืคึผื˜ื™ืึธื ืึทืœืœื™, ื“ืขืจ ืื™ื ื“ืขืงืก ืงืขื ืขืŸ ืื•ื™ืš ืึทื ื˜ื”ืึทืœื˜ืŸ ืื ื“ืขืจืข ื ื™ื˜-ื™ื ื“ืขืงืกืขื“ ืฉืคืืœื˜ืŸ. ื“ืขืจ ืื™ื ื“ืขืงืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื™ื ื˜ืขืจืœืขืึทื•ื•ืขื“ ืžื™ื˜ ื“ื™ ืคืึธื˜ืขืจ ื˜ื™ืฉ ืฆื• ืคืึทืจื’ื™ื›ืขืจืŸ ืงื•ื•ื™ืจื™ื–. ืขื˜ืœืขื›ืข ืจื™ืกื˜ืจื™ืงืฉืึทื ื– ืึทืคึผืœื™ื™ื– ืฆื• ื™ื ื“ืขืงืกื™ื–, ืึทื–ืึท ื•ื•ื™ ื“ื™ ืžืึทืงืกื™ืžื•ื ื ื•ืžืขืจ ืคื•ืŸ ื ืึธืš ืฉืคืืœื˜ืŸ ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ืกื˜ืึธืจื“ ืื™ืŸ ืึทืŸ ืื™ื ื“ืขืงืก. ืื•ื™ืš, ืคึฟืจืื’ืŸ ื“ื•ืจืš ื™ื ื“ืขืงืกื™ื– ืงืขืŸ ื ื™ืฉื˜ ื–ื™ื™ืŸ ื•ื•ื™ ืกื˜ืจื™ื™ื˜ืคืึธืจื•ื•ืขืจื“ ื•ื•ื™ ืื™ืŸ ืื ื“ืขืจืข RDBMSs.

"Cloud Spanner ืกืึทืœืขืงืฅ ืึทืŸ ืื™ื ื“ืขืงืก ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ื‘ืœื•ื™ื– ืื™ืŸ ื–ืขืœื˜ืŸ ืงืึทืกืขืก. ืื™ืŸ ื‘ืึทื–ื•ื ื“ืขืจ, ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื•ื•ืขื˜ ื ื™ืฉื˜ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ืึท ืฆื•ื•ื™ื™ื˜ื™ืง ืื™ื ื“ืขืงืก ืื•ื™ื‘ ื“ื™ ืึธื ืคึฟืจืขื’ ืจื™ืงื•ื•ืขืก ืงื™ื™ืŸ ืฉืคืืœื˜ืŸ ื•ื•ืึธืก ื–ืขื ืขืŸ ื ื™ืฉื˜ ืกื˜ืึธืจื“ ืื™ืŸ ืื™ื ื“ืขืงืก '.

  • ืกืขืจื•ื•ื™ืก ืœืขื•ื•ืขืœ ื”ืขืกืงืขื (ืกืœืึท): ื“ื™ืคึผืœื•ื™ืžืึทื ื˜ ืคื•ืŸ ืื™ื™ืŸ ื’ืขื’ื ื˜ ืžื™ื˜ 99,99% ืกืœืึท; ืžื•ืœื˜ื™-ื’ืขื’ื ื˜ ื“ื™ืคึผืœื•ื™ืžืึทื ืฅ ืžื™ื˜ 99,999% SLA. ื›ืึธื˜ืฉ ื“ื™ SLA ื–ื™ืš ืื™ื– ื ืึธืจ ืึท ื”ืขืกืงืขื ืื•ืŸ ื ื™ืฉื˜ ืึท ื’ืึทืจืึทื ื˜ื™ืจืŸ ืคื•ืŸ ืงื™ื™ืŸ ืžื™ืŸ, ืื™ืš ื’ืœื•ื™ื‘ืŸ ืึทื– Google ืžืขื ื˜ืฉืŸ ื”ืึธื‘ืŸ ืขื˜ืœืขื›ืข ืฉื•ื•ืขืจ ื“ืึทื˜ืŸ ืฆื• ืžืึทื›ืŸ ืึทื–ืึท ืึท ืฉื˜ืึทืจืง ืคืึธื“ืขืจืŸ. (ืคึฟืึทืจ ื“ืขืจืžืึธื ืขืŸ, 99,999% ืžื™ื˜ืœ 26,3 ืกืขืงื•ื ื“ืขืก ืคื•ืŸ ื“ื™ื ืกื˜ ื“ืึทื•ื ื˜ื™ื™ื ืคึผืขืจ ื—ื•ื“ืฉ.)
  • ืžืขืจ: https://cloud.google.com/spanner/

ื‘ืึทืžืขืจืงื•ื ื’: ื“ื™ Apache Tephra ืคึผืจื•ื™ืขืงื˜ ืžื•ืกื™ืฃ ืึทื•ื•ืึทื ืกื™ืจื˜ืข ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืฉื˜ื™ืฆืŸ ืฆื• Apache HBase (ืื•ื™ืš ืื™ืฆื˜ ื™ืžืคึผืœืึทืžืขื ืึทื“ ืื™ืŸ Apache Phoenix ื•ื•ื™ ืึท ื‘ื™ืชื).

3. ืื•ื ื“ื–ืขืจ ืึทืกืขืกืžืึทื ื˜

ืึทื–ื•ื™, ืžื™ืจ ื”ืึธื‘ืŸ ืึทืœืข ืœื™ื™ืขื ืขืŸ ื“ื™ ืกื˜ื™ื™ื˜ืžืึทื ืฅ ืคื•ืŸ Google ื•ื•ืขื’ืŸ ื“ื™ ื‘ืขื ืขืคื™ืฅ ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ - ื›ืžืขื˜ ืึทื ืœื™ืžืึทื˜ืึทื“ ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืกืงื™ื™ืœื™ื ื’ ื‘ืฉืขืช ื–ื™ื™ ื”ืึทืœื˜ืŸ ื”ื•ื™ืš ืงืึธื ืกื™ืกื˜ืขื ืกื™ ืื•ืŸ ืึท ื–ื™ื™ืขืจ ื”ื•ื™ืš SLA. ื›ืึธื˜ืฉ ื“ื™ ืงืœื™ื™ืžื– ื–ืขื ืขืŸ, ืื™ืŸ ืงื™ื™ืŸ ืคืึทืœ, ื’ืึธืจ ืฉื•ื•ืขืจ ืฆื• ื“ืขืจื’ืจื™ื™ื›ืŸ, ืื•ื ื“ื–ืขืจ ืฆื™ืœ ืื™ื– ื ื™ืฉื˜ ืฆื• ืึธืคึผื–ืึธื’ืŸ ื–ื™ื™. ืึทื ืฉื˜ืึธื˜, ืœืึธืžื™ืจ ืคืึธืงื•ืก ืื•ื™ืฃ ืื ื“ืขืจืข ื˜ื™ื ื’ื– ื•ื•ืึธืก ืจื•ื‘ึฟ ื“ืึทื˜ืึทื‘ื™ื™ืก ื™ื•ื–ืขืจื– ื–ืึธืจื’ืŸ ื•ื•ืขื’ืŸ: ืคึผืึทืจื™ื˜ืขื˜ ืื•ืŸ ื•ืกืึทื‘ื™ืœื™ื˜ื™.

ืžื™ืจ ืจื™ื™ื˜ืึทื“ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื•ื•ื™ ืึท ืคืึทืจื‘ื™ื™ึทื˜ ืคึฟืึทืจ Sharded MySQL

Google Cloud SQL ืื•ืŸ Amazon AWS RDS, ืฆื•ื•ื™ื™ ืคื•ืŸ ื“ื™ ืžืขืจืกื˜ ืคืึธืœืงืก OLTP ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืื™ืŸ ื“ื™ ื•ื•ืึธืœืงืŸ ืžืึทืจืง, ื”ืึธื‘ืŸ ืึท ื–ื™ื™ืขืจ ื’ืจื•ื™ืก ืฉื˜ืจื™ืš ืฉื˜ืขืœืŸ. ืึธื‘ืขืจ, ืื™ืŸ ืกื“ืจ ืฆื• ื•ื•ืึธื’ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ื•ื•ื™ื™ึทื˜ืขืจ ืคื•ืŸ ื“ื™ ื’ืจื™ื™ืก ืคื•ืŸ ืึท ืื™ื™ืŸ ื ืึธื“ืข, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื“ื•ืจื›ืคื™ืจืŸ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ืกืคึผืœื™ื˜ื™ื ื’. ื“ืขืจ ืฆื•ื’ืึทื ื’ ืงืจื™ื™ื™ืฅ ื ืึธืš ืงืึทืžืคึผืœืขืงืกื™ื˜ื™ ืคึฟืึทืจ ื‘ื™ื™ื“ืข ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ืื•ืŸ ืึทื“ืžื™ื ื™ืกื˜ืจืึทืฆื™ืข. ืžื™ืจ ื”ืึธื‘ืŸ ื’ืขืงื•ืงื˜ ื•ื•ื™ ืกืคึผืึทื ืขืจ ืคื™ืฅ ืื™ืŸ ื“ื™ ืกืฆืขื ืึทืจ ืคื•ืŸ ืงืึทืžื‘ื™ื™ื ื™ื ื’ ืงื™ื™ืคืœ ืฉืึทืจื“ื– ืื™ืŸ ืื™ื™ืŸ ื‘ื™ื™ึทืฉืคึผื™ืœ ืื•ืŸ ื•ื•ืึธืก ืคึฟืขื™ึดืงื™ื™ื˜ืŸ (ืื•ื™ื‘ ืงื™ื™ืŸ) ืงืขืŸ ื–ื™ื™ืŸ ืžืงืจื™ื‘ ื’ืขื•ื•ืขืŸ.

ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ SQL, DML ืื•ืŸ DDL, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื“ื™ ืงืึทื ืขืงื˜ืขืจ ืื•ืŸ ืœื™ื™ื‘ืจืขืจื™ื–?

ืขืจืฉื˜ืขืจ, ื•ื•ืขืŸ ืื™ืจ ืึธื ื”ื™ื™ื‘ืŸ ืžื™ื˜ ืงื™ื™ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืฉืึทืคึฟืŸ ืึท ื“ืึทื˜ืŸ ืžืึธื“ืขืœ. ืื•ื™ื‘ ืื™ืจ ื˜ืจืึทื›ื˜ืŸ ืื™ืจ ืงืขื ืขืŸ ืคืึทืจื‘ื™ื ื“ืŸ JDBC Spanner ืฆื• ื“ื™ื™ืŸ ื‘ืึทืœื™ื‘ืกื˜ืข ืกืงืœ ื’ืขืฆื™ื™ึทื’, ืื™ืจ ื•ื•ืขื˜ ื’ืขืคึฟื™ื ืขืŸ ืึทื– ืื™ืจ ืงืขื ืขืŸ ืึธื ืคืจืขื’ ื“ื™ื™ืŸ ื“ืึทื˜ืŸ ืžื™ื˜ ืขืก, ืึธื‘ืขืจ ืื™ืจ ืงืขื ืขืŸ ื ื™ืฉื˜ ื ื•ืฆืŸ ืขืก ืฆื• ืฉืึทืคึฟืŸ ืึท ื˜ื™ืฉ ืึธื“ืขืจ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ (DDL) ืึธื“ืขืจ ืงื™ื™ืŸ ืึทืจื™ื™ึทื ืœื™ื™ื’ืŸ / ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ / ื•ื™ืกืžืขืงืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื– (ื“ืžืœ). Google ืก ื‘ืึทืึทืžื˜ืขืจ JDBC ืฉื˜ื™ืฆื˜ ืื•ื™ืš ื ื™ืฉื˜.

"ื“ืจื™ื•ื•ืขืจืก ืฉื˜ื™ืฆืŸ ืื™ืฆื˜ ื ื™ืฉื˜ DML ืึธื“ืขืจ DDL ืกื˜ื™ื™ื˜ืžืึทื ืฅ."
ืกืคึผืึทื ืขืจ ื“ืึธืงื•ืžืขื ื˜ืึทื˜ื™ืึธืŸ

ื“ื™ ืกื™ื˜ื•ืึทืฆื™ืข ืื™ื– ื ื™ื˜ ื‘ืขืกืขืจ ืžื™ื˜ ื“ื™ GCP ืงืึทื ืกืึธื•ืœ - ืื™ืจ ืงืขื ืขืŸ ื‘ืœื•ื™ื– ืฉื™ืงืŸ ืกืขืœืขืงื˜ ืงื•ื•ื™ืจื™ื–. ืฆื•ืž ื’ืœื™ืง ืขืก ืื™ื– ืึท JDBC ืฉืึธืคืขืจ ืžื™ื˜ DML ืื•ืŸ DDL ืฉื˜ื™ืฆืŸ ืคื•ืŸ ื“ื™ ืงื”ืœ ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– github.com/olavloite/spanner-jdbc. ื›ืึธื˜ืฉ ื“ืขืจ ืฉืึธืคืขืจ ืื™ื– ื’ืึธืจ ื ื•ืฆื™ืง, ื“ืขืจ ืึทื•ื•ืขืง ืคื•ืŸ Google ืก ืื™ื™ื’ืขื ืข JDBC ืฉืึธืคืขืจ ืื™ื– ื—ื™ื“ื•ืฉ. ืฆื•ืž ื’ืœื™ืง, Google ืึธืคืคืขืจืก ืคืขืจืœื™ ื‘ืจื™ื™ื˜ ืงืœื™ืขื ื˜ ื‘ื™ื‘ืœื™ืึธื˜ืขืง ืฉื˜ื™ืฆืŸ (ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ gRPC): C #, Go, Java, node.js, PHP, Python ืื•ืŸ Ruby.

ื“ื™ ื›ึผืžืขื˜ ืžืึทื ื“ืึทื˜ืึธืจื™ ื ื•ืฆืŸ ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืก ืžื ื”ื’ ืึทืคึผื™ืก (ืฆื•ืœื™ื‘ ื“ื™ ืคืขืœืŸ ืคื•ืŸ DDL ืื•ืŸ DML ืื™ืŸ JDBC) ืจืขื–ื•ืœื˜ืื˜ืŸ ืขื˜ืœืขื›ืข ืœื™ืžื™ื˜ื™ื™ืฉืึทื ื– ืคึฟืึทืจ ืคึฟืึทืจื‘ื•ื ื“ืขื ืข ืงืึธื“ ื’ืขื‘ื™ื˜ืŸ ืึทื–ืึท ื•ื•ื™ ืงืึทื ืขืงืฉืึทืŸ ืคึผื•ืœื™ื ื’ ืึธื“ืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก ื‘ื™ื™ื ื“ื™ื ื’ ืคืจืึทืžืขื•ื•ืึธืจืงืก (ื•ื•ื™ Spring MVC). ืื™ืŸ ืึทืœื’ืขืžื™ื™ืŸ, ื•ื•ืขืŸ ืื™ืจ ื ื•ืฆืŸ JDBC, ืื™ืจ ื–ืขื ื˜ ืคืจื™ื™ ืฆื• ืงืœื™ื™ึทื‘ืŸ ื“ื™ื™ืŸ ื‘ืึทืœื™ื‘ืกื˜ืข ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ื‘ืขืงืŸ (ืœืžืฉืœ HikariCP, DBCP, C3PO, ืืื–"ื• ื•) ื•ื•ืึธืก ืื™ื– ื˜ืขืกื˜ืขื“ ืื•ืŸ ืึทืจื‘ืขื˜ ื’ืขื–ื•ื ื˜. ืื™ืŸ ื“ืขื ืคืึทืœ ืคื•ืŸ ืžื ื”ื’ ืกืคึผืึทื ืขืจ ืึทืคึผื™ืก, ืžื™ืจ ื”ืึธื‘ืŸ ืฆื• ืคืึทืจืœืึธื–ื  ื–ื™ืš ืคืจืึทืžืขื•ื•ืึธืจืงืก / ื‘ื™ื™ื ื“ื™ื ื’ / ืกืขืกื™ืข ืคึผืึธืึธืœืก ื•ื•ืึธืก ืžื™ืจ ื”ืึธื‘ืŸ ื‘ืืฉืืคืŸ ื–ื™ืš.

ื“ื™ ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ (ืคึผื™ืกื™) ืึธืจื™ืขื ื˜ื™ื“ ืคึผืœืึทืŸ ืึทืœืึทื•ื– ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืฆื• ื–ื™ื™ืŸ ื–ื™ื™ืขืจ ืฉื ืขืœ ื•ื•ืขืŸ ืึทืงืกืขืกื™ื ื’ ื“ืึทื˜ืŸ ื“ื•ืจืš ื“ื™ ืคึผื™ืกื™, ืึธื‘ืขืจ ืื•ื™ืš ื™ื ื˜ืจืึทื“ื•ืกื™ื– ืขื˜ืœืขื›ืข ืึธื ืคึฟืจืขื’ ื™ืฉื•ื–.

  • ืื™ืจ ืงืขื ืขืŸ ื ื™ืฉื˜ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ื“ื™ ื•ื•ืขืจื˜ ืคื•ืŸ ืึท ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ; ืื™ืจ ืžื•ื–ืŸ ืขืจืฉื˜ืขืจ ื•ื™ืกืžืขืงืŸ ื“ื™ ืึธืจื™ื’ื™ื ืขืœ ืคึผื™ืกื™ ืคึผืึธื–ื™ืฆื™ืข ืื•ืŸ ืฉื™ื™ึทืขืš-ืึทืจื™ื™ึทื ืœื™ื™ื’ืŸ ืขืก ืžื™ื˜ ื“ื™ ื ื™ื™ึท ื•ื•ืขืจื˜. (ื“ืึธืก ืื™ื– ืขื ืœืขืš ืฆื• ืื ื“ืขืจืข ืคึผื™ืกื™ ืึธืจื™ืขื ื˜ื™ื“ ื“ืึทื˜ืึทื‘ื™ื™ืก / ืกื˜ืึธืจื™ื“ื–ืฉ ืขื ื“ื–ืฉืึทื ื–.)
  • ืงื™ื™ืŸ ื•ืคึผื“ืึทื˜ืข ืื•ืŸ ื•ื™ืกืžืขืงืŸ ืกื˜ื™ื™ื˜ืžืึทื ืฅ ืžื•ื–ืŸ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ืคึผื™ืกื™ ืื™ืŸ ื“ื™ WHERE, ื“ืขืจื™ื‘ืขืจ, ืขืก ืงืขืŸ ื ื™ืฉื˜ ื–ื™ื™ืŸ ืœื™ื™ื“ื™ืง ื•ื™ืกืžืขืงืŸ ืึทืœืข ืกื˜ื™ื™ื˜ืžืึทื ืฅ - ืขืก ืžื•ื–ืŸ ืฉื˜ืขื ื“ื™ืง ื–ื™ื™ืŸ ืึท ืกืึทื‘ืงื•ื•ืขืจื™, ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ: UPDATE xxx WHERE id ืื™ืŸ (SELECT id FROM table1)
  • ืคืขืœืŸ ืคื•ืŸ ืึทืŸ ืึทื•ื˜ืึธ ื™ื ืงืจืึทืžืึทื ื˜ ืึธืคึผืฆื™ืข ืึธื“ืขืจ ืขืคึผืขืก ืขื ืœืขืš ื•ื•ืึธืก ืฉื˜ืขืœื˜ ื“ื™ ืกื™ืงื•ื•ืึทื ืก ืคึฟืึทืจ ื“ื™ ืคึผื™ืกื™ ืคืขืœื“. ืคึฟืึทืจ ื“ืขื ืฆื• ืึทืจื‘ืขื˜ืŸ, ื“ื™ ืงืึธืจืึทืกืคึผืึทื ื“ื™ื ื’ ื•ื•ืขืจื˜ ืžื•ื–ืŸ ื–ื™ื™ืŸ ื‘ืืฉืืคืŸ ืื•ื™ืฃ ื“ื™ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ื–ื™ื™ึทื˜.

ืฆื•ื•ื™ื™ื˜ื™ืง ื™ื ื“ืขืงืกื™ื–?

Google Cloud Spanner ื”ืื˜ ืึท ื’ืขื‘ื•ื™ื˜-ืื™ืŸ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืฆื•ื•ื™ื™ื˜ื™ืง ื™ื ื“ืขืงืกื™ื–. ื“ืึธืก ืื™ื– ืึท ื–ื™ื™ืขืจ ืคื™ื™ึทืŸ ืฉื˜ืจื™ืš ื•ื•ืึธืก ืื™ื– ื ื™ื˜ ืฉื˜ืขื ื“ื™ืง ืคืึธืจืฉื˜ืขืœืŸ ืื™ืŸ ืื ื“ืขืจืข ื˜ืขืงื ืึทืœืึทื“ื–ืฉื™ื–. Apache Kudu ืฉื˜ื™ืฆื˜ ื“ืขืจื•ื•ื™ื™ึทืœ ื ื™ืฉื˜ ืฆื•ื•ื™ื™ื˜ื™ืง ื™ื ื“ืขืงืกื™ื–, ืื•ืŸ Apache HBase ืฉื˜ื™ืฆื˜ ื ื™ืฉื˜ ื’ืœื™ื™ึทืš ื™ื ื“ืขืงืกื™ื–, ืึธื‘ืขืจ ืงืขื ืขืŸ ืœื™ื™ื’ืŸ ื–ื™ื™ ื“ื•ืจืš Apache Phoenix.

ื™ื ื“ืขืงืกื™ื– ืื™ืŸ Kudu ืื•ืŸ HBase ืงืขื ืขืŸ ื–ื™ื™ืŸ ืžืึธื“ืขืœืขื“ ื•ื•ื™ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ื˜ื™ืฉ ืžื™ื˜ ืึท ืึทื ื“ืขืจืฉ ื–ืึทืฅ ืคื•ืŸ ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœืขืŸ, ืึธื‘ืขืจ ื“ื™ ืึทื˜ืึธืžื™ืฉื™ื˜ื™ ืคื•ืŸ ื“ื™ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ื“ื•ืจื›ื’ืขืงืึธื›ื˜ ืื•ื™ืฃ ื“ื™ ืคืึธื˜ืขืจ ื˜ื™ืฉ ืื•ืŸ ืคึฟืึทืจื‘ื•ื ื“ืขื ืข ืื™ื ื“ืขืงืก ื˜ื™ืฉืŸ ืžื•ื–ืŸ ื–ื™ื™ืŸ ื“ื•ืจื›ื’ืขืงืึธื›ื˜ ืื•ื™ืฃ ื“ื™ ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ืžื“ืจื’ื” ืื•ืŸ ืื™ื– ื ื™ืฉื˜ ื˜ืจื™ื•ื•ื™ืึทืœ ืฆื• ื™ื ืกื˜ืจื•ืžืขื ื˜ ืจื™ื›ื˜ื™ืง.

ื•ื•ื™ ื“ืขืจืžืื ื˜ ืื™ืŸ ื“ื™ Cloud Spanner ืจืขืฆืขื ื–ื™ืข, ื“ื™ ื™ื ื“ืขืงืกื™ื– ืงืขืŸ ื–ื™ื™ืŸ ืึทื ื“ืขืจืฉ ืคื•ืŸ MySQL ื™ื ื“ืขืงืกื™ื–. ืื–ื•ื™, ืกืคึผืขืฆื™ืขืœ ื–ืึธืจื’ ืžื•ื–ืŸ ื–ื™ื™ืŸ ื’ืขื ื•ืžืขืŸ ืื™ืŸ ืึธื ืคึฟืจืขื’ ื‘ื ื™ืŸ ืื•ืŸ ืคึผืจืึธืคื™ืœื™ื ื’ ืฆื• ืขื ืฉื•ืจ ืึทื– ื“ื™ ืจื™ื›ื˜ื™ืง ืื™ื ื“ืขืงืก ืื™ื– ื’ืขื ื™ืฆื˜ ื•ื•ื• ืขืก ืื™ื– ื“ืืจืฃ.

ืคืึทืจื˜ืจืขื˜ื•ื ื’?

ื ื–ื™ื™ืขืจ ืคืึธืœืงืก ืื•ืŸ ื ื•ืฆื™ืง ื›ื™ื™ืคืขืฅ ืื™ืŸ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ื– ืงื•ืงืŸ. ื–ื™ื™ ืงืขื ืขืŸ ื–ื™ื™ืŸ ื ื•ืฆื™ืง ืคึฟืึทืจ ืึท ื’ืจื•ื™ืก ื ื•ืžืขืจ ืคื•ืŸ ื ื•ืฆืŸ ืงืึทืกืขืก; ืžื™ื™ืŸ ืฆื•ื•ื™ื™ ืคืึทื•ื•ืึธืจื™ื˜ืขืก ื–ืขื ืขืŸ ื“ื™ ืœืึทื“ื–ืฉื™ืงืึทืœ ืึทื‘ืกื˜ืจืึทืงืฆื™ืข ืฉื™ื›ื˜ืข ืื•ืŸ ื“ื™ ื–ื™ื›ืขืจื”ื™ื™ื˜ ืฉื™ื›ื˜ืข. ืฆื•ื ื‘ืึทื“ื•ื™ืขืจืŸ, ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืฉื˜ื™ืฆื˜ ื ื™ืฉื˜ ืงื•ืงืŸ. ืึธื‘ืขืจ, ื“ืึธืก ื‘ืœื•ื™ื– ื˜ื™ื™ืœ ืœื™ืžืึทืฅ ืื•ื ื“ื–, ื•ื•ื™ื™ึทืœ ืขืก ืื™ื– ืงื™ื™ืŸ ื–ื™ื™ึทืœ-ืžื“ืจื’ื” ื’ืจืึทื ื•ืœืึทืจื™ื˜ื™ ืคึฟืึทืจ ืึทืงืกืขืก ืคึผืขืจืžื™ืฉืึทื ื– ื•ื•ื• ืงื•ืงืŸ ืงืขื ืขืŸ ื–ื™ื™ืŸ ืึท ืคึผืึทืกื™ืง ืœื™ื™ื–ื•ื ื’.

ื–ืขืŸ ื“ื™ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื“ืึทืงื™ื•ืžืขื ื˜ื™ื™ืฉืึทืŸ ืคึฟืึทืจ ืึท ืึธืคึผื˜ื™ื™ืœื•ื ื’ ืžื™ื˜ ื“ื™ื˜ื™ื™ืœื“ ืงื•ื•ืึธื˜ืขืก ืื•ืŸ ืœื™ืžืึทืฅ (ืกืคึผืึทื ืขืจ / ืงื•ื•ืึธื˜ืึทืก), ืขืก ืื™ื– ืื™ื™ื ืขืจ ืื™ืŸ ื‘ืึทื–ื•ื ื“ืขืจ ื•ื•ืึธืก ืงืขืŸ ื–ื™ื™ืŸ ืคึผืจืึธื‘ืœืขืžืึทื˜ื™ืง ืคึฟืึทืจ ืขื˜ืœืขื›ืข ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื–: ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื•ื™ืก ืคื•ืŸ ื“ื™ ืงืขืกื˜ืœ ื”ืื˜ ืึท ืžืึทืงืกื™ืžื•ื ืคื•ืŸ 100 ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืคึผืขืจ ื‘ื™ื™ึทืฉืคึผื™ืœ. ื“ืึธืš, ื“ืึธืก ืงืขืŸ ื–ื™ื™ืŸ ืึท ื”ื•ื™ืคึผื˜ ื‘ืึทื˜ืึทืœื ืขืง ืคึฟืึทืจ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ื•ื•ืึธืก ืื™ื– ื“ื™ื–ื™ื™ื ื“ ืฆื• ื•ื•ืึธื’ ืฆื• ืื™ื‘ืขืจ 100 ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืฆื•ืž ื’ืœื™ืง, ื ืึธืš ื’ืขืจืขื“ื˜ ืžื™ื˜ ืื•ื ื“ื–ืขืจ Google ื˜ืขื›ื ื™ืฉ ืคืืจืฉื˜ื™ื™ืขืจ, ืžื™ืจ ื’ืขืคึฟื•ื ืขืŸ ืึทื– ื“ืขื ืฉื™ืขื•ืจ ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขื•ื•ืืงืกืŸ ืฆื• ื›ึผืžืขื˜ ืงื™ื™ืŸ ื•ื•ืขืจื˜ ื“ื•ืจืš Google ืฉื˜ื™ืฆืŸ.

ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืฉื˜ื™ืฆืŸ?

ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืึธืคืคืขืจืก ืฉื™ื™ืŸ ืœื™ื™ึทื˜ื™ืฉ ืคึผืจืึธื’ืจืึทืžืžื™ื ื’ ืฉืคึผืจืึทืš ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืืจื‘ืขื˜ืŸ ืžื™ื˜ ื–ื™ื™ึทืŸ ืึทืคึผื™. ื“ื™ ืึทืคื™ืฉืึทืœื™ ื’ืขืฉื˜ื™ืฆื˜ ืœื™ื™ื‘ืจืขืจื™ื– ื–ืขื ืขืŸ ืื™ืŸ ื“ื™ ื’ืขื’ื ื˜ ืคื•ืŸ C #, Go, Java, node.js, PHP, Python ืื•ืŸ Ruby. ื“ื™ ื“ืึทืงื™ื•ืžืขื ื˜ื™ื™ืฉืึทืŸ ืื™ื– ืคืขืจืœื™ ื“ื™ื˜ื™ื™ืœื“, ืึธื‘ืขืจ ื•ื•ื™ ืžื™ื˜ ืื ื“ืขืจืข ืงืึทื˜ื™ื ื’-ื‘ืจืขื’ ื˜ืขืงื ืึทืœืึทื“ื–ืฉื™ื–, ื“ื™ ืงื”ืœ ืื™ื– ื’ืึทื ืฅ ืงืœื™ื™ืŸ ืงืึทืžืคึผืขืจื“ ืžื™ื˜ ืจื•ื‘ึฟ ืคืึธืœืงืก ื“ืึทื˜ืึทื‘ื™ื™ืก ื˜ืขืงื ืึทืœืึทื“ื–ืฉื™ื–, ื•ื•ืึธืก ืงืขื ืขืŸ ืจืขื–ื•ืœื˜ืึทื˜ ืื™ืŸ ืžืขืจ ืฆื™ื™ื˜ ืคืืจื‘ืจืื›ื˜ ืื•ื™ืฃ ื•ื•ื™ื™ื ื™ืงืขืจ ืคึผืจืึธืกื˜ ื ื•ืฆืŸ ืงืึทืกืขืก ืึธื“ืขืจ ืคึผืจืึธื‘ืœืขืžืก.

ืึทื–ื•ื™ ื•ื•ืึธืก ื•ื•ืขื’ืŸ ื”ื™ื’ืข ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืฉื˜ื™ืฆืŸ?

ืžื™ืจ ื”ืึธื‘ืŸ ื ื™ื˜ ื’ืขืคึฟื•ื ืขืŸ ืึท ื•ื•ืขื’ ืฆื• ืฉืึทืคึฟืŸ ืึท ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื‘ื™ื™ึทืฉืคึผื™ืœ ืื™ืŸ ืœืึธืงืึทืœ. ื“ื™ ืงืœืึธื•ืกืึทืกื˜ ืžื™ืจ ื’ืึทื˜ ืื™ื– ืึท ื“ืึธืงืงืขืจ ื‘ื™ืœื“ ื˜ืึทืจืึทืงืึทืŸื•ื•ืึธืก ืื™ื– ืขื ืœืขืš ืื™ืŸ ืคึผืจื™ื ืฆื™ืคึผ, ืึธื‘ืขืจ ื–ื™ื™ืขืจ ืึทื ื“ืขืจืฉ ืื™ืŸ ืคื™ืจ. ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, CockroachDB ืงืขื ืขืŸ ื ื•ืฆืŸ PostgreSQL JDBC. ื–ื™ื ื˜ ื“ื™ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืกื•ื•ื™ื•ื•ืข ื–ืึธืœ ื–ื™ื™ืŸ ื•ื•ื™ ื ืึธืขื ื˜ ื•ื•ื™ ืžืขื’ืœืขืš ืฆื• ื“ื™ ืคึผืจืึธื“ื•ืงืฆื™ืข ืกื•ื•ื™ื•ื•ืข, Cloud Spanner ืื™ื– ื ื™ืฉื˜ ื™ื“ืขืึทืœ ื•ื•ื™ื™ึทืœ ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืคืึทืจืœืึธื–ื  ืื•ื™ืฃ ืึท ืคื•ืœ ืกืคึผืึทื ืขืจ ื‘ื™ื™ึทืฉืคึผื™ืœ. ืฆื• ืฉืคึผืึธืจืŸ ืงืึธืก, ืื™ืจ ืงืขื ืขืŸ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ืึท ืื™ื™ืŸ ื’ืขื’ื ื˜ ื‘ื™ื™ึทืฉืคึผื™ืœ.

ืึทื“ืžื™ื ื™ืกื˜ืจืึทืฆื™ืข ืฉื˜ื™ืฆืŸ?

ืฉืืคืŸ ืึท ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื‘ื™ื™ึทืฉืคึผื™ืœ ืื™ื– ื–ื™ื™ืขืจ ืคึผืฉื•ื˜. ืื™ืจ ื ืึธืจ ื“ืึทืจืคึฟืŸ ืฆื• ืงืœื™ื™ึทื‘ืŸ ืฆื•ื•ื™ืฉืŸ ืงืจื™ื™ื™ื˜ื™ื ื’ ืึท ืžื•ืœื˜ื™-ื’ืขื’ื ื˜ ืึธื“ืขืจ ืึท ืื™ื™ืŸ-ื’ืขื’ื ื˜ ื‘ื™ื™ึทืฉืคึผื™ืœ, ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื’ืขื’ื ื˜ (s) ืื•ืŸ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื–. ืื™ืŸ ื•ื•ื™ื™ื ื™ืงืขืจ ื•ื•ื™ ืึท ืžื™ื ื•ื˜, ื“ื™ ื‘ื™ื™ึทืฉืคึผื™ืœ ื•ื•ืขื˜ ื–ื™ื™ืŸ ืึทืจื•ื™ืฃ ืื•ืŸ ืคืœื™ืกื ื“ื™ืง.

ืขื˜ืœืขื›ืข ืขืœืขืžืขื ื˜ืึทืจ ืžืขื˜ืจื™ืงืก ื–ืขื ืขืŸ ื’ืœื™ื™ืš ื‘ื ื™ืžืฆื ืื•ื™ืฃ ื“ื™ ืกืคึผืึทื ืขืจ ื‘ืœืึทื˜ ืื™ืŸ ื“ื™ Google ืงืึทื ืกืึธื•ืœ. ืžืขืจ ื“ื™ื˜ื™ื™ืœื“ ืงื•ืงืŸ ื–ืขื ืขืŸ ื‘ืืจืขื›ื˜ื™ื’ื˜ ื“ื•ืจืš Stackdriver, ื•ื•ื• ืื™ืจ ืงืขื ืขืŸ ืื•ื™ืš ืฉื˜ืขืœืŸ ืžืขื˜ืจื™ืง ืฉื•ื•ืขืœืŸ ืื•ืŸ ืคืœื™ื ืง ืคึผืึทืœืึทืกื™ื–.

ืึทืงืกืขืก ืฆื• ืจืขืกื•ืจืกืŸ?

MySQL ืึธืคืคืขืจืก ื‘ืจื™ื™ื˜ ืื•ืŸ ื–ื™ื™ืขืจ ื’ืจืึทื ื™ืึทืœืขืจ ื‘ืึทื ื™ืฆืขืจ ื“ืขืจืœื•ื™ื‘ืขื ื™ืฉ / ืจืึธืœืข ืกืขื˜ื˜ื™ื ื’ืก. ืื™ืจ ืงืขื ืขืŸ ืœื™ื™ื›ื˜ ืงืึทืกื˜ืึทืžื™ื™ื– ืึทืงืกืขืก ืฆื• ืึท ืกืคึผืขืฆื™ืคื™ืฉ ื˜ื™ืฉ, ืึธื“ืขืจ ืืคื™ืœื• ื‘ืœื•ื™ื– ืึท ืกืึทื‘ืกืขื˜ ืคื•ืŸ ื–ื™ื™ึทืŸ ืฉืคืืœื˜ืŸ. ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื ื™ืฆื˜ ื“ื™ Google ืื™ื“ืขื ื˜ื™ื˜ืขื˜ & ืึทืงืกืขืก ืžืึทื ืึทื’ืขืžืขื ื˜ (IAM) ื’ืขืฆื™ื™ึทื’, ื•ื•ืึธืก ื‘ืœื•ื™ื– ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืฉื˜ืขืœืŸ ืคึผืึทืœืึทืกื™ื– ืื•ืŸ ืคึผืขืจืžื™ืฉืึทื ื– ืื•ื™ืฃ ืึท ื–ื™ื™ืขืจ ื”ื•ื™ืš ืžื“ืจื’ื”. ื“ื™ ืžืขืจืกื˜ ื’ืจืึทื ื™ืึทืœืขืจ ืึธืคึผืฆื™ืข ืื™ื– ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก-ืžื“ืจื’ื” ื“ืขืจืœื•ื™ื‘ืขื ื™ืฉ, ื•ื•ืึธืก ืงืขืŸ ื ื™ืฉื˜ ืคึผืึทืกื™ืง ืื™ืŸ ืจื•ื‘ึฟ ืคึผืจืึธื“ื•ืงืฆื™ืข ืงืึทืกืขืก. ื“ื™ ืจื™ืกื˜ืจื™ืงืฉืึทืŸ ืคืึธืจืกืขืก ืื™ืจ ืฆื• ืœื™ื™ื’ืŸ ื ืึธืš ื–ื™ื›ืขืจื”ื™ื™ื˜ ืžื™ื˜ืœืขืŸ ืฆื• ื“ื™ื™ืŸ ืงืึธื“, ื™ื ืคืจืึทืกื˜ืจืึทืงื˜ืฉืขืจ ืึธื“ืขืจ ื‘ื™ื™ื“ืข ืฆื• ืคืึทืจืžื™ื™ึทื“ืŸ ืึทื ืึธื˜ืขืจื™ื™ื–ื“ ื ื•ืฆืŸ ืคื•ืŸ ืกืคึผืึทื ืขืจ ืจืขืกื•ืจืกืŸ.

ื‘ืึทืงืงื•ืคึผืก?

ืคืฉื•ื˜, ืขืก ื–ืขื ืขืŸ ืงื™ื™ืŸ ื‘ืึทืงืึทืคึผืก ืื™ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ. ื›ืึธื˜ืฉ Google ืก ื”ื•ื™ืš SLA ืจืขืงื•ื•ื™ืจืขืžืขื ืฅ ืงืขื ืขืŸ ืขื ืฉื•ืจ ืื™ืจ ื˜ืึธืŸ ื ื™ื˜ ืคืึทืจืœื™ืจืŸ ืงื™ื™ืŸ ื“ืึทื˜ืŸ ืจืขื›ื˜ ืฆื• ื™ื™ึทื–ื ื•ื•ืึทืจื’ ืึธื“ืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก ืคื™ื™ืœื™ืขืจื–, ืžืขื ื˜ืฉ ื˜ืขื•ืช, ืึทืคึผืœืึทืงื™ื™ืฉืึทืŸ ื—ืกืจื•ื ื•ืช, ืืื–"ื• ื•. ืžื™ืจ ืึทืœืข ื•ื•ื™ืกืŸ ื“ื™ ื”ืขืจืฉืŸ: ื”ื•ื™ืš ืึทื•ื•ื™ื™ืœืึทื‘ื™ืœืึทื˜ื™ ืื™ื– ืงื™ื™ืŸ ืคืึทืจื˜ืจืขื˜ืขืจ ืคึฟืึทืจ ืึท ืงืœื•ื’ ื‘ืึทืงืึทืคึผ ืกื˜ืจืึทื˜ืขื’ื™ืข. ื“ืขืจื•ื•ื™ื™ึทืœ, ื“ืขืจ ื‘ืœื•ื™ื– ื•ื•ืขื’ ืฆื• ื‘ืึทืงืึทืคึผ ื“ืึทื˜ืŸ ืื™ื– ืฆื• ืคึผืจืึธื’ืจืึทืžืžืึทื˜ื™ืง ืกื˜ืจื™ืžื™ื ื’ ืขืก ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืฆื• ืึท ื‘ืึทื–ื•ื ื“ืขืจ ืกื˜ืึธืจื™ื“ื–ืฉ ืกื•ื•ื™ื•ื•ืข.

ืึธื ืคึฟืจืขื’ ืคืึธืจืฉื˜ืขืœื•ื ื’?

ืžื™ืจ ื’ืขื•ื•ื™ื™ื ื˜ Yahoo! ืฆื• ืœืึธื“ืŸ ื“ืึทื˜ืŸ ืื•ืŸ ืคึผืจื•ื‘ื™ืจืŸ ืคึฟืจืื’ืŸ. ื•ื•ืึธืœืงืŸ ืกืขืจื•ื•ื™ื ื’ ื‘ืขื ื˜ืฉืžืึทืจืง. ื“ื™ ื˜ื™ืฉ ืื•ื ื˜ืŸ ื•ื•ื™ื™ื–ื˜ ื“ื™ B YCSB ื•ื•ืขืจืงืœืึธื•ื“ ืžื™ื˜ ืึท 95% ืœื™ื™ืขื ืขืŸ ืฆื• 5% ืฉืจื™ื™ึทื‘ืŸ ืคืึทืจื”ืขืœื˜ืขื ื™ืฉ.

Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

* ื“ื™ ืžืึทืกืข ืคึผืจืึธื‘ืข ืื™ื– ื’ืขื•ื•ืขืŸ ืœื•ื™ืคืŸ ืื•ื™ืฃ n1-ืกื˜ืึทื ื“ืึทืจื“-32 ืงืึทืžืคึผื™ื•ื˜ืข ืขื ื’ื™ื ืข (CE) (32 ื•ื•ืงืคึผื•ืก, 120 ื’ื™ื’ืื‘ื™ื™ื˜ ื–ื›ึผืจื•ืŸ) ืื•ืŸ ื“ื™ ืคึผืจื•ื‘ื™ืจืŸ ื‘ื™ื™ึทืฉืคึผื™ืœ ืื™ื– ืงื™ื™ื ืžืึธืœ ื’ืขื•ื•ืขืŸ ื“ื™ ื‘ืึทื˜ืึทืœื ืขืง ืื™ืŸ ื“ื™ ื˜ืขืกืฅ.
** ื“ื™ ืžืึทืงืกื™ืžื•ื ื ื•ืžืขืจ ืคื•ืŸ ืคึฟืขื“ืขื ืื™ืŸ ืื™ื™ืŸ YCSB ื‘ื™ื™ึทืฉืคึผื™ืœ ืื™ื– 400. ืื™ืŸ ื’ืึทื ืฅ, ื–ืขืงืก ืคึผืึทืจืึทืœืขืœ ื™ื ืกื˜ืึทื ืกื™ื– ืคื•ืŸ YCSB ื˜ืขืกืฅ ื”ืึธื‘ืŸ ืฆื• ื–ื™ื™ืŸ ืœื•ื™ืคืŸ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืึท ื’ืึทื ืฅ ืคื•ืŸ 2400 ืคึฟืขื“ืขื.

ืงื•ืง ืื™ืŸ ื“ื™ ื‘ืขื ื˜ืฉืžืึทืจืง ืจืขื–ื•ืœื˜ืึทื˜ืŸ, ืกืคึผืขืฆื™ืขืœ ื“ื™ ืงืึธืžื‘ื™ื ืึทืฆื™ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ืงืคึผื• ืžืึทืกืข ืื•ืŸ ื˜ืคึผืก, ืžื™ืจ ืงืขื ืขืŸ ืงืœืืจ ื–ืขืŸ ืึทื– ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื•ื•ืึธื’ ื’ืึทื ืฅ ื’ื•ื˜. ื“ื™ ื’ืจื•ื™ืก ืžืึทืกืข ื‘ืืฉืืคืŸ ื“ื•ืจืš ืึท ื’ืจื•ื™ืก ื ื•ืžืขืจ ืคื•ืŸ ืคึฟืขื“ืขื ืื™ื– ืึธืคืกืขื˜ ื“ื•ืจืš ืึท ื’ืจื•ื™ืก ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื– ืื™ืŸ ื“ื™ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืงื ื•ื™ืœ. ื›ืึธื˜ืฉ ื“ื™ ืœื™ื™ื˜ืึทื ืกื™ ืงื•ืงื˜ ื’ืึทื ืฅ ื”ื•ื™ืš, ืกืคึผืขืฆื™ืขืœ ื•ื•ืขืŸ ืคืœื™ืกื ื“ื™ืง ืžื™ื˜ 2400 ืคึฟืขื“ืขื, ืขืก ืงืขืŸ ื–ื™ื™ืŸ ื ื™ื™ื˜ื™ืง ืฆื• ืจื™ื˜ืขืกื˜ ืžื™ื˜ 6 ืงืœืขื ืขืจืขืจ ื™ื ืกื˜ืึทื ืกื™ื– ืคื•ืŸ ื“ื™ ืงืึทืžืคึผื™ื•ื˜ื™ื ื’ ืžืึธื˜ืึธืจ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืžืขืจ ืคึผื™ื ื˜ืœืขืš ื ื•ืžืขืจืŸ. ื™ืขื“ืขืจ ื‘ื™ื™ึทืฉืคึผื™ืœ ื•ื•ืขื˜ ืœื•ื™ืคืŸ ืื™ื™ืŸ YCSB ืคึผืจื•ื‘ื™ืจืŸ ืึทื ืฉื˜ืึธื˜ ืคื•ืŸ ืื™ื™ืŸ ื’ืจื•ื™ืก CE ื‘ื™ื™ึทืฉืคึผื™ืœ ืžื™ื˜ 6 ืคึผืึทืจืึทืœืขืœ ื˜ืขืกืฅ. ื“ืึธืก ื•ื•ืขื˜ ืžืึทื›ืŸ ืขืก ื’ืจื™ื ื’ืขืจ ืฆื• ื•ื™ืกื˜ื™ื™ืœืŸ ืฆื•ื•ื™ืฉืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื‘ืขื˜ืŸ ื“ื™ืœื™ื™ื– ืื•ืŸ ื“ื™ืœื™ื™ื– ืฆื•ื’ืขืœื™ื™ื’ื˜ ื“ื•ืจืš ื“ื™ ื ืขืฅ ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืฆื•ื•ื™ืฉืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื•ืŸ ื“ื™ CE ื‘ื™ื™ึทืฉืคึผื™ืœ ืคืœื™ืกื ื“ื™ืง ื“ื™ ืคึผืจืึธื‘ืข.

ื•ื•ื™ ื˜ื•ื˜ Cloud Spanner ื“ื•ืจื›ืคื™ืจืŸ ื•ื•ื™ ืึทืŸ OLAP?

ืฆืขื˜ื™ื™ืœื•ื ื’?

ื“ื™ื•ื•ื™ื™ื“ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ืคื™ื–ื™ืงืœื™ ืื•ืŸ / ืึธื“ืขืจ ืœืึทื“ื–ืฉื™ืงืœื™ ืคืจื™ื™ึท ืกืขื’ืžืึทื ืฅ, ื’ืขืจื•ืคืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื–, ืื™ื– ืึท ื–ื™ื™ืขืจ ืคืึธืœืงืก ื‘ืึทื’ืจื™ืฃ ื’ืขืคึฟื•ื ืขืŸ ืื™ืŸ ืจื•ื‘ึฟ ืึธืœืึทืคึผ ืขื ื“ื–ืฉืึทื ื–. ืคึผืึทืจื˜ื™ืฉืึทื ื– ืงืขื ืขืŸ ื–ื™ื™ืขืจ ืคึฟืึทืจื‘ืขืกืขืจืŸ ืึธื ืคึฟืจืขื’ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืื•ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก ืžืึทื™ื ื˜ืึทื™ืึทื‘ื™ืœื™ื˜ื™. ื•ื•ื™ื™ึทื˜ืขืจ ื“ืขืœื•ื•ื™ื ื’ ืื™ืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ื•ื•ืึธืœื˜ ื–ื™ื™ืŸ ืึท ื‘ืึทื–ื•ื ื“ืขืจ ืึทืจื˜ื™ืงืœ (s), ืึทื–ื•ื™ ืœืึธื–ืŸ ืื•ื ื“ื– ื ืึธืจ ื“ืขืจืžืึธื ืขืŸ ื“ื™ ื•ื•ื™ื›ื˜ื™ืงื™ื™ื˜ ืคื•ืŸ ืึท ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืกื›ืขืžืข ืื•ืŸ ืกืึทื‘-ืคึผืึทืจื˜ื™ื˜ืฉืึทืŸ. ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืฉืคึผืึทืœื˜ืŸ ื“ืึทื˜ืŸ ืื™ืŸ ืคึผืึทืจื˜ื™ืฉืึทื ื– ืื•ืŸ ืืคื™ืœื• ื•ื•ื™ื™ึทื˜ืขืจ ืื™ืŸ ืกืึทื‘-ืคึผืึทืจื˜ื™ื˜ื™ื™ืฉืึทื ื– ืื™ื– ืฉืœื™ืกืœ ืฆื• ื“ื™ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืคื•ืŸ ืึทื ืึทืœื™ืกื™ืก ืงื•ื•ื™ืจื™ื–.

Cloud Spanner ืฉื˜ื™ืฆื˜ ื ื™ืฉื˜ ืคึผืึทืจื˜ื™ืฉืึทื ื– ืคึผืขืจ ืกื™ื™. ืขืก ืกืขืคึผืขืจื™ื™ืฅ ื“ืึทื˜ืŸ ื™ื ืขื•ื•ื™ื™ื ื™ืง ืื™ืŸ ืึทื–ื•ื™ ื’ืขืจื•ืคืขื ืข ืฉืคึผืึทืœื˜ืŸ-ืก ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ ืจื™ื™ื ื“ื–ืฉืึทื–. ื“ื™ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืื™ื– ื’ืขื˜ืืŸ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ืฆื• ื‘ืึทืœืึทื ืกื™ืจืŸ ื“ื™ ืžืึทืกืข ืื•ื™ืฃ ื“ื™ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืงื ื•ื™ืœ. ื ื–ื™ื™ืขืจ ื”ืึทื ื˜ื™ืง ืฉื˜ืจื™ืš ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื™ื– ืกืคึผืœื™ื˜ื™ื ื’ ื“ื™ ื‘ืึทื–ืข ืžืึทืกืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ืึท ืคืึธื˜ืขืจ ื˜ื™ืฉ (ืึท ื˜ื™ืฉ ื•ื•ืึธืก ืื™ื– ื ื™ืฉื˜ ื™ื ื˜ืขืจืœืขืึทื•ื•ืขื“ ืžื™ื˜ ืื ื“ืขืจืŸ). ืกืคึผืึทื ืขืจ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ื“ื™ื˜ืขืงืฅ ืื•ื™ื‘ ืขืก ื›ึผื•ืœืœ ืฉืคึผืึทืœื˜ืŸ ื“ืึทื˜ืŸ ื•ื•ืึธืก ืื™ื– ืœื™ื™ืขื ืขืŸ ืžืขืจ ืึธืคื˜ ื•ื•ื™ ื“ืึทื˜ืŸ ืื™ืŸ ืื ื“ืขืจืข ืฉืคึผืึทืœื˜ืŸ-ืึทื”, ืื•ืŸ ืงืขืŸ ื‘ืึทืฉืœื™ืกืŸ ืื•ื™ืฃ ืึท ื•ื•ื™ื™ึทื˜ืขืจ ืฆืขืฉื™ื™ื“ื•ื ื’. ืื–ื•ื™, ืžืขืจ ื ืึธื•ื“ื– ืงืขื ืขืŸ ื–ื™ื™ืŸ ื™ื ื•ื•ืึทืœื•ื•ื“ ืื™ืŸ ืึท ื‘ืงืฉื”, ื•ื•ืึธืก ืื•ื™ืš ื™ืคืขืงื˜ื™ื•ื•ืœื™ ื™ื ืงืจื™ืกื™ื– ื˜ืจื•ืคึผื•ื˜.

ืœืึธื•ื“ื™ื ื’ ื“ืึทื˜ืŸ?

ื“ื™ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื•ืคึฟืŸ ืคึฟืึทืจ ืคืึทืจื ืขื ื“ืึทื˜ืŸ ืื™ื– ื“ื™ ื–ืขืœื‘ืข ื•ื•ื™ ืคึฟืึทืจ ืึท ืจืขื’ื•ืœืขืจ ื•ืคึผืœืึธืึทื“. ืคึฟืึทืจ ืžืึทืงืกื™ืžื•ื ืคืึธืจืฉื˜ืขืœื•ื ื’, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื ืึธื›ืคืึธืœื’ืŸ ืขื˜ืœืขื›ืข ื’ื™ื™ื“ืœื™ื™ื ื–, ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜:

  • ืกืึธืจื˜ ื“ื™ื™ืŸ ื“ืึทื˜ืŸ ื“ื•ืจืš ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ.
  • ื˜ื™ื™ืœืŸ ื–ื™ื™ ื“ื•ืจืš 10 *ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื– ื™ื—ื™ื“ ืกืขืงืฉืึทื ื–.
  • ืฉืึทืคึฟืŸ ืึท ืกื›ื•ื ืคื•ืŸ ืึทืจื‘ืขื˜ืขืจ ื˜ืึทืกืงืก ื•ื•ืึธืก ืœืึธื“ืŸ ื“ืึทื˜ืŸ ืื™ืŸ ืคึผืึทืจืึทืœืขืœ.

ื“ื™ ื“ืึทื˜ืŸ ืžืึทืกืข ื ื™ืฆื˜ ืึทืœืข ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื ืึธื•ื“ื–.

ืžื™ืจ ื’ืขื•ื•ื™ื™ื ื˜ ื“ื™ ื YCSB ื•ื•ืขืจืงืœืึธื•ื“ ืฆื• ื“ื–ืฉืขื ืขืจื™ื™ื˜ ืึท 10 ื ืจื•ื“ืขืจืŸ ื“ืึทื˜ืึทืกืขื˜.

Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

* ื“ื™ ืžืึทืกืข ืคึผืจืึธื‘ืข ืื™ื– ื’ืขื•ื•ืขืŸ ืœื•ื™ืคืŸ ืื•ื™ืฃ ื“ื™ n1-ืกื˜ืึทื ื“ืึทืจื˜-32 ืงืึทืžืคึผื™ื•ื˜ ืžืึธื˜ืึธืจ (32 ื•ื•ืงืคึผื•ืก, 120 ื’ื™ื’ืื‘ื™ื™ื˜ ื–ื›ึผืจื•ืŸ) ืื•ืŸ ื“ื™ ืคึผืจื•ื‘ื™ืจืŸ ื‘ื™ื™ึทืฉืคึผื™ืœ ืื™ื– ืงื™ื™ื ืžืึธืœ ื’ืขื•ื•ืขืŸ ื“ื™ ื‘ืึทื˜ืึทืœื ืขืง ืื™ืŸ ื“ื™ ื˜ืขืกืฅ.
** ื 1 ื ืึธื“ืข ืกืขื˜ืึทืคึผ ืื™ื– ื ื™ืฉื˜ ืจืขืงืึทืžืขื ื“ื™ื“ ืคึฟืึทืจ ืงื™ื™ืŸ ืคึผืจืึธื“ื•ืงืฆื™ืข ื•ื•ืขืจืงืœืึธื•ื“.

ื•ื•ื™ ื“ืขืจืžืื ื˜ ืื•ื™ื‘ืŸ, ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ืคึผืจืึทืกืขืกืึทื– ืกืคึผืœื™ืฅ ื“ื™ืคึผืขื ื“ื™ื ื’ ืื•ื™ืฃ ื–ื™ื™ืขืจ ืžืึทืกืข, ืึทื–ื•ื™ ื“ื™ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ืคึฟืึทืจื‘ืขืกืขืจืŸ ื ืึธืš ืขื˜ืœืขื›ืข ืงืึธื ืกืขืงื•ื˜ื™ื•ื•ืข ื™ื˜ืขืจื™ื™ืฉืึทื ื– ืคื•ืŸ ื“ื™ ืคึผืจืึธื‘ืข. ื“ื™ ืจืขื–ื•ืœื˜ืื˜ืŸ ื“ืขืจืœืื ื’ื˜ ื“ืึธ ื–ืขื ืขืŸ ื“ื™ ื‘ืขืกื˜ืขืจ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ื•ื•ืึธืก ืžื™ืจ ื”ืึธื‘ืŸ ื‘ืืงื•ืžืขืŸ. ืื™ืจ ื–ื•ื›ื˜ ืื™ืŸ ื“ื™ ื ื•ืžืขืจืŸ ืื•ื™ื‘ืŸ, ืžื™ืจ ืงืขื ืขืŸ ื–ืขืŸ ื•ื•ื™ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื•ื•ืึธื’ (ื’ืขื–ื•ื ื˜) ื•ื•ื™ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื– ืื™ืŸ ื“ืขื ืงื ื•ื™ืœ ื™ื ืงืจื™ืกื™ื–. ื“ื™ ื ื•ืžืขืจืŸ ื•ื•ืึธืก ืฉื˜ื™ื™ืŸ ืื•ื™ืก ื–ืขื ืขืŸ ื’ืึธืจ ื ื™ื“ืขืจื™ืง ื“ื•ืจื›ืฉื ื™ื˜ืœืขืš ืœื™ื™ื˜ืึทื ืกื™, ื•ื•ืึธืก ืงืึทื ื˜ืจืึทืกืฅ ืžื™ื˜ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ืคื•ืŸ ื’ืขืžื™ืฉื˜ ื•ื•ืขืจืงืœืึธื•ื“ื– (95% ืœื™ื™ืขื ืขืŸ ืื•ืŸ 5% ืฉืจื™ื™ึทื‘ืŸ) ื•ื•ื™ ื“ื™ืกืงืจื™ื™ื‘ื“ ืื™ืŸ ื“ื™ ืึธืคึผื˜ื™ื™ืœื•ื ื’ ืื•ื™ื‘ืŸ.

ืกืงื™ื™ืœื™ื ื’?

ื™ื ืงืจืขืึทืกื™ื ื’ ืื•ืŸ ื“ื™ืงืจื™ืกื™ื ื’ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ื ืึธื•ื“ื– ืื™ื– ืึท ืื™ื™ืŸ-ื’ื™ื˜ ืึทืจื‘ืขื˜. ืื•ื™ื‘ ืื™ืจ ื•ื•ื™ืœืŸ ืฆื• ืœืึธื“ืŸ ื“ืึทื˜ืŸ ื’ืขืฉื•ื•ื™ื ื“, ืื™ืจ ืงืขืŸ ื•ื•ืขืœืŸ ืฆื• ื‘ืึทื˜ืจืึทื›ื˜ืŸ ื‘ื•ืกื˜ ื“ืขื ื‘ื™ื™ึทืฉืคึผื™ืœ ืฆื• ื“ื™ ืžืึทืงืกื™ืžื•ื (ืื™ืŸ ืื•ื ื“ื–ืขืจ ืคืึทืœ ืขืก ืื™ื– ื’ืขื•ื•ืขืŸ 25 ื ืึธื•ื“ื– ืื™ืŸ ื“ื™ ื™ื•-ืžื–ืจื— ื’ืขื’ื ื˜) ืื•ืŸ ื“ืึทืŸ ืจืขื“ื•ืฆื™ืจืŸ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื– ืคึผืึทืกื™ืง ืคึฟืึทืจ ื“ื™ื™ืŸ ื ืึธืจืžืึทืœ ืžืึทืกืข ื ืึธืš ืึทืœืข ื“ื™ ื“ืึทื˜ืŸ. ืื™ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก, ืžื™ื˜ ื“ื™ 2 ื˜ื‘ / ื ืึธื“ืข ืฉื™ืขื•ืจ ืื™ืŸ ื–ื™ื ืขืŸ.

ืžื™ืจ ื–ืขื ืขืŸ ืจื™ืžื™ื™ื ื“ื™ื“ ืคื•ืŸ ื“ืขื ืฉื™ืขื•ืจ ืืคื™ืœื• ืžื™ื˜ ืึท ืคื™ืœ ืงืœืขื ืขืจืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก. ื ืึธืš ืขื˜ืœืขื›ืข ืžืึทืกืข ืคึผืจื•ื‘ื™ืจืŸ ืจืึทื ื–, ืื•ื ื“ื–ืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ื– ื’ืขื•ื•ืขืŸ ื•ื•ืขื’ืŸ 155 ื’ื™ื’ืื‘ื™ื™ื˜ ืื™ืŸ ื’ืจื™ื™ืก, ืื•ืŸ ื•ื•ืขืŸ ืกืงื™ื™ืœื“ ืึทืจืึธืคึผ ืฆื• ืึท 1 ื ืึธื“ืข ื‘ื™ื™ึทืฉืคึผื™ืœ, ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ื˜ืขื•ืช:

Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

ืžื™ืจ ื–ืขื ืขืŸ ื‘ื™ื›ื•ืœืช ืฆื• ืคืึทืจืงืœืขื ืขืจืŸ ืคื•ืŸ 25 ืฆื• 2 ืงืึทืกืขืก, ืึธื‘ืขืจ ืžื™ืจ ื–ืขื ืขืŸ ืกื˜ืึทืง ืื•ื™ืฃ ืฆื•ื•ื™ื™ ื ืึธื•ื“ื–.

ืจื™ื™ื–ื™ื ื’ ืื•ืŸ ื“ื™ืงืจื™ืžืึทื ื˜ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื– ืื™ืŸ ืึท ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืงื ื•ื™ืœ ืงืขื ืขืŸ ื–ื™ื™ืŸ ืึธื˜ืึทืžื™ื™ื˜ื™ื“ ืžื™ื˜ ื“ื™ REST API. ื“ืึธืก ืงืขืŸ ื–ื™ื™ืŸ ืกืคึผืขืฆื™ืขืœ ื ื•ืฆื™ืง ืคึฟืึทืจ ืจื™ื“ื•ืกื™ื ื’ ื“ื™ ื’ืขื•ื•ืืงืกืŸ ืžืึทืกืข ืื•ื™ืฃ ื“ื™ ืกื™ืกื˜ืขื ื‘ืขืฉืึทืก ืคืึทืจื ื•ืžืขืŸ ืฉืขื”.

OLAP ืึธื ืคึฟืจืขื’ ืคืึธืจืฉื˜ืขืœื•ื ื’?

ืžื™ืจ ืขืจื™ื“ื–ืฉื ืึทืœื™ ืคึผืœืึทื ื ืขื“ ืฆื• ืึธืคึผื’ืขื‘ืŸ ื”ื™ืคึผืฉ ืฆื™ื™ื˜ ืฆื• ืื•ื ื“ื–ืขืจ ืืคืฉืืฆื•ื ื’ ืคื•ืŸ ืกืคึผืึทื ืขืจ ืื•ื™ืฃ ื“ืขื ื˜ื™ื™ืœ. ื ืึธืš ืึท ื‘ื™ืกืœ ืกืขืœืขืงื˜ืขื“ ืงืึทื•ื ืฅ, ืžื™ืจ ืžื™ื“ ืื™ื™ื ื’ืขื–ืขืŸ ืึทื– ื“ื™ ืคึผืจืึธื‘ืข ื•ื•ืึธืœื˜ ื–ื™ื™ืŸ ืงื•ืจืฅ ืื•ืŸ ืึทื– ืกืคึผืึทื ื ืขืจ ื•ื•ืึธืœื˜ ื ื™ืฉื˜ ื–ื™ื™ืŸ ืึท ืคึผืึทืกื™ืง ืžืึธื˜ืึธืจ ืคึฟืึทืจ OLAP. ืจืขื’ืึทืจื“ืœืขืกืก ืคื•ืŸ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ื ืึธื•ื“ื– ืื™ืŸ ื“ืขื ืงื ื•ื™ืœ, ื ืึธืจ ื˜ืฉื•ื–ื™ื ื’ ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ืจืึธื•ื– ืื™ืŸ ืึท 10 ื ืจื•ื“ืขืจืŸ ื˜ื™ืฉ ื’ืขื ื•ืžืขืŸ 55-60 ืกืขืงื•ื ื“ืขืก. ืื•ื™ืš, ืงื™ื™ืŸ ืึธื ืคึฟืจืขื’ ื•ื•ืึธืก ืคืืจืœืื ื’ื˜ ืžืขืจ ื–ื™ืงืึธืจืŸ ืฆื• ืงืจืึธื ื™ื ื˜ืขืจืžื™ื“ื™ื™ื˜ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ืื™ื– ื ื™ื˜ ืึทื ื“ืขืจืฉ ืžื™ื˜ ืึทืŸ OOM ื˜ืขื•ืช.

SELECT COUNT(DISTINCT(field0)) FROM usertable; โ€” (10M distinct values)-> SpoolingHashAggregateIterator ran out of memory during new row.

ืขื˜ืœืขื›ืข ื ื•ืžืขืจืŸ ืคึฟืึทืจ TPC-H ืงื•ื•ื™ืจื™ื– ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขืคึฟื•ื ืขืŸ ืื™ืŸ Todd Lipcon ืก ืึทืจื˜ื™ืงืœ nosql-kudu-spanner-slides.html, ืกืœื™ื™ื“ื– 42 ืื•ืŸ 43. ื“ื™ ื ื•ืžืขืจืŸ ื–ืขื ืขืŸ ืงืึธื ืกื™ืกื˜ืขื ื˜ ืžื™ื˜ ืื•ื ื“ื–ืขืจ ืื™ื™ื’ืขื ืข ืจืขื–ื•ืœื˜ืึทื˜ืŸ (ืฆื•ื ื‘ืึทื“ื•ื™ืขืจืŸ).

Google Cloud Spanner: ื’ื•ื˜, ืฉืœืขื›ื˜, ืžื™ืขืก

4. ืื•ื ื“ื–ืขืจ ืคื™ื™ื ื“ื™ื ื’ื–

ื’ืขื’ืขื‘ืŸ ื“ืขื ืงืจืึทื ื˜ ืฉื˜ืึทื˜ ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืก ืคึฟืขื™ึดืงื™ื™ื˜ืŸ, ืขืก ืื™ื– ืฉื•ื•ืขืจ ืฆื• ื–ืขืŸ ืขืก ื•ื•ื™ ืึท ืคึผืฉื•ื˜ ืคืึทืจื‘ื™ื™ึทื˜ ืคึฟืึทืจ ืึทืŸ ื™ื’ื–ื™ืกื˜ื™ื ื’ OLTP ืœื™ื™ื–ื•ื ื’, ืกืคึผืขืฆื™ืขืœ ื•ื•ืขืŸ ื“ื™ื™ืŸ ื“ืึทืจืฃ ืึทื•ื˜ื’ืจืึธื• ืขืก. ื ื‘ืึทื˜ื™ื™ื˜ื™ืง ืกื•ืžืข ืคื•ืŸ โ€‹โ€‹ืฆื™ื™ื˜ ื•ื•ืึธืœื˜ ื–ื™ื™ืŸ ืคืืจื‘ืจืื›ื˜ ืฆื• ื‘ื•ื™ืขืŸ ืึท ืœื™ื™ื–ื•ื ื’ ืึทืจื•ื ื“ื™ ืฉืึธืจื˜ืงืึธืžื™ื ื’ืก ืคื•ืŸ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ.

ื•ื•ืขืŸ ืžื™ืจ ืกื˜ืึทืจื˜ืขื“ ื™ื•ื•ืึทืœื™ื•ื™ื™ื˜ื™ื ื’ ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ, ืžื™ืจ ื“ืขืจื•ื•ืึทืจื˜ ืึทื– ื“ื™ ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ื–ืึธืœ ื–ื™ื™ืŸ ืื•ื™ืฃ ืคึผืึทืจ ืžื™ื˜, ืึธื“ืขืจ ืœืคึผื—ื•ืช ื ื™ื˜ ื•ื•ื™ื™ึทื˜ ืคื•ืŸ, ืื ื“ืขืจืข Google SQL ืกืึทืœื•ืฉืึทื ื–. ืึธื‘ืขืจ ืžื™ืจ ื–ืขื ืขืŸ ืกืึทืคึผืจื™ื™ื–ื“ ื“ื•ืจืš ื“ื™ ื’ืึทื ืฅ ืคืขืœืŸ ืคื•ืŸ ื‘ืึทืงืึทืคึผืก ืื•ืŸ ื–ื™ื™ืขืจ ืœื™ืžื™ื˜ืขื“ ืึทืงืกืขืก ืงืึธื ื˜ืจืึธืœ ืฆื• ืจืขืกื•ืจืกืŸ. ื ื™ื˜ ืฆื• ื“ืขืจืžืึธื ืขืŸ ืงื™ื™ืŸ ืงื•ืงืŸ, ืงื™ื™ืŸ ื”ื™ื’ืข ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืกื•ื•ื™ื•ื•ืข, ืึทื ืกืึทืคึผืึธืจื˜ื™ื“ ืกื™ืงื•ื•ืึทื ืกื™ื–, JDBC ืึธืŸ DML ืื•ืŸ DDL ืฉื˜ื™ืฆืŸ, ืื•ืŸ ืึทื–ื•ื™ ืื•ื™ืฃ.

ืึทื–ื•ื™, ื•ื•ื• ืฆื• ื’ื™ื™ืŸ ืคึฟืึทืจ ืขืžืขืฆืขืจ ื•ื•ืืก ื“ืึทืจืฃ ืฆื• ื•ื•ืึธื’ ืึท ื˜ืจืึทื ืกืึทืงื˜ื™ืึธื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืก? ืขืก ืงืขืŸ ื ื™ืฉื˜ ื–ื™ื™ืŸ ืึท ืื™ื™ืŸ ืœื™ื™ื–ื•ื ื’ ืื•ื™ืฃ ื“ืขื ืžืึทืจืง ื ืึธืš ื•ื•ืึธืก ืคื™ืฅ ืึทืœืข ื ื•ืฆืŸ ืงืึทืกืขืก. ืขืก ื–ืขื ืขืŸ ืคื™ืœืข ืคืืจืžืื›ื˜ ืื•ืŸ ืึธืคึฟืŸ ืžืงื•ืจ ืกืึทืœื•ืฉืึทื ื– (ืขื˜ืœืขื›ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื•ื•ืึธืก ื–ืขื ืขืŸ ื“ืขืจืžืื ื˜ ืื™ืŸ ื“ืขื ืึทืจื˜ื™ืงืœ), ื™ืขื“ืขืจ ืžื™ื˜ ื–ื™ื™ืขืจ ืื™ื™ื’ืขื ืข ืกื˜ืจืขื ื’ืงื˜ืก ืื•ืŸ ื•ื•ื™ืงื ืึทืกืึทื–, ืึธื‘ืขืจ ืงื™ื™ื ืขืจ ืคื•ืŸ ื–ื™ื™ ืึธืคืคืขืจืก ืกืึทืึทืก ืžื™ื˜ ืึท 99,999% ืกืœืึท ืื•ืŸ ืึท ื”ื•ื™ืš ืงืึธื ืกื™ืกื˜ืขื ืกื™. ืื•ื™ื‘ ืึท ื”ื•ื™ืš SLA ืื™ื– ื“ื™ื™ืŸ ืขืจืฉื˜ื™ืง ืฆื™ืœ ืื•ืŸ ืื™ืจ ื–ืขื ื˜ ื ื™ืฉื˜ ื’ืขื ื™ื™ื’ื˜ ืฆื• ื‘ื•ื™ืขืŸ ื“ื™ื™ืŸ ืื™ื™ื’ืขื ืข ืœื™ื™ื–ื•ื ื’ ืคึฟืึทืจ ืงื™ื™ืคืœ ื•ื•ืืœืงื ืก, Cloud Spanner ืงืขืŸ ื–ื™ื™ืŸ ื“ื™ ืœื™ื™ื–ื•ื ื’ ืื™ืจ ื–ื•ื›ื˜ ืคึฟืึทืจ. ืึธื‘ืขืจ ืื™ืจ ื–ืึธืœ ื–ื™ื™ืŸ ืึทื•ื•ืขืจ ืคื•ืŸ ืึทืœืข ื–ื™ื™ึทืŸ ืœื™ืžื™ื˜ื™ื™ืฉืึทื ื–.

ืฆื• ื–ื™ื™ืŸ ืฉื™ื™ืŸ, ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื™ื– ื’ืขื•ื•ืขืŸ ืคืจื™ื™ ืฆื• ื“ืขื ืฆื™ื‘ื•ืจ ื‘ืœื•ื™ื– ืื™ืŸ ืคืจื™ืœื™ื ื’ ืคื•ืŸ 2017, ืึทื–ื•ื™ ืขืก ืื™ื– ื’ืœื™ื™ึทืš ืฆื• ื“ืขืจื•ื•ืึทืจื˜ืŸ ืึทื– ืขื˜ืœืขื›ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื–ื™ื™ึทืŸ ืงืจืึทื ื˜ ืคืœืึธื– ืงืขืŸ ื™ื•ื•ืขื ื˜ืฉืึทื•ื•ืึทืœื™ ื’ื™ื™ืŸ ืึทื•ื•ืขืง (ืึทืœืขื•ื•ื™ื™ึท), ืื•ืŸ ื•ื•ืขืŸ ื“ืึธืก ืงืขืŸ ื–ื™ื™ืŸ ืึท ืฉืคึผื™ืœ-ื˜ืฉืึทื ื’ืขืจ. ื ืึธืš ืึทืœืข, ืงืœืึธื•ื“ ืกืคึผืึทื ื ืขืจ ืื™ื– ื ื™ื˜ ื ืึธืจ ืึท ื–ื™ื™ึทื˜ ืคึผืจื•ื™ืขืงื˜ ืคึฟืึทืจ Google. Google ื ื™ืฆื˜ ืขืก ื•ื•ื™ ื“ื™ ื™ืงืขืจ ืคึฟืึทืจ ืื ื“ืขืจืข Google ืคึผืจืึธื“ื•ืงื˜ืŸ. ืื•ืŸ ื•ื•ืขืŸ Google ืœืขืฆื˜ื ืก ืจื™ืคึผืœื™ื™ืกื˜ Megastore ืื™ืŸ Google Cloud Storage ืžื™ื˜ Cloud Spanner, ืขืก ืขืจืœื•ื™ื‘ื˜ Google Cloud Storage ืฆื• ื•ื•ืขืจืŸ ื”ืขื›ืกื˜ ืงืึธื ืกื™ืกื˜ืขื ื˜ ืคึฟืึทืจ ืึทื‘ื“ื–ืฉืขืงืฅ ืจืฉื™ืžื•ืช ืื•ื™ืฃ ืึท ื’ืœืื‘ืืœืข ื•ื•ืึธื’ (ื•ื•ืึธืก ืื™ื– ื ืึธืš ื ื™ืฉื˜ ื“ืขืจ ืคืึทืœ ืคึฟืึทืจ Amazon's S3).

ืึทื–ื•ื™, ืขืก ืื™ื– ื ืึธืš ื”ืึธืคืขื ื•ื ื’ ... ืžื™ืจ ื”ืึธืคึฟืŸ.

ืึทื– ืก ืึทืœืข. ื•ื•ื™ ื“ืขืจ ืžื—ื‘ืจ ืคื•ืŸ ื“ืขื ืึทืจื˜ื™ืงืœ, ืžื™ืจ ืื•ื™ืš ืคืึธืจื–ืขืฆืŸ ืฆื• ื”ืึธืคึฟืŸ, ืึธื‘ืขืจ ื•ื•ืึธืก ื˜ืึธืŸ ืื™ืจ ื˜ืจืึทื›ื˜ืŸ ื•ื•ืขื’ืŸ ื“ืขื? ืฉืจื™ื™ื‘ ืื™ืŸ ื“ื™ ื‘ืึทืžืขืจืงื•ื ื’ืขืŸ

ืžื™ืจ ืœืึทื“ืŸ ืึทืœืขืžืขืŸ ืฆื• ื‘ืึทื–ื•ื›ืŸ ืื•ื ื“ื–ืขืจ ืคึฟืจื™ื™ึท ื•ื•ืขื‘ื™ื ืึทืจ ืื™ืŸ ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ื“ืขืจืฆื™ื™ืœืŸ ืื™ืจ ืื™ืŸ ื“ืขื˜ืึทืœ ื•ื•ืขื’ืŸ ื“ืขื ืงื•ืจืก "AWS ืคึฟืึทืจ ื“ืขื•ื•ืขืœืึธืคึผืขืจืก" ืคึฟื•ืŸ OTUS.

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’