What should a solutions architect recommend?
Use Amazon DynamoDB global tables.
Use Amazon Aurora Global Database.
Use Amazon RDS for MySQL with a cross-Region read replica.
Use Amazon RDS for PostgreSQL with a cross-Region read replica.
Explanations:
While Amazon DynamoDB Global Tables provide global replication and low-latency read/write access across Regions, they are best suited for NoSQL databases rather than transactional applications needing strong consistency, making it less ideal for complex supply chain applications.
Amazon Aurora Global Database provides globally distributed and highly available storage, with low-latency replication across Regions, allowing for quick failover and a short RTO, which is ideal for transactional applications requiring near real-time global visibility and high uptime.
Amazon RDS for MySQL with cross-Region read replicas offers global read access but has higher replication latency and lacks the sub-second global data visibility and failover speed of Aurora Global Database, making it less ideal for this use case.
Amazon RDS for PostgreSQL with cross-Region read replicas also provides global read access, but it does not meet the low-latency global visibility requirement and may have slower recovery times than Aurora Global Database, making it less suitable.
Based on what I know, the answer is:
Use Amazon Aurora Global Database.