Skip to Content.
Sympa Menu

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

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] migrating grouper db strategies?


Chronological Thread 
  • From: Baron Fujimoto <>
  • To: Grouper Users <>
  • Subject: [grouper-users] migrating grouper db strategies?
  • Date: Fri, 25 Aug 2017 16:23:42 -1000
  • Ironport-phdr: 9a23:mPIw2xOyhuTV8c0WTNgl6mtUPXoX/o7sNwtQ0KIMzox0IvvzrarrMEGX3/hxlliBBdydsKMUzbKO+4nbGkU4qa6bt34DdJEeHzQksu4x2zIaPcieFEfgJ+TrZSFpVO5LVVti4m3peRMNQJW2aFLduGC94iAPERvjKwV1Ov71GonPhMiryuy+4ZPebgFLiTanfb9+MAi9oBnMuMURnYZsMLs6xAHTontPdeRWxGdoKkyWkh3h+Mq+/4Nt/jpJtf45+MFOTav1f6IjTbxFFzsmKHw65NfqtRbYUwSC4GYXX3gMnRpJBwjF6wz6Xov0vyDnuOdxxDWWMMvrRr0vRz+s87lkRwPpiCcfNj427mfXitBrjKlGpB6tvgFzz5LIbI2QMvd1Y6HTcs4ARWdZUMhfVzJPDJ6/YYQAE+UOIOhXopLhp1cStxayGRWgCfnxxjJOm3T43bc60+MkEQzewQEvBcgOsHPSrN7oNKkSTOK1zKjNzTXEc/NW3ir25Y/TfR87u/GMWrRwfNHRyUY1GQLKlFSQqY3/MzyLy+sNrnGW4ux9XuyhjG4nrht+ojmpxso0i4nJgJ4VxU7e9SV/3ok1OcO0RFRlbtG5DZtdsTyROYhuQs46XW1luTo2x78DtJ61fyUF04gryhvQZvCbb4SH/BfuW/qNLTtkgX9ofayzihiu/US41+HwSMq53ExXoidHj9XArG0B2wbN5sWBV/Bz5F2u2SyV2ADW8uxEIV47la7cK5M5x74/jJsTsUDaEi/ulkX6kLaad0o69uWm9+jreLrmppibN497jgHxLL4ildC4AeQ9KgQOXm6b9vqg1LD740H0QalGg/8zn6nXs53VPtgXq6u2DgNJzoos9ROyACu63NgEmHQKKUxJdRybg4TxPlHBOvH4DfOxg1S2lzdrwujLMab7DZXXKXjDlqzsfbZn5E9S0gUzzNFf64hKBb4cPfL/QlXxu8DADh8lLwy0xP7qCNpn1oMZRGKPGrGWMLnLvV+V/eIgPfOMZJQOtTb5Kvgl/OLujWQnlVMHfKmp24cXZ26iHvRgPUqZfWTgjs0fHmgXowptBNDt3XKYViNLamz6Yrkx/CpzXI28CprbS5ronaeMxjyTH5tKa3pAB0zWV3rkatPXde0LbXe4K9VmlHQqSLqgTog90ln6vgbgzLxPLuPL8ywZ85/vyY4mtKXoiRgu+GksXIym2GaXQjQxxztQSg==

We are planning to migrate our Grouper from MySQL db instance to another,
basically using the procedure outlined here:

<https://spaces.internet2.edu/display/Grouper/Migrating+Grouper+from+one+MySQL+to+another>

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.

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


  • [grouper-users] migrating grouper db strategies?, Baron Fujimoto, 08/26/2017

Archive powered by MHonArc 2.6.19.

Top of Page