Back to Materialize

Right Size The Cluster

doc/user/layouts/shortcodes/sql-server-direct/right-size-the-cluster.html

123850 B
Original Source

After the snapshotting phase, Materialize starts ingesting change events from the SQL Server replication stream. For this work, Materialize generally performs well with a 100cc replica, so you can resize the cluster accordingly. 1. Still in a SQL client connected to Materialize, use the ALTER CLUSTER command to downsize the cluster to 100cc: mzsql ALTER CLUSTER ingest_sqlserver SET (SIZE '100cc'); Behind the scenes, this command adds a new 100cc replica and removes the 200cc replica. 1. Use the SHOW CLUSTER REPLICAS command to check the status of the new replica: mzsql SHOW CLUSTER REPLICAS WHERE cluster = 'ingest_sqlserver';

nofmt cluster | replica | size | ready -------------------+---------+--------+------- ingest_sqlserver | r1 | 100cc | t (1 row)