Upgrade to Pro — share decks privately, control downloads, hide ads and more …

FabricとRouterを試してみた

 FabricとRouterを試してみた

2015/11/05 MySQL Casual Talks in Fukuoka vol.5
で発表したスライドです

使ったconfigとソースコードはこちら
https://github.com/matsumana/mysql-fabric-router-sandbox
https://github.com/matsumana/mysql-fabric-connectorj-sandbox

0a98ad166f9cdf8d27d92c37438c6e9d?s=128

Manabu Matsuzaki

November 05, 2015
Tweet

Transcript

  1. FabricͱRouterΛࢼͯ͠Έͨ MySQL Casual Talks in Fukuoka vol.5 2015/11/05

  2. ࣗݾ঺հ ໊લɿ দ࡚ ֶ Twitterɿ matsumana ৬ۀɿιϑτ΢ΣΞΤϯδχΞ

  3. ΧδϡΞϧͳωλ͕ ࢥ͍͔ͭͳ͔ͬͨͷͰ FabricͱRouterΛ ࢼͯ͠Έ·ͨ͠ σϞΛަ͑ͳ͕Β ൃද͠·͢

  4. Fabric 2014/06 GA ߴՄ༻ੑʢHigh Availabilityʣ γϟʔσΟϯά https://www-jp.mysql.com/products/enterprise/fabric.html

  5. Router 2015/10 GA FabricʹΑΔߏ੒΍֤छϨϓϦέʔγϣϯߏ੒΁ͷ ΞΫηεΛγϯϓϧʹ͢Δ http://www-jp.mysql.com/products/enterprise/router.html

  6. Router http://dev.mysql.com/doc/mysql-router/en/mysql-router-faq.html#faq-mysql-router-faq-router-how-ha

  7. Ͳͬͪ΋ Enterprise Edithion Ҏ্͡Όͳ͍ͱμϝ http://www-jp.mysql.com/products/

  8. ࠓճ࢖ͬͨόʔδϣϯ CentOS 7.1 MySQL 5.6.27 MySQL Fabric 1.5.6 MySQL Router

    2.0.2
  9. ࠓճͷߏ੒ʢ̍ʣ Fabricͷϙʔτ: 32274 Fabricͷઃఆ͸໰୊ͳͦ͞͏

  10. σϞ

  11. ࠓճͷߏ੒ʢ̎ʣ Routerͷϙʔτ: 7003 Fabricͷϙʔτ: 32275 RouterͱFabricͷؒ͸ࠓͷͱ͜Ζ
 MySQLϓϩτίϧ௨৴ͷΈ
 αϙʔτ͞Ε͍ͯΔ MySQLϓϩτίϧͩͱFabricରԠίωΫλͰ
 ઀ଓ͕ग़དྷͳ͍ͬΆ͍


    ͳͷͰγϟʔυΩʔͷઃఆ͕Ͱ͖ͣɺ
 γϟʔσΟϯά͕ػೳ͠ͳ͍
  12. https://github.com/mysql/mysql-router/blob/release-2.0.2/

  13. σϞ

  14. ࠓճͷߏ੒ʢ̏ʣ Routerͷϙʔτ: 7001 Routerͷmode: read-write
 (઀ଓઌMySQL failover)

  15. ࠓճͷߏ੒ʢ̐ʣ Routerͷϙʔτ: 7002 Routerͷmode: read-only
 (઀ଓઌMySQL ϥ΢ϯυϩϏϯ)

  16. σϞ

  17. ࠓճͷઃఆϑΝΠϧͱιʔε ઃఆϑΝΠϧ (Vagrant + Itamae)
 https://github.com/matsumana/mysql-fabric-router-sandbox FabricରԠυϥΠό(Java)ͰσʔλΛ
 ૢ࡞͢Διʔε
 https://github.com/matsumana/mysql-fabric-connectorj-sandbox

  18. ࢀߟʹͨ͠ϖʔδ MySQL Utilities 1.5 Manual MySQL Fabric
 http://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric.html MySQL Router


    http://dev.mysql.com/doc/mysql-router/en/ The Newest Member of the MySQL family
 http://mysqlhighavailability.com/mysql-router-on-labs-the-newest-member-of-the-mysql-family/ MySQL FabricͭΒ͍ Advent Calendar 2014
 http://qiita.com/advent-calendar/2014/mysql_fabric MySQL Fabric࢖͍͍ͨΜ͚ͩͲ Ͳ͏ͳΜ͔͢
 http://www.slideshare.net/doublemarket/mysqlcasual6fabric UCOϒϩά
 http://masato.ushio.org/blog/index.php/tag/fabric/
  19. ͓͠·͍