Database Proxy, Performance Tuning

RDS + ProxySQL Read/Write Sharding

Company: Easystore Commerce Sdn Bhd
Project URL: https://easystore.co

Currently, the Core API which lives in Ruby on Rails Framework uses an active record gem package called Makara. Seems like Makara is quite buggy and the maintainers are on hiatus, the last release was in June 2021. In search of a replacement, we came across with database proxy that is able to handle read/write sharding such as RDSProxy and ProxySQL. I am responsible for managing this project which includes:

  • POC
  • Project planning
  • Testing
  • Implementation