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

kssm id:kssm

dbã«é–¢ã™ã‚‹kssmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Amazon RDSã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ï¼‹Rails4.0ï¼‹multi_dbã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸ - ITã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ç”Ÿãã‚‹
Webã§è² è·åˆ†æ•£ã™ã‚‹å ´åˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ç°¡å˜ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆå‡ºæ¥ã¾ã™ãŒã€DBï¼ˆãŒRDBMSã®å ´åˆï¼‰ã¯ï¼‘ã¤ã«é›†ç´„ã™ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ã“ã®æ§‹æˆã ã¨ã©ã†ã—ã¦ã‚‚DBãŒæ€§èƒ½é¢ã§ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚ŠãŒã¡ã§ã€ãã‚Œã‚’è§£æ¶ˆã™ã‚‹ï¼‘ã¤ã®ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã¨ã—ã¦Readã‚’ãƒ¬ãƒ—ãƒªã‚«ã¸åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ãã‚Œã‚’Amazon RDSã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã¨multi_dbã¨ã„ã†gemã‚’ä½¿ã£ã¦è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ ã™ã§ã«DBã¯RDSï¼ˆMySQLï¼‰ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ãŒãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã¯åˆ©ç”¨ã—ã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆåœ°ç‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚ Amazon RDSã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«Amazon Web Services ãƒ–ãƒã‚°: Amazon RDSã®æ–°æ©Ÿèƒ½ï¼šRead Replica(ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«)ã®ç™ºè¡¨ ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã¨ã¯ãã®åã®é€šã‚Šã€RDSã®èªå–ã‚Šå°‚ç”¨è¤‡è£½ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã§ã™ã€‚ RDSãƒžã‚¹ã‚¿ã‹ã‚‰å®š
kssm 2013/10/03
rails

rds

db
ãƒªãƒ³ã‚¯
Railsã§è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã™ã‚‹ | TECHSCORE BLOG | TECHSCORE BLOG
ã“ã‚“ã«ã¡ã¯ã€éˆ´æœ¨ã§ã™ã€‚ Ruby on Rails ã§è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ establish_connection establish_connection ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ¡ã‚½ãƒƒãƒ‰ã§ã™ã€‚ é€šå¸¸ã¯æ˜Žç¤ºçš„ã«å‘¼ã³å‡ºã™ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«æ˜Žç¤ºçš„ã«å‘¼ã³å‡ºã™å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ class User < ActiveRecord::Base establish_connection :adapter => 'postgresql', :encoding => 'unicode', :database => 'other_database', :pool => '5', :username => 'USERNAME', :password => 'PASSWORD', :host => 'localhost' end
kssm 2013/01/31
rails

db
ãƒªãƒ³ã‚¯
Railsã®è¤‡æ•°ä¸€æ„åˆ¶ç´„ã«ã¤ã„ã¦ / ãƒãƒ¥ãƒ‘ã‚«ãƒ–ãƒ©ã®å‹‰å¼·æ—¥è¨˜
8æœˆ 6th, 2012 â€¢ rails è¤‡æ•°ä¸€æ„åˆ¶ç´„ã¨ã¯ã€è¤‡æ•°ã®ã‚«ãƒ©ãƒ ã§ã‚»ãƒƒãƒˆã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ã«ã™ã‚‹ã“ã¨ã€‚ ä¾‹ãˆã°ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®åå‰ã¨ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’ã‚»ãƒƒãƒˆã«ã—ã¦ã€åå‰ã¨ã‚¢ãƒ‰ãƒ¬ã‚¹ã®ã‚»ãƒƒãƒˆã§ã ã¶ã£ãŸã‚‰ã€é‡è¤‡ã¨ã—ã¦ã‚¨ãƒ©ãƒ¼ã‚’ãŠã“ã™ã€‚ åå‰ã¨ã‚¢ãƒ‰ãƒ¬ã‚¹ãŒï¼ˆâ€ä½è—¤â€,â€sato@mailâ€ï¼‰ã¨ã„ã†ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç™»éŒ²ã•ã‚Œã¦ã„ãŸã¨ã™ã‚‹ã¨ã€ ï¼ˆâ€ä½è—¤â€,â€sato@mailâ€ï¼‰ã¯ã‚‚ã†ç™»éŒ²ã§ããªã„ãŒã€ï¼ˆâ€éˆ´æœ¨â€,â€sato@mailâ€ï¼‰ã‚„ï¼ˆâ€ä½è—¤â€,â€suzuki@mailâ€ï¼‰ã¯ç™»éŒ²ã§ãã‚‹ã€‚ ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã‚‚ä½¿ã‚ã‚Œã‚‹ãŒã€è¤‡æ•°ä¸€æ„åˆ¶ç´„ã¯çµæ§‹ä½¿ã‚ã‚Œã‚‹ã€‚ è¤‡æ•°ä¸€æ„åˆ¶ç´„ã®å ´åˆã‚‚ã€Railsã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å´ã©ã£ã¡ã‚‚ã‚„ã£ãŸã»ã†ãŒã„ã„ã€‚ã©ã£ã¡ã‚‚ã‚„ã‚Œã°å¼·å›ºãªã‚‚ã®ã«ãªã‚‹ã€‚ ã¾ãšã€Railså´ã§ã®è¤‡æ•°ä¸€æ„åˆ¶ç´„ã®ã‚„ã‚Šæ–¹ã¯ã€ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã§ãŠã“ãªã†ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ¢ãƒ‡ãƒ«ãŒã‚ã‚Šã€nameã¨em ailã®2ã¤ã®ã‚«ãƒ©ãƒ ã«è¤‡æ•°ä¸€æ„åˆ¶ç´„ã‚’ã¤ã‘ã‚‹ã¨ã™ã‚‹
kssm 2012/12/18
rails

db
ãƒªãƒ³ã‚¯
SQLä¸Šç´šè€…ã“ãçŸ¥ã£ã¦æ¬²ã—ã„ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ï¼Ÿ
(PgDay2012ç™ºè¡¨è³‡æ–™) SQLã«ã¨ã£ã¦ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ã‚’èª¬æ˜Žã—ãŸè³‡æ–™ã§ã™ã€‚Read less
kssm 2012/12/07
db
ãƒªãƒ³ã‚¯
çœŸé¢ç›®ã«ã‚¨ãƒã‚µã‚¤ãƒˆã‚’ä½œã£ã¦ã¿ãŸã€ãƒ—ãƒã‚°ãƒ©ãƒžç·¨ã€‘ - BLOGï½œASTRODEO
æ±äº¬éƒ½å°æ±åŒºã§é»™ã€…ã¨ã‚¦ã‚§ãƒ–ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã—ã¦ã„ã‚‹æ ªå¼ä¼šç¤¾ã‚¢ã‚¹ãƒˆãƒãƒ‡ã‚ªã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§ã™ã€‚
kssm 2011/03/10
BeatIt

db

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
2. è‡ªå·±ç´¹ä»‹ ï® MySQL/Linuxå‘¨ã‚Šã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆ ï¬ 2006å¹´9æœˆã‹ã‚‰2010å¹´8æœˆã¾ã§MySQL æœ¬å®¶(MySQL/Sun/Oracle)ã§ APAC/USåœã®MySQL ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«å¾“äº‹ ï¬ ä¸»ãªè‘—æ›¸ã«ã€Œç¾å ´ã§ä½¿ãˆã‚‹MySQLã€ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/ é‹ç”¨å…¥é–€ã€ã€ŒJavaãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ã€ ï® DeNAã§ã®ä¸»ãªå½¹å‰² ï¬ å®‰å®šåŒ–/ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹/é‹ç”¨å‘¨ã‚Šã®ä¸é•·æœŸçš„ãªæ”¹å–„æ´»å‹• ï¬ L3ã‚µãƒãƒ¼ãƒˆ/é‹ç”¨/ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° â€“ é›£åº¦ã®é«˜ã„MySQLå‘¨ã‚Šã®å•é¡Œã®æ ¹æœ¬åŽŸå› ã®ç‰¹å®šã¨è§£æ±º ï¬ å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ”¯æ´ ï¬ ç¤¾å†…å‹‰å¼·ä¼š/ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚° â€“ MySQLã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç¤¾å†…ã§å…±æœ‰ã—ã€ æŠ€è¡“ã‚¹ã‚ãƒ«ã‚’åº•ä¸Šã’ã™ã‚‹ ï¬ æŠ€è¡“ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚° â€“ å›½å†…å¤–ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã€æŠ€è¡“é›‘èªŒç‰
kssm 2011/01/16
db

webã‚µãƒ¼ãƒ“ã‚¹

webåˆ¶ä½œ

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
1