Projects tigase _server server-core Issues #884
question about restoring MySQL DB (#884)
Steven Machrone opened 7 years ago

Hi,

I created a recover process to restore the DB I am running a script that dumps the MySQL DB daily and scp to another server. We use phpadmin restore method. We will drop the DB and reload the latest dump. The question is that should all the nodes be stopped before reloading the dump.

Thanks,

Steve

Artur Hefczyc commented 7 years ago

For performance and efficiency reasons Tigase heavily relies on data stored in memory, it keeps many local caches in components and other parts of the system. This is especially significant in cluster mode. So, the best/safest way to restore DB dump is to stop Tigase, restore DB and then start Tigase again.

I guess, in some very specific circumstances, when there is no significant differences between data being restored and the data already in DB you might do this while Tigase is running without restart. For example, if you restore data for offline users. But this is really case-by-case exception to the general rule above.

Please do not open a new ticket for asking a technical questions. Use our public forms instead.

issue 1 of 1
Type
Task
Priority
Normal
Assignee
RedmineID
6139
Version
tigase-server-8.0.0
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#884
Please wait...
Page is in error, reload to recover