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

nullpop8857 id:nullpop8857

dbã«é–¢ã™ã‚‹nullpop8857ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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}}

MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ãŒåŠ‡çš„å¤‰åŒ–ï¼ï¼GTIDã«ã¤ã„ã¦ä»•çµ„ã¿ã‹ã‚‰ç†è§£ã™ã‚‹
ãƒ¡ãƒªãƒ¼ã‚¯ãƒªã‚¹ãƒžã‚¹ï¼ï¼ã‚„ã‚ã€è‰¯ã„åã®ã¿ã‚“ãªï¼ï¼ã‚µãƒ³ã‚¿ã‚¯ãƒãƒ¼ã‚¹ãƒ»ãƒ»ãƒ»ã§ã¯ãªãã€ãƒ’ã‚²ãƒ¢ã‚¸ãƒ£ã‚®ãƒ¼ã‚¯ã‹ã‚‰ã®ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒˆã ã‚ˆï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€MySQL Casual Advent Calendarã®25æ—¥ç›®ã§ã‚ã‚‹ã€‚ä»ŠæœAdvent Calendarã‚’è¦—ã„ã¦ã¿ã‚‹ã¨ã€æœ¬æ—¥åˆ†ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒç„¡ã‹ã£ãŸã®ã§ã€æ€¥é½æ›¸ãã“ã¨ã«ã—ãŸã€‚Advent Calendaræœ€å¾Œã®æ—¥ã€ã‚¯ãƒªã‚¹ãƒžã‚¹ã‚’é£¾ã‚‹è¨˜äº‹ã®ãƒ†ãƒ¼ãƒžã¯GTIDã ã€‚ å‰å›žã®æŠ•ç¨¿ã§ã¯ã€MySQL 5.6ã®ç›®çŽ‰æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ãªã£ãŸã“ã¨ã‚’æŒ™ã’ãŸã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¾ã‚ã‚Šã§è¨€ãˆã°ã€ã‚‚ã†ã²ã¨ã¤å¤–ã›ãªã„ç›®çŽ‰æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ãã‚ŒãŒGTIDï¼ˆGlobal Transaction IDï¼‰ã§ã‚ã‚‹ã€‚ GTIDã¯è‰¯ãã‚‚æ‚ªãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ã‚’å¤‰åŒ–ã•ã›ã‚‹ã€‚GTIDã‚’ä½¿ã†ã“ã¨ã«ã‚ˆã£ã¦å¾—ã‚‰ã‚Œã‚‹æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€CHANGE MASTER TOã§ãƒã‚¤ãƒŠãƒªãƒ
nullpop8857 2014/12/26
GTID

MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

db
ãƒªãƒ³ã‚¯
ã‚ãªãŸãŒçŸ¥ã‚‰ãªã„ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«
1. ã‚ãªãŸãŒçŸ¥ã‚‰ãªã„ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ« @dbtech showcase tokoy 2014 å¥¥é‡Ž å¹¹ä¹Ÿ Twitter: @nippondanji mikiya (dot) okuno (at) gmail (dot) com 3. è‡ªå·±ç´¹ä»‹ â— MySQL ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ â€“ æ—¥ã€…ã®ã—ã”ã¨ â— ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°å…¨èˆ¬ â— Q&Aå›žç” â— ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ãªã© â— ãƒ©ã‚¤ãƒ•ãƒ¯ãƒ¼ã‚¯ â€“ è‡ªç”±ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®æ™®åŠ â— ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã¯ãªã„ â— ãƒ–ãƒã‚° ä»Šæ—¥ã¯å€‹äººã¨ã—ã¦ å‚åŠ ã—ã¦ã„ã¾ã™ã€‚ â€“ æ¼¢ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ â€“ http://nippondanji.blogspot.com/
nullpop8857 2014/11/13
sql

DB
ãƒªãƒ³ã‚¯
Mobage ã‚’æ”¯ãˆã‚‹ Ruby ã®æŠ€è¡“ ~ è¤‡æ•°DBç·¨ ~ : sonots:blog
nullpop8857 2014/11/11
mysql

ruby

rails

db

activerecord

Ruby on Rails
ãƒªãƒ³ã‚¯
éžåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã™ã‚‹ã€ŒDynomiteã€ã€NetflixãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
Redisã‚„Memcachedã¨ã„ã£ãŸã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éžå¸¸ã«é«˜é€Ÿã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’è¿”ã—ã¦ãã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã§ã™ãŒã€ãã‚Œå˜ä½“ã§ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚„å¯ç”¨æ€§ãªã©ã«é™ç•ŒãŒã‚ã‚Šã¾ã™ã€‚ The Netflix Tech Blog: Introducing Dynomite - Making Non-Distributed Databases, Distributed NetflixãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã—ãŸã€ŒDynomiteã€ï¼ˆãƒ€ã‚¤ãƒŠãƒžã‚¤ãƒˆã¨ã¯ç¶´ã‚ŠãŒé•ã†ã®ã«æ³¨æ„ï¼‰ã¯ã€ã“ã†ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã€é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ç‰¹é•·ã‚’æ´»ã‹ã—ã¤ã¤é«˜ã„ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚„å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ã‚ˆã†ãªé¢å€’ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’è¨å®šã™ã‚‹ã“ã¨ãªãã€Redisã‚„Memcachedã‚’ãƒŽãƒ¼ãƒ‰ã¨ã—ã€Cassandraã‚„Amazonã‚¯ãƒ©ã‚¦ãƒ‰ã®DynamoDBã®ã‚ˆã†ãªå¤§è¦
nullpop8857 2014/11/07
DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

dynamodb

åˆ†æ•£
ãƒªãƒ³ã‚¯
MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã®PostgreSQLå¯¾å¿œè¡¨ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
æ¯Žå›žã‚ã‹ã‚‰ãªããªã£ã¦ã‚°ã‚°ã£ã¦ã‚‹ã‹ã‚‰ä»Šåº¦ã‹ã‚‰ã“ã“ã«è¿½è¨˜ã—ã¦ã„ãã€‚ MySQL PostgreSQL SHOW DATABASES; \l USE dbname \c dbname SHOW TABLES; \dt SELECT * FROM tblname\G \x on SELECT * FROM tblname; SELECT * FROM information_schema.processlist; SELECT * FROM pg_stat_activity; KILL <pid>; SELECT pg_terminate_backend(pid); KILL QUERY <pid>; SELECT pg_cancel_backend(pid); table / column ã®æƒ…å ± MySQL PostgreSQL SHOW TABLE STATUS FROM dbname; ã‚
nullpop8857 2014/10/28
mysql

postgresql

db

SQL
ãƒªãƒ³ã‚¯
1