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

river2470 id:river2470

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

${{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ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚»ãƒŸãƒŠãƒ¼å¤§å…¬é–‹
3. Yahoo! JAPANã®RDBç’°å¢ƒ â€¢ 11g RAC Enterprise Edition â€¢ ç´„200DB â€¢ ã‚µãƒ¼ãƒ 200å°, Exadata ã‚‚ã‚ã‚‹ã‚ˆ â€¢ MySQL 5.1 (RR,Mixed) Percona 5.5 (RR,Mixed) Percona 5.6 (RC,RBR,GTID) â€¢ ç´„500DB â€¢ ã‚µãƒ¼ãƒ 300å° Oracle Database MySQL Percona
river2470 2016/02/23
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
river2470 2014/11/25
docker

nginx

mysql
ãƒªãƒ³ã‚¯
http://sw.wkeya.com/archives/216
river2470 2014/05/23
mysql

utf8
ãƒªãƒ³ã‚¯
MySQLãƒ¦ãƒ¼ã‚¶è¦–ç‚¹ã§ã®å°ã•ãå§‹ã‚ã‚‹Elasticsearch
2. 1. ã¯ã˜ã‚ã« 2. è‡ªå·±ç´¹ä»‹ 3. ä»Šå›žã®ãƒ†ãƒ¼ãƒž æœ¬æ—¥ã®æµã‚Œ 4. Yamabikoã®ç´¹ä»‹ 5. æ¤œç´¢ã“ã¨ã¯ã˜ã‚ 6. Elasticsearché›‘æ„Ÿ 7. ã¾ã¨ã‚ page 2
river2470 2014/02/12
mysql

elasticsearch
ãƒªãƒ³ã‚¯
MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰ã€å¿…ãšç¢ºèªã™ã¹ã10ã®è¨å®š | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«å¿…ãšè¨å®šã‚’ç¢ºèªã—ãªã‘ã‚Œã°ãªã‚‰ãªã„è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿10ã¤ã‚’æŒ™ã’ã€ãã®æ„å‘³ã‚’è§£èª¬ã™ã‚‹ã€‚MySQLã®è¨å®šå¤‰æ›´æ™‚ã®ã€ä¸€èˆ¬çš„ãªæ³¨æ„ç‚¹ã‚‚åˆã‚ã›ã¦ã€‚ January 28, 2014 By Stephane Combaudon æˆ‘ã€…ãŒãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£æŸ»ã®ä»•äº‹ã‚’ã™ã‚‹æ™‚ã«ã¯ã€MySQLã®è¨å®šã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¨æ”¹å–„ææ¡ˆã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã€‚å¤§æŠµã®å ´åˆã€ãŸãã•ã‚“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ä¸ã§ã»ã‚“ã®ã„ãã¤ã‹ã®è¨å®šã—ã‹å¤‰æ›´ã™ã‚‹ã‚ˆã†ã«ææ¡ˆã—ãªã„ã“ã¨ã«ã€å¤šãã®é¡§å®¢ã¯é©šãã€‚ã“ã®è¨˜äº‹ã®ã‚´ãƒ¼ãƒ«ã¯ã€ã‚‚ã£ã¨ã‚‚é‡è¦ãªè¨å®šã‚’ã„ãã¤ã‹æŒ™ã’ã¦ã¿ã‚‹ã“ã¨ã«ã‚ã‚‹ã€‚ æ—¢ã«ã“ã†ã„ã£ãŸææ¡ˆã¯éŽåŽ»ã«ã‚‚ã—ã¦ã„ã‚‹ãŒæ•°å¹´å‰ã®ã‚‚ã®ã§ã€ãã‚Œä»¥æ¥MySQLã®ä¸–ç•Œã§ã¯ãŸãã•ã‚“ã®å¤‰åŒ–ãŒã‚ã£ãŸã®ã ã€‚ è©±ã®å‰ã« ç†Ÿç·´ã—ãŸäººã§ã‚‚ã€é‡å¤§ãªãƒˆãƒ©ãƒ–ãƒ«ã‚’å¼•ãèµ·ã“ã™ãƒŸã‚¹ã‚’ã—ã§ã‹ã™ã“ã¨ãŒã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã“ã“ã«æŒ™ã’ãŸã‚‚ã®ã‚’ç›²ç›®çš„ã«é©ç”¨ã™ã‚‹å‰ã«ã€
river2470 2014/02/03
mysql
ãƒªãƒ³ã‚¯
Ruby/MySQLã®é€Ÿåº¦ - tmtms ã®ãƒ¡ãƒ¢
Ruby 2.1.0 preview1 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã®ã§ã€Ruby/MySQL ã®é€Ÿåº¦ã‚’æ¸¬ã£ã¦ã¿ã¾ã—ãŸã€‚ æ¸¬å®šç’°å¢ƒ ThinkPad X220 Core i5 2.3GHz Linux Mint 15 32bit MySQL 5.6.13 æ¸¬å®šå†…å®¹ã¯ https://github.com/tmtm/ruby-mysql/tree/master/bench å‚ç…§ã€‚ ruby-mysql ã™ã¹ã¦ Ruby ã§æ›¸ã‹ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã™ã€‚ select_prepare ã«æŽ›ã‹ã‚‹æ™‚é–“ãŒ 1.9.3, 2.0, 2.1 ã¨å¢—åŠ å‚¾å‘ã«ã‚ã‚Šã¾ã™ã€‚ ãã‚Œä»¥å¤–ã¯ 1.9.3 ä»¥é™ã¯ã©ã‚Œã‚‚ã»ã¼åŒã˜ã§ã™ã€‚ insert ã¨ insert_prepare ã®å·®ã¯ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ MySQL ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯è¡¨ç¾ã«å¤‰æ›ã—ã¦ã„ã‚‹éƒ¨åˆ†ã«ã‚ˆã‚‹ã‚‚ã®ã§ã—ã‚‡ã†ã‹ã€‚ ã‚‚ã—ã‹ã—ãŸã‚‰ã€æ•´æ•°ãªã‚“ã‹ã¯å¾‹å„€ã«å¤‰æ›ã›ãšã« to_s ã—ã¦æ–‡å—åˆ—
river2470 2013/09/28
mysql

ruby
ãƒªãƒ³ã‚¯
ActiveRecordã®DBã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®æŽ¥ç¶šåˆ‡ã‚Œã¨å†æŽ¥ç¶šã«ã¤ã„ã¦ã€‚reconnectã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯å±é™ºã ãªãƒ¼ã¨ã‹ã‚‚ - odeã®é–‹ç™ºãƒ¡ãƒ¢æ—¥è¨˜
ActiveRecordã¯åŸºæœ¬ãšã£ã¨æŽ¥ç¶šã‚’ã¯ã‚Šã£ã±ãªã—ã«ã—ã¾ã™ã€‚ ãªã®ã§é•·æ™‚é–“æŽ¥ç¶šã‚’ã¯ã‚Šã£ã±ãªã—ã«ã™ã‚‹ãŸã‚ ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆç‰ã§æŽ¥ç¶šãŒãã‚Œã‚‹ã¨å•é¡ŒãŒã§ã¾ã™ã€‚ MySQLã§DBã®æŽ¥ç¶šãŒãã‚Œã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚° çŠ¶æ³åˆ¥ Railsã®å ´åˆ HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆã®ã‚ã‚‹ãŸã³ã«æŽ¥ç¶šãŒåˆ‡ã‚Œã¦ãªã„ã‹ã‚’ç¢ºèªã—ã¾ã™ã€‚åˆ‡ã‚Œã¦ã‚‹å ´åˆã¯å†æŽ¥ç¶šã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã®ã§å•é¡Œãªã•ãã†ã§ã™ã€‚ ãƒãƒƒãƒã€ãƒ‡ãƒ¼ãƒ¢ãƒ³ç‰ ActiveRecordã‚’ä½¿ã£ãŸå ´åˆã¯ãšã£ã¨ã¤ãªãŽã£ã±ãªã—ã«ãªã‚‹ãŸã‚ã€é€”ä¸ã§æŽ¥ç¶šãŒåˆ‡ã‚Œã‚‹ã¨ã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã™ã€‚ reconnectã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯å±é™º ã˜ã‚ƒã‚ãƒãƒƒãƒç‰ã®å ´åˆè‡ªå‹•ã§å†æŽ¥ç¶šã—ã¦ãã‚Œã‚Œã°ã¨æ€ã†ã¨ MySqlã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒ¬ãƒ™ãƒ«ã§ãƒªã‚³ãƒã‚¯ãƒˆã®æ¦‚å¿µãŒã‚ã‚Šã¾ã—ãŸã€‚ railsã§ä½¿ã†ã«ã¯database.ymlã«:reconnect = trueã§æŒ‡å®šã§ãã¾ã™ã€‚ ãŒï¼ï¼ railsã®å®Ÿè£…ã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯OFFã«ãªã£ã¦ã„ã¾ã™
river2470 2013/09/10
ruby

activerecord

mysql
ãƒªãƒ³ã‚¯
"MySQL server has gone away" with Ruby on Rails
After our Ruby on Rails application has run for a while, it starts throwing 500s with "MySQL server has gone away". Often this happens overnight. It's started doing this recently, with no obvious change in our server configuration. Mysql::Error: MySQL server has gone away: SELECT * FROM `widgets` Restarting the mongrels (not the MySQL server) fixes it. How can we fix this?
river2470 2013/09/10
ruby

activerecord

mysql
ãƒªãƒ³ã‚¯
MySQL connection timeout - MySQL server has gone away (Sinatra, ActiveRecord)
Here is an outline of my app: require 'sinatra' require 'active_record' ActiveRecord::Base.establish_connection( :adapter => "mysql", host => $DB_HOSTNAME, :database => $DB_NAME,:username => $DB_USERNAME,:password => $DB_PASSWORD) class Sometable < ActiveRecord::Base end get '/' do #stuff with Sometable end # a lot of route handlers.. etc. I call establish_connection just once - during the app ini
river2470 2013/09/10
ruby

activerecord

mysql
ãƒªãƒ³ã‚¯
Wizard In The Market
Wizard In The Market
river2470 2012/09/21
ruby

mysql

activerecord
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
2024å¹´ä¸‹åŠæœŸã®ãƒ•ã‚£ãƒ«ãƒ å†™çœŸãŸã¡ ãµã¨æ°—ãŒã¤ãã¨2024å¹´ã‚‚æ®‹ã‚Šåƒ…ã‹ã€‚ ãã—ã¦ãµã¨æŒ¯ã‚Šè¿”ã‚‹ã¨ã“ã®ãƒ–ãƒã‚°ã«æŽ²è¼‰ã™ã‚‹å†™çœŸãŒGRIIIã§æ’®ã£ãŸã‚‚ã®ã°ã‹ã‚Šã«ãªã£ã¦ã„ãŸã®ã ã‘ã©ã€æ±ºã—ã¦ãƒ•ã‚£ãƒ«ãƒ ã«é£½ããŸã¨ã„ã†ã“ã¨ã§ã¯ãªãã€ãƒ•ã‚£ãƒ«ãƒ ã¯ãƒ•ã‚£ãƒ«ãƒ ã§æ·¡ã€…ã¨æ’®ã‚Šç¶šã‘ã¦ã„ã‚‹ã—ã€ãƒ¢ãƒŽã‚¯ãƒã‚‚ã‚«ãƒ©ãƒ¼ãƒã‚¬ã‚‚ã„ã¤ã‚‚é€šã‚Šè‡ªå®…ã§â€¦
river2470 2012/09/14
mysql

backup
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
river2470 2011/07/28
mac

mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ç™»å ´ï¼ï¼æ–°æ©Ÿèƒ½é€Ÿæ”»ãƒ¬ãƒ“ãƒ¥ãƒ¼
ç¾åœ¨ã€ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Conference & Expoã«ã‚ã‚ã›ã¦ã€æ–°ã—ã„é–‹ç™ºç‰ˆã§ã‚ã‚‹MySQL 5.6ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚MySQL 5.5ã«ãŠã‘ã‚‹æ–°æ©Ÿèƒ½ã‚‚ã‹ãªã‚Šã®ã‚‚ã®ã ã£ãŸãŒã€MySQL 5.6ã®é€²åŒ–ã¯è³ªãƒ»é‡ã¨ã‚‚ã«å‹ã¨ã‚‚åŠ£ã‚‰ãªã„å†…å®¹ã¨ãªã£ã¦ã„ã‚‹ã€‚ãã“ã§ã€ä»Šæ—¥ã¯ç°¡å˜ã«ã€MySQL 5.6ã§è¿½åŠ ã•ã‚ŒãŸæ–°æ©Ÿèƒ½ã®æ¦‚è¦ã«ã¤ã„ã¦è¦‹ã¦ã¿ã‚ˆã†ã€‚é–‹ç™ºç‰ˆãªã®ã§åˆ©ç”¨ã«ã‚ãŸã£ã¦ã¯ååˆ†ãªæ³¨æ„ãŒå¿…è¦ï¼ˆäºˆæœŸãªãäºˆå®šãŒå¤‰æ›´ã•ã‚Œã‚‹å¯èƒ½æ€§ã‚ã‚Šï¼‰ã ãŒã€æ¬¡æœŸæ£å¼ç‰ˆã®ãƒªãƒªãƒ¼ã‚¹ã«å‘ã‘ã¦æ˜¯éžè©¦ã—ã¦ã¿ã¦æ¬²ã—ã„ã€‚ InnoDBé–¢é€£MySQL 5.5ã§å¤§å¹…ãªé€²åŒ–ã‚’é‚ã’ãŸInnoDBã ãŒã€ãã®å‹¢ã„ã¯ã¾ã£ãŸãè¡°ãˆã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„ã€‚æ€§èƒ½ã®å¼·åŒ–ã ã‘ã§ãªãã€ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šãä¾¿åˆ©ãªæ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã€‚ ãƒ€ãƒ¼ãƒ†ã‚£ãƒšãƒ¼ã‚¸ã®ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã™ã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ãŒç‹¬ç«‹ã—ãŸã€‚ä»¥å‰ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰å†…ã§ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãŒè¡Œã‚ã‚Œã¦ã„ãŸãŒã€ã‚¹ãƒ¬ãƒƒãƒ‰ãŒç‹¬ç«‹ã—ãŸã“ã¨ã«ã‚ˆã£
river2470 2011/04/12
mysql

innodb
ãƒªãƒ³ã‚¯
WordPressã‚’100å€é€Ÿãã™ã‚‹ï¼ MySQLã®èª¿æ•´ã‚„nginx proxy cache | KRAY Inc
[è¿½è¨˜ï¼‘] æœ€å¾Œã§èª¬æ˜Žã—ã¦ã„ã‚‹proxy cacheã®è¨å®šã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚ [è¿½è¨˜ï¼’] nginx proxy cacheã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„å ´åˆã®å‡¦ç†ã‚’å¤‰æ›´ã—ã¾ã—ãŸã€‚ [è¿½è¨˜ï¼“] ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚„æºå¸¯ã§é–²è¦§ã—ãŸæ™‚ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãªã„è¨å®šã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« å¤§ã’ã•ãªé¡Œåã§ã™ãŒã€ä»Šå›žã¯WordPresså˜ä½“ã‚’é€Ÿãã™ã‚‹ã®ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„Webã‚µãƒ¼ãƒãªã©ã®èª¿æ•´ã€ã¾ãŸnginxã®proxy cacheæ©Ÿèƒ½ã‚’ä½¿ã£ã¦é€Ÿãã™ã‚‹è©±ã«ãªã‚Šã¾ã™ã€‚ ã‚µã‚¤ãƒˆã®æ§‹æˆã«ã‚ˆã£ã¦ã¯ã€proxy cacheã¯ä½¿ãˆãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ä½¿ã‚ãªãã¦ã‚‚5å€ç¨‹åº¦é€Ÿãã™ã‚‹ã“ã¨ã¯ã§ãã¾ã—ãŸã®ã§ã€å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žè¡Œã†ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ä¸€è¦§ DBã‚’æœ€é©åŒ–ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å°Žå…¥ã™ã‚‹ APCã‚’å°Žå…¥ã—ã¦PHPã‚’é€Ÿãã™ã‚‹ MySQLã‚’é€Ÿãã™ã‚‹ é‡ã„WordPressãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’å¤–ã™ nginx+FastCGIã«ã™ã‚‹ W
river2470 2011/04/09
nginx

mysql

wordpress
ãƒªãƒ³ã‚¯
spiritlooseã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ProxyãŒãŠã‚‚ã—ã‚ãã†
http://forge.mysql.com/wiki/MySQL_Proxy ã»ãƒ¼ãƒ»ãƒ»ãƒ»ãªã‹ãªã‹ãŠã‚‚ã—ã‚ãã†ã€‚ mod_proxy_balancer and mod_rewrite for MySQLã¿ãŸã„ãªã‹ã‚“ã˜ã‹ãªãã€‚ ã¨ã„ã£ã¦ã‚‚ã€tritonn ã¿ãŸã„ã« MySQL ã«çµ„ã¿è¾¼ã‚€ã‚“ã˜ã‚ƒãªãã£ã¦ã€åˆ¥ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ã‚µãƒ¼ãƒã€‚ load balancing fail over ã‚ãŸã‚ŠãŒ mod_proxy_balancer ã£ã½ãã¦ Query interception Query rewriting Injecting queries ã‚ãŸã‚ŠãŒ mod_rewrite ã£ã½ã„ã€‚ mod_rewrite ã¿ãŸã„ã«æŒ™å‹•ã‚’é¸ã¶(Pã¨ã‹Rã¨ã‹PTã¨ã‹)ã‚“ã˜ã‚ƒãªãã¦ã€ã‚³ã‚¢ã®æŒ™å‹•ã¯ãªãã¦ã€å…¨éƒ¨ Rewrit eMap prg:/path/to/script ã¿ãŸã„ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã£ã½ã„ã€‚ ã€Œ--proxy-lu
river2470 2011/03/30
mysql

proxy
ãƒªãƒ³ã‚¯
MySQL Clusterã¸ã®æŽ¥ç¶šæ–¹æ³•
ã©ã†ã‚„ã£ã¦ãŸãã•ã‚“ã‚ã‚‹SQLãƒŽãƒ¼ãƒ‰ã«æŽ¥ç¶šã™ã‚Œã°ã„ã„ã‚“ã ï¼Ÿ ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ã¯ï¼Ÿ ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¯ï¼Ÿ ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã¨æ€ã†ã€‚ã“ã®ãƒ†ãƒ¼ãƒžã‚’æ‰±ã£ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ã‚ã‚Šãã†ã ã¡ã‚‡ã†ã©è‰¯ã„ã‚‚ã®ãŒè¦‹ã‚ãŸã‚‰ãªã„ã€‚ãŠãã‚‰ãã“ã®ç‚¹ãŒæ˜Žç¢ºã§ãªã„ãŸã‚ã«ã€Œã‚ˆã—ã€æœ€è¿‘ã‚µã‚¤ãƒˆã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚‚å¢—ãˆã¦ããŸã“ã¨ã ã—ã€ã„ã£ã¡ã‚‡MySQL Clusterã‚’è©¦ã—ã¦ã¿ã‚ˆã†ã‹ï¼ã€ã¨ã„ã†æ°—ã«ãªã‚‰ãšã€å¤šãã®äººãŒåˆ©ç”¨ã‚’èºŠèº‡ã£ã¦ã—ã¾ã£ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã ã‚ã†ã‹ï¼Ÿãªã®ã§ä»Šæ—¥ã¯ã“ã®ç‚¹ã«ã¤ã„ã¦5ãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚ ãã®å‰ã«ã€ã€ŒMySQL Clusterã£ã¦ä½•ã ï¼Ÿã‚·ãƒ©ãƒãƒ¼ãƒ¨ï¼ã€ã£ã¦äººã¯ã€MySQL Clusterã®ç‰¹å¾´ã‚„ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ–¹æ³•ãªã©ã‚’ä»¥å‰ã«ThinkITã¸æŠ•ç¨¿ã—ãŸã®ã§ãã¡ã‚‰ã‚’å‚ç…§ã—ã¦è²°ã„ãŸã„ã€‚ http://www.thinkit.co.jp/article/95/ ã§ã¯æœ¬é¡Œã€‚ 1. mysqldã‚’ã‚¢ãƒ—ãƒªã¨å…±å˜æã‚‰ã
river2470 2011/03/30
mysql

proxy
ãƒªãƒ³ã‚¯
livedoor Techãƒ–ãƒã‚° : MySQL Proxy ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸ
ã“ã‚“ã«ã¡ã¯ã€‚é‡‘åã§ã™ã€‚ å…ˆæ—¥ã€ç¤¾å†…å‹‰å¼·ä¼šã§ MySQL Proxy ã‚’å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ãã®éš›ã¾ã¨ã‚ãŸè³‡æ–™ã‚’ã€ä¸€éƒ¨åŠ ç†ä¿®æ£ã—ã¦å…¬é–‹ã—ã¾ã™ã€‚ æœ€åˆã«ãŠè©«ã³ å¤§å…ƒã®æ–‡ç« ã‚’æ›¸ã„ãŸã®ãŒ 2007 å¹´ã® 7 æœˆãªã®ã§ã€å†…å®¹ãŒå°‘ã—å¤ã„ã§ã™ã€‚ã“ã‚Œã‚’æ›¸ããªãŒã‚‰æœ€æ–°ç‰ˆã‚’ãƒã‚§ãƒƒã‚¯ã‚¢ã‚¦ãƒˆã—ã¦ãã¦å†æ¤œè¨¼ã—ãŸã‹ã£ãŸã®ã§ã™ãŒã€ãƒ¬ãƒã‚¸ãƒˆãƒªãŒãƒ€ã‚¦ãƒ³ã—ã¦ã„ã¦æœ€æ–°ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¥æ‰‹ã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ãªã®ã§ã€ä¸€ãƒ¶æœˆå‰ã®ãƒªãƒ“ã‚¸ãƒ§ãƒ³(rev.116) æ™‚ç‚¹ã§ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ + äºŒé€±é–“ãã‚‰ã„å‰ã«ãƒ¬ãƒã‚¸ãƒˆãƒªã‚’è¦—ã„ãŸã¨ãã®è¨˜æ†¶ã®ã¿ã§æ›¸ã„ã¦ãŠã‚Šã€ã„ã‚ã„ã‚é–“é•ã£ã¦ã„ã‚‹ãŠãã‚ŒãŒã‚ã‚‹ã®ã§ã€ã¿ãªã•ã‚“æ˜¯éžè‡ªåˆ†ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦è©¦ã—ã¦ã¿ã¦ãã ã•ã„(æ³¨æ„!ãŸã ã§ã•ãˆã¤ãªãŒã‚Šã«ãã„ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’å…¨éƒ¨èªã‚“ã§ä¸€é€±é–“å¾Œã«ã¾ã MySQL Proxy ã®ã“ã¨ã‚’è¦šãˆã¦ã„ãŸäººã ã‘ãƒ¬ãƒã‚¸ãƒˆãƒªã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã ã•ã„ã) æ°—ã®æ—©ã„äººå‘ã‘ã®çµè«– ã¾ã å®Ÿè·µæŠ•å…¥ã™ã‚‹ã«ã¯åŽ³ã—
river2470 2011/03/30
mysql

proxy
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
river2470 2011/02/14
mysql

social
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
river2470 2010/09/29
friendfeed

mysql

database

schemaless
ãƒªãƒ³ã‚¯
FriendFeedã¯ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãªãƒ‡ãƒ¼ã‚¿ã‚’MySQLã«æ ¼ç´ã—ã¦ã„ã‚‹ã‹ - ãƒ¢ã‚¸ãƒã‚°
FriendFeedã®Bret TaylorãŒã€ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãªãƒ‡ãƒ¼ã‚¿ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼ˆåž‹ï¼‰ã«åˆ¶ç´„ã•ã‚Œãªã„ãƒ‡ãƒ¼ã‚¿ï¼‰ã‚’MySQLã«æ ¼ç´ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹ã€‚å®Ÿéš›ã«FriendFeedã§ä½¿ã£ã¦ã„ã‚‹æ–¹æ³•ã§ã€æœ€æ–°ã®ã‚‚ã®ã‚‰ã—ã„ã€‚ Bret Taylor's blog - How FriendFeed uses MySQL to store schema-less data http://bret.appspot.com/entry/how-friendfeed-uses-mysql MySQLã‚’é€šå¸¸ã®RDBçš„ãªæ–¹æ³•ã§ãªãã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸çš„ã«ä½¿ã„ã€JOINã‚’ä½¿ã‚ãªã„ã§ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹ã¨ã„ã†ã‚‚ã®ã€‚CouchDBãªã©ã«ã‚‚è¿‘ã„ã€æœ€è¿‘æœ‰åŠ›ã«ãªã‚Šã¤ã¤ã‚ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã ã€‚ã“ã‚Œã‚’ã€å®Ÿç¸¾ã‚‚ã‚ã‚Šæ™®åŠã—ã¦ã„ã‚‹MySQLã‚’ä½¿ã£ã¦å®Ÿç¾ã—ã€è¨€èªžã¯Pythonã§å®Ÿè£…ã—ã¦ã„ã‚‹ã€‚ ãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯æ¬¡ã®ã‚ˆã†ãªã‚‚ã®ã€‚ CREATE TABLE ent
river2470 2010/09/29
friendfeed

mysql

database

schemaless
ãƒªãƒ³ã‚¯
1