[B! db][spanner] shodaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shodai id:shodai

dbã¨spannerã«é–¢ã™ã‚‹shodaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Spanner - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã“ã‚Œã¾ã§å¤šãã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®è¦ç´ æŠ€è¡“ã‚’èª¬æ˜Žã—ã¦ããŸã€‚ Googleã®å…¬é–‹ã—ã¦ã„ã‚‹è«–æ–‡Spanner: Google's Globally-Distributed Database ã¯å…¬é–‹å½“åˆã€è¦æ±‚ã•ã‚Œã‚‹å°‚é–€æŠ€è¡“ã®å¤šã•ã‹ã‚‰ã‚ˆãã‚ã‹ã‚‰ãªã„ã¨è¨€ã£ã¦ã„ã‚‹äººãŒå¤šã‹ã£ãŸãŒã€ã“ã‚Œã¾ã§ã«èª¬æ˜Žã—ãŸè¦ç´ æŠ€è¡“ã‚’ãƒ™ãƒ¼ã‚¹ã«ã™ã‚‹ã¨ç†è§£ã—ã‚„ã™ã„ã€‚ Spannerã¨ã¯ è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«è·¨ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’è¤‡è£½ã—ç¶šã‘ã‚‹äº‹ã§é«˜ã„å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ã¨ã„ã†æ§‹æƒ³ã¯æ•°å¤šãã‚ã£ãŸã€‚ ã—ã‹ã—ãã‚Œã‚‰ã®åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯å®Ÿç”¨çš„ãªé€Ÿåº¦ã‚’å®Ÿç¾ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ãŒãŸã ã®
shodai 2019/08/16
google

db

spanner
ãƒªãƒ³ã‚¯
https://research.google.com/archive/spanner-osdi2012.pdf
shodai 2018/05/04
db

google

spanner
ãƒªãƒ³ã‚¯
è¶…å®Ÿè·µ Cloud Spanner è¨è¨ˆè¬›åº§
1. è¶…å®Ÿè·µ Cloud Spanner è¨è¨ˆè¬›åº§ çŸ¥ã£ã¦ã‚‹ã“ã¨ã‚’å…¨ã¦ç´¹ä»‹ã—ã¾ã™ï¼ Proprietary Samir Hammoudi aka ã‚µãƒŸãƒ¼ãƒ« ã‚¯ãƒ©ã‚¦ãƒ‰ã‚«ã‚¹ã‚¿ãƒžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ JULY 21, 2017 2. Cloud Spanner ã¨ã¯ï¼Ÿ Google ã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ãƒ»ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãƒ»ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚µãƒ¼ãƒ“ã‚¹ å®Œå…¨ãƒžãƒãƒ¼ã‚¸ãƒ‰ã®ã‚°ãƒãƒ¼ãƒãƒ«ã‚¹ã‚±ãƒ¼ãƒ«ã§ DB ã‚µãƒ¼ãƒ“ã‚¹1 2 3 4 ã‚¾ãƒ¼ãƒ³é–“ãƒ»ãƒªãƒ¼ã‚¸ãƒ§ãƒ³é–“ã®è‡ªå‹• synchronous ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ã‚¹ã‚ãƒ¼ãƒžã€ACID ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã€SQL Googleå†…éƒ¨ã§ã¯ã€æ—¢ã«ï¼•å¹´ä»¥ä¸Šã®é‹ç”¨çµŒé¨“ (AdWords, Google Playâ€¦) 3. æ³¨æ„äº‹é …ï¼šCloud Spanner â‰ MySQL Cloud Spanner ã¯ MySQL ã®å˜ãªã‚‹ç½®ãæ›ãˆã§ã¯ãªã„ â— ã‚¹ã‚ãƒ¼ãƒžã¯ä¼¼ã¦ã‚‹ãŒã€åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã€MySQ
shodai 2018/05/04
spanner

cloud

google

db

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Cloud Spanner ãŒå¤–éƒ¨æ•´åˆæ€§ã‚’æä¾›ã™ã‚‹ç†ç”± | Google Cloud å…¬å¼ãƒ–ãƒã‚°
çš†ã•ã‚“ã¯è¤‡é›‘ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ãƒã‚¸ãƒƒã‚¯ãŒå¥½ãã§ã™ã‹ï¼Ÿ ç§ãŸã¡ã¯ãã†ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã¨ã„ã†ã®ã‚‚ã€ç§ãŸã¡ã¯ Google ã§ 1 ã¤ã®ã“ã¨ã‚’å¦ã‚“ã ã‹ã‚‰ã§ã™ã€‚ãã‚Œã¯ã€ã€Œãƒ‡ãƒ¼ã‚¿ ã‚¹ãƒˆã‚¢ãŒæä¾›ã™ã‚‹è¤‡é›‘ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚„ãƒ‡ãƒ¼ã‚¿æ•´ç†ã®æ©Ÿèƒ½ã‚’é–‹ç™ºè€…ãŒåˆ©ç”¨ã§ãã‚Œã°ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ã‚³ãƒ¼ãƒ‰ã¯ã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ã«ãªã‚Šã€é–‹ç™ºæœŸé–“ãŒçŸç¸®ã•ã‚Œã‚‹ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ Google Cloud Spanner ã«é–¢ã™ã‚‹æœ€åˆã®è«–æ–‡ã«ã¯ã“ã†æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ã€Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®æ¬ å¦‚ã‚’è£œã†ãŸã‚ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«çµ‚å§‹ã™ã‚‹ã‚ˆã‚Šã‚‚ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®éŽåº¦ã®åˆ©ç”¨ã«ä¼´ã†ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®ç™ºç”Ÿã¨ã„ã†ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã«å–ã‚Šçµ„ã‚€ã»ã†ãŒæœ›ã¾ã—ã„ã€‚ã€*1 è¨€ã„æ›ãˆã‚Œã°ã€ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆå…¨ä½“ã«ã‚ãŸã£ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨æ•´åˆæ€§ã‚’ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æä¾›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ ã‚¹ãƒˆã‚¢ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ã€ãƒã‚°ã‚„å•é¡ŒãŒå°‘ãªãã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã—ã‚„ã™ã„ã‚¢
shodai 2018/05/04
google

cloud

spanner

db
ãƒªãƒ³ã‚¯
Spanner ã®ãƒ™ã‚¹ãƒˆ ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ Â |Â Google Cloud
ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’é€ä¿¡ ç‰¹ã«è¨˜è¼‰ã®ãªã„é™ã‚Šã€ã“ã®ãƒšãƒ¼ã‚¸ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯ã‚¯ãƒªã‚¨ã‚¤ãƒ†ã‚£ãƒ–ãƒ»ã‚³ãƒ¢ãƒ³ã‚ºã®è¡¨ç¤º 4.0 ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã‚ˆã‚Šä½¿ç”¨è¨±è«¾ã•ã‚Œã¾ã™ã€‚ã‚³ãƒ¼ãƒ‰ã‚µãƒ³ãƒ—ãƒ«ã¯ Apache 2.0 ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã‚ˆã‚Šä½¿ç”¨è¨±è«¾ã•ã‚Œã¾ã™ã€‚è©³ã—ãã¯ã€Google Developers ã‚µã‚¤ãƒˆã®ãƒãƒªã‚·ãƒ¼ã‚’ã”è¦§ãã ã•ã„ã€‚Java ã¯ Oracle ãŠã‚ˆã³é–¢é€£ä¼šç¤¾ã®ç™»éŒ²å•†æ¨™ã§ã™ã€‚ æœ€çµ‚æ›´æ–°æ—¥ 2024-02-05 UTCã€‚ ï¿½wï¿½ï¿½+V
shodai 2018/05/04
google

cloud

spanner

db
ãƒªãƒ³ã‚¯
Spannerã«é–¢ã™ã‚‹æŠ€è¡“ãƒ¡ãƒ¢
8. ãƒãƒƒã‚¯ã®ç¨®é¡ž Shared Read Lockï¼ˆå…±æœ‰ãƒãƒƒã‚¯ï¼‰ â— ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®æ›¸ãè¾¼ã¿ã‚’ç¦æ¢ â— ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®èªã¿è¾¼ã¿ã¯å¯èƒ½ â— ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯åŒæ™‚ã«å…±æœ‰ãƒãƒƒã‚¯ã‚’å–å¾—å¯èƒ½ Exclusive Write Lockï¼ˆæŽ’ä»–ãƒãƒƒã‚¯ï¼‰ â— ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®èªã¿æ›¸ãã‚’ç¦æ¢ â— ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯åŒæ™‚ã«ãƒãƒƒã‚¯ã‚’å–å¾—ã§ããªã„ â— ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒå…ˆã«å…±æœ‰ãƒãƒƒã‚¯ï¼æŽ’ä»–ãƒãƒƒã‚¯ã‚’å–ã£ã¦ã„ã‚‹å ´åˆã¯ã€æŽ’ä»–ãƒãƒƒã‚¯ã¯ ã¨ã‚Œãªã„ã€‚ 9. ãƒªãƒ¼ãƒ‰ãƒ©ã‚¤ãƒˆãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹ãƒãƒƒã‚¯ã®åˆ©ç”¨ Aã•ã‚“ã‹ã‚‰Bã•ã‚“ã«50å††é€é‡‘ã™ã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ â‡’ å¤–éƒ¨ã‹ã‚‰ã¯æ™‚åˆ» t2 ã«ã™ã¹ã¦ã®å¤‰æ›´ãŒã¾ã¨ã‚ã¦è¡Œã‚ã‚ŒãŸã‚ˆã†ã«è¦‹ãˆã‚‹ A : 100 B : 200 C : 1300 A : 100 B : 200 C : 1300 A : 50 B : 200 C : 1300 å…±æœ‰
shodai 2018/05/04
è¶³ã—ç®—ã¨ã‹ã—ãŸã‚‰ã©ã†ãªã‚‹ã‚“ã ï¼Ÿãƒãƒƒã‚¯å¾…ã¡ãŒå¤§é‡ç™ºç”Ÿã™ã‚‹ã®ã‹ï¼Ÿ

spanner

google

db
ãƒªãƒ³ã‚¯
å…ƒOracleMasterPlatinumãŒCloudSpannerè§¦ã£ã¦ã¿ãŸ
7. Cloud Spannerã¨ã¯ - Googleç¤¾ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ï¼ˆGCPï¼‰ã§æä¾›é–‹å§‹ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ï¼ˆ2017/3/3æ™‚ç‚¹betaï¼‰ - Googleç¤¾ã§ã¯ã‚‚ã£ã¨å‰ã‹ã‚‰ç¤¾å†…ã§ã®åˆ©ç”¨å®Ÿç¸¾ã‚ã‚Šã€‚ - åœ°çƒè¦æ¨¡ã®å¤§è¦æ¨¡åˆ†æ•£ã‚’å®Ÿç¾ã—ã€ä¸–ç•Œä¸ã«ã‚µãƒ¼ãƒã‚’åˆ†æ•£ã€‚ - NoSQLã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨RDBã®ä¸€è²«æ€§ã‚’ä¸¡ç«‹ã•ã›ãŸã€‚ - ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã¯MVCCã§ã¯ãªãtimestampã‚’ç”¨ã„ã¦åˆ¶å¾¡ã™ã‚‹ã€‚ - ã‚µãƒ¼ãƒã®æ™‚åˆ»åŒæœŸã¯GPSã‚„åŽŸåæ™‚è¨ˆã‚’ç”¨ã„ã¦ã€ã©ã®ã‚µãƒ¼ãƒã‚‚ã‚ºãƒ¬ãŒãªã„ã‚ˆã†ã«ã— ã¦ã„ã‚‹ ã‚ºãƒ«ã„ã¨ã¯æ€ã†ã®ã§ã™ãŒã€è©³ç´°ã¯æœ‰è˜è€…ï¼ˆä¸äº• æ‚¦å¸ã•ã‚“ï¼‰ã®è³‡æ–™ã‚’ è¦‹ã¦ã„ãŸã ãã®ãŒã¾ãšã¯è‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ https://www.slideshare.net/enakai/spanner-72217077 8. æ—¢å˜RDBã‹ã‚‰ã®ä¹—æ›ãˆã£ã¦ï¼Ÿ ä»Šã®æ‰€ã€ã—ã‚“ã©ã„ã§ã™ã€‚ï¼ˆã¾ã betaãªã®ã§ä»Šå¾Œã«æœŸå¾…ï¼‰ - D
shodai 2018/05/04
cloud

spanner

google

db
ãƒªãƒ³ã‚¯
1