[B! DB] restartrã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

restartr id:restartr

DBã«é–¢ã™ã‚‹restartrã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (63)

${{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 with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
restartr 2017/04/19
mysql

performance

database

db
ãƒªãƒ³ã‚¯
do-not-delete-softly
å…¨ä½“ãŒã„ã„æ„Ÿã˜ã«ãªã‚‹ãŸã‚ã«ã€ç§ãŸã¡Railsã‚’ãƒ›ãƒ¼ãƒ ã«ã™ã‚‹WebæŠ€è¡“è€…ãŒã§ãã‚‹ã“ã¨/let-our-whole-system-grow
restartr 2015/09/01
"ãƒ‡ãƒ¼ã‚¿é‡ã®æ‡¸å¿µã¨ã€UXã®æ‡¸å¿µã¯ãã‚Œãžã‚Œåˆ¥ã®å•é¡Œ""ä¸€ç•ªæœ€åˆã®ç”»é¢ã«å‡ºã™ã‚‚ã®ã€ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãªã‚ã‘ã§ã¯ãªã„"

db
ãƒªãƒ³ã‚¯
GitHub - gocardless/statesman: A statesmanlike state machine library.
A statesmanlike state machine library. For our policy on compatibility with Ruby and Rails versions, see COMPATIBILITY.md. Statesman is an opinionated state machine library designed to provide a robust audit trail and data integrity. It decouples the state machine logic from the underlying model and allows for easy composition with one or more model classes. As such, the design of statesman is a l
restartr 2015/09/01
db

ruby

activerecord

rails
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
restartr 2015/09/01
è¡¨ç¾ã¨ã—ã¦ã®æ˜¯éžã¯ã•ã¦ãŠãã€is_deletedã‚„statusã‚ˆã‚Šdeleted_atã®ã»ã†ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹åŠ¹çŽ‡ã‚ˆã•ãã†ã§ã¯ã‚ã‚‹. bitmapã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹...

db
ãƒªãƒ³ã‚¯
"status" vs "state" - Qiita
ã©ã¡ã‚‰ã‚‚å’Œè¨³ã™ã‚‹ã¨ã€ŒçŠ¶æ…‹ã€ã§ã™ã—ã€ä¸€èˆ¬çš„ãªè‹±èªžã¨ã—ã¦ã‚‚ã»ã¼åŒç¾©èªžæ‰±ã„ã•ã‚Œã¦ã„ã¾ã™ãŒåŽ³å¯†ã«ã¯â€¦ status å–ã‚Šå¾—ã‚‹çŠ¶æ…‹ã®ã€é›†åˆã€‘ã§ã™ã€‚ ä¾‹ï¼šã‚¹ãƒ¬ãƒƒãƒ‰ã®çŠ¶æ…‹ state å–ã‚Šå¾—ã‚‹çŠ¶æ…‹ã®ã©ã‚Œã‹ã§ã™ã€‚ ä¾‹ï¼šï¼ˆã‚¹ãƒ¬ãƒƒãƒ‰ã®ï¼‰å®Ÿè¡Œä¸çŠ¶æ…‹ http://oshiete.goo.ne.jp/qa/3909263.html ã“ã¡ã‚‰ã®å›žç”3ç•ªã€ã€Žå¾Œã‚ã«ã€Œï½žã§ã‚ã‚‹çŠ¶æ…‹ã€ã‚’ä»˜ã‘ã¦æ„å‘³ãŒé€šã‚‹å ´åˆã¯ã€stateã€ã¨ã„ã†åˆ¤æ–åŸºæº–ãŒã¨ã¦ã‚‚ã‚¯ãƒªã‚¢ã‚«ãƒƒãƒˆã§ç§€é€¸ã§ã™ãã€‚ Register as a new user and use Qiita more conveniently You get articles that match your needsYou can efficiently read back useful informationYou can use dark themeWhat you can do w
restartr 2015/09/01
statusã¯ã€ŒçŠ¶æ…‹ã®é›†åˆã€ã§ã€stateã¯ã€Œã„ãšã‚Œã‹ã®çŠ¶æ…‹ã€ã¨ã€‚DBä¸Šã¯statusã§æ“ä½œåã¯stateã‚’ä½¿ã£ãŸã»ã†ãŒã»ã†ãŒè‰¯ã„ã®ã‹ãª?

db
ãƒªãƒ³ã‚¯
Auroraã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®QuorumåŽŸç† - yoshidashingo
cloudpackã‚¨ãƒãƒ³ã‚¸ã‚§ãƒªã‚¹ãƒˆã®å‰ç”°çœŸå¾ï¼ˆ@yoshidashingoï¼‰ã§ã™ã€‚ ä»Šå›žç™ºè¡¨ã«ãªã£ãŸ Amazon RDS for Auroraã€‚æœ€å¤§ã®ç‰¹å¾´ã¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒå¾“æ¥ã®RDS(Multi-AZ)ã«ãŠã‘ã‚‹ã€Œå®Œå…¨åŒæœŸãªãƒŸãƒ©ãƒ¼ãƒ‡ã‚£ã‚¹ã‚¯åž‹ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€æ–¹å¼ã§ãªãã€ã€ŒQuorumãƒ™ãƒ¼ã‚¹ã®éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€æ–¹å¼ãŒæŽ¡ç”¨ã•ã‚ŒãŸç‚¹ã§ã™ã€‚ Quorumã®æ¦‚å¿µ Quorumè‡ªä½“ã®æ¦‚å¿µã®èª¬æ˜Žã¯Wikiãªã©ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ãƒŽãƒ¼ãƒ‰é–“ã§æŠ•ç¥¨ã‚’è¡Œã„ã€å®šè¶³æ•°ãŒæƒã£ãŸå‡¦ç†ã‚’å®Ÿè¡Œï¼ç ´æ£„ã™ã‚‹ã¨ã„ã†è€ƒãˆæ–¹ã§ã™ã€‚ Quorum - Wikipedia åŒæœŸåž‹ã®ãƒŸãƒ©ãƒ¼ãƒ‡ã‚£ã‚¹ã‚¯åž‹ã‹ã‚‰éžåŒæœŸã®Quorumåž‹ã¸ Auroraä»¥å¤–ã®RDSã®Multi-AZé…å‚™ã¯ã€ãƒžã‚¹ã‚¿ãƒ¼ãƒŽãƒ¼ãƒ‰ã®ãƒ‡ã‚£ã‚¹ã‚¯ã¸ã®æ›¸ãè¾¼ã¿ã‚’ãƒ–ãƒãƒƒã‚¯ãƒ¬ãƒ™ãƒ«ã§ã‚¹ã‚¿ãƒ³ãƒã‚¤å´ã«é©ç”¨ã™ã‚‹å®Œå…¨åŒæœŸãªãƒ•ã‚£ã‚¸ã‚«ãƒ«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã«ã¯ã„ãã¤ã‹ã®èª²é¡ŒãŒè€ƒãˆã‚‰
restartr 2014/11/28
db

mysql

aurora

aws

rds
ãƒªãƒ³ã‚¯
Scaling Pinterest - From 0 to 10s of Billions of Page Views a Month in TwoÂ Years - High Scalability -
Pinterest has been riding an exponential growth curve, doubling every month and half. Theyâ€™ve gone from 0 to 10s of billions of page views a month in two years, from 2 founders and one engineer to over 40 engineers, from one little MySQL server to 180 Web Engines, 240 API Engines, 88 MySQL DBs (cc2.8xlarge) + 1 slave each, 110 Redis Instances, and 200 Memcache Instances. Stunning growth. So whatâ€™s
restartr 2013/04/16
pinterestã¯DBã®shardingã‚’lookup tableä½¿ã£ã¦æ‰‹å‹•ã§ç®¡ç†ã—ã¦ã„ã‚‹ã¨ã€‚RDBã ã¨ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ãŒã‹ãªã‚Šã—ã‚“ã©ãã†ã€‚

db

architecture

mysql

sharding
ãƒªãƒ³ã‚¯
MySQLã«ãŠã‘ã‚‹JOINã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å®šçŸ³
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
restartr 2011/10/18
nested loop joinã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã®è§£èª¬

mysql

tuning

db

join
ãƒªãƒ³ã‚¯
Troubleshooting response time problems â€“ why you cannot trust your systemÂ metrics - High Scalability -
Production Monitoring is about ensuring the stability and health of our system, that also Â includes the application. A lot of times we encounter production systems Â that concentrate on System Monitoring, under the assumption that a Â stable system leads to stable and healthy applications. So letâ€™s see Â what System Monitoring can tell us about our Application. Letâ€™s take a very simple two tier Web A
restartr 2011/05/13
performance

java

db

tuning

monitoring
ãƒªãƒ³ã‚¯
GitHub - nathanmarz/elephantdb: Distributed database specialized in exporting key/value data from Hadoop
ElephantDB 0.5.1 (cascalog 2.x) ElephantDB 0.4.5 (cascalog 1.x) About ElephantDB is a database that specializes in exporting key/value data from Hadoop. ElephantDB is composed of two components. The first is a library that is used in MapReduce jobs for creating an indexed key/value dataset that is stored on a distributed filesystem. The second component is a daemon that can download a subset of a
restartr 2011/02/26
hadoop

db

elephantdb

cloud
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
restartr 2011/02/26
io

db

performance
ãƒªãƒ³ã‚¯
http://www.whitewashing.de/blog/articles/129
restartr 2010/06/30
*é–‹ç™º

test

phpunit

db

gearman
ãƒªãƒ³ã‚¯
http://no.gd/redis-presentation.pdf
restartr 2010/06/25
[filetype:pdf][media:document]

*ã‚µãƒ¼ãƒãƒ¼

nosql

db

redis

kvs
ãƒªãƒ³ã‚¯
InfoQ: ã‚°ãƒ©ãƒ•ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€NOSQLã€Neo4j
åŽŸæ–‡(æŠ•ç¨¿æ—¥ï¼š2010/05/12)ã¸ã®ãƒªãƒ³ã‚¯ ã¯ã˜ã‚ã« ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã«ã¯ã„ã‚ã„ã‚ã‚ã‚‹ãŒã€80å¹´ä»£ä»¥é™ã€ä¸»æµã«ãªã£ã¦ã„ã‚‹ã®ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã ã€‚ã“ã®ãƒ¢ãƒ‡ãƒ«ã«ã¯Oracleã€MySQLã€MSSQLãªã©ã®å®Ÿè£…ãŒã‚ã‚Šã€RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ : Relational Database Management Systemï¼‰ã¨å‘¼ã°ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ã—ã‹ã—æœ€è¿‘ã«ãªã£ã¦ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã“ã¨ã§å•é¡ŒãŒèµ·ã“ã‚‹ã‚±ãƒ¼ã‚¹ãŒå¢—ãˆã¦ã„ã‚‹ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«ã¯å¼±ç‚¹ã¨å•é¡ŒãŒã‚ã‚Šã€è¤‡æ•°ã‚µãƒ¼ãƒã«åŠã¶æ°´å¹³æ–¹å‘ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨è†¨å¤§ãªãƒ‡ãƒ¼ã‚¿ã®æ‰±ã„ã«åˆ¶ç´„ãŒã‚ã‚‹ãŸã‚ã ã€‚ã“ã‚Œã‚‰ã®å•é¡Œã®è¦å› ã«ã¯ã€ä¸–ç•Œä¸ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãŒæ³¨ç›®ã—ã¦ã„ã‚‹2ã¤ã®ãƒˆãƒ¬ãƒ³ãƒ‰ãŒã‚ã‚‹ã€‚ ãƒ¦ãƒ¼ã‚¶ã€ã‚·ã‚¹ãƒ†ãƒ ã€ã‚»ãƒ³ã‚µãƒ¼ã«ã‚ˆã£ã¦ç”Ÿã¿å‡ºã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã®æŒ‡æ•°çš„ãªå¢—åŠ ã€‚Amazonã€Googleã€ãã®ä»–
restartr 2010/06/17
*ã‚µãƒ¼ãƒãƒ¼

db

nosql

graph

neo4j
ãƒªãƒ³ã‚¯
Maximal write througput in MySQL
I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions, though not easy to answer, as it depends on: â€“ durability setting ( innodb_flush_log_at_trx_commit = 0 or 1 ) ? â€“ do we use binary logs ( I used ROW based replication for 5.1) â€“ do we have sync_binlog options. So why would not take t
restartr 2010/05/20
*ã‚µãƒ¼ãƒãƒ¼

mysql

benchmark

performance

db
ãƒªãƒ³ã‚¯
MeistÃ¤ - Icmfinland
NÃ¤mÃ¤ sivut on omistettu tarjoamaan tietoa ohjelmistosuunnittelusta. Sivuilla kerrotaan esimerkiksi inspiroivana esimerkkinÃ¤ erÃ¤Ã¤stÃ¤ suomalai sesta teinistÃ¤, jonka ohjelmistoalan harrastuksesta kehittyi vientiyhtiÃ¶. Ohjelmistoalan yritykset ovatkin nyt ja tulevaisuudessa erityisen tÃ¤rkeitÃ¤ ja tarjoavat monia mahdollisuuksia. On aika inspiroivaa kuulla, ettÃ¤ jo teini-ikÃ¤isenÃ¤ harrastelijamai sesti alo
restartr 2010/05/15
*é–‹ç™º

php

mongodb

tool

gui

javascript

db

nosql
ãƒªãƒ³ã‚¯
snailinaturtleneck.comÂ -Â snailinaturtleneck ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
restartr 2010/05/12
*ã‚µãƒ¼ãƒãƒ¼

db

nosql

mongodb

performance

scalability

database
ãƒªãƒ³ã‚¯
Big Data in Real-Time at Twitter
The document summarizes how Twitter handles and analyzes large amounts of real-time data, including tweets, timelines, social graphs, and search indices. It describes Twitter's original implementations using relational databases and the probl ems they encountered due to scale. It then discusses their current solutions, which involve partitioning the data across multiple servers, replicating and ind
restartr 2010/04/19
tweets, Timelines, Social Graph, SearchIndex ã«é–¢ã™ã‚‹å•é¡Œã‚’ partitioning, indexing, replication ã«ã‚ˆã£ã¦è§£æ±ºã™ã‚‹äº‹ä¾‹ç´¹ä»‹çš„ãªå†…å®¹ã€‚

*é–‹ç™º

twitter

mysql

tuning

performance

db
ãƒªãƒ³ã‚¯
å¿«é©ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆç”Ÿæ´»ã¸ã®ç¬¬ä¸€æ©ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼
å…ˆæœˆã€Not Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã§SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆãŒå‡„ã„ï¼ã¨ã„ã†è©±ã‚’æ›¸ã„ãŸã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯å‡„ã„ãƒ¤ãƒ„ã ãŒã€ãƒŽã‚¦ãƒã‚¦ãŒã‚ã¾ã‚Šã‚¦ã‚§ãƒ–ä¸Šã§è¦‹ã¤ã‹ã‚‰ãªã„ã€‚å”¯ä¸€è¦‹ã¤ã‹ã‚‹æ—¥æœ¬èªžã®è¨˜äº‹ã¯ã€ã‚¦ãƒŽã‚¦ãƒ©ãƒœã«ã‚ˆã‚‹ã€Œå›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã ã€ã ã‘ã§ã‚ã‚‹ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯æ–¯æ³¢æ°ã«ã‚ˆã‚‹å˜ç‹¬ã®ä½œå“ã§ã‚ã‚‹ãŸã‚ã€æ–¯æ³¢æ°ã¯é–‹ç™ºã ã‘ã§æ‰‹ã„ã£ã±ã„ã§ã‚ã‚Šã€ä½¿ã„æ–¹ã®ç´¹ä»‹è¨˜äº‹ã‚’æ›¸ãã“ã¨ã¾ã§ã¯æ‰‹ãŒå›žã‚‰ãªã„ã®ã§ã‚ã‚ã†ã€‚ã“ã‚“ãªå‡„ã„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒè¶³ã‚Šãªã„ã›ã„ã§ä½¿ã£ã¦è²°ãˆãªã„ãªã‚“ã¦å‹¿ä½“ãªã„ï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€ä»Šæ—¥ã¯SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚å°‘ã—é•·ã„ã‚¨ãƒ³ãƒˆãƒªã§ã‚ã‚‹ãŒã€æœ€å¾Œã¾ã§ãŠä»˜ã
restartr 2010/04/13
*ã‚µãƒ¼ãƒãƒ¼

mysql

spider

db
ãƒªãƒ³ã‚¯
yohei-y:weblog: CAPã®Cã¨ACIDã®C
CAP å®šç†ã¨ BASE ã®æ¦‚å¿µã‚’è€ƒãˆãŸã®ã¯ UCB ã® Brewer å…ˆç”Ÿã§ã€å½¼ã¯ inktomi ã®å‰ã„äººã ã£ãŸã¨ã„ã†ã®ã¯å‰å›žè¿°ã¹ãŸã€‚ å½“æ™‚ã®inktomiã¯Yahoo!ã‚„ Microsoftã€ãã‚Œã«gooã«ã‚‚æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æä¾›ã—ã¦ã„ã¦ã€1å„„ä»¥ä¸Šã®Webãƒšãƒ¼ã‚¸(ãƒ†ãƒ©ãƒã‚¤ãƒˆç´šã®ãƒ‡ãƒ¼ã‚¿)ã‚’æ‰±ã£ã¦ã„ãŸã‚ˆã†ã ã€‚ æ‰‹å…ƒã®WEB+DB PRESS Vol.49 ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«è¨˜äº‹ã«ã‚ˆã‚‹ã¨ã€ç¾åœ¨ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã¯1160ä¸‡URLã¨100GBã®HTMLãƒ‡ãƒ¼ã‚¿(åœ§ç¸®æ¸ˆã¿)ã‚’æ‰±ã£ã¦ã„ã‚‹ã‚‰ã—ã„ã®ã§ã€ã–ã£ãã‚Šã„ã£ã¦98å¹´ã®æ™‚ç‚¹ã§inktomi ã¯ç¾åœ¨ã®ã¯ã¦ãƒ–ã®10å€ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã£ã¦ã„ãŸã¨ã„ã£ã¦ã‚‚ã„ã„ã€‚inktomiã§ä½¿ã£ã¦ã„ãŸã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®æ€§èƒ½ã¯ç¾åœ¨ã®PCã‚µ ãƒ¼ãƒã«æ¯”ã¹ã‚Œã°1/10ç¨‹åº¦ã®æ€§èƒ½ãªã®ã§ã€ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã§ã¿ã‚‹ã¨ç¾åœ¨ã®ã¯ã¦ãƒ–ã®100å€ã®è¦æ¨¡ã«ãªã‚‹ã ã‚ã†ã‹ã€‚ çµæžœçš„ã«ã¯ã€inktom
restartr 2010/04/08
*ã‚µãƒ¼ãƒãƒ¼

db

nosql

acid

cap
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸