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;</ | ||