MySQL Fabricつらい Advent Calendar 2014

Participant1People

Subscriber0People

Category：Not set

Creator：

yoku0825が25日間「MySQL Fabricつらい」と言い続けるだけのAdvent Calendarです。
1日1つずつ、Advent Calendarのコメント欄(最大127文字らしい)につらさをつづっていきます。
- Secret Gistなら検索ノイズにならずに残せるのでそっちも併用していきます。
MySQL Fabricについて少しでも真面目な情報が欲しい場合は、ブログに多少調べたことを綴っているのでそちらを是非。
- 日々の覚書

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	@yoku0825 MySQL Fabric 1.5で増えたサブコマンドがマニュアルに全く書いてない。つらい。 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 簡単にHAしたいから入れたいのに、バッキングストア(Fabricの情報を保存するためのMySQL)は自分で冗長化しないといけない。つらい。 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対応コネクターを探さないといけない。今のところOracleが実装してるのはJavaと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 出力のタイムスタンプが全部UNIXTIME。挙句の果てにたまに指数表記になる。つらい。 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 HAを謳っているのに、mysqlfabric group add(登録)しただけでは切り替わりの監視してくれない。つらい。 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 WorkbenchからFabricノードに接続できる機能が追加された数ヵ月後に、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 FabricデーモンとFabricクライアントがどっちも同じ/usr/bin/mysqlfabricだからデバッガ仕掛ける方を間違えた。つらい。 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管理下のノードはGTIDが有効じゃないと登録すらさせてくれない。つらい。 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サーバーの応答が転けるのはいいとして、転けるまでにかなり時間がかかる。つらい。 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用ユーザーに許可しないといけないけど、Fabric用ユーザーのパスワードはfabric.cfgに平文で書かないといけない。つらい。 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 XML-RPCでしゃべるって話だったのに、あっという間にMySQLプロトコルが標準になるとかならないとか。PHPのFabric-awareコネクターはコミュニティ製なので、PHPコミュニティに見捨てられないか心配。つらい。 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対応mysqlコマンドラインクライアントを作った時に、"MySQL Fabric mysqlコマンド"でぐぐったらPython Fabricからmysqlコマンドを叩くやつが出てきた。つらい。 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プロトコルをしゃべる口にmysqlコマンドラインクライアントをつないでstatusを叩くとクライアントがSEGVで落ちる。つらい。 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_OPT_MODE= roにしてもマスターにもラウンドロビンされる仕様。つらい。 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 server_mode= WRITE_ONLY、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 気が付いたらConnector/C-6.2.0-labsを使って自分で対応コネクター書いてた。つらい。 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 Connector/C-6.2.0-labsに関する情報が開発者のブログにしかない上、typoがあって写経じゃ動かない。つらい。 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 Connector/C-6.2.0-labsでFabric経由のアクセスをしても、mysql構造体からFabric_contextが隠蔽されてる。つらい。 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 Connector/C-6.2.0-labs、情報もないうえにちょっと間違ったことすると容赦なくSEGVする。つらい。 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 プロバイダーの登録、暗黙のデフォルトのOPENSTACKでさえ蹴られる。開発者に聞いてもらったら、別のライブラリー入れないといけないらしい。どこにも書いてない。つらい。 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 リリースノートに"improved to support AWS and Trove."って書いてあったけどそんなライブラリーはない。開発者に問いただしてもらったら「サポートする準備をしてるよ！」って。つらい。 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 Connector/C-6.2.0-labsはサーバーサイドPREPAREに対応してない。お気に入りのtpcc-mysqlが動かなかった。つらい。 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 少なくともConnector/C-6.2.0-labsはmysql_select_dbに対応してない。レプリケーションフィルターしてると死ねそう。つらい。 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 mysqlfabricコマンドで他のサーバーのFabricデーモンを叩こうとすると、/etc/mysql/fabric.cfgを書き換えないといけない。--paramオプションでどうにかできるはずだけど、シンタックスが一切謎。つらい。 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	26	27

	@yoku0825 MySQL Fabric 1.5で増えたサブコマンドがマニュアルに全く書いてない。つらい。 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 簡単にHAしたいから入れたいのに、バッキングストア(Fabricの情報を保存するためのMySQL)は自分で冗長化しないといけない。つらい。 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対応コネクターを探さないといけない。今のところOracleが実装してるのはJavaと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 出力のタイムスタンプが全部UNIXTIME。挙句の果てにたまに指数表記になる。つらい。 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 HAを謳っているのに、mysqlfabric group add(登録)しただけでは切り替わりの監視してくれない。つらい。 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 WorkbenchからFabricノードに接続できる機能が追加された数ヵ月後に、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 FabricデーモンとFabricクライアントがどっちも同じ/usr/bin/mysqlfabricだからデバッガ仕掛ける方を間違えた。つらい。 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管理下のノードはGTIDが有効じゃないと登録すらさせてくれない。つらい。 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サーバーの応答が転けるのはいいとして、転けるまでにかなり時間がかかる。つらい。 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用ユーザーに許可しないといけないけど、Fabric用ユーザーのパスワードはfabric.cfgに平文で書かないといけない。つらい。 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 XML-RPCでしゃべるって話だったのに、あっという間にMySQLプロトコルが標準になるとかならないとか。PHPのFabric-awareコネクターはコミュニティ製なので、PHPコミュニティに見捨てられないか心配。つらい。 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対応mysqlコマンドラインクライアントを作った時に、"MySQL Fabric mysqlコマンド"でぐぐったらPython Fabricからmysqlコマンドを叩くやつが出てきた。つらい。 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プロトコルをしゃべる口にmysqlコマンドラインクライアントをつないでstatusを叩くとクライアントがSEGVで落ちる。つらい。 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_OPT_MODE= roにしてもマスターにもラウンドロビンされる仕様。つらい。 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 server_mode= WRITE_ONLY、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 気が付いたらConnector/C-6.2.0-labsを使って自分で対応コネクター書いてた。つらい。 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 Connector/C-6.2.0-labsに関する情報が開発者のブログにしかない上、typoがあって写経じゃ動かない。つらい。 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 Connector/C-6.2.0-labsでFabric経由のアクセスをしても、mysql構造体からFabric_contextが隠蔽されてる。つらい。 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 Connector/C-6.2.0-labs、情報もないうえにちょっと間違ったことすると容赦なくSEGVする。つらい。 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 プロバイダーの登録、暗黙のデフォルトのOPENSTACKでさえ蹴られる。開発者に聞いてもらったら、別のライブラリー入れないといけないらしい。どこにも書いてない。つらい。 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 リリースノートに"improved to support AWS and Trove."って書いてあったけどそんなライブラリーはない。開発者に問いただしてもらったら「サポートする準備をしてるよ！」って。つらい。 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 Connector/C-6.2.0-labsはサーバーサイドPREPAREに対応してない。お気に入りのtpcc-mysqlが動かなかった。つらい。 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 少なくともConnector/C-6.2.0-labsはmysql_select_dbに対応してない。レプリケーションフィルターしてると死ねそう。つらい。 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 mysqlfabricコマンドで他のサーバーのFabricデーモンを叩こうとすると、/etc/mysql/fabric.cfgを書き換えないといけない。--paramオプションでどうにかできるはずだけど、シンタックスが一切謎。つらい。 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

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	@yoku0825 MySQL Fabric 1.5で増えたサブコマンドがマニュアルに全く書いてない。つらい。 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 簡単にHAしたいから入れたいのに、バッキングストア(Fabricの情報を保存するためのMySQL)は自分で冗長化しないといけない。つらい。 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対応コネクターを探さないといけない。今のところOracleが実装してるのはJavaと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 出力のタイムスタンプが全部UNIXTIME。挙句の果てにたまに指数表記になる。つらい。 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 HAを謳っているのに、mysqlfabric group add(登録)しただけでは切り替わりの監視してくれない。つらい。 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 WorkbenchからFabricノードに接続できる機能が追加された数ヵ月後に、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 FabricデーモンとFabricクライアントがどっちも同じ/usr/bin/mysqlfabricだからデバッガ仕掛ける方を間違えた。つらい。 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管理下のノードはGTIDが有効じゃないと登録すらさせてくれない。つらい。 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サーバーの応答が転けるのはいいとして、転けるまでにかなり時間がかかる。つらい。 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用ユーザーに許可しないといけないけど、Fabric用ユーザーのパスワードはfabric.cfgに平文で書かないといけない。つらい。 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 XML-RPCでしゃべるって話だったのに、あっという間にMySQLプロトコルが標準になるとかならないとか。PHPのFabric-awareコネクターはコミュニティ製なので、PHPコミュニティに見捨てられないか心配。つらい。 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対応mysqlコマンドラインクライアントを作った時に、"MySQL Fabric mysqlコマンド"でぐぐったらPython Fabricからmysqlコマンドを叩くやつが出てきた。つらい。 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プロトコルをしゃべる口にmysqlコマンドラインクライアントをつないでstatusを叩くとクライアントがSEGVで落ちる。つらい。 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_OPT_MODE= roにしてもマスターにもラウンドロビンされる仕様。つらい。 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 server_mode= WRITE_ONLY、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 気が付いたらConnector/C-6.2.0-labsを使って自分で対応コネクター書いてた。つらい。 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 Connector/C-6.2.0-labsに関する情報が開発者のブログにしかない上、typoがあって写経じゃ動かない。つらい。 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 Connector/C-6.2.0-labsでFabric経由のアクセスをしても、mysql構造体からFabric_contextが隠蔽されてる。つらい。 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 Connector/C-6.2.0-labs、情報もないうえにちょっと間違ったことすると容赦なくSEGVする。つらい。 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 プロバイダーの登録、暗黙のデフォルトのOPENSTACKでさえ蹴られる。開発者に聞いてもらったら、別のライブラリー入れないといけないらしい。どこにも書いてない。つらい。 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 リリースノートに"improved to support AWS and Trove."って書いてあったけどそんなライブラリーはない。開発者に問いただしてもらったら「サポートする準備をしてるよ！」って。つらい。 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 Connector/C-6.2.0-labsはサーバーサイドPREPAREに対応してない。お気に入りのtpcc-mysqlが動かなかった。つらい。 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 少なくともConnector/C-6.2.0-labsはmysql_select_dbに対応してない。レプリケーションフィルターしてると死ねそう。つらい。 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 mysqlfabricコマンドで他のサーバーのFabricデーモンを叩こうとすると、/etc/mysql/fabric.cfgを書き換えないといけない。--paramオプションでどうにかできるはずだけど、シンタックスが一切謎。つらい。 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	26	27

	@yoku0825 MySQL Fabric 1.5で増えたサブコマンドがマニュアルに全く書いてない。つらい。 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 簡単にHAしたいから入れたいのに、バッキングストア(Fabricの情報を保存するためのMySQL)は自分で冗長化しないといけない。つらい。 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対応コネクターを探さないといけない。今のところOracleが実装してるのはJavaと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 出力のタイムスタンプが全部UNIXTIME。挙句の果てにたまに指数表記になる。つらい。 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 HAを謳っているのに、mysqlfabric group add(登録)しただけでは切り替わりの監視してくれない。つらい。 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 WorkbenchからFabricノードに接続できる機能が追加された数ヵ月後に、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 FabricデーモンとFabricクライアントがどっちも同じ/usr/bin/mysqlfabricだからデバッガ仕掛ける方を間違えた。つらい。 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管理下のノードはGTIDが有効じゃないと登録すらさせてくれない。つらい。 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サーバーの応答が転けるのはいいとして、転けるまでにかなり時間がかかる。つらい。 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用ユーザーに許可しないといけないけど、Fabric用ユーザーのパスワードはfabric.cfgに平文で書かないといけない。つらい。 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 XML-RPCでしゃべるって話だったのに、あっという間にMySQLプロトコルが標準になるとかならないとか。PHPのFabric-awareコネクターはコミュニティ製なので、PHPコミュニティに見捨てられないか心配。つらい。 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対応mysqlコマンドラインクライアントを作った時に、"MySQL Fabric mysqlコマンド"でぐぐったらPython Fabricからmysqlコマンドを叩くやつが出てきた。つらい。 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プロトコルをしゃべる口にmysqlコマンドラインクライアントをつないでstatusを叩くとクライアントがSEGVで落ちる。つらい。 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_OPT_MODE= roにしてもマスターにもラウンドロビンされる仕様。つらい。 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 server_mode= WRITE_ONLY、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 気が付いたらConnector/C-6.2.0-labsを使って自分で対応コネクター書いてた。つらい。 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 Connector/C-6.2.0-labsに関する情報が開発者のブログにしかない上、typoがあって写経じゃ動かない。つらい。 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 Connector/C-6.2.0-labsでFabric経由のアクセスをしても、mysql構造体からFabric_contextが隠蔽されてる。つらい。 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 Connector/C-6.2.0-labs、情報もないうえにちょっと間違ったことすると容赦なくSEGVする。つらい。 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 プロバイダーの登録、暗黙のデフォルトのOPENSTACKでさえ蹴られる。開発者に聞いてもらったら、別のライブラリー入れないといけないらしい。どこにも書いてない。つらい。 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 リリースノートに"improved to support AWS and Trove."って書いてあったけどそんなライブラリーはない。開発者に問いただしてもらったら「サポートする準備をしてるよ！」って。つらい。 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 Connector/C-6.2.0-labsはサーバーサイドPREPAREに対応してない。お気に入りのtpcc-mysqlが動かなかった。つらい。 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 少なくともConnector/C-6.2.0-labsはmysql_select_dbに対応してない。レプリケーションフィルターしてると死ねそう。つらい。 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 mysqlfabricコマンドで他のサーバーのFabricデーモンを叩こうとすると、/etc/mysql/fabric.cfgを書き換えないといけない。--paramオプションでどうにかできるはずだけど、シンタックスが一切謎。つらい。 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