TL;DR;
- Amazon Auroraã¯In-Memory DBã§ããªãDisk-Oriented DBã§ããªããIn-KVS DBãšã§ãåŒã¶ã¹ãæ°å°å¹³ã«ç«ã£ãŠããã
- ãã®æ¬æ°ãããããã¹ã¿ãŒã®ã¡ã€ã³ã¡ã¢ãªã¯ãã£ãã·ã¥ã§ãããªããWrite-Backã§ããªãWrite-Throughã§ããªããšããé©å€©åå°ã
- ã€ãã§ã«åŸæ¥ã®ãã§ãã¯ãã€ã³ãåŠçãäžèŠã«ãªã£ãã®ã§ã¹ã«ãŒããããåäžããã
- è©³çŽ°ãæ°ã«ãªã人ã¯ãã®èšäºããã§ãïŒ
Amazon Aurora
Amazon Auroraã¯AWSã®äžã§å©çšå¯èœãªãããŒãžã(ïŒéçšãAWSãé¢åèŠãŠããã)ãªããŒã¿ããŒã¹ãµãŒãã¹ã
ãŠãŒã¶ãŒããã¯ãã ã®MySQLããããã¯PostgreSQLãšããŠæ±ãäºãã§ããã®ã§ãããã«äŸåããæ¢åã®ã¢ããªã±ãŒã·ã§ã³è³ç£ããã®ãŸãŸå©çšããäºãã§ããŠãèœã¡ããåèµ·åãããã»ãã¥ãªãã£ããããããŠã³ã¿ã€ã ãªãã§(!?)é©çšããããªã©ãªã©ã»ãŒã«ã¹ããŒã¯ãæãã ããšããªããªããã©ãåã¯AWSãããéãè²°ã£ãŠããããã§ã¯ãªãã®ã§ããã¯æ§ããã«ããŠAuroraã§ã®ãã©ã³ã¶ã¯ã·ã§ã³ã®æ°žç¶æ§ã«ã€ããŠè«æããåããç¯å²ãšæ³åã§è£ã£ãå
容ã説æããŠããã
Auroraã®ã¢ãŒããã¯ãã£
AWSã®å ¬åŒè³æãåã£ãŠããã°ãããã§ãããã£ãœãå³ã¯ãããã説æã«åãããŠå¿ èŠãªéšåã ãåãã ããã
AZãšã¯Availability Zoneã®äºã§ãAWSã®ããŒã¿ã»ã³ã¿ãŒã§é害ãçºçããå Žåã«å¥ã®æ éåäœã«ãªãããèšèšãããŠãããŠãããã®äºã§ãããç©ççã«ã¯éšå±ãåãããŠããã®ã建ç©ãåãããŠããã®ãããããªããã黿ºãã¹ã€ããã¯ç¢ºå®ã«ç³»çµ±ãåãããŠããããã«ãŠã§ã¢ã®ããŒãžã§ã³ã¢ãããªã©ãåãããŠãããšãããããããŸããã圢ã§Masterãäžã€ãšSlaveãè€æ°(æå€§15å°)ç«ã¡äžãããMasterã¯DBã«å¯Ÿããèªã¿æžãäž¡æ¹ãã§ããããSlaveã¯èªã¿åºãããã§ããªããå žåçãªWebãµãŒãã¹ã¯èªã¿åºããè² è·ã®å€ããå ããã®ã§èªã¿åºãå¯èœãªè€è£œãè€æ°çšæã§ããã®ã¯çã«é©ã£ãŠããã
ãã®ããããã®ã³ã³ããŒãã³ããç¹ãç¢å°ã¯Redo-Logã衚ããŠãããRedo-Logãšã¯ãç¹å®ã®ããŒãžãæžãæããæäœãšãã®å
容ããèšè¿°ãããDBãã°ã®æå°åäœã§ãããäžè¬ã«DBãè€è£œãããšèšããšèªã¿æžããããããããããŒã¿ãè€è£œããããã®ã§ãããAuroraã§ã¯ãã®Redo-Logããè€è£œããªãç¹ãé¢çœããè«æäžã« THE LOG IS THE DATABASE ãšã§ã£ããæžããŠããã®ã¯æãããã®èŸºã«ç±æ¥ããã
Masterã¯æ®éã®MySQL(ãããã¯PostgreSQL)ãµãŒãã®ããã«èŠããŠãŒã¶ããèªã¿æžãããªã¯ãšã¹ãã§ããã
InnoDBã®ä»£ããã®ããã¯ãšã³ãã®ããŒã¿ã¹ãã¢ãšããŠåæ£KVSã皌åããŠããããã®åæ£KVSã¯AZãè·šã£ã6å€éã«åé·åãããŠãããè«æäžã§ã¯KVSã ãªããŠäžèšãæžããŠããªããã¹ãã¬ãŒãžããã¯ãšã³ãã®èª¬æãšããŠçè§£ããããã®ã§ãããŠKVSã«å©ããŠèª¬æããŠããã
6å€éã®ãã¡4ã€ã«ãŸã§ä¿åã§ããæ®µéã§æ°žç¶åå®äºãšèŠãªããŠãŒã¶ã«è¿çããäºã§ã¬ã€ãã³ã·ã®ççž®ãå³ã£ãŠãããã·ã¹ãã ã¯ããããªãã€ãºã§é
ããããå
šäœã®è¶³ãåŒã£åŒµã£ãŠåŸéããã¯æ±ºãŸã£ãŠstrugglerã§ããã90ããŒã»ã³ã¿ã€ã«ãããã§ããã°å§åçã«æ©æã«è¿äºãè¿ããŠããã®ã¯å·šå€§ã·ã¹ãã ã®åžžã§ããã
å
šéšã®è€è£œãå
šãåãæ
å ±ãæã£ãŠããªããšãããªãã®ã§ãä»®ã«ãã°ãåãããŒããè€è£œããããšããŠãMasterã«èãçŽããè€è£œå士ã§Gossipéä¿¡ãè¡ã£ãŠå
šéšã®ãã°ãå
šå¡ãåãåãããã«åãèšããã
ãã®èŸºã®è©±ã¯AWSã®äººã®å
¬åŒã¹ã©ã€ãã«ãè
ãã»ã©åºãŠããã®ã§åã¯è©³ãã説æããªãã
ãã©ã³ã¶ã¯ã·ã§ã³ã®æåã®éã
ã©ããã®DBã«ãšã£ãŠæ¥µç«¯ã«éœåãè¯ãã¯ãŒã¯ããŒãã§æ¯èŒããŠãåãªãã»ãŒã«ã¹ããŒã¯ã«ãããªããªãã
è€æ°ã®æ¹åŒã®DBãæçœã«ç°ãªãæåãããå
žåäŸã®ã¯ãŒã¯ããŒããšããŠã巚倧ããŒãã«ã®å
šéšã®è¡ã®ç¹å®ã®ãã©ã°ãç«ãŠãããšãããã©ã³ã¶ã¯ã·ã§ã³ãäŸã«æããŠäŒçµ±çãªDisk-Oriented DBã»In-Memory DBã»Auroraã®åäœãé ã«èª¬æããã

SQLæãšããŠã¯ãããªæãã§ããã
UPDATE table1 SET flag = true;
ãªããã®table1ã¯ãã®ãããè¡æ°ãå€ãïŒïŒçžŠã«é·ãïŒãšããã
Disk-Oriented DBã®æå
ãŸã巚倧ããŒãã«å šäœãäžæ°ã«ã¡ã¢ãªã«çœ®ãã¢ãŒããã¯ãã£ã«ã¯ãªã£ãŠããããã¡ã¢ãªäžã«çšæããããŒã¿ããŒã¹ããŒãžé åã«Diskäžã®DBã®äžéšãè€è£œããŠããæããå§ãŸãããããŸã§ã¯MySQLã§ãPostgreSQLã§ãåãã¯ãããã®æèã§ã®ããŒãžãšã¯DBã®äžèº«ã®äžéšã(MySQLãªãããã©ã«ãã§)16KBã®å€§ããæ¯ã«è©°ã蟌ãŸããé£ç¶ããã¡ã¢ãªé åã§ãããOSãæäŸããã¡ã¢ãªãºãŒãžãšã¯å°ãéãã(ã¡ãªã¿ã«PostgreSQLã®ããã©ã«ãããŒãžãµã€ãºã¯8KBïŒ
Diskäžã®å šåããŒã¿ãçŽæ¥äžç¬ã§æžãæããããšã¯åœç¶ã§ããªãã®ã§ãçãã¡ã¢ãªç©ºéã§LRUçãçšããŠåãåããªããæžã蟌ã¿ã®çµãã£ãæªã³ããããªããŒãã£ããŒãžããã£ã¹ã¯ã«æžãæ»ããªããé²è¡ããä»ãªã1ãã ããããªããšããããšããã®ç¬éã«DBã®ããã»ã¹ã匷å¶çµäºããŠãªã¹ã¿ãŒãããæã«æªã³ããããªããŒãã£ããŒãžããã£ã¹ã¯äžããèªã¿åºãå¯èœãªç¶æ ã§èŠ³æž¬ãããæãããããããã§ã¯ACIDã®ãã¡Aã«éåããŠããŸããããã§åDBã¯åã®ç¥ãéã以äžã®æåããšãã
ARIES
é²è¡ããªããRedo-Undo logããã£ã¹ã¯ã«æ°žç¶åããããéäžã§ã·ã¹ãã ããªã¹ã¿ãŒãããæã¯ãªã«ããªãšããŠUndoåŠçãè¡ãã

ãã®å³ã§èšããšããŒãž1ã¯æªã³ããããªãã©ã³ã¶ã¯ã·ã§ã³ã«ãã£ãŠæ¢ã«æžãæããããŠããããUndo-Redo Logã®åœ¢ã§æ¢ã«WALãæ°žç¶åããŠããã®ã§ãªã«ããªå¯èœã§ããããŒãã£ãªããŒãžã¯ãã®ãŸãŸãã£ã¹ã¯ã«æ°žç¶åããŠæ§ããªãããªã®ã§æ°žç¶åããŠç©ºããBuffer Poolã®ã¹ããŒã¹ã«æ¬¡ã«æŽæ°ãããããŒãž5ããã§ããããŠããäºãã§ããã
PostgreSQL
ãäžæžãã¯åžžã«æ°ããªããŒãžã§ã³ã§ã®è¿œèšæäœã§ãããclogãšããããŒã¿ã§ä¿åãããŠãããã©ã³ã¶ã¯ã·ã§ã³ã¹ããŒã¿ã¹ã commited ã§ãªãéãèªã¿åºãã§ããªãããããã£ãŠçè·¡ã¯ç©ççã«ããŒãžã«æ®ããããŒã¿ããŒã¹ã®ãŠãŒã¶ããã¯äžå¯èŠã§ããåé¡ã«ãªããããããããã¥ãŒã ãããŠç©ççã«ãæ¶å€±ããã
ãã®å³ã§ãããšãããŒãž1ã¯ç©ççã«ã¯ããŒãã£ã ã远èšããããŠããã ãã§ããclogã®ãé°ã§è«ççã«ä»ã®ãã©ã³ã¶ã¯ã·ã§ã³ããèŠããªãããªã®ã§ãã®ãŸãŸãã£ã¹ã¯ã«æ°žç¶åãããŠãåé¡ãçºçããªãã®ã§ããããŠãããã¡ããŒã«ãããã®ãŸãŸããŒãž1ã远ãåºããŠã空ããé åã«ããŒãž5ããã§ããããŠããäºãã§ããã
MySQL
ibdataã®äžã«æŽæ°åã®å€ãä¿åãããŠããããã£ã¹ã¯ã«æžãæ»ãããéã«ã¯ãã¡ããæ°žç¶åãããã®ã§ããªã¹ã¿ãŒãæã®ãªã«ããªåŠçã§ibdataãšããŒãã«ããŒã¿ãçªãåãããŠå¯èŠãªããŒã¿ããŠãŒã¶ããèŠããããã«æŽåæ§ãä¿ã€ïŒè©³ãããªããå€åïŒã
ãããã«ããããã©ã³ã¶ã¯ã·ã§ã³ãèµ°ããªãããã°ãèšè¿°ããŠããäºã¯å ±éããŠããã
In-Memory DBã®æå
å
šéšã®ããŒã¿ãã¡ã¢ãªã«åãŸãåæã眮ããŠè¯ãã®ã§ãã¡ãã¯ã ãã¶ã·ã³ãã«ã«åãŸãã
é²è¡éäžã§ãã°ãæžãåºãå¿
èŠã¯ç¡ããããããã¡ã®äžã§LRUçãçšããŠã©ã®ããŒãžããã£ã¹ã¯ã«æžãæ»ãããªã©ãå¿é
ããªããŠããã
ãã©ã³ã¶ã¯ã·ã§ã³ãã°ãæžãåºãã¿ã€ãã³ã°ã¯å
žåçãªå®è£
ãšããŠã¯ã³ãããæã«äžæ°ã«æžãåºãäºãå€ãããã ã
ãªã¹ã¿ãŒãæã¯ãã°ããŒã¿ãã¹ãã£ã³ããŠããŒã¿ããŒã¹ãåæ§ç¯ããã®ã§ããŠãŒã¶ãã commit ãåœããããŠããªããã©ã³ã¶ã¯ã·ã§ã³ã¯ãã°ã«ããæ®ã£ãŠããããããŒãã£ããŒãžã¯ããããæŠå¿µãååšããªãã
Auroraã®æå
ã¡ã¢ãªã«ãããŒã«ã«ã®ãã£ã¹ã¯ã«ãããŒãã«å
šäœãå
¥ããããªãåæã§èšèšãããŠããã
ãã©ã³ã¶ã¯ã·ã§ã³ã®éœåäžå¿
èŠãªããŒãžãMasterã®ã¡ã¢ãªã§éè¯ããã£ãã·ã¥ã§ããŠããªãå ŽåãKVSã«åãåãããè¡ãããŒãžãæã£ãŠããã
ãªããKVSã¯ç©ççã«ã¯6å€éã§ä¿åããŠãããè«ççã«ã¯äžã€ã®ããŒã¿ã6éã«ä¿åãããŠããã ããªã®ã§è«ççã«ã¯1ã€ã®ã¹ãã¬ãŒãžé åãšèããŠè¯ã(RAID1ãè«ççã«ã¯åäžã®HDDæ±ãããã®ãšåæ§)ã®ã§ããæžãã
èµ°ããªããåœç¶ãã°ãæ°žç¶åããŠããã6å€éã§ä¿åãããã®ã¯ãã°ãåãã ãåè¿°ããããã«é©ãã¹ãäºã«Redo-logããä¿åããŠãããªãã
åœç¶Masterã®ã¡ã¢ãªã«ã¯å
šããŒã¿ä¹ããªãã®ã§ãã©ãã«ãããŠåŠççšã«ã¡ã¢ãªãåãåãå¿
èŠãããã
ããã§Masterã¯äžçªäœ¿ããªããšå€æããããŒãžãKVSã«æžãæ»âŠããã«æšãŠããããããäžåºŠèšããæšãŠãã®ã ããã£ãã·ã¥ãªã®ã«ã
ãããªããšããããKVSã«èŒã£ãããŒãžã¯å€ããŸãŸãããªãããšå¿é
ã«ãªãããAuroraã®åæ£KVSã¯åãªãã¹ãã¬ãŒãžã§ã¯ãªããŠAuroraçšã®å°çšã®ããžãã¯ãé§åããã€ã³ããªãžã§ã³ããªåæ£KVSã§ããã
ããã€ãã¯Masterããåãåã£ãRedo-Logãå¿
èŠã«å¿ããŠæå
ã®ããŒãžã«é©çš(Apply)ããŠããäºãã§ãã2ã
ãªãã§ãã£ããäœã£ãæŽæ°æžã¿Page1ãæšãŠãŠãŸã§æ°ãã«KVSåŽã§ãã°ãé©çšãçŽãããšãããšãåºæ¬çã«AWSã«ãããŠMasterã®CPUããããã¯ãŒã¯è³æºã¯éããããªãœãŒã¹ã§ããäžæ¹ãKVSåŽã®CPUã¯çžå¯Ÿçã«æãŠäœãããªãœãŒã¹ã§ããå®ãããšãããã«ã¯åŸã«è¿°ã¹ããã§ãã¯ãã€ã³ãã®ç°¡æœãã®ããã«å®å
šã«åæ£KVSåŽã«åããèšèšãè¡ã£ãŠããããã«èŠããã
MasterããKVSãžã¯Redo-logããæµããªãããKVSããMasterãžã¯ããŒãžããæµããªããå§åçã«ã·ã¹ãã ãç°¡åã«ãªã£ãã
MasterãããŒãžãåãåãããå ŽåãããŒãžã§ã³çªå·ãã»ããã§åãåãããã®ã§ãããŸã§ã«æãã€ããRedo-logãKVSåŽã§é©çšããææ°ãã«ãã«ã®ããŒãžãè¿ã£ãŠããã®ã§Masterã¯æå
ã®ã¡ã¢ãªã«ä¹ã£ãŠããããŒãã£ãªããŒãžãæ°å
Œããªãä»»æã®ã¿ã€ãã³ã°ã§æšãŠãŠæ§ããªããåãåããã®éã¯ãã©ã³ã¶ã¯ã·ã§ã³ã®èå¥åãå
¥ããŠåŒããŠããã®ã§ãèªãã§ã¯ãããªãDirtyãªããŒãžãç²åŸããããšã¯ãªããSlaveãããŒãžãåãåãããå Žåã¯å¿
ãæ°žç¶åãããããŒãžã§ã³ã®ãã®ã ããèªãããã«ããŠããã
ã€ãã§ã«èšããšSlaveã®ããŒãžã¯Masterã6å€éãªåæ£KVSã®ä»ã«Slaveã«ãRedo-logãæãã€ããããããåãåããã³ã«(æããKVSãšåããããªããžãã¯ã§)ãã°é©çšãè¡ããææ°ã®ã³ãããæžã¿ããŒã¿ãèªããããã«ãªã£ãŠãããããã§æ°ã¥ãã人ããããšæãããMasterã¯Slaveã«ãã°ãå
±æããããã®å®äºãåŸ
ã€ãšã¯äžèšãæžããŠããªãã4/6ã®KVSæ°žç¶åãå®äºããæç¹ã§ãŠãŒã¶ã«ã³ããããå ±åããŠããŸãããªã®ã§MasteråŽã§æŽæ°ã確èªããããŒã¿ãSlaveåŽã§èªããããã«ãªãã«ã¯è¥å¹²ã®ã¿ã€ã ã©ã°ãçºçããå¯èœæ§ããããããããSequential Consistencyã§ãããããªç§ãªãŒããŒãªã®ã§HTTPãªWebãµãŒãã¹ã®æèã§å€§åé¡ã«ãªãã±ãŒã¹ã¯çšã ãèŠããŠãããæ¹ãããããç¥ããªãã
ãã§ãã¯ãã€ã³ãã®æåã®éã
Auroraã¯ã·ã¹ãã å šäœã§èŠããšãMasterããã£ããæŽæ°ããããŒãžããã®ãŸãŸè€è£œããã«KVSããã°ãªãã¬ã€ããŠåæ§ç¯ããåCPUã¯ããã¯ã¯ç¡é§ã«ãªã£ãŠãããããããMasterã¯ããŒãžãæžãæ»ãå¿ èŠãç¡ããªããæŽã«èšããšMasterããã§ãã¯ãã€ã³ãåŠçãããå¿ èŠããªããªã£ãããªããªããã§ãã¯ãã€ã³ãåŠçã¯åæ£KVSåŽã§ç¶ç¶çã«ããŒãžåäœã§å®æœãããŠããããã ããªãã ããã¯ãIn-MemoryDBã§ãDisk-Oriented DBãšãéããã§ãã¯ãã€ã³ãã¢ãŒããã¯ãã£ã ãããããã®ãã§ãã¯ãã€ã³ãæŠç¥ãããã«åæããã
- ARIES:
Checkpoint-BeginãWALã«æžããŠãããã®ç¬éã®Dirty Page TableãšTransaction Tableãä¿åããŠããªã¹ã¿ãŒãæã®Redo-Logé©çšéå§ãã€ã³ããç®åºå¯èœã«ããã - MySQL: ããŒãã£ãªããŒãžããã£ã¹ã¯ã«æžãåºããããŒãžã®å¢çãšãããã¯ã¹ãã¬ãŒãžã®ããŒãžå¢çãäžèŽããªãäºã®ã»ããæ®éãªã®ã§ãã§ãã¯ãã€ã³ãäžã«é»æºãèœã¡ããããŒãžã®äžéšãäžéåç«¯ã«æ°žç¶åãããŠããŸããããã§äºåºŠæžãäºã«ãã£ãŠã¢ãããã¯æ§ãéæããïŒ
Double WriteãšåŒã¶ïŒã - PostgreSQL: ããŒãã£ãªããŒãžããã£ã¹ã¯ã«æžãåºããããŒãžã®å¢çãšãããã¯ã¹ãã¬ãŒãžã®ããŒãžå¢çãäžèŽããªãäºã®ã»ããæ®éãªã®ã§ãã§ãã¯ãã€ã³ãäžã«é»æºãèœã¡ããããŒãžã®äžéšãäžéåç«¯ã«æ°žç¶åãããŠããŸããããã§ãã®ãã§ãã¯ãã€ã³ãåŸã«æåã«ãã®ããŒãžã«è§ŠãWALã®äžã«ããŒãž(ããã©ã«ãã§8KB)ãäžžã£ãšåã蟌ãã§å®å
šæ§ãä¿éãã(
Full Page WriteãšåŒã¶)ã - In-Memory DB: ã©ããã®ã¿ã€ãã³ã°ã§ã¡ã¢ãªã®å 容ãã¢ãªããšãã£ã¹ã¯ã«æžãåºããŠãªã¹ã¿ãŒãæã«æŽåæ§ãçŽãSiloRãšãããã°ã䞊åã¹ãã£ã³ããŠå®å šãªã€ã¡ãŒãžãçæããFOEDUSãšãæŠç¥ã¯ãŸã å€å²ã«æž¡ã£ãŠããã
- Aurora: ããã¯ãšã³ãã®Auroraã¹ãã¬ãŒãžãèªåã§ãã°ãé©çšããŠãããããŒãžããšã«ãã°ãããã¡ãä»ããŠãŠããããã¡ã®é·ãããããå€ãè¶ ãããã³ã«ããŒãžãžã®ãã°é©çšã宿œãããããã°ã¯æªã³ãããã®ãã©ã³ã¶ã¯ã·ã§ã³ã®é²è¡äžã®ãã°ãå«ããMasterããªã¹ã¿ãŒãããŠããæç¹ã§ãã®ãã©ã³ã¶ã¯ã·ã§ã³ã¯ãã以äžé²ãã¯ãããªãã®ã§ãã°ãåãè©°ãã(Truncate)ããã®éã«ã¯ææ°ã®æ°žç¶åæžã¿ã®ã³ãããå®äºã®LSNãŸã§åŸ©æ§ããããªããã®åŸ©æ§åŠçã¯Masterãå æ°ã«é²è¡ããŠããæäžã§ãã£ãŠãããã¯ã°ã©ãŠã³ãã§è¯ããªã«å®è¡ããããããã®ããã¯ã°ã©ãŠã³ãåŠçãšãã§ãã¯ãã€ã³ãã«å·®ããªãã®ãAuroraã®åŠè¡çæ°èŠæ§ã®äžã€ã ãšæããRedo-logãªãã¬ã€æ©èœä»ã忣ã¹ãã¬ãŒãžãããã°ãã§ãã¯ãã€ã³ãã«ä¿ãè€éããäžæ°ã«è§£æ±ºã§ããã
ãã³ãããŒã¯çµæ
è«æããæç²ãããš

倧ããã®ã€ã³ã¹ã¿ã³ã¹ã®å Žåã«æ§èœåäžã®äŒžã³ããã倧ããããã ã
ãã®ä»
ãªããä»ã«å·¥å€«ãªãã®
ãã°åŠçåšãã¯å€§èã«æãå ããããŠãããäžã§ãæå¿ããã®ã¯Flush Pipeliningãå®è£
ãããŠããã
éåžžããã°ãæ°žç¶åãããã®ãåŸ
ã€ã«ã¯ãã¬ãŒã«ãã°å
å®¹ãæž¡ããŠãå®äºãå ±åããããŸã§ã»ããã©ãªã©ã§å¯ãã®ãå
žåçãªå®è£
ãã¿ãŒã³ã§ããããããAuroraã§ã¯ãã¬ãŒã«ãã°å
å®¹ãæž¡ããåŸã«ãçµãã£ããã¯ã©ã€ã¢ã³ãã«å®äºãå ±åããããšãã¥ãŒã«äŸé Œãæã蟌ãã ãã§ããã®ã¹ã¬ããã¯å³åº§ã«æ¬¡ã®ãªã¯ãšã¹ããæãåŠçã«ç§»è¡ããããã¥ãŒã®äžèº«ã確èªããå°çšã®ã¹ã¬ãããå±
ãŠãæ°ãã«æ°žç¶åããããã°ã®LSNãšãã¥ãŒã«ç»é²ãããäŸé ŒãèŠæ¯ã¹ãŠãæ°žç¶åãããã³ãããã®å®äºãã¯ã©ã€ã¢ã³ãã«ä»£çã§å ±åããã
PostgreSQLã§ãpgbenchã§ãã³ãããŒã¯ãåã£ãŠã€ãžã¡ãŠã¿ããšããã«ã»ããã©åŠçè¿èŸºãããã«ããã¯ã«ãªãã®ã§Auroraãç䌌ãŠãã®èŸºåŒã£ãŠãè¯ããããªæ°ãããã倧æ¹é ã«ãªãã®ã§ã³ãã¥ããã£ã«ã¯æè¿ãããªãæ°ãããã
Aurora Multi-Masterã£ãŠã©ããªã®
ãã®è«æã§è§£èª¬ãããŠãä»çµã¿ã ãšLSNã®çºè¡ããããŠè€æ°å°ã®ãã·ã³ãããã£ãŠãã¡ãªã®ã§ãã°ã®ãã©ãŒãããã®ã¬ãã«ã§æ¹é ãå ããããŠãããªæ°ãããã詳ããã¯åç»ã§
https://www.youtube.com/watch?time_continue=2620&v=rPmKo2g9znA
ã©ãããããŒãã£ã·ã§ã³åäœã§ãããŒãã«ã®ãã®ç¯å²ã¯ãµãŒãAããªãŒããŒãïŒãçã«åå²çµ±æ²»ããŠMasterãè€æ°çšæããããã ããããŠèªåãMasterãããªãããŒãã«ã«ã¯äžå¿æžã蟌ãããæçµçã«ã¯èª¿åè
ãæ±ºå®ãããšã®äºã§ãããæŽæ°ãç«¶åããŠããå Žåã¯Writeæ§èœã¯äžãããªããç«¶åããŠããªãå Žåã¯æ§èœã¯ãã䌞ã³ããããã
ã©ããªæŽæ°ãããããæ¥ãããª
忣KVSåŽã®CPUãå®ããŠç©ºããŠããŠãããã€ãä¿åããŠããããŒãžå 容ã«å¯ŸããŠredo-logãé©çšã§ããçšåºŠã«äžèº«ãè§£éããŠåããŠããã®ã§ãããã€ãã«éèšç³»ã¯ãšãªãå®è¡ãããã®ã¯ã³ã¹ãã¡ãªãããè¯ããããè²§è ã®OLAPãšããŠJOINãèŠæãªDBå®è£ ãã¯ããŒãºããªäžçã«åèšããå¯èœæ§ã¯ãããšæã£ãŠããããããã¯redo-logãRedshiftã«ãã®ãŸãŸæãã€ããŠãã£ãŠSlaveã®äžã€ãšããŠçšŒåããããã«ãªããšãã
ãŸãšã
- Auroraã¯æãã€ããããRedoãã°ãã¹ãã¬ãŒãžåŽã§ããã¯ã°ã©ãŠã³ãã§é©çšã§ããããMasterã®è² æ ãæžã£ãããªã®ã§æ§èœã䌞ã³ãããã«ãªã£ãã
- ã€ã³ããªãžã§ã³ããªåæ£ã¹ãã¬ãŒãžãããŒãªïŒ
- ãããèšèšããAmazonã®äžã®äººã¯ç¢ºå®ã«ã忣ã·ã¹ãã ã®èæèŠ(Struggler察çãšãã·ã³ã°ã«ãã¹ã¿ãŒæ§æãšã)ããDisk-Oriented DBã®ACIDä¿éã®è£åŽ(æ°ããDBããŒãžäžè²«æ§ä¿éãããã³ã«èšèš)ããWebã¢ããªããã°ã©ãã®éèŠ(Webã®æèã§ã¯Slaveã®å³å¯ãªäžè²«æ§ãŸã§ã¯å¿ èŠãšããªãäº)ããã¯ã©ãŠãã®ãªãœãŒã¹æèŠ(忣KVSã®CPUã¯éãã§ãããªãœãŒã¹ã ããæŽ»çšãã¹ã)ãã®4ã€å šãŠã«ã€ããŠç¢ºå®ã«åããæ·±ãé è©£ãšçããç¥èãæã£ãŠãããæãã¹ãã
-
æ°åã®å ¥ã£ãDBãªãLRUã§ã¯ãªããŠäºéåºãªvictimä»ãã®ããŒãžç®¡çæ©æ§ã«ããããšã§åãªããã«ã¹ãã£ã³ããããã¡ããŒã«å šéšã远ãåºãç¶æ³ãäœããªãããã«é 匵ã£ãããããããã¯ä»åã¯è©±ããªãïŒ â©
-
ãã®åŠçã6å€éå šéšã§ãããšéãã®ã§å®ã¯äžéšã®ãã·ã³ã§ãããã®Applyæäœã¯ããªããããã â©




