[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?



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
>