[B! mysql][ãªã‚‹ã»ã©] harumaki_netã®ãƒ

harumaki_net id:harumaki_net

mysqlã¨ãªã‚‹ã»ã©ã«é–¢ã™ã‚‹harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãŒé€²åŒ–ã—ã¦ã„ãŸï¼ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6 ãŒå¾…æœ›ã®GAã¨ãªã‚Šã¾ã—ãŸï¼æ—©é€Ÿã€ã‚ã„ã¦ã„ãŸã‚µãƒ¼ãƒã«å…¥ã‚Œã¦ã¿ã¾ã—ãŸã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®è¨å®šãŒã€è‡³ã‚Œã‚Šå°½ãã›ã‚Šã«ãªã£ã¦ã„ã¦ã€ã³ã£ãã‚Šï¼*1 ã¡ã‚‡ã£ã¨å¼•ç”¨ãŒé•·ããªã‚‹ã‘ã©ã€æ•¢ãˆã¦é€”ä¸ã®ã‚«ãƒƒãƒˆã¨ã‹ã‚’ã—ãªã„ã§è¼‰ã›ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ã€linux(CentOS) ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã™ã€‚ ã¾ãšã€å–å¾—ã—ãŸrpmã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # rpm -ivh MySQL-server-5.6.10-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]ã™ã‚‹ã¨ã€æ•°åˆ†é–“ã‹ã‘ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–‡å—åˆ—ãŒã¤ã‚‰ã¤ã‚‰ã¨è¡¨ç¤ºã•ã‚Œã¦ãã¾ã™ï¼ˆã“ã“ã§ã¯ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã„
harumaki_net 2013/02/07
MySQL5.6

MySQL

ãªã‚‹ã»ã©
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
harumaki_net 2012/10/15
MySQL

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

ãªã‚‹ã»ã©
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
harumaki_net 2012/09/13
MySQL

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

ãªã‚‹ã»ã©
ãƒªãƒ³ã‚¯
è§£æžã¾ã§10åˆ†ï¼æœ€å¼·ã®MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒJet Profilerã€ - Lancersé–‹ç™ºãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€keiã§ã™ã€‚ ä»Šå›žã¯ã€MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å¤§æ´»èºãªã€ŒJet Profilerã€ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Jet Profilerã¨ã¯ Jet Profilerã¯ã€MySQLå‘ã‘ã®ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§ã™ã€‚ ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€DBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã§ã‚‚é‡è¦ãªä½œæ¥ã®1ã¤ã§ã™ãŒã€ Jet Profilerã‚’ä½¿ãˆã°ã€ãã®ä½œæ¥ã‚’GUIã§ç›´æ„Ÿçš„ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã®å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ãŠã‚Šã€æ©Ÿèƒ½é™å®šç‰ˆã§ã‚ã‚Œã°ç„¡æ–™ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ è³¼å…¥ã™ã‚‹å ´åˆã¯ã€$499ã¨ãªã‚Šã¾ã™ã€‚ è©³ç´°æƒ…å ±ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯å…¬å¼ãƒšãƒ¼ã‚¸ã‹ã‚‰ã©ã†ãžã€‚ http://www.jetprofiler.com/ja/ Jet Profilerã®é…åŠ› ãã®1ã€€å°Žå…¥ã®ã—ã‚„ã™ã• é€šå¸¸ã®Windowãƒžã‚·ãƒ³ã«ã€æ™®é€šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ„Ÿè¦šã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¯èƒ½ã§ã™ã€‚ ã‚¤ãƒ³
harumaki_net 2012/08/25
MySQL

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

ãªã‚‹ã»ã©

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLã®DRBDæ§‹æˆã«ãŠã‘ã‚‹ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯é…å»¶ã®å½±éŸ¿ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
ä»Šã•ã‚‰ã§ã™ãŒã€Amazon RDSã®ãƒžãƒ«ãƒAZãƒ‡ãƒ—ãƒã‚¤ãƒ¡ãƒ³ãƒˆã«ã¤ã„ã¦èª¿ã¹ã¦ã„ã¾ã—ãŸã€‚ãƒžãƒ«ãƒAZãƒ‡ãƒ—ãƒã‚¤ãƒ¡ãƒ³ãƒˆã¨ã¯ã€ç‹¬ç«‹ã—ãŸé›»æºã€ç©ºèª¿ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’å‚™ãˆãŸç‰©ç†çš„ã«ç•°ãªã‚‹ãƒã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã—ã¦åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è€éšœå®³æ€§ã‚’é«˜ã‚ã‚‹æ©Ÿèƒ½ã§ã™ã€‚AZã¯Availability Zoneã®ç•¥ã§ã™ã€‚ ç•°ãªã‚‹ãƒã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨èžãã¨ã€æ€§èƒ½ãŒå‡ºãªã„ã®ã§ã¯ãªã„ã‹ã¨ã„ã†æ‡¸å¿µãŒã©ã†ã—ã¦ã‚‚å‡ºã¦ãã¾ã™ã€‚ãã“ã§ã€ã©ã®ç¨‹åº¦æ€§èƒ½ãŒè½ã¡ã‚‹ã‚‚ã®ãªã®ã‹æ¤œè¨¼ã‚’è¡Œã„ã¾ã—ãŸã€‚ãªãŠã€ã™ã§ã«å®Ÿéš›ã®Amazon RDSã‚’åˆ©ç”¨ã—ã¦æ¤œè¨¼ã‚’è¡Œã£ãŸæ–¹ãŒã„ã‚‰ã£ã—ã‚ƒã„ã¾ã—ãŸã®ã§ã€ä»Šå›žã¯æ‰‹å…ƒã®ç’°å¢ƒã‚’åˆ©ç”¨ã—ã¦ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯é…å»¶ã‚„MySQLãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¨æ€§èƒ½ã¨ã®é–¢é€£æ€§ã‚’ç¢ºèªã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Amazon RDS MYSQL Performance Benchmarking - Cloud
harumaki_net 2012/06/25
MySQL

DRBD

ãªã‚‹ã»ã©
ãƒªãƒ³ã‚¯
æœ¬å½“ã¯æã‚ã—ã„ã€MySQLã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ï¼Ÿ - é«˜å°¾å®æ²»æ—¥è¨˜ on ã¯ã¦ãª
(2012/02/10è¿½è¨˜:ã¾ãŽã‚‰ã‚ã—ã„ã®ã§ã‚¿ã‚¤ãƒˆãƒ«ã«ã€Œï¼Ÿã€ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚) ã“ã“æ•°æ—¥ã€MySQLã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«æ‚©ã‚“ã§ã„ã¾ã—ãŸã€‚ãã£ã‹ã‘ã¯çŸ¥ã‚Šåˆã„ãŒFacebookã«æ›¸ãè¾¼ã‚“ã ä»¥ä¸‹ã®ã‚³ãƒ¡ãƒ³ãƒˆã§ã™ã€‚ MySQLã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®è©±ã‹ã‚‰ã€GPLã«ã¤ã„ã¦èª¿ã¹ã¦ãŸã€‚å—è¨—é–‹ç™ºã§GPLãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã®ã€ç´å“ã«ã¤ã„ã¦ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹å½¢æ…‹ã«ã¤ã„ã¦ã€ã¾ã ç†è§£ã§ãã¦ã„ãªã„ã€‚ ã€Œãˆã£ã€MySQLã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GPLã ã‚ˆãã€ãã‚Œãªã‚‰ç°¡å˜ã§ã—ã‚‡ã€‚ã€ã£ã¦æ€ã„ã€ã‚³ãƒ¡ãƒ³ãƒˆã—ãŸã®ã§ã™ãŒ...å°‘ã—æ°—ã«ãªã£ã¦èª¿ã¹ã‚‹ã¨é©šãã¹ãè¨˜äº‹ãŒã‚ã‚Šã¾ã—ãŸã€‚ MySQL ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§é ãŒç—›ã„: http://d.hatena.ne.jp/kurosaka/20071214/p1 ã‚ˆã‚Š ä¼æ¥ãƒ¦ãƒ¼ã‚¶ã¯100% MySQL ABç¤¾ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹è²»ç”¨ã‚’æ”¯æ‰•ã‚ãªã‘ã‚Œã°ãªã‚‰ãªã„æ„Ÿã˜ã€‚ ã¾ãŸä¸Šè¨˜ã®ãƒ–ãƒã‚°ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«è¿½è¨˜ã•ã‚Œã¦ã„ã‚‹ã€‚ GPL
harumaki_net 2012/02/09
MySQL

ãªã‚‹ã»ã©
ãƒªãƒ³ã‚¯
1