Is there any way we can flush all the caches to the db (disk) and lock and unlock the db for a while. My requirement is to automate the snapshot capturing of the disk where db is kept for backup. I want to make sure all the data is written to disk and no data is being written while capturing the snapshot.
Here is a link on FLUSH & LOCK queries of MySQL for the same. I am wondering if Influxdb has similar kind of queries / REST API.
Also please let me know if there is any better idea to take backups other than this method.