Uberã®Postgresqlã‹ã‚‰NoSQL on MySQLã¸ã®ç§»è¡Œã‚’èªã‚“ã§ã–ã£ãã‚Šã¾ã¨ã‚ãŸUber-migrated-pg-to-mysql.md Why Uber Engineering Switched from Postgres to MySQL - Uber Engineering Blog ã®ã¾ã¨ã‚ Posgresqlã 㨠pgã¯è¿½è¨˜åž‹ãªã®ã§å°‘ã—ã®æ›´æ–°ã§ã‚‚多ãã®diskã¸ã®writeãŒãŠãã‚‹ カラムを一ã¤æ›´æ–°ã—ãŸã ã‘ã§å¤šãã®indexã®æ›¸ãæ›ãˆãŒèµ·ã“ã‚‹ よã£ã¦ã€replicationã¯WALã‚’é€ã‚‹ã®ã§æ›´æ–°ãŒå¤šã„ã¨WALãŒå¤§é‡ã«é€ã‚‰ã‚Œã‚‹ repcliationã§ã¯ç‰©ç†çš„ãªdiskã®å¤‰æ›´ã‚’é€ã‚‹ DCé–“ã§ãƒ¬ãƒ—リã™ã‚‹ã¨ãã¤ã„ bugãŒã‚ã£ã¦replicaé–“ã§MVCCã®ä¸æ•´åˆãŒèµ·ãã‚‹ masterã¨replicaåŒã˜disk上ã®ãƒ‡ãƒ¼ã‚¿æ§‹æˆã‚’共有ã™ã‚‹ã®ã§upgradeãŒã¤ã‚‰ã„ cache readã¯syscallã¨osã®page cache経由ãªã®ã§é‡ã„ 1コãƒã‚¯ã‚·ãƒ§ãƒ³1プãƒã‚»ã‚¹
HOTã®åŠ¹æžœ (1) — Let's Postgres
{{#tags}}- {{label}}
{{/tags}}