Zero sync engine

Tip

This page is best viewed through the site search or through the AI.

Deploy the Zero sync engine with a Postgres database configured for logical replication in a VPC cluster.

sst.config.ts

const vpc = new sst.aws.Vpc("Vpc", {
  bastion: true,
});
const db = new sst.aws.Postgres("Database", {
  vpc,
  transform: {
    parameterGroup: {
      parameters: [
        {
          name: "rds.logical_replication",
          value: "1",
          applyMethod: "pending-reboot",
        },
        {
          name: "rds.force_ssl",
          value: "0",
          applyMethod: "pending-reboot",
        },
        {
          name: "max_connections",
          value: "1000",
          applyMethod: "pending-reboot",
        },
      ],
    },
  },
});
const cluster = new sst.aws.Cluster("Cluster", { vpc });
const connection = $interpolate`postgres://${db.username}:${db.password}@${db.host}:${db.port}`;
new sst.aws.Service("Zero", {
  cluster,
  image: "rocicorp/zero",
  dev: {
    command: "npx zero-cache",
  },
  loadBalancer: {
    ports: [{ listen: "80/http", forward: "4848/http" }],
  },
  environment: {
    ZERO_UPSTREAM_DB: $interpolate`${connection}/${db.database}`,
    ZERO_CVR_DB: $interpolate`${connection}/${db.database}_cvr`,
    ZERO_CHANGE_DB: $interpolate`${connection}/${db.database}_change`,
    ZERO_REPLICA_FILE: "zero.db",
    ZERO_NUM_SYNC_WORKERS: "1",
  },
});

View the full example.