[B! mysql][è¨å®š] harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

harumaki_net id:harumaki_net

mysqlã¨è¨å®šã«é–¢ã™ã‚‹harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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ã§ã¯kamipo TRADITIONALã‚’ä½¿ãˆï¼ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
ã‚ˆãMySQLã¯ã‚†ã‚‹ãµã‚ã ã‹ã‚‰ å€¤ãŒå‹æ‰‹ã«åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã‚‹ ã‚¨ãƒ©ãƒ¼ãŒèµ·ããšã«å¤‰ãªå€¤/æ—¥ä»˜ãŒå…¥ã‚‹ ä¸æ£ãªã‚¹ã‚ãƒ¼ãƒžãŒå…¥ã£ã¦ã—ã¾ã† ãªã©è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãŸã ãã‚Œã¯ã€ãã‚‚ãã‚‚ã®è¨å®šãŒæ‚ªã„ã®ã§ã™ã€‚(ç¢ºã‹ã«æ˜”ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒã‚†ã‚‹ãµã‚ãªã®ã¯ã„ã‘ãªã‹ã£ãŸã‚“ã§ã™ãŒ) ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ä¸æ£ãªå€¤ãŒå…¥ã‚‰ãªã„ã‚ˆã†ã«è¨å®šã¯ã¨ã«ã‹ãåŽ³ã—ãã—ã¦ãŠãã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã˜ã‚ƒã‚ã©ã†ã™ã‚‹ã‹ã€‚ MySQLã¯SQL Modeã«ã‚ˆã£ã¦ã€ãã®è¾ºã‚Šã®åˆ¶ç´„ã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥å‰ã€MySQLã®sql-modeã§ä¸€ç•ªåŽ³ã—ã„ã‚„ã¤ã¯TRADITIONALã€ã¨ã„ã†ã®ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯ä¸ååˆ†ã§ã€TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BYã¨ã™ã‚‹ã®ãŒã‚ˆã‚Šå®‰å¿ƒãªã‚ˆã†ã§ã™ã€‚ ã“ã‚Œã¯kamipoã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ @songmu TRADITI
harumaki_net 2015/07/08
mysql

è¨å®š

SQL
ãƒªãƒ³ã‚¯
MySQLã®VARCHARã«ã¤ã„ã¦èª¿ã¹ç›´ã—ã¦ã¿ãŸ | kanonjiã®ãƒ–ãƒã‚°
MySQLã«ã¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã„ãã¤ã‹ã‚ã‚‹ã®ã§ã€ãã®è¾ºã¯ã¡ã‚‡ã£ã¨ã”ã£ã¡ã‚ƒã«ãªã£ã¦ã‚‹ã¨æ€ã„ã¾ã™ã€‚InnoDBã‹MyISAMã‹ã§ã€å°‘ã—è©±ãŒé•ã£ã¦ãã‚‹ã¨ã¯æ€ã†ã‘ã©ã€ãã“ã¾ã§ã¯è¿½ãˆã¦ã¾ã›ã‚“ã€‚ VARCHAR(n)ã¯æ–‡å—æ•° æ˜”ã¯ãƒã‚¤ãƒˆæ•°ã ã£ãŸã‚ˆã†ãªæ°—ã‚‚ã™ã‚‹ã‘ã©ã€ä»Šã¯æ–‡å—æ•°ã‚’è¨å®šã—ã¾ã™ã€‚ VARCHAR(255)ã§è‰¯ã„ã¨æ€ã† CHAR ã¨ã¯å¯¾ç…§çš„ã«ã€VARCHAR å€¤ã¯å¿…è¦ãªæ–‡å—æ•°ã¨ã€é•·ã•ã‚’è¨˜éŒ²ã™ã‚‹ç‚ºã®1ãƒã‚¤ãƒˆ(255ã‚ˆã‚Šã‚‚é•·ã„ã‚«ãƒ©ãƒ ã¯2ãƒã‚¤ãƒˆ)ã ã‘ã‚’åˆ©ç”¨ã—ã¦æ ¼ç´ã§ãã¾ã™ã€‚ http://dev.mysql.com/doc/refman/5.1/ja/char.html VARCHARã¯å¯å¤‰é•·ãªã®ã§ã€ä½™åˆ†ã«è¨å®šã—ã¦ã‚‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ç„¡é§„ã«é£Ÿã†äº‹ã¯ç„¡ã„ã¨æ€ã„ã¾ã™ã€‚ãŸã VARCHAR(256)ä»¥ä¸Šã¯ã€é•·ã•ã®è¨˜éŒ²ãŒ1ãƒã‚¤ãƒˆå¢—ãˆã‚‹ã¿ãŸã„ãªã®ã§ã€ç‰¹ã«ç†ç”±ãŒç„¡ã‘ã‚Œã°VARCHAR(255)ã«è¨å®šã—ã¦ãŠãã®ãŒè‰¯ã„
harumaki_net 2015/03/18
MySQL

è¨å®š
ãƒªãƒ³ã‚¯
MySQLã®my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã‚µãƒ³ãƒ—ãƒ«
MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚ŒãŸMySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ åå‰ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å…ƒ my.cnfã‚µãƒ³ãƒ—ãƒ« ä»¥ä¸‹ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’å‚ç…§ã—ã¦ã€my.cnfãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¦ãã ã•ã„ã€‚ # ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ MySQL 5.6ã‚’åŸºæº–ã¨ã—ã¦ä½œã‚‰ã‚Œã¦ã‚ã‚Šã¾ã™ã€‚ # http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ [mysqld] ##-------------------------------------------------------------------- # mysqldã®åŸºæœ¬è¨å®š ##-------------------------------------------------------------------- # id ã¯ 1 ã‹ã‚‰ 2^
harumaki_net 2015/01/22
MySQL

è¨å®š

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
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
harumaki_net 2013/06/28
MySQL

è¨å®š

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
http://blog.inouetakuya.info/entry/20130320/1363776504
harumaki_net 2013/03/21
MySQL

è¨å®š

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
MySQLç®¡ç†è€…æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼
å··ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ãŒæµè¡Œã£ã¦ã‚‹ã®ã§ã€MySQLã‚‚å‚æˆ¦ã€‚ãŸã ã—ç®¡ç†è€…å‘ã‘ã€‚ ã¾ãšã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆ http://dev.mysql.com/downloads/ ãƒã‚¤ãƒŠãƒªã«ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ï¼ˆWindows=MSIã€Mac=DMGã€Linux=RPMã¨ã‹ï¼‰ã¨ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ï¼ˆ*NIX=tar.gz/Windows=zipï¼‰ãŒã‚ã‚‹ã‘ã©ã€åˆå¿ƒè€…ã¯é»™ã£ã¦ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒãƒ§ã‚¤ã‚¹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã«å¾“ã†ã ã‘ã€‚è‹±èªžã ã‘ã©ãã“ã¯ã‚¬ãƒžãƒ³ï¼ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒªãƒã‚¸ãƒˆãƒªãŒã‚ã‚‹OSã‚’ä½¿ã£ã¦ã‚‹ãªã‚‰ã€ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã®ã‚‚ã‚ã‚Šã ã€‚ä¾‹ãˆã°ã€ shell> sudo yum install mysqlã¨ã‹ shell$gt; sudo apt-get install mysqlã¨ã‹ã€‚ã“ã‚Œã¯æ¥½ãƒãƒ³ã ã‘ã©MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã¡ã‚‡ã£ã¨å¤ããªã‚‹ã®ã§æ³¨æ„ã€‚ ã‚‚ã¡ã‚ã‚“
harumaki_net 2011/09/28
MySQL

è¨å®š

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
1