[B! docker][MySQL] beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

beth321 id:beth321

dockerã¨MySQLã«é–¢ã™ã‚‹beth321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

Dockerã§MySQLã‚’å‹•ã‹ã™(æ°—ã‚’ä»˜ã‘ã‚‹ã¹ãã¨ã“ã‚ã¨ã‹ã„ã‚ã„ã‚) - Qiita
å¼•ãç¶šãMySQLã«ã¤ã„ã¦ã€‚Dockerã§MySQLã‚’å‹•ã‹ã™å ´åˆã¯ã€ã„ã‚ã„ã‚ã¨å·¥å¤«ãŒå¿…è¦ã§ã™ã€‚çµæ§‹ãã®è¾ºèº“ã„ãŸã®ã§ã€ãƒ¡ãƒ¢ã€‚ MySQLã‚’ä½¿ã†éš›ã®æ³¨æ„ç‚¹ Dockerã§MySQLã‚’ä½¿ã†å ´åˆã€æ³¨æ„ã™ã¹ãã“ã¨ã¯ Dockerfileã§ã¯ã€è¤‡æ•°è¡Œã«ã¾ãŸãŒã£ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚„ãƒ—ãƒã‚»ã‚¹ã®çŠ¶æ…‹ãŒä¿æŒã•ã‚Œãªã„(æ¯Žå›žã‚µãƒ¼ãƒ“ã‚¹ãƒ—ãƒã‚»ã‚¹ãŒã™ã¹ã¦çµ‚äº†ã—ãŸæ‰±ã„ã«ãªã‚‹) MySQLã¯apt-getã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã ã‘ã§ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒçµ‚ã‚ã‚‰ãªã„(ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®å®Ÿè¡ŒãŒå¿…è¦) ã¨ãã«åŽ„ä»‹ãªã®ãŒä¸€ã¤ç›®ã§ã™ã€‚MySQLã§ã®å‡¦ç†(ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¿½åŠ ã‚„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®è¨å®šã€åˆæœŸãƒ†ãƒ¼ãƒ–ãƒ«ã®ç™»éŒ²ãªã©)ã¯MySQLã®ã‚µãƒ¼ãƒ“ã‚¹ãŒèµ·å‹•ã—ãŸçŠ¶æ…‹ã§ã—ã‹æ“ä½œã§ãã¾ã›ã‚“ã®ã§ã€Dockerfileã ã‘ã§ã¯å‡¦ç†ãŒè¡Œãˆã¾ã›ã‚“(è¤‡æ•°ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’&&ã§é€£çµã—ã¦å‡¦ç†ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ãŒã€Dockerfileã®å¯èªæ€§ãŒä¸‹ãŒã‚Šã¾ã™ã—ã€è¦‹ãŸç›®ã«ã‚‚ã‹ã£ã“ã‚ˆããªã„ã§ã™ã
beth321 2015/02/14
MySQL

docker

mysql

ã‚ã¨ã§èªã‚€

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ISUCONã§Nginxã¨MySQLã‚’DockeråŒ–ã—ãŸã¨ãã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ - ã‚†ã†ã†ããƒ–ãƒã‚°
ç¾å®Ÿçš„ãªWebã‚µãƒ¼ãƒ“ã‚¹ç’°å¢ƒã«ãŠã„ã¦ã€DockeråŒ–ã«ã‚ˆã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ãŒã©ã®ç¨‹åº¦ã®ã‚‚ã®ã‹èª¿æŸ»ã™ã‚‹ãŸã‚ã«ã€ ISUCON4 ã®äºˆé¸å•é¡Œã®ã†ã¡ã€Nginx ã¨ MySQL éƒ¨åˆ†ã‚’ Docker åŒ–ã—ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã¨ã£ã¦ã¿ãŸã€‚ å…¸åž‹çš„ãªWebã‚µãƒ¼ãƒ“ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®3å±¤æ§‹é€ ï¼ˆProxy, App, DBï¼‰ã‚’æ§‹ç¯‰ã—ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚«ãƒ¼ã«ã‚ˆã‚Šé«˜ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã‚’å®Ÿç¾ã§ãã‚‹ã®ã§ã€ISUCON ã®äºˆé¸å•é¡Œã¯é©å½“ãªé¡Œæã¨ã„ãˆã‚‹ã€‚ Docker ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦ç•™æ„ã™ã‚‹ã“ã¨ã¯å…ˆæ—¥æ›¸ã„ãŸã‚¨ãƒ³ãƒˆãƒªã«å…¨ã¦æ›¸ã„ã¦ã‚‹ã€‚ ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªã‚’è¦ç´„ã™ã‚‹ã¨ã€Docker ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦é‡è¦ãªã“ã¨ã¨ã¯ storage-driver ã®é¸æŠž (AUFS or Device mapper or ...) Volume ã® ON / OFF AUFS ãªã©ã®å·®åˆ†ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚’ãƒã‚¤ãƒ‘ã‚¹ã™ã‚‹ã‹ã—ãªã„ã‹ Host networ
beth321 2014/11/25
ã‚ã¨ã§èªã‚€

MySQL

app

benchmark

docker

performance

isucon

nginx

isucon4

MySQL
ãƒªãƒ³ã‚¯
Figã‚’ä½¿ã£ã¦è¤‡æ•°ã®Dockerã‚³ãƒ³ãƒ†ãƒŠã‚’ã‚³ãƒžãƒ³ãƒ‰ä¸€ç™ºã§ç«‹ã¡ä¸Šã’ã‚‹ - y_310's diary
åœŸæ—¥ã‚’ä½¿ã£ã¦Dockerå…¥é–€ã‚’èªã¿ãªãŒã‚‰Dockerã‚’è§¦ã£ã¦ã¿ã¾ã—ãŸã€‚ Dockerå…¥é–€ Immutable Infrastructureã‚’å®Ÿç¾ã™ã‚‹ ä½œè€…: æ¾åŽŸè±Š,ç±³æž—æ£æ˜Žå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: æŠ€è¡“è©•è«–ç¤¾ç™ºå£²æ—¥: 2014/04/25ãƒ¡ãƒ‡ã‚£ã‚¢: Kindleç‰ˆã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (4ä»¶) ã‚’è¦‹ã‚‹ ã¨ã‚Šã‚ãˆãšRails/MySQL/Elasticsearchã§æ§‹æˆã•ã‚ŒãŸWebã‚µãƒ¼ãƒ“ã‚¹ã®é–‹ç™ºç’°å¢ƒã‚’ä½œã‚‹ã“ã¨ã‚’æƒ³å®šã—ã¦ã€ã²ã¨é€šã‚Šæ‰‹ã§ã‚³ãƒžãƒ³ãƒ‰ã‚’æ‰“ã¡ãªãŒã‚‰MySQLã¨Elasticsearchã®ã‚³ãƒ³ãƒ†ãƒŠã‚’ä½œã£ã¦Railsã‹ã‚‰æŽ¥ç¶šã•ã›ã‚‹ã“ã¨ã¯ã§ãã¾ã—ãŸã€‚ $ docker run -d -p 9200:9200 -p 9300:9300 dockerfile/elasticsearch $ docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=passwo
beth321 2014/08/11
MySQL

ã‚ã¨ã§è©¦ã™

docker

dockerfile

fig

elasticsearch

MySQL

development

web

ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼
ãƒªãƒ³ã‚¯
Docker ã‚³ãƒ³ãƒ†ãƒŠã§ MySQL ã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã®é«˜é€ŸåŒ– - stfuawsc
å…¨å›½1å„„2000ä¸‡ã® Docker ãƒ•ã‚¡ãƒ³ã®çš†ã•ã‚“ã“ã‚“ã«ã¡ã¯ã€‚ MySQL ã®èµ·å‹•ãŒã¨ã¦ã¤ã‚‚ãªãé…ã„ã®ã¯æœ‰åãªè©±ã€‚ ã¨ã“ã‚ãŒ Docker ã‚³ãƒ³ãƒ†ãƒŠã®èµ·å‹•ã¯ãªã‹ãªã‹æ—©ã„ã®ã§ã€ MySQL ã‚’ä½¿ã£ã¦ã„ã‚‹ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚’é«˜é€ŸåŒ–ã™ã‚‹ã‚±ãƒ¼ã‚¹ã§æœ‰ç”¨æ€§ãŒèªã‚ã‚‰ã‚Œã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã£ã¦ PoC ã‚’æ›¸ã„ã¦ã¿ãŸã€‚ ï¼ˆå®£ä¼ï¼‰ã“ã†ã„ã£ãŸè©±ã‚‚å«ã‚ã¦ YAPC ã§ãƒˆãƒ¼ã‚¯ã—ãŸã„ã®ã§ SNS ç‰ã§ upvote ãŠé¡˜ã„ã—ã¾ã™ï¼š ( âœŒ'Ï‰')âœŒ æ¥½ã—ã„ãƒ¢ãƒ‡ãƒ«å±¤é–‹ç™º - YAPC::Asia Tokyo 2014 ï¼ˆå®£ä¼ãŠã‚ã‚Šï¼‰ MySQL ã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆ MySQL ã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã‚’ã™ã‚‹å ´åˆã€ã ã„ãŸã„æ¬¡ã® 2 ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ãªã‚‹ã€‚ MySQL ã‚’ãƒ†ã‚¹ãƒˆã®ãŸã³ã«èµ·å‹•ã—ã¦ã‚¯ãƒªãƒ¼ãƒ³ãªçŠ¶æ…‹ã§ä½¿ã† ãƒãƒ¼ã‚«ãƒ«ã«ãƒ‡ãƒ¼ãƒ¢ãƒ³ã¨ã—ã¦èµ·å‹•ã—ãŸ MySQL ã«æŽ¥ç¶šã—ã¦ DROP TABLE ã‚„ TRUNCATE ã§ã‚¯ãƒªãƒ¼ãƒ³ãªçŠ¶æ…‹ã«ã—ã¦ä½¿ã† ã ã‘ã©ã€
beth321 2014/07/10
MySQL

docker

mysql

test

perl

ãƒ†ã‚¹ãƒˆ

testing

CI
ãƒªãƒ³ã‚¯
1