[B! DB] gidooomã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gidooom id:gidooom

DBã«é–¢ã™ã‚‹gidooomã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
gidooom 2013/01/15
DB
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
gidooom 2011/12/08
MySQL

db
ãƒªãƒ³ã‚¯
[37signals] Mooreæ°ã¯ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¹´é£›ã°ã™
(åŽŸæ–‡: Mr. Moore gets to punt on sharding) ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¯å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚ˆã‚Šå°ã•ãªã‚‚ã®ã«åˆ†å‰²ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹ç¯‰æ‰‹æ³•ã ã€‚ã§ã‹ã„é‰„ã®ã‹ãŸã¾ã‚Šã®ã‚ˆã†ãªï¼‘å°ã®ãƒžã‚·ãƒ³ã«ï¼‘ï¼ï¼ä¸‡äººã¶ã‚“æ ¼ç´ã™ã‚‹ä»£ã‚ã‚Šã«ã€ã‚ˆã‚Šå°ã•ãªå€‹åˆ¥ã®ï¼‘ï¼å°ã®ãƒžã‚·ãƒ³ã«ï¼‘ï¼ä¸‡äººã¶ã‚“ã¥ã¤æ ¼ç´ã™ã‚‹ã€‚ ã“ã®æ‰‹æ³•ã«ã¤ã„ã¦ã¯ä¸€èˆ¬ã«ã€å¿…è¦ã«è¿«ã‚‰ã‚Œã‚‹ã¾ã§æ‰‹ã‚’å‡ºã™ãªã€ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ã€‚Martin Fowlerï¼ˆè¨³æ³¨: ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã§ãŠãªã˜ã¿ï¼‰ãŒåˆ†æ•£ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆè¨è¨ˆã®ç¬¬ä¸€æ³•å‰‡ã¨ã—ã¦ã€Œã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’åˆ†æ•£ã•ã›ã‚‹ãªã€ã¨è¨€ã£ã¦ã„ã‚‹ã®ã¨ä¼¼ãŸã‚ˆã†ãªã‚‚ã®ã ã€‚ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¯ã„ã¾ã ã«ä»–ã®æ‰‹æ³•ã¨æ¯”ã¹ã¦é›£ã—ã„ã—ã€æ”¯æ´ãƒ„ãƒ¼ãƒ«ã¯è²§å¼±ã ã—ã€ã‚ãã‚‰ã‹ã«ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ä½œæ¥ãŒè¤‡é›‘åŒ–ã™ã‚‹ã€‚ ã¾ãã€é¸æŠžã®ä½™åœ°ãŒãªããªã‚‹æ—¥ãŒæ¥ã‚‹ã®ã¯é¿ã‘ã‚‰ã‚Œãªã„ã®ã ã¨ã„ã†ã“ã¨ã¯å¸¸ã«æ„è˜ã—ã¦ã¯ã„ã‚‹ã€‚ä¸Šæ–¹å‘ã¸ã®æ‹¡å¤§ï¼ˆè¨³æ³¨: ãƒžã‚·ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šãªã©ã®ã“ã¨ã‹ï¼‰
gidooom 2011/10/10
db

mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
RPO vs. RTO: Key differences explained with examples, tips | TechTarget
gidooom 2011/10/10
DataBase

DB
ãƒªãƒ³ã‚¯
Androidã®NFCæ©Ÿèƒ½ã§FeliCaã®èªã¿æ›¸ãã‚’ã™ã‚‹ | âˆ’ã‚†ã‚ãƒã‚°âˆ’ | ã‚†ã‚ã¿ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
gidooom 2011/09/10
åˆ†ã‹ã‚Šã‚„ã™ã„

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

DB

mysql
ãƒªãƒ³ã‚¯
æœ€çµ‚å›žã€€æ²»ç™‚ã¨ã—ã¦ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°â€•ã‚·ã‚¹ãƒ†ãƒ ã®ç—…æ°—ã¯ã©ã†æ²»ã™ï¼Ÿï¼ˆ1ï¼‰ | gihyo.jp
å‰å›žã®ãŠã•ã‚‰ã„ï¼†ä»Šå›žã®æ¦‚è¦ å‰å›žã§ã¯ã€ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰å—ã‘å–ã£ãŸSQLã«å¯¾ã—ã¦ã€DBMSãŒã©ã®ã‚ˆã†ãªæ‰‹é †ã‚’è¸ã‚“ã§ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã™ï¼ˆã¾ãŸã¯æ›´æ–°ã™ã‚‹ï¼‰ã‹ã€ã¨ã„ã†ä¸€é€£ã®æµã‚Œã‚’è§£èª¬ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€ãã“ã‹ã‚‰ä¸€æ©é€²ã‚“ã§ã€å®Ÿéš›ã«ã‚·ã‚¹ãƒ†ãƒ ã«æ€§èƒ½å•é¡ŒãŒç™ºç”Ÿã—ãŸã¨ãã€ã©ã®ã‚ˆã†ã«å¯¾å‡¦ã™ã‚‹ã‹ã€ã¨ã„ã†å®Ÿè·µçš„ãªã¨ã“ã‚ã«è¸ã¿è¾¼ã‚“ã§è§£èª¬ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å‰å›žã®å†…å®¹ã‚’å‰æã¨ã™ã‚‹ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã‚’ä¸å¿ƒã¨ã™ã‚‹ã‚¯ã‚¨ãƒªè©•ä¾¡ã‚¨ãƒ³ã‚¸ãƒ³ã®æ©Ÿèƒ½ã«ã¤ã„ã¦ã¯ã€çŸ¥ã£ã¦ã„ãŸã»ã†ãŒç†è§£ã—ã‚„ã™ã„ã§ã—ã‚‡ã†ã€‚å¿˜ã‚Œã¦ã—ã¾ã£ãŸã¨ã„ã†æ–¹ã¯ã€ç¬¬4å›žï¼ˆ1ï¼‰ã§ç°¡å˜ã«ãŠã•ã‚‰ã„ã—ã¦ãã ã•ã„ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯åŒ»ç™‚ã«è¿‘ã„ ç†è€…ã¯ã€ä»•äº‹ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’å¼•ãå—ã‘ã‚‹ã“ã¨ãŒã‚ˆãã‚ã‚Šã¾ã™ã€‚æ€§èƒ½è©¦é¨“ã®ä¸€ç’°ã¨ã—ã¦é…å»¶ãŒç™ºç”Ÿã—ãŸå‡¦ç†ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ã‚‚ã‚ã‚Œã°ã€ã™ã§ã«ã‚«ãƒƒãƒˆã‚ªãƒ¼ãƒãƒ¼ã•ã‚Œã¦é‹ç”¨ã«å…¥ã£ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ãŒé…å»¶ã‚’èµ·ã“ã—ã¦ã€ãŠç¥ã‚Šã®ä¼šå ´
gidooom 2011/05/04
DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

MySQL
ãƒªãƒ³ã‚¯
ç¬¬4å›žã€€ã‚¯ã‚¨ãƒªè©•ä¾¡ã‚¨ãƒ³ã‚¸ãƒ³ã¨å®Ÿè¡Œè¨ˆç”»â€•â€œã‚·ã‚§ãƒ•ãŠã¾ã‹ã›â€ã¯ã„ã¤ã‚‚ç¾Žå‘³ã—ã„ã®ã‹ï¼ˆ1ï¼‰ | gihyo.jp
ã¯ã˜ã‚ã« çµæžœã¨ã—ã¦ã€SQLã®ã‚ˆã†ãªé–¢ä¿‚åž‹ã®è¨€èªžã¯éžæ‰‹ç¶šãåž‹ã®è¨€èªžã¨å‘¼ã°ã‚Œã‚‹ãŒã€ã“ã‚Œã¯ãƒ¦ãƒ¼ã‚¶ã¯ã€Œã„ã‹ã«ã€ã§ã¯ãªãã€Œä½•ã‚’ã€ã‚’æŒ‡å®šã™ã‚‹â€•ã¤ã¾ã‚Šã€ç²å¾—ã™ã‚‹ãŸã‚ã®æ‰‹ç¶šãã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãªã—ã«ãƒ¦ãƒ¼ã‚¶ã¯ä½•ãŒæ¬²ã—ã„ã‹ã‚’ã„ã†â€•ã‹ã‚‰ã§ã‚ã‚‹ã€‚ â”€â â”€ Christpher J. Date[1] Webã®å…¥åŠ›ãƒ•ã‚©ãƒ¼ãƒ ã§ã‚ã‚Œã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã§ã‚ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã‹ã‹ã‚ã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹æ“ä½œã¯SQLã¨ã„ã†å°‚ç”¨ã®è¨€èªžã§è¡Œã‚ã‚Œã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ï¼ˆãƒ—ãƒã‚°ãƒ©ãƒžå«ã‚€ï¼‰ãŒæ„è˜çš„ã«ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹ã®ã¯é€šå¸¸ã“ã®SQLãƒ¬ãƒ™ãƒ«ã¾ã§ã§ã€ã‚ã¨ã¯DBMSãŒå‡¦ç†ã‚’çµ‚ãˆã€çµæžœã‚’è¿”å´ã™ã‚‹ã®ã‚’å¾…ã¤ã®ã¿ã§ã™ã€‚SQLã¨RDBMSã«ãŠã„ã¦ã¯ã€ãƒ¦ãƒ¼ã‚¶ã¯ãƒ‡ãƒ¼ã‚¿ã®ã‚ã‚Šã‹ã‚’çŸ¥ã‚‹å¿…è¦ã‚‚ãªã‘ã‚Œã°ã€ãã“ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ–¹æ³•ã‚‚è€ƒãˆã¾ã›ã‚“ã€‚ãã†ã„ã†ä»•äº‹ã¯ã€å…¨éƒ¨DBMSã«ä»»ã›ã¦ã„ã¾ã™ã€‚ ã“ã®ãƒ—ãƒã‚»ã‚¹ã¯ã€é€šå¸¸ã€Œãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã¨ã¯ã‹ãªã‚Šç•°ãªã‚Šã¾
gidooom 2011/05/04
DB

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

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
DeNAã«ã‚ˆã‚‹å¤§è¦æ¨¡ãªMySQLãƒŽãƒ³ã‚¹ãƒˆãƒƒãƒ—é‹ç”¨ã®è£å´ã«ã‚ã‚‹ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«
4æœˆ11æ—¥ã‹ã‚‰ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Expo 2011ã€ã€‚ã“ã®ã‚¤ãƒ™ãƒ³ãƒˆã§DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒã€åŒç¤¾ã®å¤§è¦æ¨¡ãªMySQLã®é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹æŠ€è¡“ã¨ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒAutomated, Non-Stop MySQL Operations and Failoverã€ã‚’è¡Œã„ã¾ã—ãŸã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸ã§ã€ç¤¾å†…ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã®è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ã™ã‚‹ã“ã¨ã«ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ï¼ˆè‹±èªžã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚‚ä½œæˆä¸ã¨ã®ã“ã¨ï¼‰ã€‚ MySQLã®å¤§è¦æ¨¡é‹ç”¨ã«ãŠã‘ã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¯ã€ç‰¹ã«ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®MySQLã®åˆ©ç”¨ãŒå¢—ãˆã‚‹ã«ã¤ã‚Œã¦ãƒ‹ãƒ¼ã‚ºãŒé«˜ã¾ã‚‹åˆ†é‡Žã¨æ€ã‚ã‚Œã¾ã™ã€‚ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ è‡ªå‹•åŒ–ã•ã‚ŒãŸãƒŽãƒ³ã‚¹ãƒˆãƒƒãƒ—ãªMySQLã®é‹ç”¨ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã§ã¯é«˜å¯ç”¨æ€§ãŒå¼·ãæ±‚
gidooom 2011/04/15
MySQL

DB

ã‚¤ãƒ³ãƒ•ãƒ©

ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢
ãƒªãƒ³ã‚¯
1