91812 - Bugzilla not available during the shadow database recreation process.

Status: RESOLVED WONTFIX

(Bugzilla :: Administration, task, P3)

Description

[Matthew Tuck [:CodeMachine]]

<myk> and, if you get a chance, file a bug on bugzilla.mozilla.org not being
available during the shadow database recreation process

Comment 1

[Dave Miller [:justdave]]

I'm not aware of anything that can be done about this.  The entire database has 
to get locked in order to make the backup without getting partial data on 
anything that happens during the backup.  So for the amount of time it takes to 
write the data out to disk for the mysqldump, the database is locked.

Comment 2

[Dave Miller [:justdave]]

Though if the mySQL server were upgraded and we were to use the built-in 
replication, we could probably back up from a replicated database instead of the 
main one.  It requires two servers though, you can't replicate to another 
database on the same server.

Comment 3

[Matthew Tuck [:CodeMachine]]

Is the script mozilla.org uses in contrib?  I don't see it.  This is kind of a
mozilla.org issue unless it is.

But on the other hand, how do other installations back up?  Do they lock the
database down?  Do we need to document how to backup?

If we learn something about replication we should file documentation bugs on it.

I don't know if replication guarantees it will get a consistent picture of the
database at one time.  If it didn't we could replicate (to get most of the
changes), then lock the database and replicate again.  The second replication
should be a lot faster and hence the database is locked for less time.

Comment 4

[Bradley Baetz (:bbaetz)]

bmo hadn't run that for a while, and we no longer manually recreate the db,
oinstead using MySQL replication.

If we do ever need to recreate the shadowdb, then its possible to allow read
only access (see the mysql manual) but since we write stuff at login, I'mnot
sure ifthat will be useful. We should never have to do that any more, except for
stuff like disk failure.

WONTFIX

Comment 5

[Dave Miller [:justdave]]

clearing target on INVALID/WORKSFORME/WONTFIX/DUPLICATE so they'll show up as
untriaged if they get reopened.