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

harigel id:harigel

*DBã«é–¢ã™ã‚‹harigelã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

${{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}}

GitHub - sonots/activerecord-refresh_connection: Refresh ActiveRecord connection on each rack request
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
harigel 2014/12/02
Railsã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ç„¡åŠ¹åŒ–ã™ã‚‹

*programming

*rails

*DB

ActiveRecord
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã¹ãé …ç›® | Yakst
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒžãƒãƒ¼ã‚¸ãƒ£ã®Morgan Tockeræ°ã«ã‚ˆã‚‹ã€MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‹ã‚‰å¤‰æ›´ã—ãŸæ–¹ãŒã‚ˆã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®è§£èª¬ã€‚ æ•°ã€…ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æ”¹å–„ã«ã‚ˆã£ã¦ã€éŽåŽ»ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨æ¯”ã¹ã¦MySQL 5.6ã§ã¯è¨å®šã—ãªãã¦ã¯ãªã‚‰ãªã„å€¤ãŒã‹ãªã‚Šæ¸›ã£ãŸã€‚ã¨ã¯è¨€ãˆã€å¤‰æ›´ã™ã¹ãã‚‚ã®ã«ã¤ã„ã¦ã“ã“ã§æ›¸ã„ã¦ãŠããŸã„ã€‚ InnoDBã®è¨å®š innodb_buffer_pool_size - ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯128Mã€‚ã“ã‚Œã¯ã€ãƒ¡ãƒ¢ãƒªã«ãƒãƒ¼ãƒ‰ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŸã‚ã«InnoDBãŒã©ã®ãã‚‰ã„ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã‹ã‚’æŒ‡å®šã™ã‚‹ã‚‚ã®ãªã®ã§ã€è¨å®šã™ã¹ãé‡è¦ãªå€¤ã ã€‚MySQLã®å°‚ç”¨ã‚µãƒ¼ãƒãªã‚‰ã€æè¼‰ã•ã‚Œã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®50%ã‹ã‚‰80%ãŒæŽ¨å¥¨ã•ã‚Œã‚‹è¨å®šå€¤ã ã€‚ä¾‹ãˆã°ã€64GBã®RAMã‚’æè¼‰ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒãªã‚‰ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯50GBç¨‹åº¦ã«ã™ã¹ãã ã‚ã†ã€‚ innodb_log_file_size -
harigel 2014/12/01
*programming

*DB

mysql

performance

tuning
ãƒªãƒ³ã‚¯
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ç³»ã¯ãƒ–
harigel 2012/08/27
*programming

*DB

è¦‹ç©ã‚‚ã‚Š
ãƒªãƒ³ã‚¯
MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ‰‹é † - ã‚ãã‚ãæŠ€è¡“ãƒ©ãƒ³ãƒ‰
æƒ³å®šã—ã¦ã„ã‚‹ã“ã¨ â€ MySQL5.0 MySQLãŒã™ã§ã«ç¨¼å‹•ä¸ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®šã¯ã—ã¦ã„ãªã„ ä»Šå›žMySQLã‚’ã‚‚ã†ä¸€å°å¢—ã‚„ã—ã¦2å°æ§‹æˆã¨ã—ã€masterã€slaveã®æ§‹æˆã«ã™ã‚‹ â€»ä»Šå›žã¨çŠ¶æ³ãŒç•°ãªã‚‹å ´åˆã¯ã€MySQLã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’èªã‚€ã¨ã„ã„ã§ã™ã€‚ â†‘ 1. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ â€ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ ä½œæˆã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒžã‚¹ã‚¿ã®ãƒã‚¤ãƒŠãƒª ãƒã‚°ã‚’èªã¿è¾¼ã‚€ã¨ãã«æŽ¥ç¶šã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ãªã‚‹ã€‚ æ—¢å˜ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯å¯èƒ½ã ãŒã€ãƒ¦ãƒ¼ã‚¶åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒ master.info ãƒ•ã‚¡ã‚¤ãƒ«å†…ã«ãƒ†ã‚ã‚¹ãƒˆã§ä¿å˜ã•ã‚Œã‚‹ãŸã‚ã€å®‰å…¨ã®ãŸã‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒã‚»ã‚¹ã«ã ã‘æ¨©é™ãŒã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ è¨å®šä¾‹(ãƒžã‚¹ã‚¿ã®ã»ã†ã«è¨å®š) 192.168.23.0/24 å†…ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã§è¨±å¯ ãƒ¦ãƒ¼ã‚¶ãƒ¼åï¼šrepl ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ï¼šslavepass mysql >
harigel 2012/03/27
*DB

mysql

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
MySQL ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®š - ã¨ã¿ãžãƒ¼ãƒŽãƒ¼ãƒˆ
1.2 ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å‹•ä½œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æœ€åˆã«DBã®å†…å®¹ã‚’åŒæœŸã•ã›ãŸå¾Œã€Masterã‚µãƒ¼ãƒãƒ¼ã§å®Ÿè¡Œã•ã‚ŒãŸæ›´æ–°ç³»ã®ã‚¯ã‚¨ãƒª(UPDATEã¨ã‹)ã‚’Slaveã«æ¸¡ã—ã¦Slaveã§ã‚‚åŒã˜ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦ã„ãã“ã¨ã§ã€DBã‚’åŒæœŸã•ã›ã¦ã„ã‚‹(å›³1)ã€‚ Masterå´ã§å®Ÿè¡Œã•ã‚ŒãŸæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã«è“„ãˆã‚‰ã‚Œã¦ãŠã‚Šã€Slaveå´ãŒæŽ¥ç¶šã—ã¦ããŸã‚‰ã€å‰å›žã®æŽ¥ç¶šã‹ã‚‰ã®å¤‰æ›´åˆ†ã‚’Slaveå´ã«é€ä¿¡ã™ã‚‹ã€‚Slaveå´ã¯å—ã‘å–ã£ãŸã‚¯ã‚¨ãƒªã‚’ä¸€æ—¦ãƒªãƒ¬ãƒ¼ãƒã‚°ã«è“„ãˆã¦é †æ¬¡ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦DBã‚’åŒæœŸã•ã›ã¦ã„ãã€‚ãƒªãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‹•ä½œã«ã¯BinlogDump,I/O,SQLã®3ã¤ã®ã‚¹ãƒ¬ãƒƒãƒ‰ãŒé€£æºã—ã¦å‹•ä½œã™ã‚‹ã€‚ 2.è¨å®šæ‰‹é † (Master-Slaveæ§‹æˆ) 2.1 Masterå´ã®è¨å®šã®ç¢ºèªMasterå´ã§ã¯ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æŽ¡å–ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚‹ã®ã§ã€Masterå´ã®my.cnfã«log-binã®è¨å®šãŒå…¥ã£ã¦ã„ã‚‹ã“ã¨ã‚’ç¢º
harigel 2012/03/27
mysql

*DB

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
CakePHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é–‹ç™ºç’°å¢ƒã¨æœ¬ç•ªç’°å¢ƒã§åˆ‡ã‚Šåˆ†ã‘ã‚‹æ–¹æ³•
CakePHPã«ã¯åˆ©ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®šç¾©ã‚’è¤‡æ•°å®šç¾©ã—ã¦ãŠã‘ã‚‹æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ãŒã€ãã®ä½¿ã„åˆ†ã‘ã«é–¢ã™ã‚‹ã‚¢ã‚¤ãƒ‡ã‚¢ã§ã™ã€‚ ã‚ˆãã‚ã‚‹è§£æ±ºç– ã‚ˆãé–‹ç™ºç’°å¢ƒã¨æœ¬ç•ªç’°å¢ƒã§è‡ªå‹•çš„ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚’åˆ‡ã‚Šæ›¿ãˆã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ã«DATABASE_CONFIGã‚¯ãƒ©ã‚¹ã®ã‚³ãƒ³ã‚¹ãƒˆãƒ©ã‚¯ã‚¿ã‚’æ”¹è‰¯ã—ãŸã‚Šã€AppModelã‚¯ãƒ©ã‚¹ã®ã‚³ãƒ³ã‚¹ãƒˆãƒ©ã‚¯ã‚¿ã«ç¾åœ¨ã®ç’°å¢ƒã‚’åˆ¤åˆ¥ã§ãã‚‹ã‚ˆã†ãªè¨å®šã‚’æ›¸ã„ãŸã‚Šã™ã‚‹ã‚¢ã‚¤ãƒ‡ã‚¢å¤šãè¦‹ã‹ã‘ã‚‰ã‚Œã¾ã™ã€‚ DATABASE_CONFIGã‚¯ãƒ©ã‚¹ã®æ”¹è‰¯ class DATABASE_CONFIG { public $default = array(); // å…¬é–‹ç”¨ public $production = array( 'driver' => 'mysql', 'persistent' => false, 'host' => 'production.mysql.server', 'login' => '
harigel 2012/02/08
*programming

CakePHP

*DB
ãƒªãƒ³ã‚¯
OpenSSHã§ãƒˆãƒ³ãƒãƒªãƒ³ã‚° | å¤‰ãªãƒ¤ãƒã„ã‚‚ã‚“ãƒã‚°
Posted on 2007å¹´10æœˆ11æ—¥ Posted by ã¡ã‚…ã† ã‚³ãƒ¡ãƒ³ãƒˆã™ã‚‹ Posted in Development Tags: Linux, Mac, tool, Windows å¤–éƒ¨ã‹ã‚‰è¦‹ãˆãªã„ã‚µãƒ¼ãƒã¸ã¤ãªãå¿…è¦ãŒã‚ã£ã¦ã€SSHã®ãƒˆãƒ³ãƒãƒªãƒ³ã‚°ã¨ã„ã†ã®ã‚’ã‚„ã£ã¦ã¿ãŸã€‚ Mac,Linuxã®å ´åˆ é¯–1 (example.com) ã§SSHã‚µãƒ¼ãƒãŒå‹•ã„ã¦ã¦ã€ã‚°ãƒãƒ¼ãƒãƒ«IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒãŸãªã„ãŒé¯–1ã¨åŒã˜ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã«ã„ã‚‹é¯–2(192.168.1.10) ã«ã¤ãªãŽãŸã„ã€ã¨ã„ã†å ´åˆ SSHãƒˆãƒ³ãƒãƒªãƒ³ã‚°ã™ã‚‹ã¨é¯–2ã«ç›´æŽ¥æŽ¥ç¶šã¤ãªã„ã§ã„ã‚‹ã‹ã®ã‚ˆã†ã«æ‰±ã†ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ä»Šã€æ‰‹å…ƒã‹ã‚‰ é¯–2 ã® MySQL ã‚µãƒ¼ãƒã«ã¤ãªãŽãå ´åˆã®ä¾‹ã§ã™ã€‚MySQLã®ãƒãƒ¼ãƒˆã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã® 3306 ã¨ã—ã€é¯–1ã‹ã‚‰æŽ¥ç¶šãŒå¯èƒ½ãªçŠ¶æ³ã¨ã—ã¾ã™ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã¨ã€è‡ªåˆ†ã®ãƒžã‚·ãƒ³ã® 19000ç•ªãƒãƒ¼ãƒˆãŒ SSHãƒˆãƒ³ãƒãƒ«ã‚’çµŒ
harigel 2011/08/15
"MySQLã¯ localhost ã¨ 127.0.0.1 ã®æ‰±ã„ãŒé•ã„ã¾ã™ã€‚localhost ã¯ ãƒãƒ¼ã‚«ãƒ«ã®ã‚½ã‚±ãƒƒãƒˆã‚’é€šã—ã¦æŽ¥ç¶šã‚’è¡Œãªã†ã®ã§ã™ãŒã€127.0.0.1 ã¯TCPã‚½ã‚±ãƒƒãƒˆã§127.0.0.1ã§æŽ¥ç¶šã‚’è¡Œãªã„ã¾ã™ã€‚"

*programming

*DB

mysql

ssh

tunnel
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
harigel 2011/08/15
*programming

*DB

mysql

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
mysqlã®collateã‚’ä½¿ã£ã¦å¤§æ–‡å—-å°æ–‡å—ã‚„å…¨è§’-åŠè§’ã‚’ç„¡è¦–ã—ãŸæ¤œç´¢ - end0tknr's kipple - webå†™çµŒé–‹ç™º
mysqlã§ã¯ã€collate = utf8_unicode_ciã‚’æŒ‡å®šã™ã‚‹ã¨ã€å¤§æ–‡å—-å°æ–‡å—ã ã‘ã§ãªãã€å…¨è§’-åŠè§’ã‚’åŒä¸€è¦–ã§ãã‚‹ãã†ã§ã™ãŒã€å®Ÿéš›ã«ã©ã®æ–‡å—ãŒåŒä¸€è¦–ã•ã‚Œã‚‹ã®ã‹ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ collateã¨ã¯ http://tetlist.info/2009/01/mysql â†‘ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã‚‚åˆ†ã‹ã‚Šã‚„ã™ãç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ãŒã€collate(ç…§åˆé †åº)ã¨ã¯ã€æ–‡å—ã‚’æ¯”è¼ƒ(ä¸€è‡´/ä¸ä¸€è‡´ã‚„è¡¨ç¤ºé †)ã™ã‚‹éš›ã®ãƒ«ãƒ¼ãƒ«ã§ã™ã€‚ utf8_unicode_ciã§å¤§æ–‡å—-å°æ–‡å—ã ã‘ã§ãªãã€å…¨è§’-åŠè§’ã‚’åŒä¸€è¦– mysqlã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆcollateã§ã‚ã‚‹utf8_general_ciã§ã¯ã€å¤§æ–‡å—-å°æ–‡å—ã‚’åŒä¸€è¦–ã—ã¾ã™ãŒã€utf8_unicode_ciã§ã¯ã€ã•ã‚‰ã«åŠè§’-å…¨è§’ã‚‚åŒä¸€è¦–ã—ã¾ã™ã€‚ â€»ci ã¨ã¯ Case Insensitive ã®ç•¥ç§°ã®ã‚ˆã†ã§ã™ tableã‚„columnè‡ªä½“ã«collateã‚’è¨å®šã™ã‚‹
harigel 2011/04/18
mysqlã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆcollateã§ã‚ã‚‹utf8_general_ciã§ã¯ã€å¤§æ–‡å—-å°æ–‡å—ã‚’åŒä¸€è¦–ã™ã‚‹ã€‚ã“ã®ã¾ã¾ã ã¨å¤§æ–‡å—å°æ–‡å—ã®ã¿ç•°ãªã‚‹ã€ä¾‹ãˆã°UIDç‰ã‚’åŒºåˆ¥ã§ããšå¤§å¤‰ãªã“ã¨ã«ãªã‚‹ã®ã§æ³¨æ„(ä½“é¨“è«‡)

*programming

*DB

mysql

collate
ãƒªãƒ³ã‚¯
mysqlã‚³ãƒžãƒ³ãƒ‰ã‚’ã‚ˆã‚Šä¾¿åˆ©ã«å®‰å…¨ã«ã™ã‚‹ãŸã‚ã®å°ç²’ãªTIPSé›†ï½œã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆ å…¬å¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
åˆã‚ã¾ã—ã¦ã€‚2010å¹´ã®3æœˆã«å…¥ç¤¾ã—ãŸ oinume ã§ã™ã€‚æ–°å¹´1æœˆã‹ã‚‰ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã«ç½¹ã‚ŠãªãŒã‚‰ã‚‚ãªã‚“ã¨ã‹ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã«é–¢ã™ã‚‹è‡ªåˆ†ãŒä»Šã¾ã§å¦ã‚“ã ï¼†æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸç´°ã‹ã„å®Ÿè·µçš„ãªTIPSã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å°ç²’ã§ã™ãŒä½•ã‹ã®å½¹ã«ç«‹ã¦ã°å¹¸ã„ã§ã™ã€‚ edit (Â¥e)ã‚³ãƒžãƒ³ãƒ‰ mysqlãƒ—ãƒãƒ³ãƒ—ãƒˆã«ã„ãªãŒã‚‰ä»»æ„ã®ã‚¨ãƒ‡ã‚£ã‚¿ã§SQLãŒç·¨é›†ã§ãã¡ã‚ƒã„ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã§ãƒ—ãƒãƒ³ãƒ—ãƒˆå¾…ã¡ã®çŠ¶æ…‹ã§ mysql> edit ã®ã‚ˆã†ã« edit ã¾ãŸã¯ Â¥e ã¨å…¥åŠ›ã™ã‚‹ã¨ã€ç’°å¢ƒå¤‰æ•°EDITORã§è¨å®šã—ã¦ã‚ã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãŒç«‹ã¡ä¸ŠãŒã‚ŠSQLãŒç·¨é›†å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ç·¨é›†ãŒçµ‚ã‚ã£ãŸã‚‰ã‚¨ãƒ‡ã‚£ã‚¿ã‚’çµ‚äº†ã—ã¦ ; ã¨ã‚„ã‚Œã°SQLãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚viãªã©ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§å‹•ãã‚¨ãƒ‡ã‚£ã‚¿ã«æ…£ã‚Œã¦ã„ã‚‹äººã¯é•·ã„SQLã‚’ç·¨é›†ã™ã‚‹æ™‚ã«é‡å®ã™ã‚‹æ©Ÿèƒ½ã§ã—ã‚‡ã†ã€‚ã“ã®æŠ€ã¯å‰è·ã®åŒåƒšã«æ•™ãˆã¦ã‚‚ã‚‰ã£ã¦ã€ä»¥é™ä¾¿
harigel 2011/01/27
*programming

*DB

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

*DB

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒª

mysql
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
ï¼ IT ä¼šè°å®¤ Indexãƒªãƒ³ã‚¯ Windows Server Insider Insider.NET System Insider XML & SOA Linux Square Master of IP Network Java Solution Security & Trust Database Expert RFIDï¼‹IC ãƒªãƒƒãƒã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ & å¸³ç¥¨ Server ï¼† Storage Coding Edge ï¼ ITã‚¯ãƒ©ãƒ– Cafe VBæ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºç ”ç©¶ ï¼ IT SpecialPR
harigel 2011/01/12
*programming

Java

*DB
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
harigel 2010/10/25
*DB
ãƒªãƒ³ã‚¯
MySQL AB :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
æ¦‚è¦ ã“ã‚Œã¯ MySQL ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã™ã€‚ MySQL 8.0 ã‹ã‚‰ 8.0.25ã€ãŠã‚ˆã³ NDB ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.0 ã‹ã‚‰ 8.0.25-ndb-8.0.25 ã«åŸºã¥ã NDB Cluster ãƒªãƒªãƒ¼ã‚¹ã«ã¤ã„ã¦ãã‚Œãžã‚Œèª¬æ˜Žã—ã¾ã™ã€‚ ã¾ã ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãªã„ MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æ©Ÿèƒ½ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®è©³ç´°ã¯ã€ã€ŒMySQL 8.0 ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ MySQL 8.0 ã®æ©Ÿèƒ½. ã“ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã¯ã€MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã¯å«ã¾ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ã€ã”è‡ªèº«ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä»˜ä¸Žã•ã‚Œã¦ã„ã‚‹ MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã¦ã„ãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ MySQL 8.0 ã®ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ©Ÿèƒ½ã«é–¢ã™ã‚‹è³ªå•ãŒã‚ã‚‹å ´åˆã¯ã€MySQL 8.0
harigel 2010/05/16
*programming

*DB

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ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã¡ã‚‡ã£ã¨å¤ããªã‚‹ã®ã§æ³¨æ„ã€‚ ã‚‚ã¡ã‚ã‚“
harigel 2010/02/05
*programming

*DB

mysql

åŸºç¤Žæ–‡æ³•æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼
ãƒªãƒ³ã‚¯
CentOS ã§ PostgreSQL ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼(2) â€” Let's Postgres
(3) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®ç¢ºèª ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã©ã‚“ãªãƒ•ã‚¡ã‚¤ãƒ«ãŒã§ããŸã®ã‹ï¼Ÿãªã©ã‚’ç¢ºèªã—ã¾ã™ã€‚ ã€Žpostgresã€ã¨ã„ã†ã‚¢ã‚«ã‚¦ãƒ³ãƒˆ ãŒä½œæˆã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ã€ã€Œidã€ã‚³ãƒžãƒ³ãƒ‰ã‚„ã€Œfingerã€ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã—ã¾ã™ã€‚ï¼ˆå„ç¨® ID ã‚„ãƒ›ãƒ¼ãƒ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¯ã€ä»¥ä¸‹ã®ä¾‹ã¨ç•°ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ï¼‰ [root @server1 ~]# id postgres uid=26(postgres) gid=26(postgres) æ‰€å±žã‚°ãƒ«ãƒ¼ãƒ—=26(postgres) [root @server1 ~]# finger postgres Login: postgres Name: PostgreSQL Server Directory: /var/lib/pgsql Shell: /bin/bash Never logged in. No mail. No Plan. ã€Œ/usr/ã€ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã€ã•ã¾
harigel 2009/12/22
*DB

*server

postgres
ãƒªãƒ³ã‚¯
yumã§PostgreSQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã‚ˆã† â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ ç¬ åŽŸ è¾°ä» ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€yum ã‚’ä½¿ã£ãŸ PostgreSQL ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚yum ã¯RedHat Enterprise Linux ã‚„ CentOSã€Fedora ãªã©ã§ä½¿ç”¨å¯èƒ½ãª RPM ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚RPM ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸é–“ã®ä¾å˜æ€§ã‚’è€ƒæ…®ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚A ã¨ã„ã† RPM ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¯ B ã¨ã„ã† RPM ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå¿…è¦ã«ãªã‚‹â€¦â€¦ã¨ã„ã£ãŸæ„Ÿã˜ã§ã™ã€‚yum ã¯ã“ã‚Œã‚‰ã®ä¾å˜é–¢ä¿‚ã‚’åˆ¤åˆ¥ã—ã€å¿…è¦ã¨ãªã‚‹å…¨ã¦ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’è‡ªå‹•ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒ»ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãã‚Œã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€Fedora ã‚’ä½¿ã£ã¦ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚Fedoraã‚’ä½¿ã£ã¦ã„ã¾ã™ãŒã€ç´¹ä»‹ã™ã‚‹æ–¹æ³•ã¯ RedHat Enterprise Linux ã‚„ CentOS ã§ã‚‚åŒã˜ã§ã™ã€‚ ã‚³ãƒŸ
harigel 2009/12/22
*server

*DB

postgres

yum
ãƒªãƒ³ã‚¯
CentOS5ã«yumã§PostgreSQL8.3ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ - shibainu55æ—¥è¨˜
CentOS 5ç³»ã®OSã§ã€yumã‚’ä½¿ã„æ¨™æº–ã®ã¾ã¾PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’è¡Œã†ã¨ã€PostgreSQL 8.1.11ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã€‚ã‚¨ãƒ³ã‚¸ãƒ³ã®æ”¹è‰¯ãŒè¡Œã‚ã‚Œã¦é«˜é€Ÿã«å‹•ä½œã™ã‚‹ã¨è¨€ã‚ã‚Œã‚‹ 8.3 ã‚„æœ€æ–°ã® 8.4 ã‚’åˆ©ç”¨ã—ãŸã„æ™‚ã¯ã€ tar.gz ã§ã‚½ãƒ¼ã‚¹ã‚’æŒã£ã¦ãã¦ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ãŒã€ã‚„ã£ã±ã‚ŠyumãŒã„ã„ãªãã¨æ€ã†ç§ã®ã‚ˆã†ãªå ´åˆã«ã¯ã€ä»¥ä¸‹ã®æ–¹æ³•ã§æœ€æ–°ã® PostgreSQLãŒåˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã—ãŸã€‚ ã¾ãšã¯ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã‚ã‚‹PostgreSQLã‚’ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« # yum -y remove postgresql æ¬¡ã«pgdg-CentOS - PostgreSQL 8.4.X PGDG RPMs for CentOS - Yum Repository Configuration ã‹ã‚‰æ¬²ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®PostgreSQLç”¨ãƒªãƒã‚¸ãƒˆãƒªã‚’å…¥æ‰‹ã—ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ # w
harigel 2009/12/21
*DB

*server

linux

yum

postgres
ãƒªãƒ³ã‚¯
MySQL InnoDBã ã‘ã§å…¨æ–‡æ¤œç´¢ - SH2ã®æ—¥è¨˜
å®Ÿé¨“ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ äºˆç¿’ã—ã¦ã¿ã‚‹ ã€Œè»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§æ¤œç´¢ã—ã¦ã€ã—ã°ã‚‰ãå‹‰å¼·ã—ã¦ã¿ã¾ã™ã€‚ è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - Wikipedia mixi Engineersâ€™ Blog Â» è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®Ÿè£…ã—ã‚ˆã† ASCII.jpï¼šæ‚Ÿç©ºã€ç§˜å‰£ã€Œè»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ã‚’æ‰‹ã«å…¥ã‚Œã‚‹ ï½œGoogleã¯ãªãœçš„ç¢ºã«æŽ¢ã›ã‚‹ã®ã‹ï¼Ÿ [ã‚’] è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚ˆã‚‹æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã£ã¦ã¿ã‚ˆã†ï¼ è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§å¦ã¶æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¸èº«ã‚¢ãƒ—ãƒª - ç¡çœ ä¸è¶³ï¼Ÿï¼ ã†ãƒ¼ã‚“ãªã‚‹ã»ã©ã€‚åˆ†ã‹ã£ãŸã‚ˆã†ãªåˆ†ã‹ã‚‰ãªã„ã‚ˆã†ãªã€‚ ä½œã£ã¦ã¿ã‚‹ ã¨ã‚Šã‚ãˆãšã€Twitter4Jã‚’ä½¿ã£ã¦ã“ã‚“ãªãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã—ã¾ã—ãŸã€‚ã¡ãªã¿ã«äººé¸ã¯æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLerã®Twitterã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¾ã¨ã‚ã€‚ã‚’å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ 5707049458,2009-11-14 20:28:34,sakaik,@hbstudy
harigel 2009/12/07
*DB

æ¤œç´¢

innodb

å…¨æ–‡æ¤œç´¢

mysql

*programming
ãƒªãƒ³ã‚¯
https://www.slony.info/bugzilla/attachment.cgi?id=35
harigel 2009/11/06
slony

bug

*DB

postgres

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸