Background: On Shop LC Website ([login to view URL]), we are currently using Hybris 6.3 as CMS and Oracle as RDS. This Oracle RDS is hosted into AWS, along with all the applications servers (EC2 instances). Shop LC analyzed the benefits of Amazon Aurora with respect to performance & Cost benefits. Shop LC management took decision to migrate Oracle RDS to Amazon Aurora RDS (v 1.19.0 Aurora version).
We tried to migrate Oracle RDS to Amazon Aurora RDS (v 1.19.0 Aurora version). While doing migration, we did a load testing with 600, 750 & 100 users and Load testing results were looking fine.
Problem statement:
Product Sync issue: While doing product sync from stage to Online version, Product sync queries are taking more time, in comparison to Oracle RDS environment.