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

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. ͓͠·͍