ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื

ืœืงืจืืช ื”ืฉืงืช ืชื–ืจื™ื ื—ื“ืฉ ื‘ืงืฆื‘ ืžื”ื ื“ืก ื ืชื•ื ื™ื ื”ื›ื ื• ืชืจื’ื•ื ืฉืœ ื—ื•ืžืจ ืžืขื ื™ื™ืŸ.

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื

ืกืงื™ืจื”

ื ื“ื‘ืจ ืขืœ ื“ืคื•ืก ืคื•ืคื•ืœืจื™ ืœืžื“ื™ ืฉื‘ื• ื™ื™ืฉื•ืžื™ื ืžืฉืชืžืฉื™ื ื‘ืžืกืคืจ ืžืื’ืจื™ ื ืชื•ื ื™ื, ื›ืืฉืจ ื›ืœ ื—ื ื•ืช ืžืฉืžืฉืช ืœืžื˜ืจื•ืช ืžืฉืœื”, ืœืžืฉืœ, ืœืื—ืกื•ืŸ ื”ืฆื•ืจื” ื”ืงื ื•ื ื™ืช ืฉืœ ื”ื ืชื•ื ื™ื (MySQL ื•ื›ื•'), ืžืกืคืงื•ืช ื™ื›ื•ืœื•ืช ื—ื™ืคื•ืฉ ืžืชืงื“ืžื•ืช (ElasticSearch, ื•ื›ื•') .), ืžื˜ืžื•ืŸ (Memcached ื•ื›ื•') ื•ืื—ืจื™ื. ื‘ื“ืจืš ื›ืœืœ, ื›ืืฉืจ ืžืฉืชืžืฉื™ื ื‘ืžืกืคืจ ืžืื’ืจื™ ื ืชื•ื ื™ื, ืื—ื“ ืžื”ื ืคื•ืขืœ ื›ืžืื’ืจ ื”ืจืืฉื™ ื•ื”ืื—ืจื™ื ื›ืžืื’ืจื™ ื ื’ื–ืจื•ืช. ื”ื‘ืขื™ื” ื”ื™ื—ื™ื“ื” ื”ื™ื ื›ื™ืฆื“ ืœืกื ื›ืจืŸ ืืช ืžืื’ืจื™ ื”ื ืชื•ื ื™ื ื”ืœืœื•.

ื‘ื“ืงื ื• ืžืกืคืจ ื“ืคื•ืกื™ื ืฉื•ื ื™ื ืฉื ื™ืกื• ืœืคืชื•ืจ ืืช ื‘ืขื™ื™ืช ื”ืกื ื›ืจื•ืŸ ืฉืœ ืžืกืคืจ ื—ื ื•ื™ื•ืช, ื›ืžื• ื›ืชื™ื‘ื” ื›ืคื•ืœื”, ืขืกืงืื•ืช ืžื‘ื•ื–ืจื•ืช ื•ื›ื•'. ืขื ื–ืืช, ืœื’ื™ืฉื•ืช ืืœื• ื™ืฉ ืžื’ื‘ืœื•ืช ืžืฉืžืขื•ืชื™ื•ืช ืžื‘ื—ื™ื ืช ืฉื™ืžื•ืฉ, ืืžื™ื ื•ืช ื•ืชื—ื–ื•ืงื” ื‘ืžืฆื™ืื•ืช. ื‘ื ื•ืกืฃ ืœืกื ื›ืจื•ืŸ ื ืชื•ื ื™ื, ื™ื™ืฉื•ืžื™ื ืžืกื•ื™ืžื™ื ืฆืจื™ื›ื™ื ื’ื ืœื”ืขืฉื™ืจ ื ืชื•ื ื™ื ืขืœ ื™ื“ื™ ื”ืชืงืฉืจื•ืช ืœืฉื™ืจื•ืชื™ื ื—ื™ืฆื•ื ื™ื™ื.

ื“ืœืชื ืคื•ืชื—ื” ื›ื“ื™ ืœืคืชื•ืจ ื‘ืขื™ื•ืช ืืœื•. ื“ืœืชื ืžืกืคืงืช ื‘ืกื•ืคื• ืฉืœ ื“ื‘ืจ ืคืœื˜ืคื•ืจืžื” ืขืงื‘ื™ืช, ืžื•ื ืขืช ืื™ืจื•ืขื™ื ืœืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื.

ืคืชืจื•ื ื•ืช ืงื™ื™ืžื™ื

ื›ื ื™ืกื” ื›ืคื•ืœื”

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

ื‘ืขื™ื•ืช:

ื‘ื™ืฆื•ืข ื”ืœื™ืš ืฉื—ื–ื•ืจ ื”ื•ื ืขื‘ื•ื“ื” ืกืคืฆื™ืคื™ืช ืฉืœื ื ื™ืชืŸ ืœืขืฉื•ืช ื‘ื” ืฉื™ืžื•ืฉ ื—ื•ื–ืจ. ื‘ื ื•ืกืฃ, ื ืชื•ื ื™ื ื‘ื™ืŸ ืžื™ืงื•ืžื™ ืื—ืกื•ืŸ ืœื ืžืกื•ื ื›ืจื ื™ื ืขื“ ืฉื”ืœื™ืš ื”ืฉื—ื–ื•ืจ ืžืชื‘ืฆืข. ื”ืคืชืจื•ืŸ ื ืขืฉื” ืžื•ืจื›ื‘ ื™ื•ืชืจ ืื ืžืฉืชืžืฉื™ื ื‘ื™ื•ืชืจ ืžืฉื ื™ ืžืื’ืจื™ ืžื™ื“ืข. ืœื‘ืกื•ืฃ, ื”ืœื™ืš ื”ืฉื—ื–ื•ืจ ื™ื›ื•ืœ ืœื”ื•ืกื™ืฃ ืขื•ืžืก ืœืžืงื•ืจ ื”ื ืชื•ื ื™ื ื”ืžืงื•ืจื™.

ืฉื™ื ื•ื™ ื˜ื‘ืœืช ื™ื•ืžืŸ

ื›ืืฉืจ ืžืชืจื—ืฉื™ื ืฉื™ื ื•ื™ื™ื ื‘ืงื‘ื•ืฆื” ืฉืœ ื˜ื‘ืœืื•ืช (ื›ื’ื•ืŸ ื”ื›ื ืกื”, ืขื“ื›ื•ืŸ ื•ืžื—ื™ืงืช ืจืฉื•ืžื”), ืจืฉื•ืžื•ืช ื”ืฉื™ื ื•ื™ ืžืชื•ื•ืกืคื•ืช ืœื˜ื‘ืœืช ื”ื™ื•ืžืŸ ื›ื—ืœืง ืžืื•ืชื” ื˜ืจื ื–ืงืฆื™ื”. ืฉืจืฉื•ืจ ืื—ืจ ืื• ืชื”ืœื™ืš ืื—ืจ ืžื‘ืงืฉ ื›ืœ ื”ื–ืžืŸ ืื™ืจื•ืขื™ื ืžื˜ื‘ืœืช ื”ื™ื•ืžืŸ ื•ื›ื•ืชื‘ ืื•ืชื ืœืžืื’ืจ ื ืชื•ื ื™ื ืื—ื“ ืื• ื™ื•ืชืจ, ื‘ืžื™ื“ืช ื”ืฆื•ืจืš, ื”ืกืจืช ืื™ืจื•ืขื™ื ืžื˜ื‘ืœืช ื”ื™ื•ืžืŸ ืœืื—ืจ ืฉื”ืจืฉื•ืžื” ืžืื•ืฉืจืช ืขืœ ื™ื“ื™ ื›ืœ ื”ืžืื’ืจื™ื.

ื‘ืขื™ื•ืช:

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

ื‘ืขื™ื” ื ื•ืกืคืช ื ืขื•ืฆื” ื‘ื”ืฉื’ืช ืฉื™ื ื•ื™ื™ ืกื›ื™ืžื” ื‘ืžืขืจื›ื•ืช ืฉืื™ื ืŸ ืชื•ืžื›ื•ืช ื‘ืฉื™ื ื•ื™ื™ ืกื›ื™ืžื” ื˜ืจื ื–ืงืฆื™ื•ืช [1][2], ื›ื’ื•ืŸ MySQL. ืœื›ืŸ, ื”ื“ืคื•ืก ืฉืœ ื‘ื™ืฆื•ืข ืฉื™ื ื•ื™ (ืœื“ื•ื’ืžื”, ืฉื™ื ื•ื™ ืกื›ื™ืžื”) ื•ืจื™ืฉื•ื ืขืกืงืื•ืช ืฉืœื• ื‘ื˜ื‘ืœืช ื™ื•ืžืŸ ื”ืฉื™ื ื•ื™ื™ื ืœื ืชืžื™ื“ ื™ืขื‘ื•ื“.

ืขืกืงืื•ืช ืžื‘ื•ื–ืจื•ืช

ื ื™ืชืŸ ืœื”ืฉืชืžืฉ ื‘ืขืกืงืื•ืช ืžื‘ื•ื–ืจื•ืช ื›ื“ื™ ืœืคืฆืœ ืขืกืงื” ืขืœ ืคื ื™ ืžืกืคืจ ืžืื’ืจื™ ื ืชื•ื ื™ื ื”ื˜ืจื•ื’ื ื™ื™ื ื›ืš ืฉื”ืคืขื•ืœื” ืžื—ื•ื™ื‘ืช ืœื›ืœ ืžืื’ืจื™ ื”ื ืชื•ื ื™ื ืฉื‘ื”ื ื ืขืฉื” ืฉื™ืžื•ืฉ, ืื• ืฉืื™ื ื” ืžื—ื•ื™ื‘ืช ืœืืฃ ืื—ื“ ืžื”ื.

ื‘ืขื™ื•ืช:

ืขืกืงืื•ืช ืžื‘ื•ื–ืจื•ืช ื”ืŸ ื‘ืขื™ื” ื’ื“ื•ืœื” ืžืื•ื“ ืขื‘ื•ืจ ืžืื’ืจื™ ืžื™ื“ืข ื”ื˜ืจื•ื’ื ื™ื™ื. ืžื˜ื‘ืขื, ื”ื ื™ื›ื•ืœื™ื ืœื”ืกืชืžืš ืจืง ืขืœ ื”ืžื›ื ื” ื”ืžืฉื•ืชืฃ ื”ื ืžื•ืš ื‘ื™ื•ืชืจ ืฉืœ ื”ืžืขืจื›ื•ืช ื”ืžืขื•ืจื‘ื•ืช. ืœื“ื•ื’ืžื”, ืขืกืงืื•ืช XA ื—ื•ืกืžื•ืช ื‘ื™ืฆื•ืข ืื ืชื”ืœื™ืš ื”ื™ื™ืฉื•ื ื ื›ืฉืœ ื‘ืฉืœื‘ ื”ื”ื›ื ื”. ื‘ื ื•ืกืฃ, XA ืื™ื ื• ืžืกืคืง ื–ื™ื”ื•ื™ ืžื‘ื•ื™ ืกืชื•ื ืื• ืชื•ืžืš ื‘ืกื›ื™ืžื•ืช ื‘ืงืจืช ืžืงื‘ื™ืœื™ื•ืช ืื•ืคื˜ื™ืžื™ื•ืช. ื‘ื ื•ืกืฃ, ืžืขืจื›ื•ืช ืžืกื•ื™ืžื•ืช ื›ืžื• ElasticSearch ืื™ื ืŸ ืชื•ืžื›ื•ืช ื‘-XA ืื• ื‘ื›ืœ ืžื•ื“ืœ ืขืกืงื” ื”ื˜ืจื•ื’ื ื™ ืื—ืจ. ืœืคื™ื›ืš, ื”ื‘ื˜ื—ืช ืื˜ื•ืžื™ื•ืช ื›ืชื™ื‘ื” ื‘ื˜ื›ื ื•ืœื•ื’ื™ื•ืช ืฉื•ื ื•ืช ืœืื—ืกื•ืŸ ื ืชื•ื ื™ื ื ื•ืชืจื” ืžืฉื™ืžื” ืžืืชื’ืจืช ืžืื•ื“ ืขื‘ื•ืจ ื™ื™ืฉื•ืžื™ื [3].

ื“ืœืชื

Delta ืชื•ื›ื ื ื” ืœืชืช ืžืขื ื” ืœืžื’ื‘ืœื•ืช ืฉืœ ืคืชืจื•ื ื•ืช ืกื ื›ืจื•ืŸ ื ืชื•ื ื™ื ืงื™ื™ืžื™ื ื•ืžืืคืฉืจืช ื’ื ื”ืขืฉืจืช ื ืชื•ื ื™ื ืชื•ืš ื›ื“ื™ ืชื ื•ืขื”. ื”ืžื˜ืจื” ืฉืœื ื• ื”ื™ื™ืชื” ืœื”ืจื—ื™ืง ืืช ื›ืœ ื”ืžื•ืจื›ื‘ื•ื™ื•ืช ื”ืœืœื• ืžืžืคืชื—ื™ ื™ื™ืฉื•ืžื™ื ื›ื“ื™ ืฉื™ื•ื›ืœื• ืœื”ืชืžืงื“ ื‘ืื•ืคืŸ ืžืœื ื‘ื™ื™ืฉื•ื ืคื•ื ืงืฆื™ื•ื ืœื™ื•ืช ืขืกืงื™ืช. ื‘ืฉืœื‘ ื”ื‘ื ื ืชืืจ ืืช "ื—ื™ืคื•ืฉ ืกืจื˜ื™ื", ืžืงืจื” ื”ืฉื™ืžื•ืฉ ื‘ืคื•ืขืœ ืขื‘ื•ืจ ื“ืœืชื ืฉืœ ื ื˜ืคืœื™ืงืก.

ื ื˜ืคืœื™ืงืก ืžืฉืชืžืฉืช ื‘ืื•ืคืŸ ื ืจื—ื‘ ื‘ืืจื›ื™ื˜ืงื˜ื•ืจืช ืžื™ืงืจื•-ืฉื™ืจื•ืช, ื•ื›ืœ ืžื™ืงืจื•-ืฉื™ืจื•ืช ืžืฉืจืช ื‘ื“ืจืš ื›ืœืœ ืกื•ื’ ืื—ื“ ืฉืœ ื ืชื•ื ื™ื. ืžื™ื“ืข ื‘ืกื™ืกื™ ืขืœ ื”ืกืจื˜ ื›ืœื•ืœ ื‘ืฉื™ืจื•ืช ืžื™ืงืจื• ืฉื ืงืจื Movie Service, ื•ื ืชื•ื ื™ื ืžืฉื•ื™ื›ื™ื ื›ื’ื•ืŸ ืžื™ื“ืข ืขืœ ืžืคื™ืงื™ื, ืฉื—ืงื ื™ื, ืกืคืงื™ื ื•ื›ืŸ ื”ืœืื” ืžื ื•ื”ืœื™ื ืขืœ ื™ื“ื™ ืžืกืคืจ ืฉื™ืจื•ืชื™ ืžื™ืงืจื• ืื—ืจื™ื (ื›ืœื•ืžืจ ืฉื™ืจื•ืช ื“ื™ืœ, ืฉื™ืจื•ืช ื›ื™ืฉืจื•ื ื•ืช ื•ืฉื™ืจื•ืช ืกืคืงื™ื).
ืžืฉืชืžืฉื™ื ืขืกืงื™ื™ื ื‘ืื•ืœืคื ื™ ื ื˜ืคืœื™ืงืก ืฆืจื™ื›ื™ื ืœืขืชื™ื ืงืจื•ื‘ื•ืช ืœื—ืคืฉ ื‘ืงืจื™ื˜ืจื™ื•ื ื™ื ืฉื•ื ื™ื ืฉืœ ืกืจื˜ื™ื, ื•ื–ื• ื”ืกื™ื‘ื” ืฉื—ืฉื•ื‘ ืœื”ื ืžืื•ื“ ืœื”ื™ื•ืช ืžืกื•ื’ืœื™ื ืœื—ืคืฉ ื‘ื›ืœ ื”ื ืชื•ื ื™ื ื”ืงืฉื•ืจื™ื ืœืกืจื˜ื™ื.

ืœืคื ื™ ื“ืœืชื, ืฆื•ื•ืช ื—ื™ืคื•ืฉ ื”ืกืจื˜ื™ื ื”ื™ื” ืฆืจื™ืš ืœืžืฉื•ืš ื ืชื•ื ื™ื ืžืžืกืคืจ ืฉื™ืจื•ืชื™ ืžื™ืงืจื• ืœืคื ื™ ื”ื•ืกืคืช ื ืชื•ื ื™ ื”ืกืจื˜ ืœืื™ื ื“ืงืก. ื‘ื ื•ืกืฃ, ื”ืฆื•ื•ืช ื”ื™ื” ืฆืจื™ืš ืœืคืชื— ืžืขืจื›ืช ืฉืชืขื“ื›ืŸ ืžืขืช ืœืขืช ืืช ืื™ื ื“ืงืก ื”ื—ื™ืคื•ืฉ ืขืœ ื™ื“ื™ ื‘ืงืฉืช ืฉื™ื ื•ื™ื™ื ืžืฉื™ืจื•ืชื™ ืžื™ืงืจื• ืื—ืจื™ื, ื’ื ืื ืœื ื”ื™ื• ืฉื™ื ื•ื™ื™ื ื›ืœืœ. ืžืขืจื›ืช ื–ื• ื”ืคื›ื” ื‘ืžื”ื™ืจื•ืช ืœืžื•ืจื›ื‘ืช ื•ืงืฉื” ืœืชื—ื–ื•ืงื”.

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื
ืื™ื•ืจ 1. ืžืขืจื›ืช ืกืงืจื™ื ืœื“ืœืชื
ืœืื—ืจ ื”ืฉื™ืžื•ืฉ ื‘-Delta, ื”ืžืขืจื›ืช ืคืฉื˜ื” ืœืžืขืจื›ืช ืžื•ื ืขืช ืื™ืจื•ืขื™ื ื›ืคื™ ืฉืžื•ืฆื’ ื‘ืื™ื•ืจ ื”ื‘ื. ืื™ืจื•ืขื™ CDC (Change-Data-Capture) ื ืฉืœื—ื™ื ืœื ื•ืฉืื™ื ืฉืœ Keystone Kafka ื‘ืืžืฆืขื•ืช Delta-Connector. ืืคืœื™ืงืฆื™ื™ืช Delta ืฉื ื‘ื ืชื” ื‘ืืžืฆืขื•ืช Delta Stream Processing Framework (ืžื‘ื•ืกืก ืขืœ Flink) ืžืงื‘ืœืช ืื™ืจื•ืขื™ CDC ืžื ื•ืฉื, ืžืขืฉื™ืจื” ืื•ืชื ืขืœ ื™ื“ื™ ืงืจื™ืื” ืœืฉื™ืจื•ืชื™ ืžื™ืงืจื• ืื—ืจื™ื, ื•ืœื‘ืกื•ืฃ ืžืขื‘ื™ืจื” ืืช ื”ื ืชื•ื ื™ื ื”ืžื•ืขืฉืจื™ื ืœืื™ื ื“ืงืก ื—ื™ืคื•ืฉ ื‘- Elasticsearch. ื”ืชื”ืœื™ืš ื›ื•ืœื• ืžืชืจื—ืฉ ื›ืžืขื˜ ื‘ื–ืžืŸ ืืžืช, ื›ืœื•ืžืจ ื‘ืจื’ืข ืฉืžืชื—ื™ื™ื‘ื™ื ืฉื™ื ื•ื™ื™ื ื‘ืžื—ืกืŸ ื”ื ืชื•ื ื™ื, ืื™ื ื“ืงืกื™ ื”ื—ื™ืคื•ืฉ ืžืชืขื“ื›ื ื™ื.

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื
ืื™ื•ืจ 2. ืฆื™ื ื•ืจ ื ืชื•ื ื™ื ื‘ืืžืฆืขื•ืช ื“ืœืชื
ื‘ืกืขื™ืคื™ื ื”ื‘ืื™ื ื ืชืืจ ืืช ืคืขื•ืœืช ื”-Delta-Connector ื”ืžืชื—ื‘ืจ ืœืื—ืกื•ืŸ ื•ืžืคืจืกื ืื™ืจื•ืขื™ CDC ืœืฉื›ื‘ืช ื”ืชืขื‘ื•ืจื”, ืฉื”ื™ื ืชืฉืชื™ืช ื”ืขื‘ืจืช ื ืชื•ื ื™ื ื‘ื–ืžืŸ ืืžืช ื”ืžื ืชื‘ืช ืื™ืจื•ืขื™ CDC ืœื ื•ืฉืื™ ืงืคืงื. ื•ื‘ืกื•ืฃ, ื ื“ื‘ืจ ืขืœ ืžืกื’ืจืช ืขื™ื‘ื•ื“ ื”ื–ืจื ืฉืœ Delta, ืืฉืจ ืžืคืชื—ื™ ืืคืœื™ืงืฆื™ื•ืช ื™ื›ื•ืœื™ื ืœื”ืฉืชืžืฉ ื‘ื” ืœืขื™ื‘ื•ื“ ื ืชื•ื ื™ื ื•ืœื•ื’ื™ืงืช ื”ืขืฉืจื”.

CDC (Change-Data-Capture)

ืคื™ืชื—ื ื• ืฉื™ืจื•ืช CDC ื‘ืฉื Delta-Connector, ืฉื™ื›ื•ืœ ืœืœื›ื•ื“ ืฉื™ื ื•ื™ื™ื ืžื—ื•ื™ื‘ื™ื ืžืžืื’ืจ ื”ื ืชื•ื ื™ื ื‘ื–ืžืŸ ืืžืช ื•ืœื›ืชื•ื‘ ืื•ืชื ืœื–ืจื. ืฉื™ื ื•ื™ื™ื ื‘ื–ืžืŸ ืืžืช ื ืœืงื—ื™ื ืžื™ื•ืžืŸ ื”ืขืกืงืื•ืช ื•ืžืžื–ื™ืžื•ืช ื”ืื—ืกื•ืŸ. ื ืขืฉื” ืฉื™ืžื•ืฉ ื‘-Dumps ืžื›ื™ื•ื•ืŸ ืฉื‘ื“ืจืš ื›ืœืœ ื™ื•ืžื ื™ ื”ืขืกืงืื•ืช ืื™ื ื ืžืื—ืกื ื™ื ืืช ื›ืœ ื”ื™ืกื˜ื•ืจื™ื™ืช ื”ืฉื™ื ื•ื™ื™ื. ืฉื™ื ื•ื™ื™ื ืžืกื•ื“ืจื™ื ื‘ื“ืจืš ื›ืœืœ ื›ืื™ืจื•ืขื™ ื“ืœืชื, ื›ืš ืฉื”ื ืžืขืŸ ืœื ืฆืจื™ืš ืœื“ืื•ื’ ืžื”ื™ื›ืŸ ืžื’ื™ืข ื”ืฉื™ื ื•ื™.

Delta-Connector ืชื•ืžืš ื‘ืžืกืคืจ ืชื›ื•ื ื•ืช ื ื•ืกืคื•ืช ื›ื’ื•ืŸ:

  • ื™ื›ื•ืœืช ืœื›ืชื•ื‘ ื ืชื•ื ื™ ืคืœื˜ ืžื•ืชืืžื™ื ืื™ืฉื™ืช ืžืขื‘ืจ ืœืงืคืงื.
  • ื™ื›ื•ืœืช ืœื”ืคืขื™ืœ dumps ื™ื“ื ื™ ื‘ื›ืœ ืขืช ืขื‘ื•ืจ ื›ืœ ื”ื˜ื‘ืœืื•ืช, ื˜ื‘ืœื” ืกืคืฆื™ืคื™ืช ืื• ืขื‘ื•ืจ ืžืคืชื—ื•ืช ืจืืฉื™ื™ื ืกืคืฆื™ืคื™ื™ื.
  • ืืคืฉืจ ืœืงื—ืช ืืช ื”ืžื–ื‘ืœื•ืช ื‘ื—ืชื™ื›ื•ืช, ื›ืš ืฉืื™ืŸ ืฆื•ืจืš ืœื”ืชื—ื™ืœ ืžื—ื“ืฉ ื‘ืžืงืจื” ืฉืœ ื›ื™ืฉืœื•ืŸ.
  • ืื™ืŸ ืฆื•ืจืš ืœื”ืฆื™ื‘ ืžื ืขื•ืœื™ื ืขืœ ื˜ื‘ืœืื•ืช, ื•ื–ื” ื—ืฉื•ื‘ ืžืื•ื“ ื›ื“ื™ ืœื”ื‘ื˜ื™ื— ืฉืชืขื‘ื•ืจืช ื”ื›ืชื™ื‘ื” ืฉืœ ืžืกื“ ื ืชื•ื ื™ื ืœืขื•ืœื ืœื ืชื™ื—ืกื ืขืœ ื™ื“ื™ ื”ืฉื™ืจื•ืช ืฉืœื ื•.
  • ื–ืžื™ื ื•ืช ื’ื‘ื•ื”ื” ืขืงื‘ ืžื•ืคืขื™ื ืžื™ื•ืชืจื™ื ื‘ืื–ื•ืจื™ ื–ืžื™ื ื•ืช AWS.

ื›ืจื’ืข ืื ื• ืชื•ืžื›ื™ื ื‘-MySQL ื•ื‘-Postgres, ื›ื•ืœืœ ืคืจื™ืกื•ืช ื‘-AWS RDS ื•-Aurora. ืื ื• ืชื•ืžื›ื™ื ื’ื ื‘ืงืกื ื“ืจื” (ืจื‘ ืžืืกื˜ืจ). ืชื•ื›ืœ ืœืžืฆื•ื ืคืจื˜ื™ื ื ื•ืกืคื™ื ืขืœ Delta-Connector ื›ืืŸ ืคื•ืกื˜ ื‘ื‘ืœื•ื’.

ืงืคืงื ื•ืฉื›ื‘ืช ื”ืชื—ื‘ื•ืจื”

ืฉื›ื‘ืช ื”ื•ื‘ืœืช ื”ืื™ืจื•ืขื™ื ืฉืœ ื“ืœืชื ื‘ื ื•ื™ื” ืขืœ ืฉื™ืจื•ืช ื”ื”ื•ื“ืขื•ืช ืฉืœ ื”ืคืœื˜ืคื•ืจืžื” ืื‘ืŸ ืจืืฉื”.

ื”ื™ืกื˜ื•ืจื™ืช, ืคืจืกื•ื ื‘ื ื˜ืคืœื™ืงืก ืขื‘ืจ ืื•ืคื˜ื™ืžื™ื–ืฆื™ื” ืœื ื’ื™ืฉื•ืช ื•ืœื ืœืืจื™ื›ื•ืช ื™ืžื™ื (ืจืื” ืœื”ืœืŸ). ืžืืžืจ ืงื•ื“ื). ื”ืคืฉืจื” ื”ื™ื™ืชื” ื—ื•ืกืจ ืขืงื‘ื™ื•ืช ื‘ื ืชื•ื ื™ ื‘ืจื•ืงืจ ื‘ืชืจื—ื™ืฉื™ ืงืฆื” ืฉื•ื ื™ื. ืœื“ื•ื’ืžื”, ื‘ื—ื™ืจืช ืžื ื”ื™ื’ ืœื ื ืงื™ ืื—ืจืื™ืช ืœื›ืš ืฉืœื ืžืขืŸ ื™ื”ื™ื• ืื™ืจื•ืขื™ื ื›ืคื•ืœื™ื ืื• ืื‘ื“ื•.

ืขื ื“ืœืชื, ืจืฆื™ื ื• ืขืจื‘ื•ื™ื•ืช ืขืžื™ื“ื•ืช ื—ื–ืงื•ืช ื™ื•ืชืจ ื›ื“ื™ ืœื”ื‘ื˜ื™ื— ืžืฉืœื•ื— ืื™ืจื•ืขื™ CDC ืœื—ื ื•ื™ื•ืช ื ื’ื–ืจื•ืช. ืœืฆื•ืจืš ื›ืš, ื”ืฆืขื ื• ืืฉื›ื•ืœ ืงืคืงื ืฉืขื•ืฆื‘ ื‘ืžื™ื•ื—ื“ ื›ืื•ื‘ื™ื™ืงื˜ ืžืžื“ืจื’ื” ืจืืฉื•ื ื”. ืืชื” ื™ื›ื•ืœ ืœื”ืกืชื›ืœ ืขืœ ื›ืžื” ื”ื’ื“ืจื•ืช ื‘ืจื•ืงืจ ื‘ื˜ื‘ืœื” ืœืžื˜ื”:

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื

ื‘ืืฉื›ื•ืœื•ืช ืงื™ื™ืกื˜ื•ืŸ ืงืคืงื, ื‘ื—ื™ืจืช ืžื ื”ื™ื’ ืœื ื ืงื™ ื‘ื“ืจืš ื›ืœืœ ื›ืœื•ืœ ื›ื“ื™ ืœื”ื‘ื˜ื™ื— ื ื’ื™ืฉื•ืช ืœื‘ืขืœื™ ืืชืจื™ื. ื”ื“ื‘ืจ ืขืœื•ืœ ืœื’ืจื•ื ืœืื•ื‘ื“ืŸ ื”ื•ื“ืขื•ืช ืื ื”ืขืชืง ืœื ืžืกื•ื ื›ืจืŸ ื™ื™ื‘ื—ืจ ื›ืžื ื”ื™ื’. ืœืืฉื›ื•ืœ ื—ื“ืฉ ืฉืœ ืงืคืงื ื–ืžื™ื ื•ืช ื’ื‘ื•ื”ื”, ื”ืืคืฉืจื•ืช ื‘ื—ื™ืจืช ืžื ื”ื™ื’ ืœื ื ืงื™ ื›ื‘ื•ื™ ื›ื“ื™ ืœืžื ื•ืข ืื•ื‘ื“ืŸ ื”ื•ื“ืขื•ืช.

ื’ื ื”ื’ื“ืœื ื• ื’ื•ืจื ืฉื›ืคื•ืœ ืž-2 ืขื“ 3 ื• ืžื™ื ื™ืžื•ื ื”ืขืชืงื™ื ืœืกื™ื ื›ืจื•ืŸ 1 ืขื“ 2. ื‘ืขืœื™ ืืชืจื™ื ืฉื›ื•ืชื‘ื™ื ืœืืฉื›ื•ืœ ื–ื” ื“ื•ืจืฉื™ื ืื™ืฉื•ืจื™ื ืžื›ืœ ื”ืื—ืจื™ื, ื›ื“ื™ ืœื”ื‘ื˜ื™ื— ืฉืœ-2 ืžืชื•ืš 3 ื”ืขืชืงื™ื ื™ืฉ ืืช ื”ื”ื•ื“ืขื•ืช ื”ืขื“ื›ื ื™ื•ืช ื‘ื™ื•ืชืจ ืฉื ืฉืœื—ื• ืขืœ ื™ื“ื™ ื”ืžืคืจืกื.

ื›ืืฉืจ ืžื•ืคืข ืžืชื•ื•ืš ืžืกืชื™ื™ื, ืžื•ืคืข ื—ื“ืฉ ืžื—ืœื™ืฃ ืืช ื”ื™ืฉืŸ. ืขื ื–ืืช, ื”ื‘ืจื•ืงืจ ื”ื—ื“ืฉ ื™ืฆื˜ืจืš ืœื”ื“ื‘ื™ืง ืืช ื”ื”ืขืชืงื™ื ื”ืœื ืžืกื•ื ื›ืจื ื™ื, ืžื” ืฉืขืฉื•ื™ ืœื”ื™ืžืฉืš ืžืกืคืจ ืฉืขื•ืช. ื›ื“ื™ ืœืฆืžืฆื ืืช ื–ืžืŸ ื”ื”ืชืื•ืฉืฉื•ืช ืขื‘ื•ืจ ืชืจื—ื™ืฉ ื–ื”, ื”ืชื—ืœื ื• ืœื”ืฉืชืžืฉ ื‘ืื—ืกื•ืŸ ื ืชื•ื ื™ื ื‘ืœื•ืง (Amazon Elastic Block Store) ื‘ืžืงื•ื ื‘ื“ื™ืกืงื™ื ืžืงื•ืžื™ื™ื ืฉืœ ื‘ืจื•ืงืจ. ื›ืืฉืจ ืžื•ืคืข ื—ื“ืฉ ืžื—ืœื™ืฃ ืžื•ืคืข ื‘ืจื•ืงืจ ืฉื”ื•ืคืกืง, ื”ื•ื ืžืฆืจืฃ ืืช ื ืคื— ื”-EBS ืฉื”ื™ื” ืœืžื•ืคืข ืฉื”ื•ืคืกืง ื•ืžืชื—ื™ืœ ืœื”ื“ื‘ื™ืง ื”ื•ื“ืขื•ืช ื—ื“ืฉื•ืช. ืชื”ืœื™ืš ื–ื” ืžืงื˜ื™ืŸ ืืช ื–ืžืŸ ืคื™ื ื•ื™ ื”ืขื•ืžืก ืžืฉืขื•ืช ืœื“ืงื•ืช ืžื›ื™ื•ื•ืŸ ืฉื”ืžื•ืคืข ื”ื—ื“ืฉ ื›ื‘ืจ ืœื ืฆืจื™ืš ืœืฉื›ืคืœ ืžืžืฆื‘ ืจื™ืง. ื‘ืื•ืคืŸ ื›ืœืœื™, ืžื—ื–ื•ืจื™ ื—ื™ื™ื ื ืคืจื“ื™ื ืฉืœ ืื—ืกื•ืŸ ื•ืชื™ื•ื•ืš ืžืคื—ื™ืชื™ื ืžืฉืžืขื•ืชื™ืช ืืช ื”ื”ืฉืคืขื” ืฉืœ ืžืขื‘ืจ ืžืชื•ื•ืš.

ื›ื“ื™ ืœื”ื’ื“ื™ืœ ืขื•ื“ ื™ื•ืชืจ ืืช ืขืจื‘ื•ืช ืžืกื™ืจืช ื”ื ืชื•ื ื™ื, ื”ืฉืชืžืฉื ื• ืžืขืจื›ืช ืžืขืงื‘ ืื—ืจ ื”ื•ื“ืขื•ืช ื›ื“ื™ ืœื–ื”ื•ืช ืื•ื‘ื“ืŸ ื”ื•ื“ืขื” ื‘ืชื ืื™ื ืงื™ืฆื•ื ื™ื™ื (ืœื“ื•ื’ืžื”, ื‘ื™ื˜ื•ืœ ืกื ื›ืจื•ืŸ ืฉืขื•ืŸ ื‘ืžื•ื‘ื™ืœ ื”ืžื—ื™ืฆื”).

ืžืกื’ืจืช ืขื™ื‘ื•ื“ ื–ืจื

ืฉื›ื‘ืช ื”ืขื™ื‘ื•ื“ ืฉืœ ื“ืœืชื ื‘ื ื•ื™ื” ืขืœ ื’ื‘ื™ ืคืœื˜ืคื•ืจืžืช Netflix SPaaS, ื”ืžืกืคืงืช ืื™ื ื˜ื’ืจืฆื™ื” ืฉืœ Apache Flink ืขื ื”ืžืขืจื›ืช ื”ืืงื•ืœื•ื’ื™ืช ืฉืœ Netflix. ื”ืคืœื˜ืคื•ืจืžื” ืžืกืคืงืช ืžืžืฉืง ืžืฉืชืžืฉ ื”ืžื ื”ืœ ืืช ื”ืคืจื™ืกื” ืฉืœ ืžืฉืจื•ืช Flink ื•ืชื–ืžื•ืจ ืฉืœ ืืฉื›ื•ืœื•ืช Flink ืขืœ ื’ื‘ื™ ืคืœื˜ืคื•ืจืžืช ื ื™ื”ื•ืœ ื”ืžื›ื•ืœื” Titus ืฉืœื ื•. ื”ืžืžืฉืง ื’ื ืžื ื”ืœ ืชืฆื•ืจื•ืช ืขื‘ื•ื“ื” ื•ืžืืคืฉืจ ืœืžืฉืชืžืฉื™ื ืœื‘ืฆืข ืฉื™ื ื•ื™ื™ ืชืฆื•ืจื” ื‘ืื•ืคืŸ ื“ื™ื ืžื™ ืœืœื ืฆื•ืจืš ืœื”ื“ืจ ืžื—ื“ืฉ ืขื‘ื•ื“ื•ืช Flink.

Delta ืžืกืคืงืช ืžืกื’ืจืช ืœืขื™ื‘ื•ื“ ื–ืจื ื”ืžื‘ื•ืกืกืช ืขืœ Flink ื•-SPaaS ื”ืžืฉืชืžืฉืช ืžื‘ื•ืกืก ื”ืขืจื•ืช DSL (ืฉืคื” ืกืคืฆื™ืคื™ืช ืœืชื—ื•ื) ืœืคืจื˜ื™ื ื˜ื›ื ื™ื™ื ืžื•ืคืฉื˜ื™ื. ืœื“ื•ื’ืžื”, ื›ื“ื™ ืœื”ื’ื“ื™ืจ ืืช ื”ืฉืœื‘ ืฉื‘ื• ื™ื•ืขืฉืจื• ืื™ืจื•ืขื™ื ืขืœ ื™ื“ื™ ืงืจื™ืื” ืœืฉื™ืจื•ืชื™ื ื—ื™ืฆื•ื ื™ื™ื, ื”ืžืฉืชืžืฉื™ื ืฆืจื™ื›ื™ื ืœื›ืชื•ื‘ ืืช ื”-DSL ื”ื‘ื, ื•ื”ืžืกื’ืจืช ืชื™ืฆื•ืจ ืขืœ ื‘ืกื™ืกื• ืžื•ื“ืœ ืฉื™ื‘ื•ืฆืข ืขืœ ื™ื“ื™ Flink.

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื
ืื™ื•ืจ 3. ื“ื•ื’ืžื” ืœื”ืขืฉืจื” ื‘-DSL ื‘ื“ืœืชื

ืžืกื’ืจืช ื”ืขื™ื‘ื•ื“ ืœื ืจืง ืžืคื—ื™ืชื” ืืช ืขืงื•ืžืช ื”ืœืžื™ื“ื”, ืืœื ื’ื ืžืกืคืงืช ืชื›ื•ื ื•ืช ื ืคื•ืฆื•ืช ืฉืœ ืขื™ื‘ื•ื“ ื–ืจื ื›ื’ื•ืŸ ืžื ื™ืขืช ื›ืคื™ืœื•ื™ื•ืช, ืกื›ืžื˜ื™ื–ืฆื™ื” ื•ื’ืžื™ืฉื•ืช ื•ื’ืžื™ืฉื•ืช ืœืคืชืจื•ืŸ ื‘ืขื™ื•ืช ืชืคืขื•ืœื™ื•ืช ื ืคื•ืฆื•ืช.

Delta Stream Processing Framework ืžื•ืจื›ื‘ืช ืžืฉื ื™ ืžื•ื“ื•ืœื™ื ืžืจื›ื–ื™ื™ื, ืžื•ื“ื•ืœ DSL & API ื•ืžื•ื“ื•ืœ ื–ืžืŸ ืจื™ืฆื”. ืžื•ื“ื•ืœ ื”-DSL & API ืžืกืคืง ืžืžืฉืงื™ API ืฉืœ DSL ื•-UDF (User-Defined-Function) ื›ืš ืฉืžืฉืชืžืฉื™ื ื™ื›ื•ืœื™ื ืœื›ืชื•ื‘ ืœื•ื’ื™ืงืช ืขื™ื‘ื•ื“ ืžืฉืœื”ื (ื›ื’ื•ืŸ ืกื™ื ื•ืŸ ืื• ื˜ืจื ืกืคื•ืจืžืฆื™ื•ืช). ืžื•ื“ื•ืœ Runtime ืžืกืคืง ื™ื™ืฉื•ื ืฉืœ ืžื ืชื— DSL ื”ื‘ื•ื ื” ื™ื™ืฆื•ื’ ืคื ื™ืžื™ ืฉืœ ืฉืœื‘ื™ ืขื™ื‘ื•ื“ ื‘ืžื•ื“ืœื™ื ืฉืœ DAG. ืจื›ื™ื‘ ื”ื‘ื™ืฆื•ืข ืžืคืจืฉ ืžื•ื“ืœื™ื ืฉืœ DAG ื›ื“ื™ ืœืืชื—ืœ ืืช ื”ืฆื”ืจื•ืช Flink ื‘ืคื•ืขืœ ื•ื‘ืกื•ืคื• ืฉืœ ื“ื‘ืจ ืœื”ืคืขื™ืœ ืืช ืืคืœื™ืงืฆื™ื™ืช Flink. ื”ืืจื›ื™ื˜ืงื˜ื•ืจื” ืฉืœ ื”ืžืกื’ืจืช ืžื•ืžื—ืฉืช ื‘ืื™ื•ืจ ื”ื‘ื.

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื
ืื™ื•ืจ 4. ืืจื›ื™ื˜ืงื˜ื•ืจืช ืžืกื’ืจืช ืขื™ื‘ื•ื“ ื–ืจื Delta

ืœื’ื™ืฉื” ื–ื• ืžืกืคืจ ื™ืชืจื•ื ื•ืช:

  • ืžืฉืชืžืฉื™ื ื™ื›ื•ืœื™ื ืœื”ืชืžืงื“ ื‘ืœื•ื’ื™ืงื” ื”ืขืกืงื™ืช ืฉืœื”ื ืžื‘ืœื™ ืœื”ื™ื“ืจืฉ ืœืคืจื˜ื™ื ื”ืกืคืฆื™ืคื™ื™ื ืฉืœ Flink ืื• ืžื‘ื ื” SPaaS.
  • ื ื™ืชืŸ ืœื‘ืฆืข ืื•ืคื˜ื™ืžื™ื–ืฆื™ื” ื‘ืื•ืคืŸ ืฉืงื•ืฃ ืœืžืฉืชืžืฉื™ื, ื•ื ื™ืชืŸ ืœืชืงืŸ ืฉื’ื™ืื•ืช ืœืœื ืฆื•ืจืš ื‘ืฉื™ื ื•ื™ื™ื ื‘ืงื•ื“ ื”ืžืฉืชืžืฉ (UDF).
  • ื—ื•ื•ื™ืช ืืคืœื™ืงืฆื™ื™ืช Delta ืžืคื•ืฉื˜ืช ืœืžืฉืชืžืฉื™ื ืžื›ื™ื•ื•ืŸ ืฉื”ืคืœื˜ืคื•ืจืžื” ืžืกืคืงืช ื’ืžื™ืฉื•ืช ื•ื’ืžื™ืฉื•ืช ืžื—ื•ืฅ ืœืงื•ืคืกื” ื•ืื•ืกืคืช ืžื’ื•ื•ืŸ ืžื“ื“ื™ื ืžืคื•ืจื˜ื™ื ืฉื ื™ืชืŸ ืœื”ืฉืชืžืฉ ื‘ื”ื ืœื”ืชืจืื•ืช.

ืฉื™ืžื•ืฉ ื‘ื™ื™ืฆื•ืจ

ื“ืœืชื ื ืžืฆืืช ื‘ื”ืคืงื” ื™ื•ืชืจ ืžืฉื ื” ื•ืžืžืœืืช ืชืคืงื™ื“ ืžืคืชื— ื‘ื™ื™ืฉื•ืžื™ Netflix Studio ืจื‘ื™ื. ื”ื™ื ืขื–ืจื” ืœืฆื•ื•ืชื™ื ืœื™ื™ืฉื ืžืงืจื™ ืฉื™ืžื•ืฉ ื›ื’ื•ืŸ ืื™ื ื“ืงืก ื—ื™ืคื•ืฉ, ืื—ืกื•ืŸ ื ืชื•ื ื™ื ื•ื–ืจื™ืžื•ืช ืขื‘ื•ื“ื” ืžื•ื ื—ื•ืช ืื™ืจื•ืขื™ื. ืœื”ืœืŸ ืกืงื™ืจื” ื›ืœืœื™ืช ืฉืœ ื”ืืจื›ื™ื˜ืงื˜ื•ืจื” ื‘ืจืžื” ื’ื‘ื•ื”ื” ืฉืœ ืคืœื˜ืคื•ืจืžืช ื“ืœืชื.

ื“ืœืชื: ืคืœื˜ืคื•ืจืžืช ืกื ื›ืจื•ืŸ ื•ื”ืขืฉืจื” ื ืชื•ื ื™ื
ืื™ื•ืจ 5. ื”ืืจื›ื™ื˜ืงื˜ื•ืจื” ื‘ืจืžื” ื’ื‘ื•ื”ื” ืฉืœ ื“ืœืชื.

ืชื•ื“ื•ืช

ื‘ืจืฆื•ื ื ื• ืœื”ื•ื“ื•ืช ืœืื ืฉื™ื ื”ื‘ืื™ื ืฉื”ื™ื• ืžืขื•ืจื‘ื™ื ื‘ื™ืฆื™ืจื” ื•ื‘ืคื™ืชื•ื— ืฉืœ ื“ืœืชื ื‘ื ื˜ืคืœื™ืงืก: ืืœืŸ ื•ื•ืื ื’, ืฆ'ืืจืœืก ื–'ืื•, ื’'ื‘ื™ืŸ ื™ื•ืŸ, ื’'ื•ืฉ ืกื ื™ื™ื“ืจ, ืงืกื˜ื•ืจื™ ืฆ'ืื˜ืจื’'ื™, ืžืืจืง ืฆ'ื•, ืื•ืœื•ืฃ ื’'ื•ื”ื ืกื•ืŸ, ืคื™ื•ืฉ ื’ื•ื™ืืœ, ืคืจืืฉื ืช' ืจืžื“ืืก, ืจื’'ื•ืจืื ืื•ื ื˜ื™ Srinivasan, Sandeep Gupta, Steven Wu, Tharanga Gamaethige, Yun Wang ื•-Zhenzhong Xu.

ืžืงื•ืจื•ืช

  1. dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
  2. dev.mysql.com/doc/refman/5.7/en/cannot-roll-back.html
  3. Martin Kleppmann, Alastair R. Beresford, Boerge Svingen: ืขื™ื‘ื•ื“ ืื™ืจื•ืขื™ื ืžืงื•ื•ืŸ. Commun. ACM 62(5): 43โ€“49 (2019). DOI: doi.org/10.1145/3312527

ื”ื™ืจืฉื ืœืกืžื™ื ืจ ืžืงื•ื•ืŸ ื‘ื—ื™ื ื: "ื›ืœื™ ืœื‘ื ื™ื™ืช ื ืชื•ื ื™ื ืขื‘ื•ืจ ืื—ืกื•ืŸ ืืžื–ื•ืŸ ืœืื“ื•ื."

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

ื”ื•ืกืคืช ืชื’ื•ื‘ื”