Materialize/misc/cockroach/setup_materialize.sql

-- Copyright Materialize, Inc. and contributors. All rights reserved.
--
-- Use of this software is governed by the Business Source License
-- included in the LICENSE file at the root of this repository.
--
-- As of the Change Date specified in that file, in accordance with
-- the Business Source License, use of this software will be governed
-- by the Apache License, Version 2.0.

-- Sets up a CockroachDB cluster for use by Materialize.

-- See: https://github.com/cockroachdb/cockroach/issues/93892
-- See: https://github.com/MaterializeInc/database-issues/issues/4843
SET CLUSTER SETTING sql.stats.forecasts.enabled = false;

SET CLUSTER SETTING storage.max_sync_duration.fatal.enabled = false;

CREATE SCHEMA IF NOT EXISTS consensus;
CREATE SCHEMA IF NOT EXISTS adapter;
CREATE SCHEMA IF NOT EXISTS storage;
CREATE SCHEMA IF NOT EXISTS tsoracle;