Hey @Kay_Khan ,
EFS is NFS on steroids. If we look into the debate from the angle of block storage vs NFS, then I would not suggest NFS/EFS for production databases:
- performance limitations - NFS performs extremely poor for random I/O operations, which is critical for dbs.
- NFS might have locking limitations due to its networking nature. Again, critical for DBs to maintain concurrent access. To this bucket - there might be some integrity concerns that again will be solved from a performance pocket.
As for multi-AZ. Even EBS is single-AZ, you can still deploy your database across various AZs with proper affinity settings. You will have a dedicated block volume per AZ per your DB Pod. It is how we see other companies doing it and what we usually recommend.
Let me know if you still in doubt