852606 - MySQL Dumps for prod butter/thimble

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[JP Schneider :jp]

Hi there!
I'd like to grab a mysqldump of the thimble and butter prod db's to move over to AWS for testing/eval for the migration over.

Thanks!

Comment 1

[Philippe M. Chiasson (:gozer)]

I can get you the prod butter, but the other one isn't in labs.

Comment 2

[Philippe M. Chiasson (:gozer)]

[gozer@boris ~]$ scp butter-20120319.sql.gz [e-mail]:
Done!

Comment 3

[Philippe M. Chiasson (:gozer)]

Ping, can this be closed as resolved ?

Comment 4

[JP Schneider :jp]

Not yet, we have not gotten a thimble dump, and will need to do it again for go-live.

Comment 5

[JP Schneider :jp]

Hi Gozer, thoughts on who I can assign this to in IT or webops to coordinate a flip over to AWS for thimble?

Comment 6

[Philippe M. Chiasson (:gozer)]

Sure, but at this point, what do you still need?

You have the thimble dump now?

Are we talking about a DNS/load-balancing flip over to AWS or something else?

Comment 7

[JP Schneider :jp]

Mmm, I don't think we've gotten a thimble dump yet.  I guess my question is to whom to route this ticket?

Comment 8

[Philippe M. Chiasson (:gozer)]

Bouncing over to #webops

Comment 9

[JP Schneider :jp]

We'll have two needs, specifically, First will be a dump just to test and try things out, and the second dump will come in coordination during a flip over to AWS, likely in the next 10 days.

Comment 10

[JP Schneider :jp]

Hi there webops!
Is there someone I can coordinate with on this?

Comment 11

[Chris Turra [:cturra]]

:jp - i can, grabbing this bug.

Comment 12

[Chris Turra [:cturra]]

:jp - as discussed on irc, i have emailed you a database dump from stage so you can test your new thimble environment. stage only has test data and was never a back port from production.

Comment 13

[JP Schneider :jp]

Understood, thanks.  That unfortunately will not allow me to measure the time I'll need for go-live data migration or measure performance in a like-live env, but once we get a +1 on getting the data I'll be able to grab all that info.

Thanks for your help.

Comment 14

[Joe Stevensen [:joe]]

JP,

You should be good to go on this, but what is your plan for handling the data?

* where will it sit? 
* who will you give it to?
* how will you get it to them?

Comment 15

[Sheeri Cabral [:sheeri]]

joes - I can give it to them, and they've given me a temporary login to their AWS system to scp the backup. That should be enough for the last 2 questions, I can't speak to the first.

Comment 16

[Sheeri Cabral [:sheeri]]

thimble backup copied to:

/home/ubuntu/webpagemaker_mozilla_com.2013.04.16.sql.gz

on the EC2 instance wex provided.

Comment 17

[Sheeri Cabral [:sheeri]]

I'm going to call this resolved. When you're ready to do the production migration, please open another bug as part of your migration tracker for the thimble export. You can make it part of mozilla.org -> Server Operations:Database.