[B! database][MySQL] umiyoshã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

umiyosh id:umiyosh

databaseã¨MySQLã«é–¢ã™ã‚‹umiyoshã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãŒé€²åŒ–ã—ã¦ã„ãŸï¼ - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6 ãŒå¾…æœ›ã®GAã¨ãªã‚Šã¾ã—ãŸï¼æ—©é€Ÿã€ã‚ã„ã¦ã„ãŸã‚µãƒ¼ãƒã«å…¥ã‚Œã¦ã¿ã¾ã—ãŸã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®è¨å®šãŒã€è‡³ã‚Œã‚Šå°½ãã›ã‚Šã«ãªã£ã¦ã„ã¦ã€ã³ã£ãã‚Šï¼*1 ã¡ã‚‡ã£ã¨å¼•ç”¨ãŒé•·ããªã‚‹ã‘ã©ã€æ•¢ãˆã¦é€”ä¸ã®ã‚«ãƒƒãƒˆã¨ã‹ã‚’ã—ãªã„ã§è¼‰ã›ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚ã€linux(CentOS) ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã™ã€‚ ã¾ãšã€å–å¾—ã—ãŸrpmã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # rpm -ivh MySQL-server-5.6.10-1.rhel5.x86_64.rpm Preparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]ã™ã‚‹ã¨ã€æ•°åˆ†é–“ã‹ã‘ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–‡å—åˆ—ãŒã¤ã‚‰ã¤ã‚‰ã¨è¡¨ç¤ºã•ã‚Œã¦ãã¾ã™ï¼ˆã“ã“ã§ã¯ã€ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã„
umiyosh 2013/09/23
MySQL

database
ãƒªãƒ³ã‚¯
chef ã§ mysql ã®ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ - Hack like a rolling stone
ä»¥å‰ã€ã‚ã‚‹ç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ãŸã¨ãã¯ã€å¿™ã—ãã¦æ‰‹ãŒå›žã‚‰ãªã„ã¨ã„ã†ç†ç”±ã§ ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã¯ script ãƒªã‚½ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãˆã„ã‚„ã¨æ¸ˆã¾ã›ã¦ã—ã¾ã£ãŸ tk0miya ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šå›žã¯ã™ã¹ã¦ community cookbook ã§ç’°å¢ƒã‚’ä½œã‚‹æ–¹æ³•ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã‚„ã‚Šæ–¹ãŒåˆ†ã‹ã£ã¦ã—ã¾ãˆã°ã‚·ãƒ³ãƒ—ãƒ«ã«å®Ÿç¾ã§ãã‚‹ã®ã§ã€æ³¥è‡ã script ãƒªã‚½ãƒ¼ã‚¹ã‚’ä½œã‚‰ãšã«æ¸ˆã¿ãã†ã§ã™ã€‚ éµã¯ database cookbook ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ãƒ¬ã‚·ãƒ”ãŒ mysql cookbook ã«å…¥ã£ã¦ã„ãªã„ãŸã‚ã€ å…¬å¼ã«ã¯æä¾›ã•ã‚Œã¦ã„ãªã„ã‚‚ã®ã¨ã„ã¾ã¾ã§è«¦ã‚ã¦ã„ãŸã®ã§ã™ãŒã€ èª¿ã¹ã¦ã¿ã‚‹ã¨ mysqll cookbook ã§ã¯ãªã database cookbook ã§ãƒªã‚½ãƒ¼ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ä»¥ä¸‹ã€README ã®èª¬æ˜Žã§ã™ã€‚ The main highlight of
umiyosh 2013/05/26
mysql

database

chef
ãƒªãƒ³ã‚¯
ç›®è¦šã¾ã—ã„é€²åŒ–ã‚’è¦‹ã›ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ - PBXTæ”¹å–„ã®è»Œè·¡
PBXTã¨ã„ã†ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã‚ã‚‹ã€‚ã“ã‚Œã¯ã€PrimeBaseç¤¾ã«ã‚ˆã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸæœ¬æ ¼çš„ãªã‚‚ã®ã§ã‚ã‚‹ã€‚ï¼ˆã¤ã¾ã‚Šã€InnoDBã‚„Falconã®ä»£æ›¿ã¨ã—ã¦ä½¿ã†ã“ã¨ã‚’ç›®æŒ‡ã—ãŸã‚¨ãƒ³ã‚¸ãƒ³ãªã®ã§ã‚ã‚‹ã€‚ï¼‰PBXTã¯æ¬¡ã®ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¯èƒ½ã ã€‚ http://www.primebase.org/ ä¸Šè¨˜ã®ãƒšãƒ¼ã‚¸ã«ã‚‚æ›¸ã„ã¦ã‚ã‚‹ãŒã€PBXTã®ç‰¹å¾´ã¯æ¬¡ã®é€šã‚Šã€‚ MVCCï¼ˆMulti Version Concurrency Controlï¼‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚µãƒãƒ¼ãƒˆACIDæº–æ‹ è¡Œãƒ¬ãƒ™ãƒ«ã®ãƒãƒƒã‚¯ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯æ¤œçŸ¥å¤–éƒ¨ã‚ãƒ¼ã®ã‚µãƒãƒ¼ãƒˆWrite Onceï¼ˆè¿½è¨˜åž‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ï¼‰BLOBã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚° æœ€å¾Œã®2ã¤ä»¥å¤–ã¯InnoDBã¨åŒã˜ã§ã‚ã‚‹ã€‚Write Onceã¨ã¯è¿½è¨˜åž‹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã€InnoDBã®ã‚ˆã†ã«ç‹¬ç«‹ã—ãŸãƒã‚°ãŒå˜åœ¨ã—ãªã„ã¨ã„ã†æ„å‘³ã§ã‚ã‚‹ã€‚ï¼ˆPostgreSQL
umiyosh 2009/05/31
database

mysql

æ€§èƒ½

EV
ãƒªãƒ³ã‚¯
MySQL Conference 2008ã«è¡Œã£ã¦æ¥ãŸ - stanaka's blog
ä»Šå¹´ã‚‚MySQL Conference 2008ã«è¡Œã£ã¦ãã¾ã—ãŸã€‚ç¤¾å†…å‘ã‘ã®å ±å‘Šè³‡æ–™ã¨é›‘å¤šãªãƒ¡ãƒ¢ã§ã™ãŒã€ã‚ˆã‚ã—ã‘ã‚Œã°å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ *1 æ¦‚è¦ MySQLãŒSunã«è²·åŽã•ã‚Œã¦å§‹ã‚ã¦ã®Conference 8ã‚»ãƒƒã‚·ãƒ§ãƒ³ä¸¦åˆ—ã§ã€OSCONã®è¦æ¨¡ã«ã ã„ã¶è¿‘ã„ MySQLãŒæ‰±ã†ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯é‡ãƒ»ãƒ‡ãƒ¼ã‚¿é‡ãŒã©ã‚“ã©ã‚“å¤§ãããªã£ã¦ãã¦ãŠã‚Šã€ãã‚Œã«ã©ã†è¿½å¾“ã™ã‚‹ã‹ã€ã¨ã„ã†è¦³ç‚¹ã®è©±ãŒå¤šã„ è²·åŽã®è©±ã¨ã‹ "MySQLã€æ–°æ©Ÿèƒ½è¿½åŠ ã¯æœ‰å„Ÿç‰ˆã®ã€ŒMySQL Enterpriseã€ã ã‘ã‚’å¯¾è±¡ã«"ã¨ã„ã†ã®ã¯ã€ã‹ãªã‚ŠãƒŸã‚¹ãƒªãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãªè¨˜äº‹ å®Ÿä½“ã¯ä¸€éƒ¨ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å½¢ã®æ©Ÿèƒ½ã‚„native storage engine-specific driverã‚’MySQL Enterpriseã¨ã—ã¦å‡ºã™ã€ã¨ã„ã†è©± Backupæ©Ÿèƒ½ã‚„ã€Falcon, Mariaã¨ã„ã£ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®é–‹ç™ºã§ã¯ã€Community Serverã¨E
umiyosh 2008/04/23
mysql

database

converse

ã¾ã¨ã‚

EV
ãƒªãƒ³ã‚¯
http://www.technobahn.com/news/2008/200804172000.html
umiyosh 2008/04/19
mysql

database

sun microsystems

EV
ãƒªãƒ³ã‚¯
1