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

ariyos id:ariyos

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

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

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯å†åˆ©ç”¨ã®æ•µã§ã‚ã‚‹
é‡£ã‚Šã£ã½ã„ã‚¿ã‚¤ãƒˆãƒ«ã€‚ã€ŒRDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒçµ¡ã‚€ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒæ›¸ãã«ãããªã‚‹ã€ã¨ã„ã†è©±ã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€RDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯å‰å¤§ã§ã‚ã‚Šã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚æ„è˜ã—ã¦ä½¿ã‚ãªã‘ã‚Œã°ãªã‚‰ãšã€ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãªã‚“ã¦ä½¿ã†ãªã€ã¨è¨€ã„ãŸã„ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ åˆæˆã§ããªã„é–¢æ•° PHPã§ç´ ã®PDOã‹ã‚‰è€ƒãˆã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®é–¢æ•°ã«å•é¡Œã¯ã‚ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ <?php /* * å¤ã„ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒ†ãƒ¼ãƒ–ãƒ«ã«ç§»ã™é–¢æ•°ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ */ function moveDataToArchive(PDO $db) { $db->beginTransaction(); try { $db->exec(' INSERT INTO archives SELECT * FROM data WHERE published < CURRENT_DATE '); $db->exec
ariyos 2013/10/23
db

php
ãƒªãƒ³ã‚¯
DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
ariyos 2011/07/21
DB
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
ariyos 2010/01/19
key-value

DB
ãƒªãƒ³ã‚¯
æ–°æ›¸ç±ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨å…¥é–€ã€
Linuxä¸Šã§ã€Œé«˜é€Ÿã§ã€è½ã¡ãªã„ã€DBã‚µãƒ¼ãƒãƒ¼ã‚’æ§‹ç¯‰ã™ã‚‹ãŸã‚ã®æŠ€è¡“è§£èª¬ã‚’ã—ãŸæ›¸ç±ã‚’å‡ºç‰ˆã—ã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã¯ã‚¹ãƒˆãƒ¬ãƒ¼ãƒˆã«ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨å…¥é–€ã€ã§ã™ã€‚ 9æœˆ17æ—¥ç™ºå£²ã§ã™ãŒã€ã‚¸ãƒ¥ãƒ³ã‚¯å ‚ãªã©ä¸€éƒ¨ã®æ›¸åº—ã§ã¯ã™ã§ã«å…¥è·ã—ã¦ã„ã‚‹ãã†ãªã®ã§ã€è¦‹ã‹ã‘ãŸã‚‰ãœã²èªã‚“ã§ã¿ã¦ãã ã•ã„ã€‚ç« æ§‹æˆã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ ç¬¬1ç« ã€€è«–ç†ãƒœãƒªãƒ¥ãƒ¼ãƒ ãƒžãƒãƒ¼ã‚¸ãƒ£(LVM)ã‚’æ´»ç”¨ã™ã‚‹ ç¬¬2ç« ã€€Heartbeatã«ã‚ˆã‚‹ã‚¯ãƒ©ã‚¹ã‚¿ç’°å¢ƒã®æ§‹ç¯‰ ç¬¬3ç« ã€€DRBDã«ã‚ˆã‚‹ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒŸãƒ©ãƒ¼ãƒªãƒ³ã‚°(å‰ç·¨) ç¬¬4ç« ã€€DRBDã«ã‚ˆã‚‹ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒŸãƒ©ãƒ¼ãƒªãƒ³ã‚°(å¾Œç·¨) ç¬¬5ç« ã€€é«˜å¯ç”¨DBã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ ç¬¬6ç« ã€€ç¾å ´ã§ä½¿ã‚ã‚Œã‚‹é«˜å¯ç”¨æ§‹æˆ ç¬¬7ç« ã€€DBã‚µãƒ¼ãƒãƒ¼ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¦‚è«– ç¬¬8ç« ã€€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°(å‰ç·¨) ç¬¬9ç« ã€€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°(å¾Œç·¨) ç¬¬10ç« ã€€DBã‚µãƒ¼ãƒãƒ¼ã®ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢é¸å®š ç¬¬11ç« ã€€SSDã®åŠ¹æžœã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·
ariyos 2009/09/16
db

linux
ãƒªãƒ³ã‚¯
ã‚ªãƒ¬ã‚ªãƒ¬æ¤œç´¢çª“ã‚’è¨ç½®ã—ã‚ˆã† - mixi engineer blog
ã¾ã ãƒ”ã‚¯ãƒŸãƒ³2ã‚’ã‚¯ãƒªã‚¢ã—ã¦ãªã„ã®ã§ã‚±ã‚¸ãƒ¡çš„ã«æ–°ä½œã‚²ãƒ¼ãƒ ã‚’è²·ãˆãªã„mikioã§ã™ã€‚ä»Šå›žã¯ã€Tokyo Cabinetã‚’ä½¿ã£ã¦æ¿€çƒˆç°¡å˜ã«ç‰¹å®šã‚µã‚¤ãƒˆã®å°‚ç”¨ã®æ¤œç´¢æ©Ÿèƒ½ã‚’è¨ç½®ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã‚¯ãƒãƒ¼ãƒªãƒ³ã‚°ã‹ã‚‰æ¤œç´¢ã¾ã§ã‚’10åˆ†ãã‚‰ã„ã®ä½œæ¥ã§å¯èƒ½ã«ã—ã¾ã™ã€‚ ç‰¹å®šã‚µã‚¤ãƒˆã®æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ Webå…¨ä½“ã®æ¤œç´¢æ©Ÿèƒ½ã‚’ä½œã‚‹ã®ã¯ã€é€”æ–¹ã‚‚ãªã„æŠ€è¡“åŠ›ã¨è¨å‚™ã‚’æŒã£ã¦ã„ã‚‹Googleã‚„Microsoftãªã©ã®ãƒ“ãƒƒã‚°ãƒ—ãƒ¬ãƒ¼ãƒ¤ã§ãªã„ã¨é›£ã—ã„ã®ãŒç¾å®Ÿã§ã™ã€‚ã§ã‚‚ã€è‡ªåˆ†ãŒæ°—ã«å…¥ã£ã¦ã„ã‚‹ã„ãã¤ã‹ã®ã‚µã‚¤ãƒˆã‚’å¯¾è±¡ã¨ã—ãŸæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½œã‚‹ã®ã§ã‚ã‚Œã°å€‹äººã ã£ã¦ã§ãã¾ã™ã€‚ã¾ãŸã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰æ‰‹ãŒå±Šã‹ãªã„ã‚¤ãƒ³ãƒˆãƒ©ãƒãƒƒãƒˆã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®æ¤œç´¢æ©Ÿèƒ½ã¯è‡ªåˆ†é”ã§æ‰‹ãŒã‘ãªã„ã¨æ§‹ç¯‰ã§ãã¾ã›ã‚“ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ä¼æ¥ç”¨ã®æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ãŒæ•°å¤šãå£²ã‚‰ã‚Œã¦ã„ã¾ã™ã—ã€Luceneã‚„Groongaã‚„Hyper Estraierãªã©ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹è£½å“ã‚‚ä¸–ã«å¤šæ•°å˜åœ¨ã—ã¾
ariyos 2009/07/16
search

db
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
ariyos 2007/09/05
sql

database

db
ãƒªãƒ³ã‚¯
1