I am writing a script to snapshot EBS volumes on AWS. One of the volumes contains the data for a mysql database. I am aware that I need to somehow stop data being written to the database while the snapshot is initiated so that the data is consistent but I cannot obtain a lock on all the tables on the database.
Will using xfs_freeze without a lock on the tables suffice for a consistent solution?
Ty