This shows you the differences between two versions of the page.
— | citus [2021/05/25 12:35] (current) – created - external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | Coordinator node may be replicated using STREAMING REPLICATION | ||
+ | ====== Start replication ====== | ||
+ | Set replication factor before start | ||
+ | < | ||
+ | SET citus.shard_count = 2;</ | ||
+ | Set shard distributed table | ||
+ | < | ||
+ | SELECT truncate_local_data_after_distributing_table($$public.tablename$$);</ | ||
+ | or Copy table to all nodes | ||
+ | < | ||
+ | ---\\ | ||
+ | Show connected workers | ||
+ | < | ||
+ | ====== Rebalance table ====== | ||
+ | < | ||
+ | |||
+ | ====== Drain node ====== | ||
+ | < | ||
+ | |||
+ | ====== Basic status ====== | ||
+ | < | ||
+ | SELECT * FROM citus_tables;</ |