MySQL Fabric＆Routerつらくない Advent Calendar 2015

Participant1People

Subscriber35People

Category：Database & DWH

Creator：

MySQL Fabricつらい Advent Calendar 2014 - Qiita の2015年版です。
yoku0825が25日間「MySQL Fabricつらくない」または「MySQL Routerつらくない」と言い続けるだけのAdvent Calendarです。
1日1つずつ、Advent Calendarのコメント欄(最大127文字らしい)につらくなさをつづっていきます。
- 127文字を超えたものはブログ書きます。

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
29	30	@yoku0825 MySQL Routerはつらくない。何故ならまだ触っていないからだ。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（自前ビルド時のcmakeエラー編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（yumでインストールして動かしてみた編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（CentOS 6.6でもビルドがしたい編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL RouterはC++なので読めるしgdbで刺し放題。つらくない(単に俺はPythonのデバッガーに慣れていない) Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@yoku0825 MySQL Routerには現在のコンフィグやバックエンドが落ちてるかどうかをどう認識しているかを確認するコマンドがない。迷ったら再起動しろってことだと思う。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL FabricからAWSのAPIを叩いてゴニョゴニョ…なんて話があったけどどこ行ったんだろう。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 1コマンドですぐに試せるように、MySQL Fabric-awareなコンテナを作ってある(server-id自動で振るようにしてある) つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 今年はMySQL FabricのデーモンもDockerイメージにしてある。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（MySQL Fabricと組み合わせて使ってみる編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 targetが今のところgroupしか指定できないってことは、MySQL Fabricのシャード機能(mysqlfabricのサブコマンドと対応してるとしたらsharding)はサポートされてない？でも別につらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Utilitiesをインストールしなくても試せるように、コマンドラインクライアントとしてのmysqlfabricもDockerイメージした。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@yoku0825 もちろんMySQL RouterのDockerイメージも用意した。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（Dockerで誰でも試せるMySQL Fabric Cache Plugin編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 allow_primary_reads(デフォルトOFF)がread-onlyモードの時のマスターからの読み込みを制御できる。けど、これ、URIに書くんだってさ！ ……つらく…ない…。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerは全てのパケットを中継する、文字通りルーターになる。MySQL Fabricは落ちてもTTLの間は大丈夫、ってことになってたけど、MySQL Routerは落ちたらそこでコネクションが切れる。別につらくはない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 Fabric Cache Pluginを使っていなくてread-writeに複数サーバーを指定する場合、フェイルバックに相当する機能が（少なくとも今は）ないので、下手するとRouterごとにマスターが変わってしまう。。一考する必要あり Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerがプロキシーの側面も持つため、各ルーティング(=LISTENするポート)単位でmax_connectionsを設定できる。デフォルトは512 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Proxyの拡張はLuaで、もともとL7(MySQLのクエリー文字列のレベルまで)プラグインの中から覗ける作りだった。MySQL Routerはどうだろう。言語はC++だろうけど。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@yoku0825 今のところ、ユーザーがプラグインを書くのに有効そうな記述はない。つらくない。。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 クライアントから渡すuserとpasswordはFabricに管理されている MySQLのものを指定するが、Fabricの接続にも認証が必要で、でもrouter.iniにFabricのパスワードを書くと怒られる。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerさん、SIGHUPではコンフィグの読み直しはしてくれない模様。完全に停止起動が必要かー。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Fabric Cache Pluginを使っている状態でMySQL Fabricを落とすとなんか30秒くらいハングした。ドキュメントにtimeout変数っぽい記載はない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 しかもMySQL Fabricのfabric.cfgではttl= 1(sec)で設定されてるけどいつまでもMySQL Routerがキャッシュしっぱなしなのはそれでいいのか。。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerをlocalhostに置いたらどれくらいの遅延になるかを考えるメモと、MySQL Routerは本当につらくなかったのかのまとめ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	26

@yoku0825
MySQL Routerはつらくない。何故ならまだ触っていないからだ。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（自前ビルド時のcmakeエラー編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（yumでインストールして動かしてみた編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（CentOS 6.6でもビルドがしたい編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL RouterはC++なので読めるしgdbで刺し放題。つらくない(単に俺はPythonのデバッガーに慣れていない)
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerには現在のコンフィグやバックエンドが落ちてるかどうかをどう認識しているかを確認するコマンドがない。迷ったら再起動しろってことだと思う。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL FabricからAWSのAPIを叩いてゴニョゴニョ…なんて話があったけどどこ行ったんだろう。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
1コマンドですぐに試せるように、MySQL Fabric-awareなコンテナを作ってある(server-id自動で振るようにしてある) つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
今年はMySQL FabricのデーモンもDockerイメージにしてある。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（MySQL Fabricと組み合わせて使ってみる編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
targetが今のところgroupしか指定できないってことは、MySQL Fabricのシャード機能(mysqlfabricのサブコマンドと対応してるとしたらsharding)はサポートされてない？でも別につらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Utilitiesをインストールしなくても試せるように、コマンドラインクライアントとしてのmysqlfabricもDockerイメージした。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
もちろんMySQL RouterのDockerイメージも用意した。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（Dockerで誰でも試せるMySQL Fabric Cache Plugin編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
allow_primary_reads(デフォルトOFF)がread-onlyモードの時のマスターからの読み込みを制御できる。けど、これ、URIに書くんだってさ！ ……つらく…ない…。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerは全てのパケットを中継する、文字通りルーターになる。MySQL Fabricは落ちてもTTLの間は大丈夫、ってことになってたけど、MySQL Routerは落ちたらそこでコネクションが切れる。別につらくはない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
Fabric Cache Pluginを使っていなくてread-writeに複数サーバーを指定する場合、フェイルバックに相当する機能が（少なくとも今は）ないので、下手するとRouterごとにマスターが変わってしまう。。一考する必要あり
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerがプロキシーの側面も持つため、各ルーティング(=LISTENするポート)単位でmax_connectionsを設定できる。デフォルトは512
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Proxyの拡張はLuaで、もともとL7(MySQLのクエリー文字列のレベルまで)プラグインの中から覗ける作りだった。MySQL Routerはどうだろう。言語はC++だろうけど。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
今のところ、ユーザーがプラグインを書くのに有効そうな記述はない。つらくない。。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
クライアントから渡すuserとpasswordはFabricに *管理されている* MySQLのものを指定するが、Fabricの接続にも認証が必要で、でもrouter.iniにFabricのパスワードを書くと怒られる。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerさん、SIGHUPではコンフィグの読み直しはしてくれない模様。完全に停止起動が必要かー。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Fabric Cache Pluginを使っている状態でMySQL Fabricを落とすとなんか30秒くらいハングした。ドキュメントにtimeout変数っぽい記載はない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
しかもMySQL Fabricのfabric.cfgではttl= 1(sec)で設定されてるけどいつまでもMySQL Routerがキャッシュしっぱなしなのはそれでいいのか。。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerをlocalhostに置いたらどれくらいの遅延になるかを考えるメモと、MySQL Routerは本当につらくなかったのかのまとめ
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
29	30	@yoku0825 MySQL Routerはつらくない。何故ならまだ触っていないからだ。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（自前ビルド時のcmakeエラー編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（yumでインストールして動かしてみた編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（CentOS 6.6でもビルドがしたい編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL RouterはC++なので読めるしgdbで刺し放題。つらくない(単に俺はPythonのデバッガーに慣れていない) Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@yoku0825 MySQL Routerには現在のコンフィグやバックエンドが落ちてるかどうかをどう認識しているかを確認するコマンドがない。迷ったら再起動しろってことだと思う。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL FabricからAWSのAPIを叩いてゴニョゴニョ…なんて話があったけどどこ行ったんだろう。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 1コマンドですぐに試せるように、MySQL Fabric-awareなコンテナを作ってある(server-id自動で振るようにしてある) つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 今年はMySQL FabricのデーモンもDockerイメージにしてある。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（MySQL Fabricと組み合わせて使ってみる編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 targetが今のところgroupしか指定できないってことは、MySQL Fabricのシャード機能(mysqlfabricのサブコマンドと対応してるとしたらsharding)はサポートされてない？でも別につらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Utilitiesをインストールしなくても試せるように、コマンドラインクライアントとしてのmysqlfabricもDockerイメージした。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@yoku0825 もちろんMySQL RouterのDockerイメージも用意した。つらくない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerつらくない（Dockerで誰でも試せるMySQL Fabric Cache Plugin編） Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 allow_primary_reads(デフォルトOFF)がread-onlyモードの時のマスターからの読み込みを制御できる。けど、これ、URIに書くんだってさ！ ……つらく…ない…。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerは全てのパケットを中継する、文字通りルーターになる。MySQL Fabricは落ちてもTTLの間は大丈夫、ってことになってたけど、MySQL Routerは落ちたらそこでコネクションが切れる。別につらくはない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 Fabric Cache Pluginを使っていなくてread-writeに複数サーバーを指定する場合、フェイルバックに相当する機能が（少なくとも今は）ないので、下手するとRouterごとにマスターが変わってしまう。。一考する必要あり Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerがプロキシーの側面も持つため、各ルーティング(=LISTENするポート)単位でmax_connectionsを設定できる。デフォルトは512 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Proxyの拡張はLuaで、もともとL7(MySQLのクエリー文字列のレベルまで)プラグインの中から覗ける作りだった。MySQL Routerはどうだろう。言語はC++だろうけど。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@yoku0825 今のところ、ユーザーがプラグインを書くのに有効そうな記述はない。つらくない。。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 クライアントから渡すuserとpasswordはFabricに管理されている MySQLのものを指定するが、Fabricの接続にも認証が必要で、でもrouter.iniにFabricのパスワードを書くと怒られる。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerさん、SIGHUPではコンフィグの読み直しはしてくれない模様。完全に停止起動が必要かー。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Fabric Cache Pluginを使っている状態でMySQL Fabricを落とすとなんか30秒くらいハングした。ドキュメントにtimeout変数っぽい記載はない。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 しかもMySQL Fabricのfabric.cfgではttl= 1(sec)で設定されてるけどいつまでもMySQL Routerがキャッシュしっぱなしなのはそれでいいのか。。 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@yoku0825 MySQL Routerをlocalhostに置いたらどれくらいの遅延になるかを考えるメモと、MySQL Routerは本当につらくなかったのかのまとめ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	26

@yoku0825
MySQL Routerはつらくない。何故ならまだ触っていないからだ。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（自前ビルド時のcmakeエラー編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（yumでインストールして動かしてみた編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（CentOS 6.6でもビルドがしたい編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL RouterはC++なので読めるしgdbで刺し放題。つらくない(単に俺はPythonのデバッガーに慣れていない)
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerには現在のコンフィグやバックエンドが落ちてるかどうかをどう認識しているかを確認するコマンドがない。迷ったら再起動しろってことだと思う。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL FabricからAWSのAPIを叩いてゴニョゴニョ…なんて話があったけどどこ行ったんだろう。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
1コマンドですぐに試せるように、MySQL Fabric-awareなコンテナを作ってある(server-id自動で振るようにしてある) つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
今年はMySQL FabricのデーモンもDockerイメージにしてある。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（MySQL Fabricと組み合わせて使ってみる編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
targetが今のところgroupしか指定できないってことは、MySQL Fabricのシャード機能(mysqlfabricのサブコマンドと対応してるとしたらsharding)はサポートされてない？でも別につらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Utilitiesをインストールしなくても試せるように、コマンドラインクライアントとしてのmysqlfabricもDockerイメージした。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
もちろんMySQL RouterのDockerイメージも用意した。つらくない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerつらくない（Dockerで誰でも試せるMySQL Fabric Cache Plugin編）
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
allow_primary_reads(デフォルトOFF)がread-onlyモードの時のマスターからの読み込みを制御できる。けど、これ、URIに書くんだってさ！ ……つらく…ない…。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerは全てのパケットを中継する、文字通りルーターになる。MySQL Fabricは落ちてもTTLの間は大丈夫、ってことになってたけど、MySQL Routerは落ちたらそこでコネクションが切れる。別につらくはない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
Fabric Cache Pluginを使っていなくてread-writeに複数サーバーを指定する場合、フェイルバックに相当する機能が（少なくとも今は）ないので、下手するとRouterごとにマスターが変わってしまう。。一考する必要あり
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerがプロキシーの側面も持つため、各ルーティング(=LISTENするポート)単位でmax_connectionsを設定できる。デフォルトは512
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Proxyの拡張はLuaで、もともとL7(MySQLのクエリー文字列のレベルまで)プラグインの中から覗ける作りだった。MySQL Routerはどうだろう。言語はC++だろうけど。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
今のところ、ユーザーがプラグインを書くのに有効そうな記述はない。つらくない。。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
クライアントから渡すuserとpasswordはFabricに *管理されている* MySQLのものを指定するが、Fabricの接続にも認証が必要で、でもrouter.iniにFabricのパスワードを書くと怒られる。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerさん、SIGHUPではコンフィグの読み直しはしてくれない模様。完全に停止起動が必要かー。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Fabric Cache Pluginを使っている状態でMySQL Fabricを落とすとなんか30秒くらいハングした。ドキュメントにtimeout変数っぽい記載はない。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
しかもMySQL Fabricのfabric.cfgではttl= 1(sec)で設定されてるけどいつまでもMySQL Routerがキャッシュしっぱなしなのはそれでいいのか。。
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@yoku0825
MySQL Routerをlocalhostに置いたらどれくらいの遅延になるかを考えるメモと、MySQL Routerは本当につらくなかったのかのまとめ
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after November 1 of the year can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use