How is it possible to lock all access to the db while resetting the db in production ?

Hello,

For some reasons, I need to add a button to let the user reset the entire database.

But it's a real time application and messages come from RabbitMQ and are handled by the application and needs to access to the DB.

RabbitMQ and the other services have to continue running while resetting the database.

How can I do to avoid the application to throw errors during resetting the DB ?

I have these ideas :

• set a RESETTING_DATABASE flag in the session

• handle the messages from RabbitMQ only if the flag is true

• set the flag to false, reset the database, set the flag to true

Do you see any other ways to do that ?

Thanks for your help.

V