[EPIC] Source DB Benchmark Tests

[sherifnada]

Tell us about the problem you're trying to solve

As part of making our databases more reliable, we should start working on a test suite containing benchmarks for validating that our DB connectors are able to serve certain workloads/scales.

The idea is that today, we see a lot of issues around DB replication that we cannot reproduce (doc containing example of problems) so we want to create a test harness specifically for reproducing this style of test. I have not thought about what shape it should take.

Suggested benchmarks are available in the Q4 prios doc:

https://docs.google.com/document/d/17EcJClZBJ-2Sa4HgmeD4rxgZ8aozi7B5squ9TjX_QRQ/edit#heading=h.v66ysrgf09i3

Describe the solution you’d like

• airbytehq/airbyte-internal-issues#339
• Document how to use SQL scripts to create benchmark databases #8712
• Analyze possible bottleneck
• Source MySQL: stress test 1000 tables / columns per sync #7489
• Create an RDS instance
• populate DB instance with dummy data for benchmarks #8048

Describe the alternative you’ve considered or used

A clear and concise description of any alternative solutions or features you've considered or are using today.

Additional context

Add any other context or screenshots about the feature request here.

Are you willing to submit a PR?

Remove this with your answer :-)

[tuliren]

MVP baseline results:

[tuliren]

Closed with #8215