Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] migrating grouper db strategies?

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] migrating grouper db strategies?

Chronological Thread 
  • From: Jeffrey Crawford <>
  • To: Grouper Users <>
  • Subject: Re: [grouper-users] migrating grouper db strategies?
  • Date: Wed, 13 Sep 2017 16:15:35 -0700
  • Ironport-phdr: 9a23:nkrHvxPss1HBoTmNmdgl6mtUPXoX/o7sNwtQ0KIMzox0Ivr4rarrMEGX3/hxlliBBdydsKMUzbKO+4nbGkU4qa6bt34DdJEeHzQksu4x2zIaPcieFEfgJ+TrZSFpVO5LVVti4m3peRMNQJW2aFLduGC94iAPERvjKwV1Ov71GonPhMiryuy+4ZPebgFLiTanfb9+MAi9oBnMuMURnYZsMLs6xAHTontPdeRWxGdoKkyWkh3h+Mq+/4Nt/jpJtf45+MFOTav1f6IjTbxFFzsmKHw65NfqtRbYUwSC4GYXX3gMnRpJBwjF6wz6Xov0vyDnuOdxxDWWMMvrRr0vRz+s87lkRwPpiCcfNj427mfXitBrjKlGpB6tvgFzz5LIbI2QMvd1Y6HTcs4ARWdZXMlRWSxPDI2/YYUSEeQOIf1VoJPhq1YUtxayGRWgCeHpxzRVhnH2x6o60+E5HA/CwgMgEdwOsG7Ko9T1KawfT/q1w7PGzDXNaPNWwyry45XPfxAjv/6MU7xwcdDPxkgvCwzIlUiQppD+PzyJzOgCrXWU7/d5WO+plmUppQZxoj21ycctjInEnoMVylbY9Spn2oY1I8O3SFJlbdK+DpRfqjyaOo1rSc0hW2FloDg2x7watZO5eSUKxpcqyAXDZ/GCfIWE/g7vWPuULDhkmH5oebeyihOs/US+0eLxUNS/3kxQoSpfiNbMs2gA1xzN5ciDTftw5kKh1iyO1wDX8+1EIEc0mbbCJ58u3LI8iIEcvV7MHi/xn0X2g6uWeVs+9ue07OTnZ63qpp6aN4BqlgHzKroil82jDek6NwUOUWuW9v+g2LDm8kD1XKlGguAzn6bFrJzXJMEWq6unDwNLyYkv8xO/AC2n0NQck3kHNlVFeBefgojrJV7OLv74De2hjFWsjDhm3O3GMaH6AprRNHTMjqrufatl505G1AUz1cxf545TCrwZL/LzQEjxtMHADhAnKQy42vvnCM5j2YMEQmKCGauZMKLJsV+U/eIjPfOAZI4TuDbhNfcl/fjugmElmVMDZ6Wmw4YYaG3rVshhdmqDZmf0j81JLHwHpBF2GOPwj0CaXCQWem2/RbkU5zcnBZigAJuZAI2hnerS8j28G8h0a25IEF2dWVzyfpqKXO0AIHaQL8FviDEVXpC8QJQqkxyiqVmpmPJcMuPI93hA5trY399v6riWzElq+A==

The only thing I can suggest is when we moved from postgres to Oracle, I had to devise a dump from postgres, throw that through some perl filters and populate the other DB. I would do that several times and have new grouper instances connect to the DB to be migrated to, then test.

When we were confident we had a working migration script we switched over and only had an around 5 min. downtime. Granted we didn't have the data we have now.

Jeffrey E. Crawford
Enterprise Service Team
    ^         ^
   / \  ^    / \    ^
  /   \/ \  /   \  / \
 /        \/     \/   \
/                      \

You have been assigned this mountain to prove to others that it *can* be moved.

On Fri, Aug 25, 2017 at 7:23 PM, Baron Fujimoto <> wrote:
We are planning to migrate our Grouper from MySQL db instance to another,
basically using the procedure outlined here:


Presumably, we want to prevent any updates to the Grouper db until the
migration is completed to ensure cnosistency between the old and new DBs.

We know from experience though that the db export and import process are
quite time consuming (hours, at least).

Does anyone have any suggestions for lessening the impact on our Grouper
users during this migration process? For example, is there a way to put
Grouper in a read-only mode? Else, in the absence of options, I think
we're looking at a complete service outage for the duration of the
export/import migration process.

Baron Fujimoto <> :: UH Information Technology Services
minutas cantorum, minutas balorum, minutas carboratum desendus pantorum

  • Re: [grouper-users] migrating grouper db strategies?, Jeffrey Crawford, 09/13/2017

Archive powered by MHonArc 2.6.19.

Top of Page