In this meetup at Innovid Office, we will hear about very interesting Case-Studies of Two companies, using Databases on/with AWS services.
18:00 - 18:30 - Gathering, Food And Drinks.
18:30 - 19:00 - AWS Redshift Concurrency Scaling Explained
Adam Sharvit, Director of Engineering @ Innovid
Innovid processes more than 5 billion events per day. The basic processing is carried out by a Spark EMR cluster followed by the application of a business logic layer, which validates and applies some business logic into this raw data. This mission-critical business logic layer is implemented on Amazon Redshift, which aggregates the raw data and slices it into various forms of information. We still want to onboard more workloads without having to manage a fleet of clusters ourselves, and can't compromise with degraded performance or queries waiting in queue for our mission-critical applications. Speed matters.
In this session, we'll explore Amazon Redshift Concurrency Scaling. What it is, how it works and what use-cases work best. We'll try to understand when Amazon Redshift Concurrency Scaling is the right tool for the job and who could benefit from it the most.
19:00 - 19:30 - Use ProxySQL to upgrade your Aurora Cluster without downtime
Michael Greenshtein - Devops @ Cloudinary
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.
If you'd like to submit a talk please email-
Tal - [masked]