723693 - drop nightly prod DB dump on graphs1.stage.dmz.sjc1.mozilla.com

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Robert Helmer [:rhelmer]]

Right now, there is a nightly dump from the production graphserver database automatically imported to:

host: tm-stage01-master01
db: graphs_stage2_prod

It would be very useful to have a copy of this dump available for development purposes.

Would it be possible to copy the dump that's already being generated to graphs1.stage.dmz.sjc1.mozilla.com ? We only need one copy, so just copying over the same file would be fine.


Thanks!

Comment 1

[Sheeri Cabral [:sheeri]]

I'm testing out a script on this now, the same script that copies to tm-stage01-master01 seems to be working to copy to graphs1.stage.dmz.sjc.mozilla.com, but I won't know for sure until it's done.

Comment 2

[Sheeri Cabral [:sheeri]]

The script was successful - can you confirm that you can use the *.sql.gz files that are on server:folder - 

graphs1.stage.dmz.sjc1.mozilla.com:/data/backup-drop/b01/mysql/graphs_mozilla_org_new/

??

If so, I'll put it as part of a cron script and it will be automated.

Comment 3

[Jonathan Eads ( :jeads )]

I can confirm, I was able to copy graphs1.stage.dmz.sjc1.mozilla.com:/data/backup-drop/b01/mysql/graphs_mozilla_org_new/ locally and build a MySQL database that's working great.  Thanks for your help.

Comment 4

[Sheeri Cabral [:sheeri]]

awesome, I'll leave this open for at least another day so we can confirm the cron script works.

Comment 5

[Sheeri Cabral [:sheeri]]

Checking, for some reason the cron script isn't working.  I'm debugging now.

Comment 6

[Sheeri Cabral [:sheeri]]

Cron script is working again (and has been for a while). Resolving.