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

restartr id:restartr

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

${{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
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
Open Source Database (RDBMS) for the Enterprise | MariaDB
MARIADB ENTERPRISE SERVER FREEDOM TO GO ANYWHERE A reliable, cloud-native database that doesnâ€™t force choices. Run where you want, how you want, at a fraction of the cost of proprietary databases. Learn Whatâ€™s New Webinar On Demand Untethering from Oracle: Technical Guide for Migrating Your Enterprise to MariaDB
restartr 2010/01/19
*é–‹ç™º

MariaDB

mysql

db
ãƒªãƒ³ã‚¯
Top 20+ MySQL Best Practices | Envato Tuts+
Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. In this article, I'll list some MySQL optimization techniques for programmers. Before we start,
restartr 2009/11/26
*é–‹ç™º

mysql

æœ€é©åŒ–

db

sql

tips
ãƒªãƒ³ã‚¯
MySQLãƒŽã‚¦ãƒã‚¦
ã„ã‚ã„ã‚ãªæœ¬ã‹ã‚‰ãƒ¡ãƒ¢ã£ã¦ããŸãƒ¡ãƒ¢ã®ãƒ¡ãƒ¢ã€‚å‡ºå…¸ã‚’æ›¸ã„ã¦ãŠãã®ã‚’å¿˜ã‚ŒãŸã€‚æ€ã„å‡ºã—æ¬¡ç¬¬è£œå®Œã™ã‚‹ã‹ã‚‚ã€‚ deleteã®ã‚³ã‚¹ãƒˆã¯é«˜ã„ã®ã§ã€ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã£ã¦updateã™ã¹ã slow query logã«è¦æ³¨æ„ å¤šãã®ã‚¨ãƒ³ãƒˆãƒªã§ã»ã¨ã‚“ã©ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒåŒã˜å€¤ã‚’æŒã¤å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå°ã•ã„ â†’è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå¤§ãã„ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æŒ‡å®šã®é †ç•ªãŒå¤§åˆ‡ã€‚Aã¨Bã¨ã„ã†æŒ‡å®šã®å ´åˆã€Aå˜ç‹¬ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒã‚ã‚‹ã€‚é€†ã¯çœŸã§ãªã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹å ´é¢ã¯ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã‚’å®šæ•°ã¨æ¯”è¼ƒã™ã‚‹ã¨ã (where name = 'hogehoge') ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã§JOINã™ã‚‹ã¨ã (where a.name = b.name) ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã®ç¯„å›²ã‚’æ±‚ã‚ã‚‹ã¨ã (<,>,between) LIKEå¥ãŒæ–‡å—åˆ—ã‹ã‚‰å§‹ã¾ã‚‹ã¨ã (where name like 'hoge%') min(),
restartr 2009/09/30
*ã‚µãƒ¼ãƒãƒ¼

mysql

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

æœ€é©åŒ–

é«˜é€ŸåŒ–

sql

DB
ãƒªãƒ³ã‚¯
http://japan.internet.com/developer/20071009/26.html
restartr 2009/09/08
mysql5.0

*é–‹ç™º

db

mysql
ãƒªãƒ³ã‚¯
ç±³å¤§çµ±é ˜é¸ã§MySQLã¯ã©ã®ã‚ˆã†ã«ä½¿ã‚ã‚ŒãŸã®ã‹
æ—¥æœ¬ã®è¡†è°é™¢é¸æŒ™ãŒé–“è¿‘ã«è¿«ã£ã¦ã„ã¾ã™ãŒã€æ˜¨å¹´ç±³å›½ã§è¡Œã‚ã‚ŒãŸå¤§çµ±é ˜é¸ã«ãŠã„ã¦ã€ã‚ªãƒãƒžé™£å–¶ãŒIT æŠ€è¡“ã‚’é§†ä½¿ã—ãŸã¨ã„ã†è©±ã¯ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚MySQLã‚‚ã‚‚ã¡ã‚ã‚“ä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šå¹´4æœˆã«ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§é–‹å‚¬ã•ã‚ŒãŸMySQL Conference & Expo 2009ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã¯ã€æœ€çµ‚æ—¥ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ã€Obama Tech Teamã®æ–¹ã€…ã‚ˆã‚Šã€å¤§çµ±é ˜é¸ã«ãŠã„ã¦MySQLãŒã„ã‹ã«ä½¿ã‚ã‚ŒãŸã‹ã¨ã„ã†ç™ºè¡¨ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ æœ¬å½“ã¯ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹çµ‚äº†å¾Œã«ã™ãã¡ã‚ƒã‚“ã¨ã—ãŸãƒ¬ãƒãƒ¼ãƒˆã‚’æ›¸ã„ã¦å…¬é–‹ã™ã‚‹äºˆå®šã ã£ãŸã®ã§ã™ãŒã€ãã®é€±ã«èµ·ã“ã£ãŸè‰ãªãŽå‰›é€®æ•ã¨ã‹ã€ãã®ã»ã‹ã®å‡ºæ¥äº‹ã«ã™ã£ã‹ã‚Šæ°—ã‚’å–ã‚‰ã‚Œã¦æ”¾ç½®ã—ã¦ã„ã¾ã—ãŸã€‚Blogã‚’å§‹ã‚ãŸå¥‘æ©Ÿã«Twitterã®ä¸ã§èˆˆå‘³ã‚’æŒã£ã¦ã„ã‚‹æ–¹ãŒã„ã‚‹ã‹ã©ã†ã‹èžã„ãŸã¨ã“ã‚ã€ãã“ãã“ã®æ–¹ãŒèˆˆå‘³ã‚’ç¤ºã—ãŸã®ã§ã€ã“ã“ã§ç°¡å˜ã«ã¾ã¨ã‚ãŸãƒ¡ãƒ¢ã‚’å…¬é–‹ã™ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ â—ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒãƒ¼ ç™ºè¡¨è€…ã¯
restartr 2009/08/28
*ã‚µãƒ¼ãƒãƒ¼

mysql

db

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

æœ€é©åŒ–

sql

tips
ãƒªãƒ³ã‚¯
MyNA Web Site
Home è³‡æ–™ç½®ãå ´ ä½œè€…ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« â€ æ°åï¼šæ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) æ‰€å±žï¼šã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ å½¹å‰²ï¼šMySQLã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° Blogï¼šhttp://opendatabaselife.blogspot.com/ Twitterï¼šhttp://twitter.com/matsunobu â†‘
restartr 2009/08/13
*ã‚µãƒ¼ãƒãƒ¼

db

mysql

reference
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
restartr 2009/08/01
*é–‹ç™º

db

mysql

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
BKCon 2006 - ã«ã½ãŸã‚“ç ”ç©¶æ‰€
æ˜¨æ—¥ã¯ BKCon 2006 ã«è¡Œã£ã¦ããŸã€‚ BK ã¨ã„ã†ã®ã¯ã€Œä¸€èˆ¬çš„ã«ã¯ãƒãƒƒãƒ‰ãƒŽã‚¦ãƒã‚¦ã®äº‹ã€ãªã‚“ã§ã™ãŒã€æ˜¨æ—¥ã®ã¯ã€BKCon ã¨è¨€ã£ã¦ã‚‚ã€ã‹ã¤ã¦é–‹å‚¬ã•ã‚ŒãŸ Bad Knowhow Conference 2004 ã®ç¶šç·¨ã¨ã‹ã§ã¯ãªãã€"B"atara "K"esuma "Con"ference 2006 ã§ã™ã€‚ â€»æ£ã—ãã¯æ¨ªæµœ Linux ãƒ¦ãƒ¼ã‚¶ã‚°ãƒ«ãƒ¼ãƒ—ä¸»å‚¬ã®ã€Œç¬¬ 65 å›žã‚«ãƒ¼ãƒãƒ«èªæ›¸ä¼šã€ã®ãƒ†ãƒ¼ãƒž "mixi.jp: Scaling Out With Open Source" ã§ã™ã€‚ ã¡ãªã¿ã«ã€Batara Kesuma ã•ã‚“ã¨ã„ã†ã®ã¯ã€æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ã®å–ç· å½¹ã€‚ mixi ã®è£å´ã‚’è¦‹ã›ã¾ã™ã¨ã„ã†ã‹ã€ã¡ã‚‡ã£ã¨ hip ãªè¨€ã„ã‹ãŸã‚’ã™ã‚Œã° "Inside mixi's backend" ã£ã¦ã‚«ãƒ³ã‚¸ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€ãƒ—ãƒ¬ã‚¼ãƒ³å†…å®¹ã¯ YAPC::Asia ã®æ™‚ã¨å¤§å‡¡åŒã˜ã§ã—ãŸãŒã€ãƒ—ãƒ¬ã‚¼ãƒ³ã®æŒã¡
restartr 2009/08/01
*ã‚µãƒ¼ãƒãƒ¼

db

mysql

perl

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
PHPè£½ã®Webãƒ–ãƒ©ã‚¦ã‚¶ãƒ™ãƒ¼ã‚¹ã®DBã‚³ãƒ³ã‚½ãƒ¼ãƒ«Â·Uhura MOONGIFT
MySQLã‚’ä½¿ã£ãŸWebã‚·ã‚¹ãƒ†ãƒ ã®å ´åˆã€ãã®DBç®¡ç†ã«phpMyAdminã‚’ç”¨ã„ã‚‹ã“ã¨ãŒå¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã§ã¯PostgreSQLã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã©ã†ã ã‚ã†ã€‚ãã®å ´åˆã«ã¯phpPgAdminãŒã‚ã‚‹ã€‚ã•ã‚‰ã«Firebirdã®å ´åˆã¯ã©ã†ã ã‚ã†ã€‚ ã¾ã‚‹ã§GUIã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆã†ãªDBç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ ä¸€ã¤ã®DBå‘ã‘ã«é™ã‚‰ãšå¯¾å¿œã—ã¦ã„ã‚‹ã¨ã€æ“ä½œãŒåŒã˜ã§æ¸ˆã‚€ã®ã§ã¯æ··ä¹±ãŒå°‘ãªãã¦æ¸ˆã‚€ã€‚æ§˜ã€…ãªDBã‚’ä½¿ã„ã“ãªã™ãªã‚‰Uhuraã‚’ä½¿ã£ã¦ã¿ã¦ã¯ã©ã†ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Uhuraã€Webãƒ™ãƒ¼ã‚¹ã®DBã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã ã€‚ Uhuraã¯PHPã§ä½œã‚‰ã‚ŒãŸDBç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã‚„ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã€ãƒ“ãƒ¥ãƒ¼ã‚„ãƒˆãƒªã‚¬ãƒ¼ã®ä¸€è¦§ã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ExtJSã‚’ç”¨ã„ã¦ã„ã‚‹ã®ã§ã€ã¾ã‚‹ã§GUIã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆã†ãªç”»é¢æ§‹æˆã«ãªã£ã¦ã„ã‚‹ã€‚ æ§˜ã€…ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ãŒ
restartr 2009/06/16
*ã‚µãƒ¼ãƒãƒ¼

db

php

ã‚¢ãƒ—ãƒª

mysql

PostgreSQL
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
restartr 2009/05/13
*é–‹ç™º

db

è¨è¨ˆ

oracle

mysql

PostgreSQL

python
ãƒªãƒ³ã‚¯
1