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

Nilfs id:Nilfs

MySQLã«é–¢ã™ã‚‹Nilfsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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 WorkBenchã§å¤–éƒ¨ã‚µãƒ¼ãƒã¸SSHã‚’é€šã—ã¦æŽ¥ç¶šã™ã‚‹æ–¹æ³•
ä»Šæ—¥ã¯MySQLã®GUIç®¡ç†ãƒ„ãƒ¼ãƒ«ã§ã‚ã‚‹â€MySQL WorkBenchâ€œã§SSHãƒˆãƒ³ãƒãƒ«ã‚’ä½¿ã£ã¦ã€ãƒªãƒ¢ãƒ¼ãƒˆã®MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹/ã‚µãƒ¼ãƒã‚’ç®¡ç†ã™ã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ MySQL WorkBenchã®å…¥æ‰‹ã¯ã“ã¡ã‚‰ã‹ã‚‰ SSHãƒˆãƒ³ãƒãƒ«ã§æŽ¥ç¶šã§ãã‚‹ã¨ä½•ãŒå¬‰ã—ã„ã®ï¼Ÿ SSHã®ãƒãƒ¼ãƒˆãŒç©ºã„ã¦ã„ã‚Œã°ã€MySQL WBã‚’ä½¿ã£ã¦GUIã§å¿«é©ã«DBã®ç®¡ç†ä½œæ¥ãŒå‡ºæ¥ã¾ã™ã€‚ SSHã‚’é€šã—ã¦ã®é€šä¿¡ã«ãªã‚‹ã®ã§é€šä¿¡å†…å®¹ã¯å…¨ã¦æš—å·åŒ–ã•ã‚Œã¾ã™ã€‚ phpMyAdminãªã©ã¨ã„ã£ãŸãƒ¬ã‚¬ã‚·ãƒ¼ãªWebãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã¨ã¯ã‚‚ã†ãŠã•ã‚‰ã°ï¼ ã‚„ã‚Šã‹ãŸ MySQL WorkBenchã‚’èµ·å‹•å¾Œã€SQL Developmentã®åˆ—ã«ã‚ã‚‹ã€ŒNew Connectionã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã™ã€‚ ã€ŒSetup New Connectionã€ã¨ã„ã†ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ãŒé–‹ãã¾ã™ã®ã§ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã—ã¦ãã¾ã™ã€‚ Connection Name è˜åˆ¥åãªã®ã§é©å½“
Nilfs 2013/06/24
ç¢ºã‹ã«ã€SSHä½¿ãˆã°ååˆ†ã ã£ãŸã€‚å¤–éƒ¨å…¬é–‹ã§ãã‚‹ã‚ˆã†ã«è¨å®šã¨ã‹ã—ã¦ã¦å±ãªã„

ssh

MySQL

workbench
ãƒªãƒ³ã‚¯
Chefã§ã®MySQLãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®æ‰±ã„ - matetsuã ã‚‚ã‚“ã§
opscodeã®ãƒªãƒã‚¸ãƒˆãƒªã«ã‚ã‚‹MySQLã®cookbookã§ã¯ã€rootãƒ¦ãƒ¼ã‚¶ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®ãƒ¦ãƒ¼ã‚¶ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã«ç”Ÿæˆã—ã¦è¨å®šã—ã¦ã„ã‚‹ã€‚ opscode ã® recipe ã®ç‰¹å¾´ ã“ã®ãƒ©ãƒ³ãƒ€ãƒ ã¨ã„ã†ç‚¹ã‚’ã‚«ãƒãƒ¼ã™ã‚‹ã¹ãã€ã†ã¾ã„ä»•çµ„ã¿ãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹ã€‚ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã™ã‚‹ã¨ã“ã‚ã¯ node.set_unless['mysql']['server_root_password'] = secure_password ã¨ã„ã£ãŸå½¢ã§ã€attributeã«è¨å®šã•ã‚Œã¦ã„ãªã„å ´åˆã¯ãƒ©ãƒ³ãƒ€ãƒ ã«ç”Ÿæˆã™ã‚‹ã¨ã„ã†äº‹ã‚’ã—ã¦ã€2åº¦ç›®ä»¥é™ã‚‚åŒã˜ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¨ãªã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ 2å›žç›®ä»¥é™ã‚‚åŒã˜ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä¿è¨¼ã™ã‚‹ãŸã‚ã«ã€ã‚‚ã†ã²ã¨ã¤ã®æŠ€ãŒ unless Chef::Config[:solo] ruby_block "save node data" do block do node.save end
Nilfs 2012/06/07
chef

mysql

è¨å®š
ãƒªãƒ³ã‚¯
MySQL-MHAã‚’åˆ©ç”¨ã—ã¦MySQLã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’å®Ÿç¾ã—ã¦ã¿ãŸ - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
MySQL-MHAï¼ˆMySQL Master High Availabilityï¼‰ã¯ã€MySQLãŒãƒ€ã‚¦ãƒ³ã—ãŸæ™‚ã«è‡ªå‹•çš„ã«ä»–ã®MySQLã‚µãƒ¼ãƒã¸å‡¦ç†ã‚’å¼•ãç¶™ãã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ©Ÿèƒ½ã‚’å®Ÿç¾ã—ãŸãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã™ã€‚ DeNAã®æ¾ä¿¡å˜‰ç¯„æ°ãŒé–‹ç™ºã—ã¦ãŠã‚Šã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ã—ã¦å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ http://code.google.com/p/mysql-master-ha/ ä»Šå›žã¯ä»¥ä¸‹ã®å›³ã®ã‚ˆã†ãªæ§‹æˆã§ä½œæˆã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®MySQL-MHAã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§[ã‚µãƒ¼ãƒA]ã«éšœå®³ãŒç™ºç”Ÿã—ã¦ã—ã¾ã£ãŸå ´åˆã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«è‡ªå‹•çš„ã«ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’è¡Œã£ã¦ãã‚Œã¾ã™ã€‚ æ§‹ç¯‰ä½œæ¥ ã¾ãšã¯4å°ã®ã‚µãƒ¼ãƒã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãã ã•ã„ã€‚ ä¸Šå›³ã®é€šã‚Šå„ã‚µãƒ¼ãƒã¯[ã‚µãƒ¼ãƒA][ã‚µãƒ¼ãƒB][ã‚µãƒ¼ãƒC][ã‚µãƒ¼ãƒZ]ã¨ã—ã¾ã™ã€‚ å‚è€ƒï¼š CentOS5.6ã«MySQL5.5.15ã‚’ã‚¤ãƒ³ã‚¹
Nilfs 2012/05/09
è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ãƒ¼ãƒãƒ¼ã®ä½¿ã„æ–¹

mysql

MySQL

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
Windowsã§MySQL-Pythonã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Â« BPSæ ªå¼ä¼šç¤¾ é–‹ç™ºãƒ–ãƒã‚° Beyond Perspective Solutions LTD.
Category android (21) IDE (3) Eclipse (3) Linux (16) CentOS (1) nagios (1) Mac (2) MindTouch Deki (4) Web (16) CSS (4) HTML (3) ãƒ–ãƒ©ã‚¦ã‚¶ (2) Firefox (1) IE (1) Windows (55) ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ (5) ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ (26) ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ (35) CakePHP (15) dojo toolkit (5) Ethna (10) Ruby on Rails (3) Zend Framework (2) ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªž (95) C# (20) C++ (2) java (12) javascript (13) PHP (40) Python (2) Ruby (6) ä»®æƒ³åŒ– (9) æŠ•ç¨¿è€… (298) ä¸äº• (8) ä¼Šè—¤ (7
Nilfs 2011/06/20
MySQL-Python

MySQL

Windows

Python
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
2. è‡ªå·±ç´¹ä»‹ ï® MySQL/Linuxå‘¨ã‚Šã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆ ï¬ 2006å¹´9æœˆã‹ã‚‰2010å¹´8æœˆã¾ã§MySQL æœ¬å®¶(MySQL/Sun/Oracle)ã§ APAC/USåœã®MySQL ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«å¾“äº‹ ï¬ ä¸»ãªè‘—æ›¸ã«ã€Œç¾å ´ã§ä½¿ãˆã‚‹MySQLã€ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/ é‹ç”¨å…¥é–€ã€ã€ŒJavaãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ã€ ï® DeNAã§ã®ä¸»ãªå½¹å‰² ï¬ å®‰å®šåŒ–/ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹/é‹ç”¨å‘¨ã‚Šã®ä¸é•·æœŸçš„ãªæ”¹å–„æ´»å‹• ï¬ L3ã‚µãƒãƒ¼ãƒˆ/é‹ç”¨/ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° â€“ é›£åº¦ã®é«˜ã„MySQLå‘¨ã‚Šã®å•é¡Œã®æ ¹æœ¬åŽŸå› ã®ç‰¹å®šã¨è§£æ±º ï¬ å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ”¯æ´ ï¬ ç¤¾å†…å‹‰å¼·ä¼š/ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚° â€“ MySQLã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç¤¾å†…ã§å…±æœ‰ã—ã€ æŠ€è¡“ã‚¹ã‚ãƒ«ã‚’åº•ä¸Šã’ã™ã‚‹ ï¬ æŠ€è¡“ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚° â€“ å›½å†…å¤–ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã€æŠ€è¡“é›‘èªŒç‰
Nilfs 2011/01/18
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL

è¨è¨ˆ

DB
ãƒªãƒ³ã‚¯
1