cockroachdb / cockroachdb/cockroach

cdc: allow database as changefeed target

Offen
#93,793 1 Kommentar 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
A-cdc C-enhancement T-cdc
Vorherrschende Sprache
Go
Sterne
32.5k
Forks
4.1k
PR-Merge-Kennzahlen
PR-Kennzahlen ausstehend

Beschreibung

**Is your feature request related to a problem? Please describe.**

Users have expressed interest in create a changefeed for an entire database, instead of specific tables. In addition to being a convenience, I believe the intention is that new tables in said database will always be included in (added to) the changefeed.

**Describe the solution you'd like**

New syntax to have a changefeed for a database.

Question: is there a semantic distinction between a changefeed on a “database” vs “all tables in a database”? Depending on this answer, our syntax could be:

- `CREATE CHANGEFEED FOR DATABASE mydb`
- `CREATE CHANGEFEED FOR TABLE *` or `CREATE CHANGEFEED FOR TABLE mydb.*`

Or the `ALL` keyword in there somewhere.

We might also consider same for `SCHEMA`.

Edit, see also previous issue: https://github.com/cockroachdb/cockroach/issues/73435. I’ll still keep this issue open since it’s narrower.

Jira issue: CRDB-22530

Epic CRDB-1421

Beitragsleitfaden

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.