メタデータの末尾にスキップ
メタデータの先頭に移動

Clustrixはデータがクラスタ内でどう分散されるかを連続的に監視します。非平衡を検知すると、必要に応じてデータを移動、コピーおよび分割してリバランスします。データは、例えばディスクまたはノードが喪失した場合に、保護的な目的でもコピーされます。

 

最近のリバランスの活動を調べる
mysql> select * from rebalancer_activity_log order by 8 desc limit 10;
+---------------------+-------------+-----------------------------+----------+---------------+------------------------------+------------+---------------------+---------------------+-------+
| id                  | op          | reason                      | database | relation      | representation               | bytes      | started             | finished            | error |
+---------------------+-------------+-----------------------------+----------+---------------+------------------------------+------------+---------------------+---------------------+-------+
| 5832803107035702273 | rerank      | distribution read imbalance | statd    | statd_history | __idx_statd_history__PRIMARY |  236879872 | 2013-01-13 05:35:01 | 2013-01-13 05:35:01 | NULL  |
| 5832802677131749377 | rerank      | distribution read imbalance | statd    | statd_history | __idx_statd_history__PRIMARY |  478674944 | 2013-01-13 05:33:21 | 2013-01-13 05:33:21 | NULL  |
| 5832802504311179267 | slice split | slice too big               | statd    | statd_history | __idx_statd_history__PRIMARY |  473628672 | 2013-01-13 05:32:41 | 2013-01-13 05:34:08 | NULL  |
| 5832791312486337538 | rerank      | distribution read imbalance | statd    | statd_history | __idx_statd_history__PRIMARY |  475987968 | 2013-01-13 04:49:15 | 2013-01-13 04:49:15 | NULL  |
| 5832791036763671553 | slice split | slice too big               | statd    | statd_history | __idx_statd_history__PRIMARY | 1195999232 | 2013-01-13 04:48:11 | 2013-01-13 04:49:15 | NULL  |
| 5832788503671368706 | rerank      | distribution read imbalance | statd    | statd_history | __idx_statd_history__PRIMARY |  754778112 | 2013-01-13 04:38:21 | 2013-01-13 04:38:21 | NULL  |
| 5832788202047166465 | slice split | slice too big               | statd    | statd_history | __idx_statd_history__PRIMARY |  471269376 | 2013-01-13 04:37:11 | 2013-01-13 04:38:29 | NULL  |
| 5832674257801927682 | rerank      | distribution read imbalance | statd    | statd_history | __idx_statd_history__PRIMARY |  754778112 | 2013-01-12 21:15:01 | 2013-01-12 21:15:01 | NULL  |
| 5832673827981474818 | rerank      | distribution read imbalance | statd    | statd_history | __idx_statd_history__PRIMARY |  471400448 | 2013-01-12 21:13:21 | 2013-01-12 21:13:21 | NULL  |
| 5832673526398766083 | slice split | slice too big               | statd    | statd_history | __idx_statd_history__PRIMARY |  755400704 | 2013-01-12 21:12:11 | 2013-01-12 21:13:43 | NULL  |
+---------------------+-------------+-----------------------------+----------+---------------+------------------------------+------------+---------------------+---------------------+-------+
10 rows in set (0.32 sec)
  • ラベルなし
TOP
inserted by FC2 system