559717 - SUMO stage and stage-new: sync database with production

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Paul Craciunoiu [:paulc]]

It would be awesome if you could sync the support-stage and support-stage-new databases with production.

We need to test some database changes, and the more up-to-date the data, the better.

Thanks!

Comment 1

[Shyam Mani [:fox2mike]]

Why exactly is this critical?

Comment 2

[James Socol [:jsocol, :james]]

Critical is the 8 hours for stage updates specified in the SLA. And it's blocking QA (by blocking another thing we'll file after it's done and we've double checked some data).

Comment 3

[Shyam Mani [:fox2mike]]

Haha, I could have sworn I've read the SLA and didn't see anything about stage, but James is right and I stand pwned ;)

Will keep you guys posted and it'll be done within 8 hours ;)

Comment 4

[Reed Loden [:reed]]

The 8 hours means 8 hours pacific time (normal business hours, 9-5), fyi. :)

Comment 5

[James Socol [:jsocol, :james]]

(In reply to comment #4)
> The 8 hours means 8 hours pacific time (normal business hours, 9-5), fyi. :)

I know. Of course Shyam is in Singapore, which is convenient in this case. ;)

Anyway, he just asked why it was critical; I answered.

Comment 6

[Shyam Mani [:fox2mike]]

[root@tm-stage01-master01 ~]# time (zcat support_mozilla_com.2010.04.15.sql.gz | mysql --max_allowed_packet=1G support_wiki)

real    21m53.704s
user    2m59.322s
sys     0m12.270s

[root@tm-stage01-master01 ~]# time (zcat support_mozilla_com.2010.04.15.sql.gz | mysql --max_allowed_packet=1G support_stage_new_mozilla_com)

real    23m21.198s
user    2m58.591s
sys     0m12.622s

Done.