"Hey everyone, just wanted to share my experience with scaling MySQL for our blockchain DApp that reached 100k users overnight. We went from a simple setup to a multi-node replica setup with Galera cluster and it was a wild ride. Would love to hear about your experiences and any lessons you've learned from scaling your own databases."
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
"Scaling MySQL for the Next-Gen Crypto Trader ( Lessons Learned from a 100,000-User Blockchain DApp )?"
- Thread starter alload
- Start date
"Yo, just wanted to chime in, we scaled our DApp's MySQL instance by adding a load balancer and sharding the db into 4 separate instances, reduced downtime from 2 hours to <10 minutes." "Also, consider using caching layers like Redis, it saved us a ton of resources"
Who Is You
Member
- Joined
- Sep 10, 2017
- Messages
- 6
- Reaction score
- 0
latest news - let's talk
"Ya saw my post on the 'Crypto Trader Bot' thread, same issues with query overload. We ended up using a mix of caching (Redis) and partitioning the db to distribute the load, didn't have to switch to a new db. Still, would love to hear more about your set-up and what worked for you."