[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Re: Adding fields to a live system - any data integrity concerns?



Excellent! Thanks all; time to go and bang out a proper deployment plan!

On 21/07/2014 09:17, "Yuri" <yurj at alfa.it> wrote:

>Il 21/07/2014 09:51, Andrew Beeken ha scritto:
>> Okay, so I take it when Apache is stopped you can still run Perl scripts
>> on the server (epadmin etc?)?
>
>sure, because it uses the perl libraries directly and not apache.
>
>>
>> On 18/07/2014 16:57, "Sebastien Francois" <sf2 at ecs.soton.ac.uk> wrote:
>>
>>> Also stop the indexer when you stop apache and restart the indexer when
>>> you restart apache.
>>>
>>> Seb.
>>>
>>> On 18/07/14 16:49, Jan Ploski wrote:
>>>> If you want to do it as a hotfix, the proper procedure would be to
>>>> 1. Add expected columns and indexes to database tables
>>>> 2. Add the field definition (which depends on 1)
>>>> 3. (optional) Run whatever initialization scripts you need to run for
>>>> the field
>>>> 4. apachectl graceful
>>>>
>>>> Unfortunately, EPrints tools assume that you add the field definition
>>>> first and that they then update the database for you. This leaves a
>>>> window of inconsistency during which your users will get errors.
>>>>
>>>> Obviously, if you don't mind a short service interruption, it's not a
>>>> concern and you can do it "offline" during a maintenance window:
>>>> 1. apachectl stop
>>>> 2. Add field definition
>>>> 3. Use epadmin to update database
>>>> 4. (optional) Run whatever initialization scripts you need to run for
>>>> the field
>>>> 5. apachectl start
>>>>
>>> *** Options: 
>>>http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>> *** Archive: http://www.eprints.org/tech.php/
>>> *** EPrints community wiki: http://wiki.eprints.org/
>>> *** EPrints developers Forum: http://forum.eprints.org/
>>
>> The University of Lincoln, located in the heart of the city of Lincoln,
>>has established an international reputation based on high student
>>satisfaction, excellent graduate employment and world-class research.
>>
>> The information in this e-mail and any attachments may be confidential.
>>If you have received this email in error please notify the sender
>>immediately and remove it from your system. Do not disclose the contents
>>to another person or take copies.
>>
>> Email is not secure and may contain viruses. The University of Lincoln
>>makes every effort to ensure email is sent without viruses, but cannot
>>guarantee this and recommends recipients take appropriate precautions.
>>
>> The University may monitor email traffic data and content in accordance
>>with its policies and English law. Further information can be found at:
>>http://www.lincoln.ac.uk/legal.
>>
>> *** Options: 
>>http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive: http://www.eprints.org/tech.php/
>> *** EPrints community wiki: http://wiki.eprints.org/
>> *** EPrints developers Forum: http://forum.eprints.org/
>
>
>*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>*** Archive: http://www.eprints.org/tech.php/
>*** EPrints community wiki: http://wiki.eprints.org/
>*** EPrints developers Forum: http://forum.eprints.org/