Show HN: DBChaos – A Database stress testing tool

github.com

80 points·debarshri··10 comments

If using Postgres (as shown in the GitHub example), what are the benefits over using something established like pgbench?

Thanks for asking. I think goal here is diferent. If your goal is benchmarking a query, i would recommend pgbench. Goal is to keep running the query or bunch of queries concurrently for x amount of time and observe dependent application and database behavior.

One of the features we are adding would allow you specify an audit log and replay all queries on the database. Also something we are planning to add is parameter randomization. This is kind of the goal of this tool.

Another key design goal is to support bunch of database.

I would normally not particularly care enough to mention a lack of license, but permissively licensed open source tools in the DB stress testing space are few and far between.

Are you planning to add a proper license at some point?

Added MIT License.

Appreciated, thank you!

When is this actually preferable over hand-selected queries run occasionally for regression testing (missing / incomplete indexes for example)?

The only thing I can think of is testing auto-scaling.

Autoscaling, replication problems, undesired application behavior due to database slowness, database misconfigurations etc. are some other things were this can be used.

We use it internally to figure misconfiguration, CDC behaviour as well as trigger performance.

Another thing that is in works is, replaying audit logs on the database as is.

Plans to add support for MongoDB?

We will be adding support for MongoDB in couple of weeks.

How it is different from performing chaos exercises using LitmusChaos or ChaosMesh?

Reply on news.ycombinator.com