Hello,
We want to take an export of all tables and views from DB. As the export of 180 entities can take time, there should not be any data updated on the DB duing the export period.
To do this, can we lock the MySQL DB for a some period of time. I am afraid a lock can create failures to users if any write fails.
Are there any other options like taking a snapshot of DB from Appian? Let us know.
Thank you,
Harish
Discussion posts and replies are publicly visible
I'm not aware of any functionality that can completely lock down the database.
My recommendation is to create a scheduled job that will run in the middle of the night when few users are working in the system. You can use this shared component and create a process initiated on a timer.