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

bash0C7 id:bash0C7

mysqlã«é–¢ã™ã‚‹bash0C7ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

äºŒåƒä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®alterã‚’ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ãšã«æµã™ | All Your Bugs Are Belong To Ass
â€»ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯MySQL Casual Advent Calendar 2015ã®5æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ openark-kit ã¨ã„ã†ã‚‚ã®ã«ã¤ã„ã¦ ã“ã“ã¾ã§èªã‚“ã§ã‚ã‹ã£ãŸæ–¹ã¯ã€ã“ã®å…ˆã‚’èªã‚€å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ openark-kitã¨ã¯ã€mysqlã®é‹ç”¨ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã‚ãƒƒãƒˆã‚’14å€‹ã‚ã¤ã‚ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã™ã€‚ Shlomi Noachã¨ã„ã†æ–¹ãŒPythonã§é–‹ç™ºã—ã¦ãŠã‚Šã€å°‘ãªãã¨ã‚‚2009å¹´ã«ç™ºè¡¨ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ 2015-12-05æ™‚ç‚¹ã§ã®æœ€æ–°ç‰ˆã¯196.1ã¨ãªã£ã¦ãŠã‚Šã€.tar.gz ãŠã‚ˆã³ .deb ã§é…å¸ƒã•ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ãŸèƒŒæ™¯äº‹æƒ… ãã‚‚ãã‚‚åƒ•è‡ªèº«ã€50ã‚’è¶…ãˆã‚‹ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸmysqlãƒŽãƒ¼ãƒ‰ã¨ä¸€ç·’ã«æ¥å‹™ç”Ÿæ´»ã‚’é€ã£ã¦ãŠã‚Šã¾ã™ã€‚ ã¨ã“ã‚ãŒã€ã‚·ã‚¹ãƒ†ãƒ ãŒéžå¸¸ã«å¤ãã•ã„æ§‹æˆã®ãŸã‚ã€åˆè¨ˆãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒ2å„„ã‹ã‚‰3å„„ç¨‹åº¦ã‚ã‚‹åž‚ç›´åˆ†å‰²ã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ALTERã‚’æŠ•
bash0C7 2015/12/24
mysql
ãƒªãƒ³ã‚¯
[MySQL5.7]ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨å®šæ–¹æ³• â€“ (ã£Â´âˆ€ï½€)ã£ ã‚ƒãƒ¼ | ä¸€æ’ƒ
ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆIPã‚¢ãƒ‰ãƒ¬ã‚¹ã¯eth1ã«æŒ¯ã£ã¦ã„ã¾ã™ã€‚ã•ãã‚‰ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã§CentOS7ã®eth1ã«IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒ¯ã‚‹æ‰‹é †ã¯ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã©ã†ãžã€‚ ä»Šå›žæ§‹ç¯‰ã™ã‚‹ã‚µãƒ¼ãƒãƒ¼ã®ã€ãƒžã‚¹ã‚¿ãƒ¼ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã®é–¢ä¿‚ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ master0 ã¯ test0 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒžã‚¹ã‚¿ãƒ¼ã€‚ãƒãƒ£ãƒãƒ«ã¯0 master1 ã¯ test1 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒžã‚¹ã‚¿ãƒ¼ã€‚ãƒãƒ£ãƒãƒ«ã¯1 slave0 ã¯ ä¸Šè¨˜ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãªã‚‹ slave1 ã¯ ä¸Šè¨˜ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãªã‚‹ ã¡ãªã¿ã«ã€ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚¤ã‚³ãƒ¼ãƒ«ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã“ã¡ã‚‰ã®å›³è¡¨ã‚’è¦‹ã‚‹ã¨é•ã„ãŒä¸€ç›®çžç„¶ã§ã™ãŒã€ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯å¾ªç’°åž‹ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã€SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¯ã©ã®ãƒŽãƒ¼ãƒ‰ã«æ›¸ãè¾¼ã¿ã‚’è¡Œã£ã¦ã‚‚ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹æˆã™ã‚‹ã™ã¹ã¦ã®ãƒŽãƒ¼ãƒ‰ã«ç‰ã—ããƒ‡ãƒ¼ã‚¿ãŒåŒæœŸã•ã‚Œã¾ã™ã€‚ã„ã£ã½ã†
bash0C7 2015/10/25
mysql
ãƒªãƒ³ã‚¯
GitHub - drecom/activerecord-turntable: ActiveRecord Sharding Plugin
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
bash0C7 2012/05/09
rails

mysql
ãƒªãƒ³ã‚¯
Rails2.3.10 ã« i18n ã‚’ æ–‡å—ã‚³ãƒ¼ãƒ‰ EUC-JP ã§å°Žå…¥ã™ã‚‹ãƒ¡ãƒ¢ - åŸºæœ¬ã¸å¸°ã‚ã†
i18n ã‚’ æ–‡å—ã‚³ãƒ¼ãƒ‰ EUC-JP ã§ Rails2.3.10 ã«å°Žå…¥ã™ã‚‹ãƒ¡ãƒ¢ã§ã™ã€‚ å®Ÿé¨“ç’°å¢ƒ OS CentOS release 5.3 (Final) Ruby ruby 1.8.6 (2010-02-05 patchlevel 399) [i686-linux Rails Rails 2.3.10 i18n 0.5.0 æ–‡å—ã‚³ãƒ¼ãƒ‰ EUC Rails2.3.10ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ã¾ãšã¯ã€é©å½“ã«Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã—ã¾ã™ã€‚ã™ã¹ã¦ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯EUC-JPã§ä½œæˆã—ã¾ã™ã€‚ ä¾‹ã¨ã—ã¦ã€å¾“æ¥ã® scaffold ã§åãå‡ºã—ãŸé››å½¢ã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ç¢ºèªã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ model ã¯ class User < ActiveRecord::Base validates_presence_of :name end ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãŠé¦´æŸ“ã¿ã®
bash0C7 2011/10/06
mysql

ruby
ãƒªãƒ³ã‚¯
MySQLã§äºŒç‚¹é–“è·é›¢ã‚’ç®—å‡ºã™ã‚‹ | Parmy Party
ã“ã‚“ã«ã¡ã‚ã€ä¸å±±ã§ã™ã€‚ã„ããªã‚Šã§ã™ãŒã€ã§ãã¾ã—ãŸï¼ã§ãã¾ã—ãŸã‚ˆï¼ã€ŒMySQLã§ï¼’ç‚¹é–“ã®ç·¯åº¦ãƒ»çµŒåº¦ã‹ã‚‰è·é›¢ç®—å‡ºã€ãŒã€å‰å›žæŽ²è¼‰ã—ãŸã€ŒMySQL ä½ç½®å‚ç…§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ã¿ã‚‹ã€ã¨ã€ŒPostgreSQLã§ä½ç½®å‚ç…§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ã¿ã‚‹ã€ã®å†…å®¹ã§å‰ã‹ã‚‰æ°—ã«ãªã£ã¦ã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã—ãŸã€PostgreSQLã®PostGISã«ã¯ã‚ã£ã¦ã€MySQLã®ã‚¸ã‚ªãƒ¡ãƒˆãƒªé–¢æ•°ã«ã¯ãªã„é–¢æ•°ã€distance_spheroid ã¨ã„ã†ã‚‚ã®ã§ã€å›žè»¢æ¥•å††ä½“ã§è¨ˆç®—ã§ã€ç‚¹é–“è·é›¢ã‚’ç®—å‡ºã™ã‚‹é–¢æ•°ãªã®ã§ã™ãŒã€ã“ã‚ŒãŒã€MySQLã«ã¯å®Ÿè£…ã•ã‚Œã¦ã„ãªã„ãŸã‚ã€PostGISã‚’ä½¿ã†ã‹ã€MySQLã‚’ä½¿ã†ã‹ãšã£ã¨æ‚©ã‚“ã§ã„ãŸã®ã§ã™ãŒã€MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã—ã¦ã€ã“ã®distance_spheroidãŒå®Ÿç¾ã§ããªã„ã‹ãªï¼Ÿã¨è€ƒãˆã¦ã„ãŸã¨ã“ã‚ã€ã»ã¼èª¤å·®ã‚¼ãƒã§äºŒç‚¹é–“ã®è·é›¢ãŒç®—å‡ºã§ãã‚‹ã‚ˆã†ãªã‚‚ã®ãŒã§ãã¾ã—ãŸã®ã§ã€ã“ã“ã«æŽ²è¼‰ã—ãŸã„ã¨æ€ã„ã¾ã™
bash0C7 2011/06/28
MySQL

ä½ç½®æƒ…å ±
ãƒªãƒ³ã‚¯
1