For majority of hosting in AWS it would be interesting to use AWS-native services, like Aurora and Timestream. It allows outsourcing all DB management tasks to AWS itself and concentrate only on operating Zabbix itself.