[RAS] Fwd: [ACIS-tech] Migration Help
Dan Hayes
dhayes501 at gmail.com
Tue Aug 30 12:28:09 CDT 2011
In that case, should we wait until Sept 17-18?
On Tue, Aug 30, 2011 at 11:43 AM, Christian Zimmermann <
zimmermann at stlouisfed.org> wrote:
> Please keep in mind that typically 3-11th days of the month are very busy
> because get their monthly emails. I can delay a bit if needed, but soon they
> start bugging.
>
> --
> Christian Zimmermann FIGUGEGL!
> Economic Research
> Federal Reserve Bank of St. Louis
> P.O. Box 442
> St. Louis MO 63166-0442 USA
> http://ideas.repec.org/zimm/
>
>
> On Tue, 30 Aug 2011, Ivan Kurmanov wrote:
>
> ---------- Forwarded message ----------
>> From: Ivan Kurmanov <duraley at gmail.com>
>> Date: Tue, Aug 30, 2011 at 7:37 PM
>> Subject: Re: [ACIS-tech] Migration Help
>> To: ACIS technical list <acis-tech at lists.openlib.org>
>>
>>
>> On Tue, Aug 30, 2011 at 7:22 PM, Dan Hayes <dhayes501 at gmail.com> wrote:
>>
>>> It looks like it will take editing /etc/hosts to access the web
>>> interface.
>>> Set authors.repec.org to 65.89.18.160.
>>>
>>> Also, the Affiliations section appears to be working fine now.
>>>
>>
>> I witness.
>>
>> Which means the Storable strings that were written (with nfreeze) on
>> the old nebka are readable on the new one, and we do not need any
>> other serialization changes at the moment.
>>
>>
>> Dan, did you measure or record the time it took to restore the database?
>>>>>
>>>> It took a solid 8 hours. I didn't time it exactly though. I watched
>>>> the
>>>> size of /var/lib/mysql and it grew to over 35G, acis is 32G and rdb is
>>>> 4.2G
>>>>
>>>
>> Then it looks like we should plan for at least 10-12 hours of downtime
>> of the service for the final migration.
>>
>> From the point of view of the least user experience damage (and brand
>>>
>> damage), it would be great to do the migration over the weekend. But
>> the nearest weekend (3-4 Sep) i'm occupied except at night, when I'd
>> like to have some sleep. The weekend after (10-11 Sep) i'm available.
>>
>> Or we can ignore the weekends and plan the transition on a business
>> day. I guess Dan will do the large part of the work again, so his
>> availability is key here. I'm pretty flexible at the moment.
>>
>>
>> And of course, there's more tests and checks to be done.
>>
>> -i
>>
>>
>>> On Tue, Aug 30, 2011 at 10:19 AM, Dan Hayes <dhayes501 at gmail.com> wrote:
>>>
>>>>
>>>> It took a solid 8 hours. I didn't time it exactly though. I watched
>>>> the
>>>> size of /var/lib/mysql and it grew to over 35G, acis is 32G and rdb is
>>>> 4.2G
>>>>
>>>> On Tue, Aug 30, 2011 at 10:05 AM, Ivan Kurmanov <duraley at gmail.com>
>>>> wrote:
>>>>
>>>>>
>>>>> Dan, did you measure or record the time it took to restore the
>>>>> database?
>>>>>
>>>>> -ivan
>>>>>
>>>>> On Tue, Aug 30, 2011 at 5:41 PM, Dan Hayes <dhayes501 at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> The SQL database has been loaded, and it appears to be running
>>>>>> properly.
>>>>>> You can test it at 65.89.18.160 or at http://nebka.stlouisfed.org.
>>>>>>
>>>>>> Did I not need to run the updareq commands again? It appears to be
>>>>>> working
>>>>>> without me needing to do anything else.
>>>>>>
>>>>>> On Mon, Aug 29, 2011 at 10:16 AM, Dan Hayes <dhayes501 at gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>>
>>>>>>> FYI
>>>>>>>
>>>>>>> I rsynced the files Saturday afternoon, and dumped the sql database
>>>>>>> then
>>>>>>> as well. I transferred the db backup on Sunday, and I'm now
>>>>>>> restoring
>>>>>>> the
>>>>>>> sql databases on the STL server. It looks like its going to take a
>>>>>>> while.
>>>>>>>
>>>>>>> On Sun, Aug 28, 2011 at 9:22 AM, Thomas Krichel <krichel at openlib.org
>>>>>>> >
>>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> Dan Hayes writes
>>>>>>>>
>>>>>>>> So the reason is that its faster than MySQL for what its being used
>>>>>>>>> for?
>>>>>>>>>
>>>>>>>>
>>>>>>>> Yes. At least we think so.
>>>>>>>>
>>>>>>>> Kindly send me an ssh public key to give you access to the test
>>>>>>>> server.
>>>>>>>>
>>>>>>>>
>>>>>>>> Cheers,
>>>>>>>>
>>>>>>>> Thomas Krichel http://openlib.org/home/**
>>>>>>>> krichel <http://openlib.org/home/krichel>
>>>>>>>> http://authorprofile.org/pkr1
>>>>>>>> skype: thomaskrichel
>>>>>>>>
>>>>>>>> ______________________________**_________________
>>>>>>>> ACIS-tech mailing list
>>>>>>>> ACIS-tech at lists.openlib.org
>>>>>>>> http://lists.openlib.org/**mailman/listinfo/acis-tech<http://lists.openlib.org/mailman/listinfo/acis-tech>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> ______________________________**_________________
>>>>>> ACIS-tech mailing list
>>>>>> ACIS-tech at lists.openlib.org
>>>>>> http://lists.openlib.org/**mailman/listinfo/acis-tech<http://lists.openlib.org/mailman/listinfo/acis-tech>
>>>>>>
>>>>>>
>>>>> ______________________________**_________________
>>>>> ACIS-tech mailing list
>>>>> ACIS-tech at lists.openlib.org
>>>>> http://lists.openlib.org/**mailman/listinfo/acis-tech<http://lists.openlib.org/mailman/listinfo/acis-tech>
>>>>>
>>>>
>>>
>>> ______________________________**_________________
>>> ACIS-tech mailing list
>>> ACIS-tech at lists.openlib.org
>>> http://lists.openlib.org/**mailman/listinfo/acis-tech<http://lists.openlib.org/mailman/listinfo/acis-tech>
>>>
>>>
>> ______________________________**_________________
>> RAS-run mailing list
>> RAS-run at lists.openlib.org
>> http://lists.openlib.org/cgi-**bin/mailman/listinfo/ras-run<http://lists.openlib.org/cgi-bin/mailman/listinfo/ras-run>
>>
>
> _______________________________________________
> RAS-run mailing list
> RAS-run at lists.openlib.org
> http://lists.openlib.org/cgi-bin/mailman/listinfo/ras-run
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/ras-run/attachments/20110830/50f23f42/attachment.html>
More information about the RAS-run
mailing list