...
Potentially Large DB Changes and Pre-Upgrade Option
Mifos 2.5 6 contains a substantial amount of database related upgrades. If you are a small or medium user, this shouldn't amount to much upgrade time and you can ignore this note as the normal Mifos upgrade takes care of everything. If you are a large/very large user it may matter. See below to get an idea of how long the upgrade will be for you.
...
Also, as a side-effect, there was a 12 to 15% decrease in InnoDB database space usage.
Indication of How Long the Mifos 2.
...
6 upgrade is likely to take
1. Run the following query against your production database to get your 'Data Size' (substituting your mifos database name if it is not 'mifos'):
...
If you decide the upgrade time is too long for you (or you want to pay forward some of the benefits highlighted above), you can run the database change part of the upgrade separately prior to upgrading to mifos 2.5 6 as the changes work fine on mifos 2.1.x. Here are the steps.
1. Download the mifos 2.5 6 zip file and unzip it in a directory of your choosing.
...
5. When you come to upgrading to mifos 2.56, the mifos upgrade process will recognise that the database changes have been done.
Upgrading newer versions of Mifos (2.2.x, 2.3.x, 2.4.x, 2.5.x) to Mifos 2.
...
6.x
Follow the steps below to upgrade newer versions of Mifos (2.2.x, 2.3.x, 2.4.x, 2.5.x) to Mifos 2.56:
STEP 1: Unzip Mifos distribution zip (eg. mifos-v2.56.zip)
NOTE: Do not modify any file using an editor.
| No Format |
|---|
mifos-v2.56/ config/ db/ bin/ contract_db.sh expand_db.sh liquibase.sh undo_contract_db.sh undo_expand_db.sh changesets/ (contain liquibase xml format database changes - http://www.liquibase.org/manual/changeset) lib/ (dependencies required for liquibase) sql/ (sql scripts not related to upgrade, only used for creating a new Mifos database) mifos-db-template.properties (database configuration template used by liquibase) INSTALL install-ubuntu.sh LICENSE mifos.war (deploying war will run expansion script automatically) |
...