> next Ruby on Rails & VitessʹΑΔ
 DBεέʔϧΞ΢τ Jun Sumida / mixi,inc. XFLAG™ ελδΦ Meetup

> < next previous Jun Sumida ΤοΫεϑϥοάελδΦ ւ֎൛Ϟϯετ & ৽نλΠτϧ 2013೥৽ଔೖࣾ

> < next previous RailsΛ࢖ͬͨ͜ͱͷ͋Δํ?

> < next previous RailsͰԿ͔͠ΒͷDBͷਫฏ/ਨ௚ ෼ׂΛߦͬͨ͜ͱͷ͋Δํʁ

> < next previous Railsʹ͓͚ΔDB෼ׂ ‣ Octopus ‣ ਫฏਨ௚෼ׂʹରԠ ‣ SwitchPoint ‣ Cookpad͞Μ ‣ ਨ௚෼ׂʹରԠ ‣ ActiveRecord::Turntable ‣ Drecom͞Μ ‣ ਫฏਨ௚෼ׂʹରԠ ‣ ฐࣾͰ΋࢖͍ͬͯ·͢ * https://github.com/thiagopradi/octopus * http://techlife.cookpad.com/entry/2014/08/28/194147 * https://github.com/drecom/activerecord-turntable

> < next previous DB෼ׂ / shardingपΓͰۤ ࿑ͨ͜͠ͱ͋Γ·ͤΜ͔?

> < next previous MySQLͷindex΍σʔλू໿΋ࣺͯ೉͍
 NoSQLͷεέʔϧੑ΋ࣺͯ೉͍

> < next previous ͦ͜Ͱग़ձͬͨͷ͕

> < next previous Vitess by youtube * http://vitess.io

> < next previous Vitessʹ͍ͭͯ؆୯ʹ ‣ ݩʑ͸Youtube༻ͷconnection-pooling proxy ‣ ঃʑʹ͍Ζ͍Ζͳػೳ͕௥Ճ͞Ε͍ͯͬͨ ‣ Go੡ ‣ gRPC, BSON RPC ͰΫϥΠΞϯτͱ௨৴ ‣ PHP, Go, Python, JavaͷެࣜΫϥΠΞϯτ ‣ 2011೥͔Βyoutubeͷຊ൪؀ڥͰ࢖༻ * Youtube Vitess (Cloud Native Platform) * https://github.com/youtube/vitess

> < next previous Կ͕Ͱ͖Δͷʁ

> < next previous ৭ʑͰ͖·͢

> < next previous Vitess͕Ͱ͖Δ͜ͱ ‣ Connection pooling ‣ QueryͷΩϟογϡ ‣ Queryղੳ, ةݥͳΫΤϦͷॻ͖׵͑ ‣ ߏ੒֬ೝ / εΩʔϚมߋ༻ͷ web console ‣ DBΠϯελϯεͷϞχλϦϯά ‣ Live Resharding, master failover, etc… * Youtube Vitess (Scaling MySQL with Vitess Kubernetes)

> < next previous Live Resharding * http://vitess.io/resources/openworld-2015-vitess.pdf

> < next previous Vitess vs MySQL ‣ ܰྔͳconnection (BSON vs MySQL) ‣ SQL Parser͕ةݥͳΫΤϦΛ๷ࢭ ‣ ਫฏɺਨ௚෼ׂΛαϙʔτ ‣ Rangeϕʔεͷsharding ‣ master failover΍data backupʹ΋ରԠ * http://vitess.io/overview/

> < next previous Vitess vs NoSQL ‣ ୯७ͳKVSͱ͸ҟͳΓɺwhere, join, count, group byͳ Ͳ͕Ͱ͖Δ ‣ VTGate V3Ͱ͸·ͩcount, group byͳͲͷू໿ܥ͕ಈ͔ͳ͍ ‣ Transaction͕࢖͑Δ ‣ cross shardͳTransaction͸·ͩͰ͖ͳ͍ ‣ MySQLΛ࢖͑ΔϢʔβʔͰ͋Ε͹ֶशίετ͕௿͍ ‣ MySQLͰ࢖͑Δindexػೳ͕͢΂ͯ࢖͑Δ * http://vitess.io/overview/

> < next previous Vitessͷߏ੒

> < next previous app mysql vttablet mysql vttablet mysql vttablet * Youtube Vitess (Anatomy of a Distributed Database on Kubernetes) app app vtctl schema؅ཧ / ߏ੒֬ೝ gRPC / BSON RPC gRPC / BSON RPC vtgate ܰྔproxy / routing

> < next previous ߏ੒ʹ͍ͭͯ΋͏ͪΐͬͱ͚ͩ ‣ MySQL 5.6 / MariaDB 10.0 or higher ʹରԠ ‣ ੲ͸ΦϦδφϧͷMySQLͩͬͨ ‣ etcd or Zookeeper Λ࢖ͬͯɺSchema΍DBߏ੒ͳͲΛ ෼ࢄͯ͠ه࿥͍ͯ͠Δ ‣ Google಺෦Ͱ͸Goolgle ChubbyΛ࢖͍ͬͯΔΒ͍͠ ‣ vttablet, vtctldʹ͸web console͕෇͍͍ͯͯschemaΛ ૢ࡞ͨ͠ΓɺmysqldͷϞχλϦϯά͕Ͱ͖Δ * http://vitess.io/overview/ * https://www.youtube.com/watch?v=midJ6b1LkA0

> < next previous Ͳ͏Railsͱܨ͛Δͷ͔

> < next previous app mysql vttablet mysql vttablet mysql vttablet * Youtube Vitess (Anatomy of a Distributed Database on Kubernetes) app app gRPC / BSON RPC vtgate ܰྔproxy / routing

> < next previous A high performance, open source, general RPC framework that puts mobile and HTTP/2 first. * http://www.grpc.io

> < next previous gRPCͱ͸ ‣ ͍ΘΏΔRPCϑϨʔϜϫʔΫ ‣ HTTP/2 ඪ४ʹଇ͍ͬͯΔ ‣ ίΞ෦෼͸ڞ௨ɺCͰ࣮૷ ‣ 10ݴޠʹରԠ ‣ C, C++, Ruby, NodeJS, Python, PHP, Objective-C, C#, Go, Java ‣ σϑΥϧτͷσʔλߏ଄ͱͯ͠Protocol Buffers * http://www.grpc.io * https://github.com/grpc/grpc

> < next previous * What is gRPC? (www.grpc.io/docs/#what-is-grpc) gRPCͷྫ

> < next previous Protocol Buffers?

> < next previous Protocol Buffersͱ͸ ‣ ݴޠʹ΋ɺϓϥοτϑΥʔϜʹ΋தཱͳɺߏ଄Խ͞ ΕͨσʔλΛγϦΞϥΠζ͢ΔͨΊͷ֦ுՄೳͳػ ߏ (௚༁) ‣ ΑΓγϯϓϧͰߴ଎Ͱখ͍͞XML (௚༁) ‣ ΋ͷ͘͢͝ࡶʹݴ͏ͱɺ࠷ۙ͸΍ΓͷJSON Schema Έ͍ͨͳ΍ͭɺͨͩ͠όΠφϦ ‣ MessagePackͱൺֱ͞ΕΔ͜ͱ͕ଟ͍Ͱ͢ * https://developers.google.com/protocol-buffers/

> < next previous * Service Definition (www.grpc.io/docs/guides/concepts.html#service-definition) Protocol Buffersͷྫ

> < next previous * What is gRPC? (www.grpc.io/docs/#what-is-grpc) Protocol Buffersͷྫ (࣮ࡍͷVitessͷ.proto file) Rubyͩͱ͜Μͳײ͡ʹͳΓ·͢

> < next previous gRPC w/ Protocol Buffers ‣ ଞݴޠରԠͯ͠ΔͨΊɺClient΍Mock Server·ͰΛ ࣗಈੜ੒͢Δ͜ͱ͕Մೳ ‣ ௨৴ର৅ͷΞϓϦέʔγϣϯͷ۱ʑ·ͰίʔυΛಡ ·ͳͯ͘΋ClientΛ࡞Δ/͔ͭ͏͜ͱ͕Ͱ͖Δ * https://developers.google.com/protocol-buffers/

> < next previous gRPCͰΫϥΠΞϯτ͕ॻ͚Δ protocol bufferͰΫϥΠΞϯτ͸ࣗಈੜ੒Ͱ͖Δ ΫϥΠΞϯτͷwrapper͚ͩRubyͰॻ͚͹͍͍ͷͰ͸? ͋ͱ͸ActiveRecordͷAdapterͱͭͳ͛Δ͚ͩͰOKͩͶ! ͜͜Ͱࢥ͍͍ͭͯ͠·ͬͨ…

> < next previous ͦ͏ࢥ͍ͬͯͨ࣌ظ͕ ࢲʹ΋͋Γ·ͨ͠

> < next previous VitessͷRuby ClientΛ࡞Δ্ͰͰਏ͔ͬͨ͜ͱ ‣ ҰԠ·ͩgRPC͕beta൛ɺVitess Client΋৭ʑ଍Γͳ͍ ‣ Protocol Buffer͔ΒRubyͷίʔυ͕ࣗಈੜ੒Ͱ͖Δ͕ɺੜ੒͞ ΕΔίʔυͷ໊લۭ͕ؒRubyͱ૬ੑ͕ѱ͘ɺࣗಈੜ੒͞Εͨ ίʔυΛ͍͡Γճ͢Ӌ໨ʹ ‣ Mock serverͷΑ͏ͳ΋ͷ΋࡞ΕΔ͕ɺbinaryͷarrayΛ͏·͘ σ/γϦΞϥΠζͰ͖ͳ͍ͷ͔ΤϥʔΛى͜͢ ‣ ͨ·ʹMock server͕segvͰࢮ͵ ‣ ͜ͷลͷ໰୊ͷ੾Γ෼͚͕Ұ൪ਏ͔ͬͨ ‣ ͦ΋ͦ΋RubyͷgRPC gem͕versionʹΑͬͯίϯύΠϧͰ͖ͳ͔ͬͨΓ͢Δ ‣ Railsͷίʔυ(ಛʹActiveRecord)ΛԆʑͱ௥͏Ӌ໨ʹ ‣ ͓͔͛ͰActiveRecordपΓͷίʔυʹ͸ৄ͘͠ͳΕ·ͨ͠^^

> < next previous Rails mysql vttablet mysql vttablet mysql vttablet vtctl gRPC / BSON RPC gRPC / BSON RPC vtgate ruby
 client schema༻ mysql Rails w/ Vitess

> < next previous ͜Ε͔Βͷ՝୊ ‣ ·ͩ৭ʑͱݕূத (2016 2݄ݱࡏ) ‣ ήʔϜͰ࢖ͬͨ৔߹ͷύϑΥʔϚϯεͳͲ ‣ εΩʔϚ؅ཧ͋ͨΓ΋ ‣ ڊେͳΞϓϦέʔγϣϯͳͷͰɺ·ͩ·ͩClientʹ଍Γͳ͍ػ ೳ͕͋Δ ‣ GoogleͷBorgʹ࠷దԽ͞Ε͍ͯΔͷͰɺAWS EC2ɺmonitoring πʔϧ, ߏ੒؅ཧπʔϧͳͲͱͲ͏ંΓ߹͍Λ͚ͭΔ͔ ‣ ӡ༻ϑϩʔ͕ͳΔ΂͘มΘΒͳ͍Α͏ʹ͍ͨ͠

> < next previous ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠

> < next previous ࣭໰͕͋Ε͹͓ؾܰʹͲ͏ͧʂ