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

shin0O id:shin0O

MySQLã«é–¢ã™ã‚‹shin0Oã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

ç¬¬105å›žã€€MySQLã§ãƒ‰ãƒãƒ¼ãƒ³ã‚’é£›ã°ã—ã¦ã¿ã‚‹ | gihyo.jp
åŽ»å¹´ã®ã‚¯ãƒªã‚¹ãƒžã‚¹ã«ç¬¬87å›ž MySQLã§ã‚±ãƒ¼ã‚ã‚’ç„¼ã„ã¦ã¿ã‚‹ã¨ã„ã†è¨˜äº‹ã‚’ç™ºè¡¨ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®å¾Œã”ç¸ãŒã‚ã‚Šã¾ã—ã¦8æœˆ29æ—¥ã‹ã‚‰8æœˆ31æ—¥ã¾ã§é–‹å‚¬ã•ã‚Œã¦ã„ãŸBuilderscon 2019ã®å‰å¤œç¥ã§ç™ºè¡¨ã‚’è¡Œã£ã¦ãã¾ã—ãŸã€‚Buildersconã§ã‚ˆãè¨€ã‚ã‚Œã‚‹ã“ã¨ã¯ã€Œãƒ–ãƒã‚°ã‚’æ›¸ãã¾ã§ãŒBuildersconã€ã¨ã„ã†è©±ãŒã•ã‚Œã¾ã™ã€‚ ä»Šå›žã¯ãã®ãƒ–ãƒã‚°ã«ä»£ã‚ã‚Šã¾ã—ã¦ã€Buildersconã§å¦ã‚“ã ã“ã¨ã‚’åˆ©ç”¨ã—ã¦MySQLã§ãƒ‰ãƒãƒ¼ãƒ³ã‚’é£›ã°ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯å®Ÿéš›ã«ãƒ‰ãƒãƒ¼ãƒ³ã‚’é£›ã°ã™è¨˜äº‹ã¨ãªã‚Šã¾ã™ã€‚ã“ã®è¨˜äº‹ã‚’è¿½è©¦ã•ã‚Œã‚‹å ´åˆã«ã¯ã€ãƒ‰ãƒãƒ¼ãƒ³ã‚’é£›ã°ã™éš›ã®æ³•å¾‹ãªã©ã«æ³¨æ„ã—ã¦é£›ã°ã—ã¾ã—ã‚‡ã†ã€‚ ã¾ãŸã€è½ä¸‹ã‚„ç ´æãªã©ã§æ€ªæˆ‘ã‚’ã™ã‚‹å¯èƒ½æ€§ã‚‚æ™®æ®µã®è¨˜äº‹ã¨æ¯”ã¹ã¦é«˜ã„ã®ã§ã€å‘¨ã‚Šã‚’ã‚ˆãè¦‹ã¦æ³¨æ„ã‚’ã—ã¦å®‰å…¨ã‚’ç¢ºèªã—ã¦è¡Œã„ã¾ã—ã‚‡ã†ã€‚ å‚è€ƒã«ã•ã›ã¦ã„ãŸã ã„ãŸç™ºè¡¨ ä»Šå›žã®é“æ™®è«‹ä¾¿ã‚Šã®ç™ºç«¯ã¨ã—ã¦ã¯ã€åŒã˜ãBuildersco
shin0O 2019/09/11
MySQL
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
shin0O 2018/10/05
MySQL

programming
ãƒªãƒ³ã‚¯
CVE-2016-6662 MySQL Remote Root Code Execution / Privilege Escalationã«ã¤ã„ã¦ - Qiita
å…è²¬ å–ã‚Šæ•¢ãˆãšã‚ã‹ã£ã¦ã„ã‚‹ç¯„å›²ã§æ›¸ã„ãŸã ã‘ãªã®ã§ã€æ‰‹å…ƒã§å†ç¾ã‚„ãƒ‘ãƒƒãƒã®æ£å½“æ€§ã¯ç¢ºèªã—ã¦ã„ã¾ã›ã‚“ã€‚ è‡ªå·±è²¬ä»»ã§ã©ã†ãžã€‚ ã“ã‚Œ(2016/09/22 22:00)ä»¥é™æ–°ã—ã„æƒ…å ±ãŒå‡ºã¦ãã¦ã‚‚ã€ãŠãã‚‰ãã‚‚ã†æ›´æ–°ã—ã¾ã›ã‚“ã€‚ CVE-2016-6662 ã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ MySQLã«é‡å¤§ãªè„†å¼±æ€§è¦‹ã¤ã‹ã‚‹ã€ãƒ‘ãƒƒãƒå˜åœ¨ã›ãšãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§å½±éŸ¿ - ITmedia ãƒ‹ãƒ¥ãƒ¼ã‚¹ oss-sec: CVE-2016-6662 - MySQL Remote Root Code Execution / Privilege Escalation ( 0day ) ã“ã®è„†å¼±æ€§ã‚’å†ç¾ã•ã›ã‚‹ãŸã‚ã«å¿…è¦ãªã‚‚ã® (æœªæ¤œè¨¼) 5.5.52, 5.6.33, 5.7.15ã¯å½±éŸ¿ã‚’å—ã‘ãªã„ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚è©³ã—ãã¯å›³ã®ã•ã‚‰ã«ä¸‹ã«ã€‚ æ‰‹å…ƒã§å†ç¾ã•ã›ã¦ã¯ã„ã¾ã›ã‚“ãŒã€ ã‚ªãƒªã‚¸ãƒŠãƒ«ã®è„†å¼±æ€§å ±å‘Š ã®å½±éŸ¿ã‚’å—ã‘ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã—ã‚ƒã‚‰ã£ã¨ "5.7.14
shin0O 2016/09/13
security

MySQL
ãƒªãƒ³ã‚¯
æŒ¿å…¥ã¨å‚ç…§ãƒãƒƒã‚¯ã«ç–²ã‚Œæžœã¦ãŸä¿ºãŸã¡ã¯ - ichirin2501's diary
ãªã‹ã£ãŸã‚‰INSERTã—ãŸã„ã—ã€ã‚ã‚‹ãªã‚‰ãƒãƒƒã‚¯å–ã‚ŠãŸã„ã‚„ã‚“? from ichirin2501 www.slideshare.net å‡ºæ¥äº‹ @ichirin2501 ã¨ã‚Šã‚ãˆãšä½•ã‚‚è€ƒãˆãšã“ã®å‰ã®ãƒãƒƒã‚¯ã®è©±ã‚’Slideshareã«ã‚ã’ã¦ãã‚Œï¼ï¼â€” æŸ´å´Žå„ªå£ (@shiba_yu36) 2015, 8æœˆ 22 ã¯ã˜ã‚ã« ã“ã‚Œã¯å…ˆæ—¥ã®ç¤¾å†…å‹‰å¼·ä¼šã§ç™ºè¡¨ã—ãŸã‚‚ã®ã§ã€MySQLã§ç‰¹å®šã®å•é¡Œã‚’è§£æ±ºã—ãŸã„ã¨ãã®ãƒŽã‚¦ãƒã‚¦è©±ã§ã™ã€‚ç‰¹å®šã®å•é¡Œã¨ã¯ã€ã‚¢ãƒ—ãƒªã‚’æ›¸ã„ã¦ã‚‹ã¨ã€Œãƒ‡ãƒ¼ã‚¿ãŒãªã‹ã£ãŸINSERTã—ãŸã„ã€ã‚ã‚‹ãªã‚‰æŽ’ä»–ãƒãƒƒã‚¯ã—ã¤ã¤å–å¾—ã—ãŸã„ã€ã¨ã„ã†è¦æœ›ãŒã‚ã£ãŸã‚Šã—ã¾ã™ã€‚ä¾‹ãˆã°ã€ã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã§åˆæœŸå€¤ã‚‚ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã§æ¸¡ã•ã‚Œã‚‹ã‚±ãƒ¼ã‚¹ã§ã€ãƒ‡ãƒ¼ã‚¿ãŒãªã„ãªã‚‰ãã®ã¾ã¾INSERTã€æ—¢ã«ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‚‹ãªã‚‰å–å¾—ã—ã¦çŠ¶æ…‹ã«ä¾å˜ã—ã¦æ›´æ–°å‡¦ç†ã‚’è¡Œã„ãŸã„å ´åˆãªã©ã§ã™ã€‚è¦‹ã‹ã‘ã®ãƒã‚¸ãƒƒã‚¯ã¯å˜ç´”ã«è¦‹ãˆã¾ã™ãŒã€MySQLã§ã“ã‚Œã‚’å®Ÿç¾ã—ã‚ˆã†
shin0O 2015/08/24
ã‚ˆãã‚ã‚‹ã€Œæ€§èƒ½åŠ£åŒ–ã•ã›ã‚‹ã“ã¨ãªãè‡ªå‹•ã§é€£ç•ªã‚’ä»˜ä¸Žã›ã‚ˆã€ãŸã ã—æŠœã‘ã¯è¨±ã•ãªã„ã€‚ã€ã¿ãŸã„ãªã®ãŒè¾›ãã†ãªæ„Ÿã˜

MySQL

slideshare
ãƒªãƒ³ã‚¯
MySQL 5.7.4ã§å°Žå…¥ã•ã‚ŒãŸdefault_password_lifetimeãŒã˜ã‚ã˜ã‚ãã‚‹ï¼ˆMySQL 5.7.11ã§FIXï¼ï¼ï¼‰
MySQL 5.7.4ã§å°Žå…¥ã•ã‚ŒãŸdefault_password_lifetimeãŒã˜ã‚ã˜ã‚ãã‚‹ï¼ˆMySQL 5.7.11ã§FIXï¼ï¼ï¼‰ ã€2016/01/13 10:12ã€‘ MySQL 5.7.11ã§default_password_lifetimeã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯0ã«å¤‰æ›´ã«ãªã‚Šã¾ã—ãŸï¼ ãã‚Œä»¥é™ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚Œã°ã“ã®è¨˜äº‹ã®å†…å®¹ã¯æ°—ã«ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æ—¥ã€…ã®è¦šæ›¸: MySQL 5.7.11ã§default_password_lifetimeã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒ0ã«ãªã‚‹ã‚‰ã—ã„ï¼ TL;DR default_password_lifetime= 0 ã‚’ç§˜ä¼ã®my.cnfã«å…¥ã‚Œã¦ãŠãã¤ã‚‚ã‚Šã€‚ MySQL :: MySQL 5.7 Reference Manual :: 5.1.4 Server System Variables ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã®æ„å‘³ã¯èªã‚“ã§å—ã®ã”ã¨ãã€ã€Œæœ€å¾Œã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ›´æ–°ã•
shin0O 2015/06/09
MySQL

password
ãƒªãƒ³ã‚¯
ã‚³ãƒ¼ãƒ‰ã§è¡Œã†MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆç®¡ç† - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ãƒ¼éƒ¨ã®è…åŽŸï¼ˆ@sgwr_dts)ã§ã™ã€‚ ã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ãƒ¼éƒ¨ã®ãƒ¡ãƒ³ãƒãƒ¼ã¯ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ãŸã‚å¼·åŠ›ãªæ¨©é™ã®MySQLã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã‚’ã™ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‚æ¥å‹™ã®ãŸã‚ã«ã‚µãƒ¼ãƒ“ã‚¹ã®DBã®å‚ç…§ãƒ»æ›´æ–°æ¨©é™ã‚’æŒã£ãŸã‚¢ã‚«ã‚¦ãƒ³ãƒˆãŒå¿…è¦ã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚„ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒŸã‚¹ã®ã“ã¨ã‚’è€ƒãˆã‚‹ã¨ã€ã™ã¹ã¦ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã™ã‚‹ã‚ã‘ã«ã¯ã„ã‹ãªã„ãŸã‚ã€éƒ½åº¦é©åˆ‡ãªæ¨©é™ã‚’ä»˜ä¸Žã—ã¦ã„ã¾ã™ãŒã€æ‰‹å‹•ã§ã®ä½œæ¥ã¯åœ°å‘³ã«æ‰‹é–“ãŒã‹ã‹ã‚Šã¾ã™ã€‚ ãã“ã§ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæƒ…å ±ã‚’ã‚³ãƒ¼ãƒ‰åŒ–ã—ã€ãƒªãƒã‚¸ãƒˆãƒªã§ç®¡ç†ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ gratanã«ã‚ˆã‚‹ã‚³ãƒ¼ãƒ‰åŒ– MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆç®¡ç†ã¯gratanã¨ã„ã†è‡ªä½œã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦è¡Œã£ã¦ã„ã¾ã™ã€‚ gratanã‚’ä½¿ã†ã¨MySQLã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’Rubyã®DSLã§è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚
shin0O 2015/04/10
development

MySQL
ãƒªãƒ³ã‚¯
MySQL ã¨å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
MySQL ã¨ Unicode Collation Algorithm (UCA) - ã‹ã¿ã½ã‚ãƒ¼ã‚‹ ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã§ã€ MySQL ã«ã¯å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã¨ã„ã†ã®ãŒã‚ã‚‹ã€‚ å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã©ã£ã‹ã§è©³ã—ããŠè©±ã‚’èžãã¹ãã ã‚ˆãªãã€‚ã€‚ã€‚â€” RKajiyama (@RKajiyama) March 18, 2015 ã“ã‚Œã¯ã©ã†ã„ã†å•é¡Œã‹ã¨ã„ã†ã¨ã€ MySQL ã® Unicode ã§ã¯ binary collation ã«ã—ã¦ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã§æ¯”è¼ƒã—ãªã„ã¨ðŸ£ã¨ðŸºã«é™ã‚‰ãšçµµæ–‡å—ãŒåŒå€¤åˆ¤å®šã•ã‚Œã‚‹ã¨ã„ã†å•é¡Œã§ã™ã€‚ ã‚ã‚Œï¼Ÿ MySQL ã® utf8mb4 charset ã£ã¦ã€4ãƒã‚¤ãƒˆæ–‡å—åŒå£«ã‚’æ¯”è¼ƒã™ã‚‹ã¨åŒã˜æ–‡å—æ‰±ã„ã•ã‚Œã‚‹ï¼Ÿ SELECT 'ðŸ£'='ðŸº' â†’ 1 MySQLçš„ã«ã¯å¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã¯åŒã˜æ‰±ã„ã€‚â€” ã¨ã¿ãŸã¾ã•ã²ã‚ (@tmtms) December 22, 2014 MySQLã§ select
shin0O 2015/03/23
MySQL

database

character
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ãŒåŠ‡çš„å¤‰åŒ–ï¼ï¼GTIDã«ã¤ã„ã¦ä»•çµ„ã¿ã‹ã‚‰ç†è§£ã™ã‚‹
ãƒ¡ãƒªãƒ¼ã‚¯ãƒªã‚¹ãƒžã‚¹ï¼ï¼ã‚„ã‚ã€è‰¯ã„åã®ã¿ã‚“ãªï¼ï¼ã‚µãƒ³ã‚¿ã‚¯ãƒãƒ¼ã‚¹ãƒ»ãƒ»ãƒ»ã§ã¯ãªãã€ãƒ’ã‚²ãƒ¢ã‚¸ãƒ£ã‚®ãƒ¼ã‚¯ã‹ã‚‰ã®ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ—ãƒ¬ã‚¼ãƒ³ãƒˆã ã‚ˆï¼ï¼ ã¨ã„ã†ã‚ã‘ã§ã€MySQL Casual Advent Calendarã®25æ—¥ç›®ã§ã‚ã‚‹ã€‚ä»ŠæœAdvent Calendarã‚’è¦—ã„ã¦ã¿ã‚‹ã¨ã€æœ¬æ—¥åˆ†ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒç„¡ã‹ã£ãŸã®ã§ã€æ€¥é½æ›¸ãã“ã¨ã«ã—ãŸã€‚Advent Calendaræœ€å¾Œã®æ—¥ã€ã‚¯ãƒªã‚¹ãƒžã‚¹ã‚’é£¾ã‚‹è¨˜äº‹ã®ãƒ†ãƒ¼ãƒžã¯GTIDã ã€‚ å‰å›žã®æŠ•ç¨¿ã§ã¯ã€MySQL 5.6ã®ç›®çŽ‰æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ãªã£ãŸã“ã¨ã‚’æŒ™ã’ãŸã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¾ã‚ã‚Šã§è¨€ãˆã°ã€ã‚‚ã†ã²ã¨ã¤å¤–ã›ãªã„ç›®çŽ‰æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚ãã‚ŒãŒGTIDï¼ˆGlobal Transaction IDï¼‰ã§ã‚ã‚‹ã€‚ GTIDã¯è‰¯ãã‚‚æ‚ªãã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é‹ç”¨ã‚’å¤‰åŒ–ã•ã›ã‚‹ã€‚GTIDã‚’ä½¿ã†ã“ã¨ã«ã‚ˆã£ã¦å¾—ã‚‰ã‚Œã‚‹æœ€å¤§ã®ãƒ¡ãƒªãƒƒãƒˆã¯ã€CHANGE MASTER TOã§ãƒã‚¤ãƒŠãƒªãƒ
shin0O 2014/12/26
development

MySQL
ãƒªãƒ³ã‚¯
Goã¨MySQLã‚’ç”¨ã„ãŸã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã‚‹ã¨ãã«è€ƒãˆãŸã“ã¨ - ã‚†ã†ã†ããƒ–ãƒã‚°
ã€è¿½è¨˜ã€‘2023å¹´3æœˆ21æ—¥ YAPC::Kyoto 2023ã§ã€ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã‚·ã‚¹ãƒ†ãƒ Fireworqã®è¨è¨ˆã¨é‹ç”¨å®Ÿç¸¾ã‚‚å«ã‚ã¦ç™ºè¡¨ã•ã‚Œã¾ã—ãŸã€‚id:tarao ++ ã€åŠ ç†ä¿®æ£ã€‘ 2020å¹´2æœˆ16æ—¥ åŸ·ç†æ™‚ã‹ã‚‰6å¹´ã‚‚çµŒéŽã—ã¦ã„ã¾ã™ãŒã€ãŸã¾ãŸã¾ã“ã®è¨˜äº‹ã‚’æŒ¯ã‚Šè¿”ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã€æ—¥æœ¬èªžãŒãŠã‹ã—ã„ã¨ã“ã‚ã‚’ä¸€éƒ¨ä¿®æ£ã—ãŸã‚Šã€ä¸€ç·’ã«å–ã‚Šçµ„ã‚“ã æ–¹ã€…ã®åå‰ãŒæ›¸ã‹ã‚Œã¦ã„ãªã‹ã£ãŸã¨ã“ã‚ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚ ã€è¿½è¨˜ã€‘2017å¹´12å¹´24æ—¥ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã®ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼å®Ÿè£…ãŒFireworqã¨ã„ã†åã§OSSã¨ã—ã¦å…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚id:tarao ++ github.com ã“ã®è¨˜äº‹ã¯ã¯ã¦ãª ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2014ã®4æ—¥ç›®ã§ã™ã€‚ å‰å›žã¯ Mackerelã§æŽ¡ç”¨ã—ã¦ã„ã‚‹æŠ€è¡“ä¸€è¦§ã¨ãã®ç´¹ä»‹ - Hatena Developer Blog ã§ã—ãŸã€‚ ç¤¾å†…ã®é–‹ç™ºåˆå®¿ã§ã€ id:taraoã•ã‚“ã€id:hakobe
shin0O 2014/12/05
hatena

JobQueue

Programming

MySQL
ãƒªãƒ³ã‚¯
Mobage ã‚’æ”¯ãˆã‚‹ Ruby ã®æŠ€è¡“ ~ è¤‡æ•°DBç·¨ ~ : sonots:blog
shin0O 2014/11/11
rails

mysql
ãƒªãƒ³ã‚¯
MySQLã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®ãªã„ALTER TABLEã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆãªã©ã‚’è¡Œã†ã¨ã€ãã®é–“ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã®ãŸã‚ã“ã‚Œã‚‰ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã¯ã€é€šå¸¸åˆ©ç”¨è€…ã®å°‘ãªã„æ·±å¤œæ—©æœå¸¯ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ã¦å®Ÿæ–½ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ—¥ã¯ãã‚Œã‚’ç„¡åœæ¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ã¾ã¾ã§ã§ããªã„ã‹ã¨ã„ã†è©±é¡Œã§ã™ã€‚ åŸºæœ¬çš„ãªã‚¢ã‚¤ãƒ‡ã‚¢ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å¯¾è±¡ã®å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€ä½œæ¥ç”¨ã®ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ è¿½åŠ ãªã©ã®å¤‰æ›´ã‚’åŠ ãˆã¾ã™ ãã®é–“ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦è¡Œã‚ã‚Œã‚‹æ›´æ–°å‡¦ç†ã«ã¤ã„ã¦å·®åˆ†ã‚’è¨˜éŒ²ã—ã¦ãŠãã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å¤‰æ›´ãŒçµ‚ã‚ã£ãŸã‚‰ã€è¨˜éŒ²ã—ã¦ãŠã„ãŸå·®åˆ†ãƒ‡ãƒ¼ã‚¿ã‚’ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¾ã™ å·®åˆ†ãƒ‡ãƒ¼ã‚¿ã®åæ˜ ãŒçµ‚ã‚ã£ãŸã‚‰ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã¾ã™ ã“ã‚Œã¨ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆãŸæ–¹ã¯çµæ§‹ã„ã‚‰ã£ã—ã‚ƒã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãŸã ã€è¨€ã†ã¯æ˜“ã—ã€è¡Œã†ã¯é›£ã—ã§ã™ã€‚æ•´åˆæ€§ãŒãã¡ã‚“ã¨å–ã‚Œã‚‹ã‹ã©ã†
shin0O 2010/07/04
web

MySQL

db
ãƒªãƒ³ã‚¯
1