[B! mysql] hatano99ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hatano99 id:hatano99

mysqlã«é–¢ã™ã‚‹hatano99ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{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ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æˆ¦ç•¥
2017/10/08 phpcon 2017 https://joind.in/event/japan-php-conference-2017/session05-mysqlRead less
hatano99 2017/10/09
ã‚ã¨ã§èªã‚€

mysql

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

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

optimization

é–‹ç™º
ãƒªãƒ³ã‚¯
ã€Œãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€…ã€ã‚’åä¹—ã‚‹ãªã‚‰èº«ã«ã¤ã‘ãŸã„æŠ€è¡“ã¨çŸ¥è˜ã€2017å¹´ç‰ˆã€‘
ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€…ã«æ±‚ã‚ã‚‹ã‚¹ã‚ãƒ«ã¯æ™‚ä»£ã¨ã¨ã‚‚ã«å¤‰ã‚ã£ã¦ã„ã¾ã™ã€‚2017å¹´ã®ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€…ã‚’åä¹—ã‚‹ãªã‚‰æœ€ä½Žé™çŸ¥ã£ã¦ãŠãã¹ãæŠ€è¡“ã¨çŸ¥è˜ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã‹ã‚‰å®Œå…¨ãªMVPï¼ˆMinimum Viable Productï¼šå®Ÿç”¨æœ€å°é™ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆï¼‰ã¾ã§ã‚«ãƒãƒ¼ã™ã‚‹ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€…ã®ã“ã¨ã‚’ã€Œå¤šèŠ¸ã¯ç„¡èŠ¸ã€ã¨è©•ä¾¡ã™ã‚‹äººã‚‚ã„ã¾ã™ã€‚ãã‚“ãªä¸€é¢ã‚‚ã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ã€ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€…ã‚’çŸ¥ã‚‹ãŸã‚ã«ã€æ´å²ã‚’æŒ¯ã‚Šè¿”ã‚Šã¾ã™ã€‚ ä»¥å‰ã®ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€… 2000å¹´ã”ã‚ï¼ˆã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã§ã®17å¹´å‰ã¯å¤§æ˜”ã§ã™ï¼‰ã®ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯é–‹ç™ºè€…ã®å®šç¾©ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã—ãŸã€‚ Photoshopã€Fireworksãªã©Adobeç³»ãƒ„ãƒ¼ãƒ«ã§Webãƒšãƒ¼ã‚¸ã‚’æ‰‹æ—©ãä½œã‚‹ ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’HTMLã‚„CSSã«å¤‰æ›ã—ã€ç”»åƒã«ãƒ›ãƒƒãƒˆã‚¹ãƒãƒƒãƒˆã‚’è¿½åŠ ã™ã‚‹ï¼ˆã‚‚ã¯ã‚„å¿˜å´ã®ã‹ãªãŸã§ã™ã‹ï¼Ÿï¼‰ ç°¡å˜ãªPHP4.0ã‚¹ã‚¯ãƒªãƒ—ãƒˆï¼ˆå½“æ™‚ã®PHPã¯ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã¨ã¯ç„¡ç¸ï¼‰
hatano99 2017/07/13
mysql

product

Adobe

photoshop
ãƒªãƒ³ã‚¯
MySQLã‚’èµ·å‹•ã™ã‚‹ã¨ã€ŒNo directory, logging in with HOME=/ã€ã¨è¡¨ç¤ºã•ã‚Œã‚‹ - æ—¥å¸¸ãƒ¡ãƒ¢
MySQLã‚’èµ·å‹•ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ã«ãªã‚‹ã€‚ èµ·å‹•ã¯æˆåŠŸã™ã‚‹ãŒã€ã€ŒNo directory, logging in with HOME=/ã€ã¨ã„ã†ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒã§ã¦ã„ã‚‹ã€‚ root@ubuntu:~# /etc/init.d/mysql start No directory, logging in with HOME=/ ...... * MySQL Community Server 5.6.20 is started ãƒã‚°ã‚¤ãƒ³ã™ã‚‹éš›ã®HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒç„¡ã„ã“ã¨ã‚’æ„å‘³ã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®ã‚ˆã†ã«è¦‹ãˆã‚‹ã€‚ ã“ã‚Œã¯ä¸€ä½“èª°ã®HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒç„¡ã„ã¨ã„ã£ã¦ã„ã‚‹ã®ã‹ï¼Ÿrootã§èµ·å‹•ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹ã®ã§ã€rootã ã‚ã†ã‹ï¼Ÿ ã¾ãšã€rootã®HOMEãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ç¢ºèªã™ã‚‹ã€‚ root@ubuntu:~# cat /etc/passwd | grep root root:x:0:0:root:/root
hatano99 2017/06/26
MySQL
ãƒªãƒ³ã‚¯
MySQLã«ã‚ˆã‚‹JSONãƒ‡ãƒ¼ã‚¿åž‹å‡¦ç† â€“ variable.jp [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹,ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹,é‹ç”¨]
MySQL5.7ã«ãŠã„ã¦ã€JSON(JavaScript Object Notation)ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã¦ã€ æ§˜ã€…ãªè¨€èªžã‚„ã‚¢ãƒ—ãƒªé–“ã§ã€ã‚ˆã‚Šç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ã®å—ã‘æ¸¡ã—ãŒè¡Œãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’JSONãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã—ã¦ã€ æ§˜ã€…ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰å‘¼ã³å‡ºã—ã¦åˆ©ç”¨å‡ºæ¥ã‚‹ãªã©ã€ æ±Žç”¨æ€§ã¨é‹ç”¨é¢ã§ã®æ´»ç”¨ãŒå‡ºæ¥ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ 1) ãƒã‚¤ãƒ†ã‚£ãƒ–ã®JSONãƒ‡ãƒ¼ã‚¿åž‹ åŠ¹çŽ‡çš„ãªãƒ‡ãƒ¼ã‚¿å‡¦ç†ã¨ä¿ç®¡ã«ãƒã‚¤ãƒ†ã‚£ãƒ–å†…éƒ¨ãƒã‚¤ãƒŠãƒªå½¢å¼ã‚’ã‚µãƒãƒ¼ãƒˆã€‚ 2) çµ„ã¿è¾¼ã¿JSONãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ åŠ¹çŽ‡ã‚ˆããƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä¿å˜,æ¤œç´¢,æ›´æ–°,æ“ä½œã™ã‚‹äº‹ã‚’å¯èƒ½ã«ã—ã¾ã™ã€‚ 3) JSON ã‚³ãƒ³ãƒ‘ãƒ¬ãƒ¼ã‚¿ãƒ¼ æ–‡æ›¸ãƒ‡ãƒ¼ã‚¿ã‚’å®¹æ˜“ã«SQLã‚¯ã‚¨ãƒªã¨çµ±åˆã™ã‚‹ã“ã¨ãŒå¯èƒ½ 4) Generated Columnsã‚’åˆ©ç”¨ã—ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹äº‹ãŒå¯èƒ½ã€‚ æ–°ã—ã„ã‚¢ãƒŠãƒ©ã‚¤ã‚¶ãƒ¼ã¯,è‡ªå‹•çš„ã«åˆ©ç”¨å¯èƒ½ã§æœ€é©ãªæ©Ÿèƒ½
hatano99 2017/06/07
JSON

MySQL

localhost

root

SQL

SELECT
ãƒªãƒ³ã‚¯
Node.jsã§MySQLã‚’ä½¿ã†ãƒ¡ãƒ¢ - Qiita
JavaScriptã¨MySQLãŒã¤ãªãŒã‚‹ã€‚ãã†ã€€Node.jsãªã‚‰ãã€‚ #å‰ç½®ã node.jså§‹ã‚ã¦3æ—¥ç›®ç¨‹åº¦ã®çŸ¥è˜ã§æ›¸ã„ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€MySQLã‚‚ãã‚“ãªã«è©³ã—ã„ã‚ã‘ã§ã¯ãªã„ã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯æœ¬å®¶ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å…ƒã«ä½œæˆã—ã¾ã—ãŸã€‚ ã‚³ãƒ¼ãƒ‰ã‚‚ã»ã¼æœ¬å®¶ã®ã‚³ãƒ”ãƒšã§ã™ã€‚ é–“é•ã„ç‰ã‚ã‚Šã¾ã—ãŸã‚‰ã‚³ãƒ¡ãƒ³ãƒˆã§ãŠã—ãˆã¦ãã ã•ã„ã€‚ ã“ã“ã§ã¯node-mysqlã‚’ä½¿ã„ã¾ã™ã€‚ #ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« npm install mysql #ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ var mysql = require('mysql'); var connection = mysql.createConnection({ host : 'localhost', user : 'me', password : 'secret' }); //ã“ã‚Œã¯çœç•¥ã—ã¦ã‚‚oKã€‚ connection.connect();
hatano99 2017/04/04
â€œ`â€

mysql

MySQL

CONNECT

Node.js
ãƒªãƒ³ã‚¯
MonoQL - MySQL Admin & MySQL Query Tool
MonoQL is an AJAX web application to manage MySQL databases. MonoQL will provide all major features of phpMyAdmin for MySQL, including database & table design, data browsing & editing, advanced querying & more. MySQL 4+, MySQL 5+ and MySQL 6+ support
hatano99 2013/12/24
mysql

yui
ãƒªãƒ³ã‚¯
MySQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã‚‹ã¹ãMySQLã®å†…éƒ¨æ§‹é€ ã¨ã¯ï¼Ÿ | Yakst
MySQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã‚‹ã¹ãMySQLã®å†…éƒ¨æ§‹é€ ã«ã¤ã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ä¼šç¤¾PalominoDBã‚’çµŒå–¶ã™ã‚‹Laine Campbellæ°ã«ã‚ˆã‚‹å›žç”ã€‚MySQLã‚’çŸ¥ã‚‹ãŸã‚ã«ã¯ä½•ã‚’ãƒã‚¤ãƒ³ãƒˆã«å¦ç¿’ã™ã‚Œã°ã‚ˆã„ã®ã‹ãŒã‚ˆãã‚ã‹ã‚‹ã€DBAã‚„é–‹ç™ºè€…ã«ã¨ã£ã¦ã‚‚å½¹ç«‹ã¤å†…å®¹ã€‚ 1. ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã€æ°¸ç¶šæ€§ã€ãƒãƒƒã‚¯æ©Ÿæ§‹ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®æŒ¯ã‚‹èˆžã„ã‚„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã„ã£ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®åŸºç¤Žã¨ãªã‚‹å‹•ãã«ã¤ã„ã¦ã®ç†è§£ãªã—ã«ã€MySQLè‡ªä½“ã‚„ãƒ¢ãƒ‡ãƒ«ãƒ‡ãƒ¼ã‚¿ã®ã‚³ãƒ¼ãƒ‰ã‚’ã„ã˜ã‚‹ã¹ãã§ãªã„ã€‚ãã‚Œã«åŠ ãˆã¦ã€InnoDBã®ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚„ã€MyISAMã®å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚ˆã†ãªã‚³ã‚¢è¦ç´ ã‚‚ã€æ¥µã‚ã¦é‡è¦ãªæƒ…å ±ã ã€‚ 2. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆ ç‰¹ã«ä»¥ä¸‹ã®ã‚ˆã†ãªç‚¹ã«ã¤ã„ã¦ã€‚ ã‚«ãƒãƒªãƒ³ã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é€£çµã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸã‚½ãƒ¼ãƒˆ
hatano99 2013/12/18
ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹

mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
MySQLã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©é™ã‚’è¨å®š - MySQLé‹å–¶ã‚¬ã‚¤ãƒ‰ - [SMART]
ã“ã“ã§ã¯ã€MySQLã®æ¨©é™ã‚·ã‚¹ãƒ†ãƒ ã‚’è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚è¨å®šã®ä»•æ–¹ã¯ã€ŒæŽ¥ç¶šã®æ‰¿èªã€ã‚’å‚ç…§ãã ã•ã„ã€‚ MySQLç‰¹æ¨©ã‚·ã‚¹ãƒ†ãƒ æ¦‚è¦ MySQLã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ›ã‚¹ãƒˆã€ãƒ¦ãƒ¼ã‚¶ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰æ¯Žã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œï¼ˆé–²è¦§ã€æŒ¿å…¥ã€æ›´æ–°ã€å‰Šé™¤ãªã©ï¼‰ã™ã‚‹ãŸã‚ã®æ§˜ã€…ãªæ¨©é™ã‚’è¨å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ãƒ¦ãƒ¼ã‚¶/ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰/ãƒ›ã‚¹ãƒˆåã‚’mysqlã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç™»éŒ²ã—ã¦ã„ã‚‹ã®ã§ã€ãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¨å®šã—ã¦ã„ãã“ã¨ã«ãªã‚Šã¾ã™ã€‚ mysqlãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ç®¡ç†ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€dbã€hostã€userã€tables_privã€columns_privã®5ã¤ã§ã€ã“ã‚Œã«ã‚ˆã‚Šã€ã©ã®ãƒ¦ãƒ¼ã‚¶ãŒã©ã®ãƒ›ã‚¹ãƒˆã‹ã‚‰ã®ä½•ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‹æŒ‡å®šã§ãã¾ã™ã€‚ mysqlãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å èª¬æ˜Ž
hatano99 2013/12/05
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å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
hatano99 2012/09/12
linux

æ¯”è¼ƒ

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

PostgreSQL

MySQL

SQL
ãƒªãƒ³ã‚¯
x.com
hatano99 2012/04/07
ã‚ã¨ã§èªã‚€

php

apache

server

ã‚µãƒ¼ãƒ

mysql

CentOS
ãƒªãƒ³ã‚¯
ã‚¸ãƒ§ã‚¤ãƒ³ãŒ70å€é«˜é€Ÿã§ã€Memcached APIæè¼‰ã®ã€ŒMySQL Cluster 7.2ã€æ£å¼ç‰ˆãŒç™»å ´
ç±³ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æ™®åŠã—ã¦ã„ã‚‹MySQLã‚’ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã—ã¦åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒMySQL Cluster 7.2ã€ã®æ£å¼ç‰ˆã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ GPLã«æº–æ‹ ã—ãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆã¨åŒæ™‚ã«ã€ç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’åŒæ¢±ã—ã€24æ™‚é–“365æ—¥ã®ã‚µãƒãƒ¼ãƒˆã‚‚è¡Œã†å•†ç”¨ç‰ˆã®ã€ŒMySQL Cluster Carrier Grade Editionã€ã‚‚åŒæ™‚ã«å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‚¸ãƒ§ã‚¤ãƒ³ãŒ70å€é«˜é€Ÿã« MySQL Cluster 7.2ã®æœ€å¤§ã®ãƒã‚¤ãƒ³ãƒˆã¯ã€ã‚¸ãƒ§ã‚¤ãƒ³ãŒé«˜é€Ÿã«ãªã£ãŸã“ã¨ã§ã™ã€‚ã“ã‚Œã¾ã§ã‚¯ãƒ©ã‚¹ã‚¿ã§ã®ã‚¸ãƒ§ã‚¤ãƒ³ã¯ã€ã‚¸ãƒ§ã‚¤ãƒ³ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãŒã‚¯ãƒ©ã‚¹ã‚¿å†…ã®ãƒŽãƒ¼ãƒ‰é–“ã‚’ã„ã¡ã„ã¡é£›ã³äº¤ã£ã¦ã„ãŸãŸã‚ã€è¤‡é›‘ãªã‚¸ãƒ§ã‚¤ãƒ³ã«ãªã‚‹ã»ã©é…ã„ã‚‚ã®ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ MySQL Cluster 7.2ã§æŽ¡ç”¨ã•ã‚ŒãŸAdaptive Query Localizationï¼ˆã‚ã‚‹ã„ã¯Push Down Joinsï¼‰ã¨å‘¼ã°
hatano99 2012/02/16
mysql

memcached

mysql_cluster
ãƒªãƒ³ã‚¯
Windowsï¼‹Apacheï¼‹MySQLï¼‹PHP/Perl/Pythonç’°å¢ƒã‚’ç°¡å˜ã«æ§‹ç¯‰ã§ãã‚‹ã€ŒAMPPSã€NOT SUPPORTED
hatano99 2012/01/18
movabletype

webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

mysql

ã‚½ãƒ•ãƒˆ

python

perl

php

apache

windows

web
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã€é‹å–¶ã®æœ€å‰ç·šã§å¾—ã‚‰ã‚ŒãŸãƒŽã‚¦ãƒã‚¦ã€€ï½žãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨é‹ç”¨ã€18ã®ãƒã‚¤ãƒ³ãƒˆï½ž
å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é‹å–¶ã®ãƒã‚¤ãƒ³ãƒˆï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã€æ£å»¶æ°ã¯æ¬¡ã®7ã¤ã®ãƒã‚¤ãƒ³ãƒˆã‚’æŒ™ã’ã¾ã—ãŸã€‚ 1ï¼šnet_slave_timeoutã¯çŸãã™ã‚‹ ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã§ã¯ã€ã—ã°ã—ã°ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒè¡Œã‚ã‚Œãªããªã£ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ä½•ã‚‰ã‹ã®åŽŸå› ã§ãƒžã‚¹ã‚¿ãƒ¼ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–é–“ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¤±ã‚ã‚ŒãŸãŸã‚ã§ã™ãŒã€MySQLã¯ã“ã®ã“ã¨ã‚’èªè˜ã—ã¾ã›ã‚“ã€‚ã—ã‹ã‚‚ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é€šä¿¡ãŒè¡Œã‚ã‚Œãªã„å ´åˆã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³å†æŽ¥ç¶šæ™‚é–“ãŒã€æ¨™æº–ã§3,600ç§’ã¨éžå¸¸ã«é•·ãå®Ÿè³ªçš„ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚net_slave_timeoutã®æ™‚é–“ã‚’çŸãã™ã‚‹ã“ã¨ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒæ¢ã¾ã£ã¦ã‚‚ã™ãã«å†é–‹ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ 2ï¼šmax_binlog_sizeã¯å°ã•ãã™ã‚‹ max_binlog_sizeã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ãŒãƒãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚Œã‚‹ã‚µã‚¤ã‚ºã®ã—ãã„å€¤ã‚’æŒ‡å®šã—ã¾ã™ãŒã€æ¨™æº–ã§1GBãŒè¨å®šã•ã‚Œã¦ã„ã¾ã™ã€‚
hatano99 2011/12/22
mysql

innodb
ãƒªãƒ³ã‚¯
ç¤¾å†…ã‚µãƒ¼ãƒã‚¤ãƒ³ãƒ•ãƒ©å‹‰å¼·ä¼š(DB)
2. ä»Šå›žã®ç›®çš„ 1. ã€Œãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã€ã¨ã„ã†ã“ã¨ãŒã€å®Ÿéš›ã«ã© ã†ã„ã†ã“ã¨ãªã®ã‹ã‚’çŸ¥ã‚‹ã€‚ 2. ä¸ã®å‹•ä½œã‚’è¸ã¾ãˆã‚‹ã“ã¨ã§ã€åŠ¹çŽ‡ã®ã‚ˆã„ã‚¢ãƒ— ãƒªã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ 3. å•é¡ŒãŒèµ·ããŸã¨ãã«ã€ãã®åŽŸå› ã‚’çªãæ¢ã‚ã‚‰ ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ ä¸€èˆ¬è«–ã‚’ãƒ¡ã‚¤ãƒ³ã¨ã—ã€MySQLç‰ã®ç´°ã‹ã„ å€‹åˆ¥ãƒŽã‚¦ãƒã‚¦ã¯å–ã‚Šä¸Šã’ã¾ã›ã‚“ã€‚ 3. ãŠã—ãªãŒã 1. ã€Œãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã€ã¨ã¯ã©ã†ã„ã†ã“ã¨ã‹ 2. MySQLãŒãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãã¾ã§ 3. ä»®æƒ³ãƒ¡ãƒ¢ãƒªã¨ãƒšãƒ¼ã‚¸ã‚ãƒ£ãƒƒã‚·ãƒ¥ 4. ã¨ã£ã¦ã‚‚è¤‡é›‘ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å‹•ä½œ 5. MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ãƒ¡ãƒ¢ãƒªã®é–¢ä¿‚
hatano99 2011/10/01
mysql

ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯

ã‚ã¨ã§èªã‚€

database

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

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

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

DB

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒª

database

game

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQL 5.5æ–°æ©Ÿèƒ½å¾¹åº•è§£èª¬
ä»Šå¹´ã‚‚æ®‹ã™ã¨ã“ã‚ã‚ã¨ã‚ãšã‹ã¨ãªã£ãŸã€‚2010å¹´ã‚‚ITæ¥ç•Œã«ã¨ã£ã¦ã¯å¤‰åŒ–ã®å¤šã„ä¸€å¹´ã ã£ãŸãŒã€çš†ã•ã‚“ã«ã¨ã£ã¦ã¯è‰¯ã„å¹´ã ã£ãŸã ã‚ã†ã‹ï¼Ÿæ—¢ã«ä½•åº¦ã‹MySQL 5.5ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã¯å–ã‚Šä¸Šã’ãŸãŒã€ã¤ã„ã«æ£å¼ç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã¨ã„ã†ã“ã¨ã§ã“ã“ã§æ”¹ã‚ã¦æ–°æ©Ÿèƒ½ã‚’è§£èª¬ã—ã€ä»Šå¹´æœ€å¾Œã®ã‚¨ãƒ³ãƒˆãƒªã‚’ç· ã‚ããã‚ã†ã¨æ€ã†ã€‚ MySQL 5.5ã«ã¯ã“ã‚Œã§ã‚‚ã‹ã£ï¼ã¨ã„ã†ãã‚‰ã„æ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã€‚ã—ã‹ã‚‚ã„ãšã‚Œã‚‚ãƒŠã‚¤ã‚¹ãªã‚‚ã®ã°ã‹ã‚Šã ã€‚ä¸€èˆ¬çš„ã«ã¯ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã¨é‡ããªã£ãŸã‚Šå®‰å®šæ€§ãŒä½Žä¸‹ã™ã‚‹äº‹ä¾‹ãŒå¾Œã‚’çµ¶ãŸãªã„ã®ã ãŒã€MySQL 5.5ã«é–¢ã—ã¦ã¯ãã®ã‚ˆã†ãªã“ã¨ã¯å…¨ããªã„ã®ã§å®‰å¿ƒã—ã¦åˆ©ç”¨ã—ã¦é ‚ããŸã„ï¼ InnoDBã®å¤§å¹…ãªæ”¹å–„ç¨®ã€…ã‚ã‚‹æ”¹å–„ç‚¹ã®ä¸ã§ã‚‚ç‰¹ã«ç›®ã‚’ã²ãã®ãŒInnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¸ã®æ”¹è‰¯ã ã€‚å®Ÿã¯ã€InnoDBã¯MySQL 5.1ãŒæœ€åˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã¨ãã‹ã‚‰ã€2å›žã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã€‚My
hatano99 2010/12/30
innodb

ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ»IT

mysql

ã‚ã¨ã§èªã‚€

ã“ã‚Œã¯ã™ã”ã„

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢
ãƒªãƒ³ã‚¯
MySQLã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®ãªã„ALTER TABLEã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆãªã©ã‚’è¡Œã†ã¨ã€ãã®é–“ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã®ãŸã‚ã“ã‚Œã‚‰ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã¯ã€é€šå¸¸åˆ©ç”¨è€…ã®å°‘ãªã„æ·±å¤œæ—©æœå¸¯ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ã¦å®Ÿæ–½ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ—¥ã¯ãã‚Œã‚’ç„¡åœæ¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ã¾ã¾ã§ã§ããªã„ã‹ã¨ã„ã†è©±é¡Œã§ã™ã€‚ åŸºæœ¬çš„ãªã‚¢ã‚¤ãƒ‡ã‚¢ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å¯¾è±¡ã®å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€ä½œæ¥ç”¨ã®ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ è¿½åŠ ãªã©ã®å¤‰æ›´ã‚’åŠ ãˆã¾ã™ ãã®é–“ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦è¡Œã‚ã‚Œã‚‹æ›´æ–°å‡¦ç†ã«ã¤ã„ã¦å·®åˆ†ã‚’è¨˜éŒ²ã—ã¦ãŠãã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å¤‰æ›´ãŒçµ‚ã‚ã£ãŸã‚‰ã€è¨˜éŒ²ã—ã¦ãŠã„ãŸå·®åˆ†ãƒ‡ãƒ¼ã‚¿ã‚’ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¾ã™ å·®åˆ†ãƒ‡ãƒ¼ã‚¿ã®åæ˜ ãŒçµ‚ã‚ã£ãŸã‚‰ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã¾ã™ ã“ã‚Œã¨ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆãŸæ–¹ã¯çµæ§‹ã„ã‚‰ã£ã—ã‚ƒã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãŸã ã€è¨€ã†ã¯æ˜“ã—ã€è¡Œã†ã¯é›£ã—ã§ã™ã€‚æ•´åˆæ€§ãŒãã¡ã‚“ã¨å–ã‚Œã‚‹ã‹ã©ã†
hatano99 2010/07/05
mysql

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

ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ã‚¢ã‚¤ãƒ‡ã‚¢

web
ãƒªãƒ³ã‚¯
Amazonã€MySQL 5.1ã®ã‚¯ãƒ©ã‚¦ãƒ‰DBã‚µãƒ¼ãƒ“ã‚¹ã€ŒAmazon RDSã€ã‚’Î²å…¬é–‹
Amazon RDSã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã®MySQL 5.1ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ§‹ç¯‰ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã€‚å¾“æ¥ã®SimpleDBã¨ä½µç”¨ã§ãã‚‹ã€‚ ç±³Amazon.comå‚˜ä¸‹ã®Amazon Web Servicesã¯10æœˆ27æ—¥ã€ã‚¯ãƒ©ã‚¦ãƒ‰ç’°å¢ƒã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ§‹ç¯‰ãƒ»é‹å–¶ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒAmazon Relational Database Serviceï¼ˆRDSï¼‰ã€ã®Î²ç‰ˆã‚’å…¬é–‹ã—ãŸã€‚ Amazon RDSã¯ç±³Sun Microsystemsã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQL 5.1ã€ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ãŠã‚Šã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯RDS APIã‚„ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã®RDSã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã€æ“ä½œã§ãã‚‹ã¨ã„ã†ã€‚ Amazonã¯ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒAmazon SimpleDBã€ã‚‚æä¾›ã—ã¦ã„ã‚‹ãŒã€SimpleDBã¯ã‚·ãƒ³ãƒ—ãƒ«ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã‚¯ã‚¨ãƒªãŒç‰¹å¾´ãª
hatano99 2009/10/29
mysql

amazon

ã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)
å…ˆé€±é‡‘æ›œæ—¥ã€BPStudy#25ã§ã€ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨ã„ã†é¡Œç›®ã§è©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®éš›ã«ä½¿ç”¨ã—ãŸç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ 1. Happy Optimization æœ€åˆã«ã€æœ€é©åŒ–ã®è€ƒãˆæ–¹ã¨ã—ã¦ã€ä¸Šé™å€¤ã‚’äºˆæ¸¬ã—ã€ãã‚Œã‚’å…ƒã«ãƒªã‚½ãƒ¼ã‚¹é…åˆ†ã‚’è€ƒãˆã‚‹ã€ã¨ã„ã†æ‰‹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚
hatano99 2009/09/29
è² è·åˆ†æ•£

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

database

ã‚ã¨ã§èªã‚€

performance

server

mysql

é‹ç”¨

è³‡æ–™
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘Facebookã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«è¦‹ã‚‹MySQLæ´»ç”¨äº‹ä¾‹ - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
Copyright (C) Mainichi Communications Inc. All rights reserved. æŽ²è¼‰è¨˜äº‹ã®ç„¡æ–è»¢è¼‰ã‚’ç¦ã˜ã¾ã™
hatano99 2008/04/29
mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸