dolthub / dolthub/dolt

Multi database replication requires global `replicate_to_remote`

Open
#5,736 0 comments 0 reactions 0 assignees View on GitHub
configuration enhancement replication
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

A single database uses its local dolt config to replicate to a remotes on dolt commit ([relevent docs](https://docs.dolthub.com/sql-reference/server/replication#configuring-a-primary)). A database defines a valid remote with a name `dolt remote add `, and then the named remote is indicated for pushing commits: `dolt sql -q "set @@persist.dolt_replicate_to_remote = ''"`

A multi-database server requires the first step for all individual databases - a valid remote with a common name. But the `dolt_replicate_to_remote` session variable appears to be initialized from the global config. The local values for `replicate_to_remote` are ignored.

The additional step for a multi-database server is `dolt config --global --set sqlserver.global.dolt_replicate_to_remote `.

This is confusing for users. It is probably not ideal to force replication for all of a computer's databases through a global variable. This is related to a broader set of problems regarding how Dolt's CLI-designed configuration has not translated cleanly to a multi-database server UX.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.