3 ms·
Show HN: DBChaos – A Database stress testing tool
- bma13 3y agoIf using Postgres (as shown in the GitHub example), what are the benefits over using something established like pgbench?
- debarshri 3y agoThanks 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.
- stevomacdaddy 3y agoPlans to add support for MongoDB?
- debarshri 3y agoWe will be adding support for MongoDB in couple of weeks.
- 22c 3y agoI 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?
- qainsights 3y agoHow it is different from performing chaos exercises using LitmusChaos or ChaosMesh?
- tills13 3y agoWhen 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.
- debarshri 3y agoAutoscaling, 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.