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

koyhoge id:koyhoge

mysqlã¨clusterã«é–¢ã™ã‚‹koyhogeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

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

MariaDBãƒ™ãƒ¼ã‚¹ã®å®Œå…¨åŒæœŸåž‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ŒMariaDB Galera Cluster 5.5.39ã€ãƒªãƒªãƒ¼ã‚¹ | OSDN Magazine
MariaDB Foundationã¯8æœˆ21æ—¥ã€MariaDBå‘ã‘ã®ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚·ã‚¹ãƒ†ãƒ ã€ŒMariaDB Galera Cluster 5.5.39ã€ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚æœ€æ–°ã®MariaDBã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã€wsrep(WriteSet Replication) APIã‚‚æ›´æ–°ã—ãŸã€‚ MariaDB Galera Clusterã¯MariaDBå‘ã‘ã®åŒæœŸãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼åž‹ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼æŠ€è¡“ã€‚MySQLã‹ã‚‰ãƒ•ã‚©ãƒ¼ã‚¯ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã‚ã‚‹MariaDBã¨ã€ã‚¯ãƒ©ã‚¹ã‚¿æŠ€è¡“ã€ŒGalera Clusterã€ã¨ã‚’çµ„ã¿åˆã‚ã›ãŸã‚‚ã®ã€‚Galera Clusterã¯ãƒ•ã‚£ãƒ³ãƒ©ãƒ³ãƒ‰CodershipãŒé–‹ç™ºã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿æŠ€è¡“ã§ã€wsrep(WriteSet Replication) APIã‚’æä¾›ã™ã‚‹ã€‚Galeraãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã®ãŸã‚ã«MariaDBã‚’å¼·åŒ–ã€ãƒ¬ãƒ—
koyhoge 2014/08/22
ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ã€åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã‚¢ã‚¯ãƒ†ã‚£ãƒ–-ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã§ã™ã¨ãƒ¼ã€‚è©¦ã—ã¦ã¿ã‚‹ã‹â€•ã€‚

mysql

mariadb

cluster
ãƒªãƒ³ã‚¯
æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã€Twitterã‚’é–‹å§‹ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»ã‚¢ã‚¸ã‚¢ãƒ‘ã‚·ãƒ•ã‚£ãƒƒã‚¯ï¼†ã‚¸ãƒ£ãƒ‘ãƒ³ ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ»ã‚»ãƒ³ã‚¿ãƒ¼
ã‚ªãƒ©ã‚¯ãƒ«ã€2023å¹´ã®GartnerÂ® Magic Quadrantâ„¢ã«ãŠã„ã¦Financial Planning Softwareã¨Financial Close and Consolidation Solutionsä¸¡éƒ¨é–€ã§ãƒªãƒ¼ãƒ€ãƒ¼ã®1ç¤¾ã«ä½ç½®ã¥ã‘ãƒ“ã‚¸ãƒ§ãƒ³ã®å®Œå…¨æ€§ã¨å®Ÿè¡Œèƒ½åŠ›ä¸¡è»¸ã«ãŠã„ã¦ã€ã€ŒOracle Cloud EPMã€ãŒãƒªãƒ¼ãƒ€ãƒ¼ãƒ»ã‚¯ã‚¢ãƒ‰ãƒ©ãƒ³ãƒˆã«ä½ç½®ã¥ã‘
koyhoge 2014/05/28
MySQL Fabricã€‚éšœå®³ã«ã‚ˆã£ã¦åˆ‡ã‚Šé›¢ã•ã‚ŒãŸãƒžã‚¹ã‚¿ãƒ¼ã®å¾©æ—§æ‰‹é †ã¯ã©ã†ãªã‚“ã ã‚ã€‚

mysql

cluster
ãƒªãƒ³ã‚¯
Products | Galera Cluster for MySQL
Worldâ€™s most advanced features and Un-seen benefits True Multi-master,Â Active-Active Cluster Read and write to any node at any time. Synchronous Replication No slave lag, no data is lost at node crash. Tightly Coupled All nodes hold the same state. No diverged data between nodes allowed. Multi-threaded Slave For better performance. For any workload. No Master-Slave Failover Operations or Use of V
koyhoge 2013/07/16
MySQLãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€‚

mysql

cluster
ãƒªãƒ³ã‚¯
Clustrix - Scale-out RDBMS
SCALABILITY FOR MISSION-CRITICAL DATA-INTENSIVE APPLICATIONS MariaDB supports all scalability needs â€“ whether there are ten or tens of millions of users. Scale up with more cores, memory and storage with MariaDB Enterprise Server and scale out reads, writes and storage with hundreds of instances.
koyhoge 2013/07/14
MySQLã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ãƒ“ã‚¸ãƒã‚¹ã€‚AWSã§ã‚‚å‹•ãã€‚

mysql

cluster

business

aws
ãƒªãƒ³ã‚¯
MariaDB Galera Cluster ã«ã‚ˆã‚‹ DB ã‚µãƒ¼ãƒã®å†—é•·åŒ– - dogmap.jp
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç ”ç©¶æ‰€ã•ã‚“ã®ã€ŒMariaDB Galera Clusterã‚’è©¦ã™ã€ã¨ã„ã†è¨˜äº‹ã‚’èªã‚“ã§å±…ã¦ã‚‚ç«‹ã£ã¦ã‚‚ã„ã‚‰ã‚Œãªããªã‚Šã€ã•ã£ãã AWS ã§æ§‹ç¯‰ã—ã¦ã¿ã¾ã—ãŸã€‚ ä¸Šè¨˜ã®è¨˜äº‹ã«ã‚ˆã‚Œã° ç°¡å˜ã«ã¾ã¨ã‚ã‚‹ã¨æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ Galera ReplicationãŒè¤‡æ•°ã®RDBMã‚’ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹wsrep APIã‚’æä¾›ã—ã€åŒæœŸã‚’ã¨ã‚Šã¾ã™ å®Œå…¨åŒæœŸåž‹ã§ã‚ã‚‹ãŸã‚ã€ã™ã¹ã¦ã®ãƒŽãƒ¼ãƒ‰ãŒã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‹ã¤ãƒžã‚¹ã‚¿ãƒ¼ã¨ãªã‚Šã¾ã™ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ãƒŽãƒ¼ãƒ‰ã®ã©ã‚Œã«å¯¾ã—ã¦ã‚‚ãƒªãƒ¼ãƒ‰ï¼ãƒ©ã‚¤ãƒˆãŒå¯èƒ½ã§ã™ ãƒŽãƒ¼ãƒ‰ã®è¿½åŠ ï¼å‰Šé™¤ã¯è‡ªå‹•ã§è¡Œãˆã¾ã™ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæŽ¥ç¶šã¯é€šå¸¸ã®MySQLã¨ãªã‚“ã‚‰å¤‰ã‚ã‚Šãªãä½¿ãˆã¾ã™ via. MariaDB Galera Clusterã‚’è©¦ã™ (1) Â« ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç ”ç©¶æ‰€ ãŠãƒ¼ï¼ã‚¹ãƒ¬ãƒ¼ãƒ–/ãƒžã‚¹ã‚¿ãƒ¼å½¢å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ˆã‚Šã‚‚ã€æ–ç„¶ä½¿ã„ã‚„ã™ãã†ã‚„ã‚“ã‹ï¼ ã£ã¦ã‚ã‘ã§ AWS ã® ELB é…ä¸‹ã«è¤‡
koyhoge 2013/02/22
mysql

cluster

aws
ãƒªãƒ³ã‚¯
Free Dynamic DNS(DDNS) by POP3,IMAP4,FTP,HTTP-BASIC for Home Server, VPS | MyDNS.JP
myhome.munetika.mydns.jp is not accessible... Sorry. I do not know why this site is not working. If you know Administrator of this site, please contact directly. You may be able to see it in Google cache. For administrator ... MyDNS.JP did not received IP address from you over One week. Please check your notify system. If you restart notification of IP address, MyDNS.JP will apply your IP address
koyhoge 2011/08/26
mysql

cluster
ãƒªãƒ³ã‚¯
å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãªMySQLã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
koyhoge 2009/11/12
mysql

cluster
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Pacific ã¨ã„ã†åå‰ã®åˆ†æ•£ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ä½œã‚Šå§‹ã‚ãŸä»¶
å¤§è¦æ¨¡ãªã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã¨ã„ã†ç‚¹ã«ã¤ã„ã¦ã¯ã€å¤šãã®åŒæ„ãŒå¾—ã‚‰ã‚Œã‚‹ã¨ã“ã‚ã ã¨æ€ã„ã¾ã™ã€‚è§£æ±ºç–ã¨ã—ã¦ã¯ã€åŒã˜ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡æ•°ã® RDBMS ã«ä¿å˜ã™ã‚‹ã€Œshardingã€ (åˆ¥åï¼šã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¬ãƒ™ãƒ«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼ãƒ¬ãƒ™ãƒ«ï¼’åˆ†æ•£æ³¨1) ãŒä¸€èˆ¬çš„ã§ã™ãŒã€æœ€è¿‘ã§ã¯ã€åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ (åˆ†æ•£ KVS) ã‚’ä½¿ãŠã†ã¨ã™ã‚‹è©¦ã¿ã‚‚ã¿ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚ åˆ†æ•£ KVS ãŒ RDBMS sharding ã«å¯¾ã—ã¦å„ªã‚Œã¦ã„ã‚‹è¦ç´ ã¨ã—ã¦ã¯ã€äº‹å‰ã®åˆ†å‰²è¨è¨ˆãŒä¸è¦ã§ã€å‹•çš„ãªãƒŽãƒ¼ãƒ‰è¿½åŠ ï¼ˆã¨ãã‚Œã«ã¨ã‚‚ãªã†è² è·ã®å†åˆ†æ•£ï¼‰ãŒå®¹æ˜“ã€ã¨ã„ã£ãŸç‚¹ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ä¸€æ–¹ã§ã€Kai ã‚„ Kumofs ã®ã‚ˆã†ãªæœ€è¿‘ã®å®Ÿè£…ã§ã¯ eventually consistent ã§ã“ãç„¡ããªã£ã¦ãã¦ã„ã‚‹ã‚‚ã®ã®ã€ãƒãƒƒã‚·ãƒ¥ãƒ™ãƒ¼ã‚¹ã®åˆ†æ•£ KVS ã¯ã€ãƒ¬ãƒ³ã‚¸ã‚¯ã‚¨ãƒªãŒã§ããªã‹ã£ãŸã‚Š (ä¾‹:
koyhoge 2009/06/12
mysql

cluster
ãƒªãƒ³ã‚¯
Yahoo!ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã®MySQL å†—é•·åŒ–æŠ€è¡“
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ãƒ—ãƒ©ãƒƒãƒˆãƒ›ãƒ¼ãƒ æŠ€è¡“ã®ãƒãƒ£ãƒƒã‚¯ã§ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ä¸€éƒ¨ã‚µãƒ¼ãƒ“ã‚¹ã« RDBMS ã® MySQL ã‚’ä½¿ã£ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æä¾›ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯å¤šãã®ãŠå®¢æ§˜ã‚ˆã‚Šã‚¢ã‚¯ã‚»ã‚¹ã‚’é ‚ã„ã¦ãŠã‚Šã¾ã™ã®ã§ã€å¤§é‡ã®æ›´æ–°ã€å‚ç…§ã®å‡¦ç†é€Ÿåº¦ã«å„ªã‚ŒãŸ MySQL ã‚’é¸æŠžã—ã€ãŠå®¢æ§˜ã«ã‚¹ãƒˆãƒ¬ã‚¹ãªãã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹ã‚ˆã† æ—¥ã€…æ¥å‹™ã«å–ã‚Šçµ„ã¾ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ç²¾å¯†æ©Ÿå™¨ã«ã¯æ•…éšœãŒã¤ãã‚‚ã®ã§ã€ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨ã®è¦³ç‚¹ã‹ã‚‰ã¯ ã€Œæ©Ÿå™¨ãŒæ•…éšœã™ã‚‹ã®ã¯ã—ã‹ãŸãªã„ã€ã—ã‹ã—ãã‚Œã‚’ã„ã‹ã«æ—©ãå¾©æ—§ã•ã›ã‚‹ã‹ã€ ã¨ã„ã£ãŸã“ã¨ã‚’å¿µé ã«å…¥ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã€éšœå®³ãŒèµ·ã“ã£ã¦ã‹ã‚‰å¾©æ—§ã•ã›ã‚‹ã®ã§ã¯ãªãã€éšœå®³ãŒç™ºç”Ÿã—ãŸå ´åˆã«
koyhoge 2009/03/27
mysql

cluster

sysadmin
ãƒªãƒ³ã‚¯
æœ€å¼·ã®MySQL HAåŒ–æ‰‹æ³• - Semi-Synchronous Replication
MySQL 6.0ã§æè¼‰ã•ã‚Œã‚‹äºˆå®šã®æ©Ÿèƒ½ã®ä¸€ã¤ã«ã€Semi-Synchronous Replicationã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ã‚³ã‚¤ãƒ„ã‚’ä½¿ã†ã¨ã¨ã‚“ã§ã‚‚ãªãå‡„ã„HAåŒ–ãŒã§ãã‚‹ã®ã§ã€ä»Šæ—¥ã¯ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ ã¾ãšã¯Semi-Synchronous Replicationã®æ©Ÿèƒ½èª¬æ˜Žã‹ã‚‰ã€‚ãã‚‚ãã‚‚Semi-Synchrounousã£ã¦ãƒŠãƒ‹ï¼Ÿã©ã†ã—ã¦å®Œå…¨ãªåŒæœŸã§ã‚‚ãªãéžåŒæœŸã§ã‚‚ãªãSemi-Synchronousãªã®ï¼Ÿã¨ã„ã†ç–‘å•ã‚’ã¾ãšã¯è§£æ¶ˆã—ãŸã„ã¨æ€ã†ã€‚ã•ã£ããæ¬¡ã®å›³ã‚’è¦‹ã¦æ¬²ã—ã„ã€‚ ã“ã‚Œã¯Semi-Synchronous Replicationã®å‹•ä½œã‚’å›³ã§è¡¨ã—ãŸã‚‚ã®ã§ã‚ã‚‹ã€‚å›³ã ã‘ã§ã¯ãªã‚“ã ã‹ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ä»¥ä¸‹ã«å„ã‚¹ãƒ†ãƒƒãƒ—ã®è©³ç´°ã‚’èª¬æ˜Žã™ã‚‹ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼‰ã‹ã‚‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’COMMITè¦æ±‚ã‚’å‡ºã™ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æ›´æ–°ã™ã‚‹ã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ã‚’æ›´æ–°ã™ã‚‹ã€‚
koyhoge 2009/03/02
mysql

cluster
ãƒªãƒ³ã‚¯
MySQL Clusterã¸ã®æŽ¥ç¶šæ–¹æ³•
ã©ã†ã‚„ã£ã¦ãŸãã•ã‚“ã‚ã‚‹SQLãƒŽãƒ¼ãƒ‰ã«æŽ¥ç¶šã™ã‚Œã°ã„ã„ã‚“ã ï¼Ÿ ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ã¯ï¼Ÿ ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¯ï¼Ÿ ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã¨æ€ã†ã€‚ã“ã®ãƒ†ãƒ¼ãƒžã‚’æ‰±ã£ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ã‚ã‚Šãã†ã ã¡ã‚‡ã†ã©è‰¯ã„ã‚‚ã®ãŒè¦‹ã‚ãŸã‚‰ãªã„ã€‚ãŠãã‚‰ãã“ã®ç‚¹ãŒæ˜Žç¢ºã§ãªã„ãŸã‚ã«ã€Œã‚ˆã—ã€æœ€è¿‘ã‚µã‚¤ãƒˆã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚‚å¢—ãˆã¦ããŸã“ã¨ã ã—ã€ã„ã£ã¡ã‚‡MySQL Clusterã‚’è©¦ã—ã¦ã¿ã‚ˆã†ã‹ï¼ã€ã¨ã„ã†æ°—ã«ãªã‚‰ãšã€å¤šãã®äººãŒåˆ©ç”¨ã‚’èºŠèº‡ã£ã¦ã—ã¾ã£ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã ã‚ã†ã‹ï¼Ÿãªã®ã§ä»Šæ—¥ã¯ã“ã®ç‚¹ã«ã¤ã„ã¦5ãƒ‘ã‚¿ãƒ¼ãƒ³ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚ ãã®å‰ã«ã€ã€ŒMySQL Clusterã£ã¦ä½•ã ï¼Ÿã‚·ãƒ©ãƒãƒ¼ãƒ¨ï¼ã€ã£ã¦äººã¯ã€MySQL Clusterã®ç‰¹å¾´ã‚„ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ–¹æ³•ãªã©ã‚’ä»¥å‰ã«ThinkITã¸æŠ•ç¨¿ã—ãŸã®ã§ãã¡ã‚‰ã‚’å‚ç…§ã—ã¦è²°ã„ãŸã„ã€‚ http://www.thinkit.co.jp/article/95/ ã§ã¯æœ¬é¡Œã€‚ 1. mysqldã‚’ã‚¢ãƒ—ãƒªã¨å…±å˜æã‚‰ã
koyhoge 2009/02/20
mysql

cluster
ãƒªãƒ³ã‚¯
MySQL Clusterè¿‘æ³
å…ˆæ—¥ã®DevMeetingã§è¦‹ã¦ããŸã‚‚ã®ã®ä¸ã§ã€æœ€ã‚‚èˆˆå‘³æ·±ã„ã®ã¯MySQL Clusterã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒŽãƒ¼ãƒ‰è¿½åŠ ã§ã‚ã‚ã†ã€‚DevMeetingã§ã¯JonasãŒã§ãã‚ãŒã£ã¦ã„ã‚‹ã¨ã“ã‚ã¾ã§ãƒ‡ãƒ¢ã‚’ã—ã¦ãã‚ŒãŸã®ã ãŒã€ã¾ã£ãŸãã‚‚ã£ã¦ç´ æ™´ã‚‰ã—ã„ã€‚å½¼ã®ãƒ–ãƒã‚°ï¼ˆä¸‹è¨˜ï¼‰ã«è©³ç´°ãŒè¼‰ã£ã¦ã„ã‚‹ãŒã€ã‚ãˆã¦ã“ã“ã§ã‚‚ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚ http://jonasoreland.blogspot.com/2008/08/status-of-createdrop-nodegroup.html ã“ã‚Œã¾ã§MySQL Clusterã‚’ä½¿ã‚ãªã„ã€ã‚‚ã—ãã¯é¿ã‘ã¦ããŸãƒ¦ãƒ¼ã‚¶ãŒå£ã‚’æƒãˆã¦è¨€ã†ã‚»ãƒªãƒ•ã¯ã€Œã ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒŽãƒ¼ãƒ‰ã‚’å‹•çš„ã«å¢—ã‚„ã›ãªã„ã§ã—ã‚‡ï¼Ÿï¼ã€ã§ã‚ã£ãŸã€‚ã—ã‹ã—ã€è¿‘ã„å°†æ¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒŽãƒ¼ãƒ‰è¿½åŠ ã¨ã„ã†æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹äºˆå®šã§ã‚ã‚‹ã€‚ã“ã‚Œã¯å¹³ãŸãè¨€ã†ã¨ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§ãƒ‡ãƒ¼ã‚¿ãƒŽãƒ¼ãƒ‰ã‚’è¿½åŠ ã™ã‚‹æ©Ÿèƒ½ã§ã‚ã‚‹ã€‚ï¼ˆãã®ã¾ã‚“ã¾ã‚„ã‚“ã‘
koyhoge 2008/10/09
mysql

cluster
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» æœŸé–“é™å®šã®æ–°æ©Ÿèƒ½ã€Œã‚¨ã‚³ãƒ¼ã€ç™»å ´
ã“ã‚“ã«ã¡ã¯ã€‚mixié–‹ç™ºéƒ¨ã®youheiã§ã™ã€‚ ä»Šå›žã¯å…ˆæ—¥8æœˆ4æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€Œã‚¨ã‚³ãƒ¼ã€ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¨ã‚³ãƒ¼ã¨ã¯ ã¾ãšã¯ã‚¨ã‚³ãƒ¼ã¨ã¯ã©ã†ã„ã†æ©Ÿèƒ½ã‹ã®ã”ç´¹ä»‹ã§ã™ãŒã€ãƒ—ãƒãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ãƒšãƒ¼ã‚¸ãŒã”ã–ã„ã¾ã™ã®ã§ãã¡ã‚‰ã‚’ã”è¦§ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã”ã–ã„ã¾ã™ã€‚ http://mixi.jp/guide_echo.pl ã„ãã¤ã‹æŠœç²‹ã—ã¾ã™ã¨ã€ ã‚ãªãŸã®"ä»Š"ã‚’ä¸€è¨€ã«ã—ã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿèª°ã‹ã«ä¼ãˆãŸã„ã“ã¨ã€ã²ã¨ã‚Šã”ã¨ç‰ã€ä½•ã§ã‚‚OKï¼ æ°—è»½ãªæ–°ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã™ã€‚ ãŸã¨ãˆã°ã€ã€Œä»Šæ—¥ã¯ã„ã„å¤©æ°—ã ãªã€œã€ã¨ã„ã†ã€ã²ã¨ã‚Šã”ã¨ã‹ã‚‰ã€ã€ŒãŠè…¹ã™ã„ãŸãƒ¼ï¼èª°ã‹ãƒ©ãƒ³ãƒã«ã„ã“ã†ã‚ˆï¼ã€ã¨ã„ã†ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸çš„ãªä½¿ã„æ–¹ã¾ã§ã€ã€Œã‚¨ã‚³ãƒ¼ã€ã®æ¥½ã—ã¿æ–¹ã¯ã‚ãªãŸæ¬¡ç¬¬ï¼ ãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£åŒå£«ã§ã€Œã‚¨ã‚³ãƒ¼ã€ã‚’ä½¿ã†ã¨ãƒ›ãƒ¼ãƒ ã«ãŠäº’ã„ã®æ›¸ãã“ã¿ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ æ°—ã«ãªã£ãŸæ›¸ãã“ã¿ã«ã¯ã€è¿”ä¿¡ã™ã‚‹ã“ã¨ã‚‚ã§ãã¡ã‚ƒã„ã¾ã™ã€‚ã‚ãªãŸãŒãµã¨æ›¸ãã“ã‚“ã ä¸€è¨€ã«ã€æ€ã‚ã¬è¿”
koyhoge 2008/08/06
mixi

mysql

cluster

q4m
ãƒªãƒ³ã‚¯
CodeZineï¼šDeNAã®äººæ°—ã‚µã‚¤ãƒˆã«å¦ã¶ LAMPã«ã‚ˆã‚‹Web-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨ã®æ¥µæ„ï¼ˆå‰ç·¨ï¼‰ï¼ˆãƒ¢ãƒã‚ªã‚¯, ãƒ¢ãƒã‚²ãƒ¼ï¼‰
ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ã®éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã¯ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ãŒ1å°ã«é™å®šã•ã‚Œã€ãƒžã‚¹ã‚¿ã‹ã‚‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã¸ã®è¤‡è£½ã¯éžåŒæœŸã§è¡Œãªã‚ã‚Œã‚‹ãŸã‚é…å»¶ãŒç”Ÿã˜ã€çŸæ™‚é–“ã®ã‚¹ã‚±ãƒ¼ãƒ«ã§è¦‹ã‚‹ã¨å…¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã¨ã®åŒæœŸãŒä¿è¨¼ã•ã‚Œãªã„ã€‚ã—ã‹ã—ã€ãã®åé¢ã‚¹ãƒ¬ãƒ¼ãƒ–ã®å°æ•°ã‚’å¢—åŠ ã•ã›ã¦ã„ã£ã¦ã‚‚ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ã®æ›´æ–°è² è·ã¯å¤§ãããªã‚‰ãšã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ç¶æŒã§ãã‚‹ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚‹ã€‚DeNAã«ã‚ˆã‚‹é‹ç”¨å®Ÿç¸¾ã§ã‚‚ã€ãƒžã‚¹ã‚¿ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–é–“ã®é…å»¶ã¯é€šå¸¸æ•°ç§’ç¨‹åº¦ä»¥å†…ã«åŽã¾ã‚‹ã€‚ã€€ã“ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã¯ãƒ‡ãƒ¼ã‚¿æ›´æ–°æ™‚ã«ã¯ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã—ã€ãƒ‡ãƒ¼ã‚¿å‚ç…§ã®ã¿ã‚’è¡Œãªã†å ´åˆã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã™ã‚‹ã‚ˆã†ã«ä½œæˆã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã€€Webã‚„æºå¸¯é›»è©±å‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã€å°ã•ãªè¦æ¨¡ã§å§‹ã‚ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼è¦æ¨¡ã€ãƒ‡ãƒ¼ã‚¿è¦æ¨¡ã€ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼æ•°ã‚’å¾ã€…ã«å¢—åŠ ã•ã›ã¦ã„ãã“ã¨ãŒå¤šã„ã€‚å°ã•ãªè¦æ¨¡ã®ãŸã‚DBã®è² è·åˆ†æ•£ãŒä¸è¦ãªå ´åˆã§ã‚‚ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼1å°ã€ã‚¹ãƒ¬ãƒ¼
koyhoge 2007/08/01
mysql

perl

cluster
ãƒªãƒ³ã‚¯
MySQL Master-Master Replication Manager 1.0 Released Â« :: Oleksiy Kovyrin
Itâ€™s been a long time since weâ€™ve started this project and it is time to make a checkpoint. So, Iâ€™ve decided to release final 1.0 version and make 1.X branch stable while all serious development with deep architectural changes will be done 2.X branch (trunk at this moment). Changes from previous release: Perl semaphores implementation caused huge memory leaks (mmmd_mod). Now we do not send any com
koyhoge 2007/04/20
mysql

cluster
ãƒªãƒ³ã‚¯
è£½å“æ¦‚è¦ uni/cluster for MySQL
è£½å“æ¦‚è¦ ã€€-ã€€uni/cluster for MySQLã€€-ã€€ ã€Œuni/cluster for MySQLã€ã¯ã€MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¦æ¨¡æ‹¡å¤§ã«æœ€é©ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ GUIãƒ„ãƒ¼ãƒ«ï¼ˆç®¡ç†ç”»é¢ï¼‰ã¨ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒæ—¥æœ¬èªžåŒ–ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€å¾“æ¥ã®è£½å“ã‚ˆã‚Šã‚‚åˆ†ã‹ã‚Šã‚„ã™ããªã£ã¦ã„ã¾ã™ã€‚ ã€Œuni/cluster for MySQLã€ã®ç‰¹å¾´ ãƒ»é€éŽæ€§ã®é«˜ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚° ã«ã‚ˆã‚Šã€MySQL4.0.xã€œ5.0.x ã‚’ã‚µãƒãƒ¼ãƒˆ ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®äºŒé‡åŒ–ã«ã‚ˆã‚‹é«˜å¯ç”¨æ€§ ãƒ»Javaã€Perlã€PHPã€C/C++ã®å°‚ç”¨ãƒ‰ãƒ©ã‚¤ãƒã¨ã‚¯ãƒ©ã‚¹ã‚¿ã®ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ã«ã‚ˆã‚‹è² è·åˆ†æ•£ ãƒ»16å°ã¾ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¿½åŠ ã§ãã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ ãƒ»éšœå®³ç™ºç”Ÿæ™‚ã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’å®Ÿç¾ ãƒ»2ãƒŽãƒ¼ãƒ‰ã‹ã‚‰ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã‚’å®Ÿç¾ ãƒ»ä»®æƒ³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ©Ÿèƒ½ã«ã‚ˆã‚Šã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«å˜ä¸€ã®ãƒ“ãƒ¥ãƒ¼ã‚’æä¾› ãƒ»ã‚¯ãƒ©ã‚¹ã‚¿ã®ã‚³ãƒ³ãƒˆãƒãƒ¼
koyhoge 2007/02/17
mysql

cluster
ãƒªãƒ³ã‚¯
1