At Cloudinary we use AWS Aurora managed database service that reduces overhead allowing us focus on product development. Aurora comes with a lot of great features out of the box such as: automatic failover in case of master db issue. It also constantly upgrades with new feature, security and performance improvements.
However, upgrade requires up to 1 minute downtime which for heavy load SaaS company is not an option.
In this session, I will present our journey. From the research for proper tools to accomplish zero downtime upgrade with ProxySQL - proven to be a great tool for various scenarios. I will also describe the long POC and issues we faced and will provide code snippets and configuration examples, along with a LIVE demo of Migrating Aurora cluster without any downtime.