Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow workload subcommand to write to real db #926

Open
bobvawter opened this issue Jul 1, 2024 · 2 comments
Open

Allow workload subcommand to write to real db #926

bobvawter opened this issue Jul 1, 2024 · 2 comments
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@bobvawter
Copy link
Member

The workload command only targets the webhook endpoints at the moment. It would be useful if it could also write to a source db and run the checks against a separate target database.

@bobvawter bobvawter added enhancement New feature or request good first issue Good for newcomers labels Jul 1, 2024
@ryanluu12345
Copy link
Contributor

So if I'm understanding this context correctly:

  1. Write data to the source database via INSERTS/UPSERTS
  2. Check the data on the source and target sides?

One thing I can think of here is to support 1 and then use molt verify for part 2 since it's built for comparing source and target data

@bobvawter
Copy link
Member Author

I'm finalizing a PR that uses the workload generator and the apply package running against the source cluster for pglogical. Once that's in, the workload subcommand should be mostly copy-and-paste. The workload.Checker already has post-copy validation which could be leveraged.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

2 participants