Open ppedziwiatr opened 2 years ago
Some benchmarks:
16.170.224.226
- preprod (exact same config as prod), oldschool psql on AWS RDS, db.m6g.large
13.53.39.138
- aurora Serverless v2 (0.5 - 16 ACUs)
Autocannon config:
connections: 5,
pipelining: 1,
duration: 10,
workers: 2,
/gateway/interactions-contract-groups?group=all_pst&limit=1000
/gateway/v2/interactions-sort-key?contractId=Daj-MNSnH55TDfxqC7v4eq0lKzVIwh98srUaWqyuZtY&fromSDK=true
/gateway/contracts
/gateway/search/warp
turns out I was testing on a wrong Aurora instance 🤡
The proper one is database-1.cluster-cjz2pdvgbj34.eu-north-1.rds.amazonaws.com
/gateway/interactions-contract-groups?group=all_pst&limit=1000
Aurora:
Psql:
/gateway/v2/interactions-sort-key?contractId=Daj-MNSnH55TDfxqC7v4eq0lKzVIwh98srUaWqyuZtY&fromSDK=true
Aurora:
Psql:
/gateway/contracts
Aurora:
Psql:
/gateway/search/warp
Aurora:
psql:
In general - Aurora wins - but behaves kinda "unstable".
e.g. I've run the /gateway/contracts
endpoint test again (the only one that Aurora lost in the first round) - and now the results are much better:
It looks like Aurora needs more time to reach its peak performance (i.e. to "warm up" properly) - and then keeps this peek performance for some period of time.
The "raw" psql instance gives more stable results - let's say it works in a "chu*owo, ale stabilnie" fashion ;-)
In general - we can go on with Aurora (at least from the performance perspective - I still need to make some integration testing). The only question that remains - what will be the cost? ;-)
Made some more tests (contracts deployment, sending interactions, reading state, etc), looking good so far...I believe we can go with the deployment!
more testing done (for all kind of contract deployments - js/wasm, full or from existing source), bundling interactions, reading state, etc - it works.
We need to discuss alternatives (if we plan to move to GCP). Candidates: SQL:
NoSQL:
Requirements:
"infinite scalability" blah blah blah.
Work already in progress.
Test cluster https://eu-north-1.console.aws.amazon.com/rds/home?region=eu-north-1#database:id=tst-aurora-migration-2-cluster;is-cluster=true;tab=connectivity