[B! replication] manabouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

manabou id:manabou

replicationã«é–¢ã™ã‚‹manabouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (71)

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

Terraformç®¡ç†ã•ã‚ŒãŸã‚¹ãƒ†ãƒ¼ã‚¸ãƒ³ã‚°ç’°å¢ƒãƒ»æœ¬ç•ªç’°å¢ƒã®å·®ç•°ã‚’æ¤œå‡ºã—ãŸãã¦é ‘å¼µã£ã¦ã„ã‚‹è©± - KAYAC engineers' blog
SREãƒãƒ¼ãƒ ã®æ©‹æœ¬ã§ã™ã€‚ä»Šå›žã¯ã‚¹ãƒ†ãƒ¼ã‚¸ãƒ³ã‚°ç’°å¢ƒã®é‹ç”¨ã§ã‚ã‚ŠãŒã¡ãªæœ¬ç•ªã¨ã®å·®åˆ†ã«å¯¾å‡¦ã™ã‚‹è©¦ã¿ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ ã‚¹ãƒ†ãƒ¼ã‚¸ãƒ³ã‚°ç’°å¢ƒã«ã¤ã„ã¦ã€ä¾‹ãˆã°ITç”¨èªžè¾žå…¸ã§ã¯ ã‚¹ãƒ†ãƒ¼ã‚¸ãƒ³ã‚°ç’°å¢ƒã¨ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ã‚„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®é–‹ç™ºã®æœ€çµ‚æ®µéšŽã§æ¤œè¨¼ç”¨ã«ç”¨æ„ã•ã‚Œã‚‹ã€å®Ÿéš›ã®é‹ç”¨ç’°å¢ƒã¨å¤‰ã‚ã‚‰ãªã„ç’°å¢ƒã®ã“ã¨ã€‚ ã¨èª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚æ¤œè¨¼ç”¨ã§ã™ã‹ã‚‰ã€ã‚¤ãƒ³ãƒ•ãƒ©é¢ã§è¨€ã£ã¦ã‚‚æœ¬ç•ªç’°å¢ƒã¨ãªã‚‹ã¹ãä¸€è‡´ã—ãŸæ§‹æˆã§ã‚ã£ã¦ã»ã—ã„ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—å®Ÿéš›ã«ã¯ã•ã¾ã–ã¾ãªçµŒç·¯ï¼ˆã‚¹ãƒ†ãƒ¼ã‚¸ãƒ³ã‚°ç’°å¢ƒã‚’å¾Œã‹ã‚‰ç«‹ã¦ãŸã‚Šï¼ï¼‰ã‹ã‚‰ã€ãŸã¨ãˆTerraformç®¡ç†ã—ã¦ã„ãŸã¨ã—ã¦ã‚‚å·®ç•°ãŒç™ºç”Ÿã—ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã†ã—ãŸã¨ãã€ãã®å·®ç•°ã‚’æ¤œå‡ºã™ã‚‹ä¸€ã¤ã®æ–¹æ³•ã¨ã—ã¦ã¯Terraformã®.tfãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ¯”è¼ƒã™ã‚‹ã“ã¨ã§ã™ãŒã€ã“ã‚Œã«ã‚‚ã„ã‚ã„ã‚ãªæ›¸ãæ–¹ãŒã‚ã‚Šãˆã¾ã™ã€‚ ä¾‹ãˆã°aws_db_proxy_endpointã¯terraform-provider-a
manabou 2022/10/28
terraform

replication

operation
ãƒªãƒ³ã‚¯
MySQL 8.0 ã¸ã®ç§»è¡ŒãŒå®Œäº†ã—ã¾ã—ãŸ ï½žã•ã‚ˆã†ãªã‚‰å…¨ã¦ã® MySQL 5.7ï½ž - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¯ãƒ©ã‚¦ãƒ‰é‹ç”¨ãƒãƒ¼ãƒ ã®é£¯å¡šã§ã™ã€‚ ç§ãŸã¡ã¯ cybozu.com æœ¬ç•ªç’°å¢ƒã® MySQL ã‚’æ˜¨å¹´æœ«ã‹ã‚‰é †æ¬¡ 8.0 ç³»ã¸ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ã¦ãŠã‚Šã€å‰å›žã®å®šæœŸãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã«ãŠã„ã¦å…¨ã¦ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚’å®Œäº†ã—ã¾ã—ãŸã€‚ã“ã®è¨˜äº‹ã§ã¯ã€ç§ãŸã¡ãŒ MySQL 8.0 ã¸ã®ç§»è¡Œã«å–ã‚Šçµ„ã‚“ã ç†ç”±ã¨å¿…è¦ã«ãªã£ãŸå¯¾å¿œã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãªãœ MySQL 8.0 ã¸ç§»è¡Œã—ãŸã®ã‹ GTID-based ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹åˆ¶é™ã®ç·©å’Œ å†èµ·å‹•æ™‚ã« AUTO_INCREMENT ã®ã‚«ã‚¦ãƒ³ã‚¿ãŒå·»ãæˆ»ã‚‹å•é¡Œã®è§£æ¶ˆ å®Ÿéš›ã«å¯¾å¿œãŒå¿…è¦ã ã£ãŸ MySQL 8.0 ã®å¤‰æ›´ç‚¹ utf8mb4 ã®ç…§åˆé †åºã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®å¤‰æ›´ SQL_CALC_FOUND_ROWS ã¨ FOUND_ROWS() ãŒ deprecated ã« Connector/J ã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿å–å¾—å‡¦ç†ã®æ€§èƒ½ä½Žä¸‹ sys.innodb_lo
manabou 2021/05/25
mysql

index

replication
ãƒªãƒ³ã‚¯
MySQL ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰10å¹´é–“é€ƒã’ã¦ããŸæˆ‘ã€…ãŒå¦ã‚“ã ã“ã¨8é¸ - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¯ãƒ©ã‚¦ãƒ‰é‹ç”¨ãƒãƒ¼ãƒ ã§ SRE ã‚’ã—ã¦ã„ã‚‹é£¯å¡šã§ã™ã€‚ ä»Šå›žã¯ã€MySQL ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’ç´„10å¹´ã‚‚ã®é–“ãšã£ã¨ä½¿ã£ã¦ã“ãªã‹ã£ãŸç§ãŸã¡ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ãŸé«˜å¯ç”¨æ€§æ§‹æˆã«ç§»è¡Œã™ã‚‹ãŸã‚ã®å–ã‚Šçµ„ã¿ã®ä¸ã§å¦ã‚“ã ã“ã¨ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ å·¨å¤§ãªãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã® primary key ã®ä»˜ä¸Ž ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚µã‚¤ã‚ºãŒå¤§ãã„å ´åˆã«ã¯ tmpdir ã«æ³¨æ„ mysqldump ã§çµµæ–‡å—ãŒæ¶ˆãˆã¦ã„ãªã„ã‹è¦ãƒã‚§ãƒƒã‚¯ mysqldump ãŒ Error 1412: Table definition has changed... ã§å¤±æ•—ã™ã‚‹ mysqldump ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ãƒªã‚¹ãƒˆã‚¢ãŒ Duplicate entry 'xxx-yyy-PRIMARY-n_diff_pfx01' for key 'PRIMARY' ã§å¤±æ•—ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ mysqldump ã—ãŸãƒ‡ãƒ¼ã‚¿ã®ãƒªã‚¹ãƒˆã‚¢æ™‚ã®ãƒ‡ã‚£ã‚¹ã‚¯
manabou 2020/10/26
mysql

replication

dump

mysqldump
ãƒªãƒ³ã‚¯
GitHub - timakin/gopli: DB replication tool to synchronize data with multi environments written in Golang.
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
manabou 2017/01/26
mysql

database

gopli

golang

backup

replication
ãƒªãƒ³ã‚¯
MySQL group replication: installation with Docker
manabou 2017/01/23
mysql

docker

replication
ãƒªãƒ³ã‚¯
Goã§ä½œã‚‹DBãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«
gopli - DB replication tool to synchronize data with multi environments written in Golang. ãƒ„ãƒ¼ãƒ«ã®åå‰ã¯gopli (go replication)ã§ã€æ„å›³ã©ãŠã‚Šã®åå‰ã§ã™ãã€‚ ã“ã‚Œã¯ä½•tomlã§æ›¸ã„ãŸã€ssh/dbæŽ¥ç¶šç”¨ã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’å…ƒã«ã€ç‰¹å®šã®ç’°å¢ƒé–“ã§ãƒ‡ãƒ¼ã‚¿ã‚’åŒæœŸã•ã›ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ä»Šã®æ‰€MySQLã®ã¿å¯¾å¿œã§ã€postgresqlã«å¯¾å¿œã—ã‚ã¨è¨€ã‚ã‚ŒãŸã‚‚ã®ã®ã€ãªã‹ãªã‹æ‰‹ãŒå›žã£ã¦ã„ãªã„çŠ¶æ³ã§ã™ã€‚ ä½¿ã„æ–¹ã¯ç°¡å˜ã§ã€ ã¾ãšä»¥ä¸‹ã®ã‚ˆã†ã«ã€ sshã§ã®ã‚µãƒ¼ãƒãƒ¼ã¸ã®æŽ¥ç¶šã¨ã€MySQLã¸ã®æŽ¥ç¶šè¨å®šã‚’tomlã§æ›¸ãã¾ã™ã€‚ [database] [database.local] host = "localhost" management_system = "mysql" name = "app_developmen
manabou 2016/12/27
golang

database

db

replication
ãƒªãƒ³ã‚¯
MySQL 5.7æ–°æ©Ÿèƒ½è§£èª¬ï¼šãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç·¨
ä»Šæœˆã®é ã€è©³è§£MySQL 5.7ã®å‡ºç‰ˆè¨˜å¿µç¬¬ä¸€å¼¾ã¨ã—ã¦ã€MyNAï¼ˆæ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼šï¼‰åç¾©ã§ã‚¤ãƒ™ãƒ³ãƒˆã‚’è¡Œã£ãŸã®ã§ã€ãã®éš›ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ç´¹ä»‹ã—ã¦ãŠã“ã†ã€‚ä»Šå›žç´¹ä»‹ã—ãŸæ–°æ©Ÿèƒ½ã®ã‚«ãƒ†ã‚´ãƒªã¯2ã¤ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®é‹ç”¨ã¨åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Šé›¢ã›ãªã„ã»ã©é‡è¦ãªã‚‚ã®ã§ã‚ã‚Šã€ãã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã«ã¨ã£ã¦ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãŒé‡è¦ã§ã‚ã‚‹ã“ã¨ã¯ã€è¨€ã†ã¾ã§ã‚‚ãªã„ã ã‚ã†ã€‚ ä»Šå›žã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¤§ããé€²åŒ–ã—ã¦ã„ã‚‹ã€‚ ã¾ãšã€MySQL 5.7ã§ã¯ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒˆãƒãƒã‚¸ã®é™ç•Œã‚’æ‰“ã¡ç ´ã£ãŸï¼ï¼MySQL 5.6ã¾ã§ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯ã²ã¨ã¤ã®ãƒžã‚¹ã‚¿ãƒ¼ã—ã‹æŒã¤ã“ã¨ãŒã§ããªã„ã¨ã„ã†åˆ¶ç´„ãŒã‚ã£ãŸã®ã ãŒã€ãã‚ŒãŒãªããªã£ãŸã€‚ã™ãªã‚ã¡ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒè¤‡æ•°ã®ãƒžã‚¹ã‚¿ãƒ¼ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’é€£ç¶šçš„ã«è¤‡è£½ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§ã‚ã‚‹ã€‚ãã‚Œã«ã‚ˆã‚Šã€ã“ã‚Œã¾ã§ä»¥ä¸Šã«æ§˜ã€…ãª
manabou 2016/10/06
mysql

replication

slide
ãƒªãƒ³ã‚¯
Improving the design of MySQL replication
manabou 2016/09/28
mysql

replication
ãƒªãƒ³ã‚¯
mikasafabric for MySQLã‚¯ã‚¤ãƒƒã‚¯ã‚¹ã‚¿ãƒ¼ãƒˆ | GMOãƒ¡ãƒ‡ã‚£ã‚¢ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã¬ã„ãã‚‹ã¿ãŒå¥½ããªæ–¹ã®DBAã§ã™ã€‚ mikasafabric for MySQLã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ã¾ã—ãŸ ã§ç´¹ä»‹ã—ãŸ mikasafabric for MySQLï¼ˆä»¥ä¸‹mikasafabricï¼‰ã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã§ã™ã€‚ æ±ºã—ã¦ç¤¾å†…å‘ã‘ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’æ›¸ãã®ãŒé¢å€’ã«ãªã£ãŸã‹ã‚‰ãƒ–ãƒã‚°ã«æ›¸ã„ã¦ã„ã‚‹è¨³ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãªãŠã€ç‰¹ã«æ˜Žè¨˜ã—ãªã„å ´åˆã¯mikasafabricã¨MySQL Fabricã§æ‰‹é †ã¯å¤‰ã‚ã‚Šã¾ã›ã‚“ã®ã§ã€ã‚ªãƒªã‚¸ãƒŠãƒ«ã®MySQL Fabricã®ã‚¯ã‚¤ãƒƒã‚¯ã‚¹ã‚¿ãƒ¼ãƒˆã¨ã—ã¦ã‚‚ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ä¸€ç²’ã§äºŒåº¦ç¾Žå‘³ã—ã„ã€‚ ã¾ãšã€mikasafabricã¯MySQL Fabricã®ã‚¯ãƒãƒ¼ãƒ³ãªã®ã§åŒã˜ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ãƒãƒƒã‚ãƒ³ã‚°ã‚¹ãƒˆã‚¢ã¨å‘¼ã°ã‚Œã‚‹mysqldmikasafabricãƒ‡ãƒ¼ãƒ¢ãƒ³(mysqlfabric)mikasafabricãªã®ã«ãƒ—ãƒã‚»ã‚¹åãŒmy
manabou 2016/08/31
mikasafabric

mysql

replication
ãƒªãƒ³ã‚¯
mikasafabric for MySQLã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ã¾ã—ãŸ | GMOãƒ¡ãƒ‡ã‚£ã‚¢ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã‚ã¾ã‚Šã«ã‚‚ã¤ã‚‰ã‹ã£ãŸã®ã§ã€ãŠã¨ãªã—ããƒ•ã‚©ãƒ¼ã‚¯ã—ã¦è‡ªå‰ã§ãƒ‘ãƒƒãƒã‚’å½“ã¦ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ãƒ•ã‚©ãƒ¼ã‚¯ã™ã‚‹ã¤ã„ã§ã«åå‰ã‚’å¤‰ãˆãŸã®ãŒ mikasafabric for MySQL ï¼ˆã¿ã‹ã•ãƒ•ã‚¡ãƒ–ãƒªãƒƒã‚¯ ãƒ•ã‚©ãƒ¼ ãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã«ãªã‚Šã¾ã™ã€‚ æœŸå¾…é€šã‚Šã«ä½¿ãˆã‚‹MySQL Fabric ã‚’ç›®æŒ‡ã—ãŸçµæžœãªã®ã§ã€ã¾ã‚ã¾ã‚æœŸå¾…é€šã‚Šã«å‹•ãã¾ã™ï¼ˆãŸã ã—ã€MySQL Routerã¨ã®çµ„ã¿åˆã‚ã›ã—ã‹ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã›ã‚“ã€‚ä»–ã®ã‚³ãƒã‚¯ã‚¿ãƒ¼ã¯å‹•ãã‹ã‚‚çŸ¥ã‚Œãªã„ã—å‹•ã‹ãªã„ã‹ã‚‚çŸ¥ã‚Œãªã„ã€‚ä¸€éƒ¨ã€APIã®æˆ»ã‚Šã«ã‚‚æ‰‹ã‚’å…¥ã‚Œã¦ã„ã‚‹ã®ã§ï¼‰ åå‰ã‚’å¤‰ãˆãŸç†ç”±- MySQLã¯å•†æ¨™ãªã®ã§ãƒ•ã‚©ãƒ¼ã‚¯ã¨ã¯ã„ãˆMySQL Fabricã¯å¾®å¦™ï¼ˆMySQL xxxã¯ãƒ€ãƒ¡ã§ã€xxx for MySQLãªã‚‰OKï¼‰ - mikasafabric for MySQL ã¯ MySQL Fabric 1.5.6 ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦ã„ã‚‹ã®ã§ã€ãƒªãƒã‚¸ãƒˆãƒªãƒ¼åˆ†ã‘ã‚‹ã¾ã§ã¯1.5.
manabou 2016/08/23
mysql

slide

fabric

replication
ãƒªãƒ³ã‚¯
Facebookã®Simon Martinæ°ã¸ã®æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã®ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼(The Percona Performance Blogã‚ˆã‚Š) | Yakst
Facebookã®Simon Martinæ°ã¸ã®æº–åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã®ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼(The Percona Performance Blogã‚ˆã‚Š) å‡ºå…¸ã«ã¤ã„ã¦ ã“ã®è¨˜äº‹ã¯The Percona Performance Blogå†…ã®Tom Diederichæ°ã«ã‚ˆã‚‹Facebookâ€™s Simon Martin on semi-synchronous replication(2015/9/4)ã‚’ç¿»è¨³ã—ãŸã‚‚ã®ã§ã™ã€‚ Facebookã«ã¯æœˆé–“14.9å„„ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒãŠã‚Šã€ä¸–ç•Œã®æœ€å¤§ã®MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã®1ã¤ã§ã‚ã‚‹ã€‚Facebookã®MySQLã‚¤ãƒ³ãƒ•ãƒ©ãƒãƒ¼ãƒ ã®ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹Simon Martinã¯ã€ã‚¹ãƒšã‚¢ã®ãªã„2å°ã®ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰å§‹ã¾ã£ã¦ã€ä¸–ç•Œã§æœ€å¤§ã®è¦æ¨¡ã®1ã¤ã«ãªã‚‹ã¾ã§ã€ã‚ãƒ£ãƒªã‚¢ã®å¤§éƒ¨åˆ†ã§MySQLã«å–çµ„ã‚“ã§ããŸã€‚ Simonã¯FacebookãŒå–çµ„ã‚“ã§ããŸã€
manabou 2015/10/09
replication

mysql

facebook
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯master.infoã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ - There's an echo in my head
MySQLã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹éš›ã«CHANGE MASTER TOã§è¨å®šã—ãŸãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä¸‹ã®master.infoãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚
manabou 2015/08/18
replication

mysql
ãƒªãƒ³ã‚¯
MySQLå…¥é–€ã€€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ - Qiita
#çµŒç·¯ ã¨ã‚ã‚‹å‹‰å¼·ä¼šã®å†…å®¹ã®å¾©ç¿’ï¼†æ•´ç† #ã‚¿ã‚¤ãƒˆãƒ« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åŸºç¤Žç·¨ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ã€€â†ä»Šå›žã¯ã“ã¡ã‚‰ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç·¨ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°åŸºç¤Žç·¨ #ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ç¨®é¡ž ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨å®šæ–¹æ³• ãƒã‚¤ãƒŠãƒªãƒã‚°ã®ç®¡ç†æ–¹æ³• ãã®ä»–ã®è€ƒæ…®äº‹é … å‚è€ƒæƒ…å ± #1. ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ ##1.1. åŸºç¤ŽçŸ¥è˜ ãƒ‡ãƒ¼ã‚¿ã®è¤‡è£½ï¼ˆãƒ¬ãƒ—ãƒªã‚«ï¼‰ã‚’åˆ¥ã®ã‚µãƒ¼ãƒã«ãƒ¢ãƒ†ã‚‹æ©Ÿèƒ½ MySQLã®æ¨™æº–æ©Ÿèƒ½ã§ã€å¤šæ•°ã®Webã‚µã‚¤ãƒˆç‰ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ ï¼ã€€ã‚·ãƒ³ãƒ—ãƒ«ãªè¨å®šã§åˆ©ç”¨å¯èƒ½ ï¼ã€€ãƒžã‚¹ã‚¿ãƒ¼ â†’ ã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆ ##1.2. ãƒžã‚¹ã‚¿ãƒ¼ã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆ ã‚µãƒ¼ãƒã¯ãƒžã‚¹ã‚¿ãƒ¼ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã¾ãŸã¯ä¸¡æ–¹ã«ãªã‚Œã‚‹ ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒ ï¼ã€€ãƒ‡ãƒ¼ã‚¿ã‚’å¤‰æ›´ ï¼ã€€å¤‰æ›´å†…å®¹ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«è»¢é€ ï¼ã€€ãƒžã‚¹ã‚¿ãƒ¼ã¯è¤‡æ•°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’æŒã¦ã‚‹ ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒ ï¼ã€€ãƒžã‚¹ã‚¿ãƒ¼ã§ã®å¤‰æ›´å†…å®¹ã‚’
manabou 2015/07/03
mysql

replication
ãƒªãƒ³ã‚¯
MongoDBã¨Elasticsearchã‚’åŒæœŸã•ã›ã‚‹ - Qiita
ãã‚ŒRiverã§ã§ãã‚‹ã˜ã‚ƒã‚“ ã¯ã„ã€ãã†ã§ã™ ç´ ç›´ã«River Pluginä½¿ãˆã°ã„ã„ã®ã§ã™ãŒ Riverç”¨ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’çµ„ã¾ãªãã‚ƒãªã„ Elasticsearchæœ¬ä½“ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³é•ã„ãŒæ€ã‚ã¬ã¨ã“ã‚ã§åœ°é›·ã«ãªã‚‹ ãã®ä»–ã®äº‹æƒ… ãªã©ã®ç†ç”±ã§Riverã‚’ä½¿ã‚ãªã„å ´åˆã¯ã©ã†ã™ã‚“ã¹ã¨ã„ã†è©± Mongooseã«ã¯middlewareã¨ã„ã†æ©Ÿèƒ½ãŒã‚ã‚Šã€ä»–ã®RDBMSã®Triggeræ©Ÿèƒ½ã®ã‚ˆã†ã«å„ç¨®ã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚³ãƒ¼ãƒ«ã«å‡¦ç†ã‚’å·®ã—è¾¼ã‚ã‚‹ã®ã§ã€ã“ã‚Œã‚’ä½¿ã†ã“ã¨ã«ã—ã¾ã™ å®Ÿè£… äºˆã‚Elasticsearchå´ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã£ã¦ãŠã ãã—ã¦Mongooseã¨Elasticsearchã‚’çµã¶ã‚ˆã†ãªãƒ¢ãƒ‡ãƒ«ã‚’ä½œã‚‹ å€‹äººçš„ã«ã¯app.jsã®ä¸‹ã«lib/model.jsã ã£ãŸã‚Šlib/model/dbå.jsã¨ã‹ä½œã‚‹ã®ãŒå¥½ã¿ã§ã™ module.exports = function(){ va
manabou 2015/06/01
node.js

mongodb

elasticsearch

replication
ãƒªãƒ³ã‚¯
Ansibleã¦ã‚™å§‹ã‚ã‚‹postgre sqlã®å†—é•·åŒ–
43. PostgreSQLã¨ã¯ var ãƒªãƒªãƒ¼ã‚¹æ—¥ ä¸»ãªæ©Ÿèƒ½è¿½åŠ 8.4 2009/07/01 å†å¸°ã‚¯ã‚¨ãƒª, ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦é–¢æ•°, åˆ—å˜ä½ã®ã‚¢ã‚¯ã‚»ã‚¹åˆ¶å¾¡, SQL ã¨é–¢æ•°ã®æ€§èƒ½è§£æžæ©Ÿèƒ½ 9.0 2010/09/20 ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³, ä¸€æ‹¬æ¨©é™å¤‰æ›´, åŒ¿åãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£, 64bit Windows ã‚µãƒãƒ¼ãƒˆ, ç§»å‹•å¹³å‡, åˆ—/æ¡ä»¶ãƒˆãƒªã‚¬, ä¸€æ„ æ€§åˆ¶ç´„ã®é…å»¶, æŽ’ä»–åˆ¶ç´„ 9.1 2011/09/12 åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³, å¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«, ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ç®¡ç†, UNLOGGEDãƒ†ãƒ¼ãƒ–ãƒ«, æ›´æ–°å¯èƒ½ãªWITHå¥, è¿‘å‚æ¤œç´¢, SELinuxæ¨©é™åˆ¶å¾¡ 9.2 2012/09/10 ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚ªãƒ³ãƒªãƒ¼ã‚¹ã‚ãƒ£ãƒ³, ã‚«ã‚¹ã‚±ãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚· ãƒ§ãƒ³, JSONåž‹, ç¯„å›²åž‹ 9.3 2013/09/09 ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼, å¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®æ›¸ãå‡ºã—, ã‚¤ãƒ™ ãƒ³ãƒˆãƒˆãƒªã‚¬, ãƒ‡ãƒ¼ã‚¿ãƒšãƒ¼ã‚¸ãƒ»ãƒã‚§ãƒƒã‚¯ã‚µãƒ , L
manabou 2015/02/23
slide

ansible

postgresql

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

replication
ãƒªãƒ³ã‚¯
ã¾ã MySQL 5.5ã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼ŸMySQL 5.6ã§ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ´»ç”¨ã—ã¦æž•ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹æ—¥ã€…ã‚’æº€å–«ã™ã‚‹æ–¹æ³•
MySQL 5.6ãŒç™»å ´ã—ã¦ã‹ã‚‰ã‹ãªã‚Šã®æœˆæ—¥ãŒéŽãŽãŸãŒã€ä»–ã®ã“ã¨ã§å¤šå¿™ã ã£ãŸã›ã„ã‹ã€MySQL 5.6ã«ã¤ã„ã¦ã¯ã‚ã¾ã‚Šãƒ–ãƒã‚°ã§æƒ…å ±ã‚’ç™ºä¿¡ã—ã¦ã„ãªã„ã“ã¨ã«æ°—ãŒã¤ã„ãŸã€‚ã“ã‚Œã¯ã‚¤ã‚«ãƒ³ï¼ï¼ã¨æ€ã„ã€MySQL Casual Advent Calendar 2014ã«åˆã‚ã›ã¦ã€MySQL 5.6ã‚’ä½¿ç”¨ã™ã‚‹ä¸Šã§æœ€ã‚‚ã‚ªã‚¹ã‚¹ãƒ¡ã—ãŸã„æ©Ÿèƒ½ã§ã‚ã‚‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ã“ã®è¨˜äº‹ã¯16æ—¥ç›®ã®è¨˜äº‹ã§ã‚ã‚‹ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã¨ã¯ã©ã†ã„ã†ã“ã¨ã‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã¨ã¯ã€ä½•ã‚‰ã‹ã®äº‹æƒ…ã«ã‚ˆã‚Šã€ãƒ—ãƒã‚»ã‚¹ãŒãƒ€ã‚¦ãƒ³ã—ãŸã‚Šãƒžã‚·ãƒ³ãŒé›»æºã”ã¨è½ã¡ãŸã‚Šï¼ˆã¤ã¾ã‚Šã‚¯ãƒ©ãƒƒã‚·ãƒ¥ï¼‰ã—ã¦ã‚‚ã€å†èµ·å‹•å¾Œã«ä»¥å‰ã®çŠ¶æ…‹ã«æˆ»ã£ã¦å‡¦ç†ã‚’å†é–‹ã§ãã‚‹ã¨ã„ã†ã“ã¨ã ã€‚ãƒ‡ãƒ¼ã‚¿ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã§ã‚ã‚Œã°ã¿ãªã•ã‚“æ—¢ã«ã‚ˆãã”å˜çŸ¥ã§ã‚ã‚ã†ã€‚ï¼ˆREDOã‚„UNDOã™ã‚‹ã‚¢ãƒ¬ã®ã“ã¨ã ã€‚æœ¬ç¨¿ã§ã¯é¢å€’è‡ã„ãƒ»ãƒ»ãƒ»ã§ã¯ãªã‹ã£ãŸã€æœ¬é¡Œã§ã¯ãªã„ãŸ
manabou 2014/12/16
mysql

innodb

replication

crash
ãƒªãƒ³ã‚¯
Mongoã‚¯ã‚¨ãƒªãƒ¼ãƒ»ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ - ä¸å¹´engineerã®ç‹¬ã‚Šè¨€ - crumbjp
ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ Mongo DBã§ã¯ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã‚’è·¨ã„ã§ãƒ‡ãƒ¼ã‚¿ã‚’åŒæœŸã™ã‚‹æ‰‹æ®µãŒç„¡ã„ã€‚ ãã‚‚ãã‚‚ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆè‡ªä½“ãŒå†—é•·æ§‹æˆã‚’ç›®çš„ã¨ã—ã¦ã„ã‚‹ã®ã§è¨è¨ˆã«çµ„ã¿è¾¼ã¾ã‚Œã¦ã„ãªã„ã®ã ã‚ã†ã€‚ ã—ã‹ã—ç¾å®Ÿã¯ Stagingç’°å¢ƒã‚„ã€PVç³»ï¼é›†è¨ˆç³»ã®åˆ†é›¢ãªã©ã€ç”¨é€”ã¯ã‚ã‚‹ã€‚ ä»Šã¯ã€ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã®slaveã‚’ï¼‘å°åˆ‡ã‚Šé›¢ã—ã¦ãã“ã§ä½•ã‹ã™ã‚‹ã—ã‹ãªã„ã€‚ ãƒ•ãƒ¬ãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ã˜ã‚ƒãªã„ã—é‹ç”¨ã‚‚é¢å€’ã€‚ monmo-repl https://github.com/monmo/monmo-repl ãªã‘ã‚Œã°ä½œã‚Œã°è‰¯ã„ã®ã§ä½œã£ãŸã€‚ oplogãƒ™ãƒ¼ã‚¹ã®åŒæœŸã‚’è¡Œã†ã€‚-s ã§æŒ‡å®šã—ãŸãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã®PRIMARYã®oplogã‚’èªã¿ã€-d ã§æŒ‡å®šã—ãŸãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã«åæ˜ ã—ã¦ã„ãã€‚ PRIMARYãƒ€ã‚¦ãƒ³æ™‚ã®æŒ™å‹•ãªã©ã€ã¾ã æœªãƒ†ã‚¹ãƒˆã®éƒ¨åˆ†ã¯å¤šã„ãŒ ã€Žã¨ã‚Šã‚ãˆãšå‹•ãã€ ç¨‹åº¦ã®å®Œæˆåº¦ã€‚ ä¾‹ ReplicaSet1 =sync=> R
manabou 2014/08/25
mongodb

replication
ãƒªãƒ³ã‚¯
MySQL User Forum - MySQL Replication & MySQL Fabric (Japanese)
MySQL Fabric ã¨ Replication ã®æ©Ÿèƒ½ã‚’è§£èª¬ã—ã¾ã™ã€‚ 2014å¹´4æœˆ25æ—¥ã«é–‹å‚¬ã—ãŸMySQL User Forum ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ï¼‘ã¤ã§ã™ã€‚MySQL User Forum ã¯ã€MySQL 5.7ã‚’å«ã‚€æœ€æ–°é–‹ç™ºãƒ»æŠ€è¡“å‹•å‘ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å¼·åŒ–ãƒã‚¤ãƒ³ãƒˆã€MySQLè£½å“ç´¹ä»‹ã€æœ€æ–°ç‰ˆã®MySQL Workbenchãƒ‡ãƒ¢ãªã©ã€MySQL ã®æœ€æ–°ã®æŠ€è¡“æƒ…å ±ã‚’ãŠå±Šã‘ã—ã¾ã—ãŸã€‚ Subscribe to the MySQL Youtube channel and watch more tutorials and presentations: http://www.youtube.com/mysqlchannel Like the MySQL facebook page to receive latest updates on product releases, technical
manabou 2014/05/30
movie

mysql

replication
ãƒªãƒ³ã‚¯
MariaDB 10.0 GAè¨˜å¿µã€€ä¸¦åˆ—ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã£ã¦ä½•ï¼Ÿ - interdbâ€™s blog
2014å¹´3æœˆæœ«ã«MariaDB 10.0.10 GAãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã€ä¸¦åˆ—ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(Parallel replication)ãŒç›®çŽ‰ã®ï¼‘ã¤ã£ã½ãæ›¸ã‹ã‚Œã¦ã„ã‚‹ã®ã§ã€ç°¡å˜ã«è§£èª¬ã€‚(2014.12.3è¿½è¨˜ï¼šä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚è¨˜è¿°ã—ãŸã€‚) ä¸¦åˆ—ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–å´ã®æ©Ÿèƒ½ã§ã€å¾“æ¥ã¯SQLã‚¹ãƒ¬ãƒƒãƒ‰ï¼‘ã¤ã§å‡¦ç†ã—ã¦ã„ãŸrelayãƒã‚°ã®å†ç”Ÿã‚’ã€è¤‡æ•°ã®ã‚¹ãƒ¬ãƒƒãƒ‰ã§ä¸¦åˆ—ã«å‡¦ç†ã—ã‚ˆã†ã¨ã„ã†ã‚‚ã®ã€‚ MySQLã«ã‚‚ãƒ‘ãƒ©ãƒ¬ãƒ«workerã¨ã„ã†æ©Ÿèƒ½ãŒã‚ã‚‹ãŒã€MariaDBã®ãã‚Œã¨ã¯ä¸¦åˆ—åŒ–ã®ç²’åº¦ãŒå…¨ãç•°ãªã‚‹ã€‚(æ³¨ï¼šMySQL5.7ã§MariaDBã¨åŒãƒ¬ãƒ™ãƒ«ã®æ©Ÿèƒ½ãŒå®Ÿè£…ã•ã‚ŒãŸã€‚) MariaDBã®ãƒžã‚¹ã‚¿ãŒã‚³ãƒŸãƒƒãƒˆã—ã¦ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æ›¸ãéš›ã«ã€ä¸¦åˆ—å®Ÿè¡Œã§ãã‚‹ã‹ã©ã†ã‹ã‚’ãƒã‚¤ãƒŠãƒªãƒã‚°ã«æ›¸ãè¾¼ã‚“ã§ã„ã‚‹ã€‚ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯ãã‚Œã«å¿œã˜ã¦ã€ä¸¦åˆ—ã«å®Ÿè¡Œã§ãã‚‹SQLã¯ä¸¦åˆ—ã«å®Ÿè¡Œã™ã‚‹ã€‚ å…·ä½“ä¾‹ã‚’ã¿ã¦ã¿ã‚ˆã†ã€‚ ãƒžã‚¹ã‚¿ã§binlog_commi
manabou 2014/04/04
mariadb

database

db

replication
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸