Results 1 to 5 of 5

Thread: how long did it take to run the migrate20100913-Mysql51.pl

  1. #1
    alto is offline Special Member
    Join Date
    Feb 2007
    Location
    Ireland
    Posts
    125
    Rep Power
    8

    Question how long did it take to run the migrate20100913-Mysql51.pl

    I'll be upgrading to 7.2.1 shortly and wonder how long the MYSQL table upgrade script has taken other people to run?

    In the release notes the example is for a 4000 mailbox, 250 MB mailbox size, the script could take about 70 minutes to run.

    Now I only have 170 mailboxes but most of those are GB's in size, with the average about 4GB

    So anybody remember how long theirs took and how many mailboxes + size?

    Thanks

  2. #2
    iehrenwaldTA is offline Starter Member
    Join Date
    Sep 2012
    Posts
    2
    Rep Power
    2

    Default

    Quote Originally Posted by alto View Post
    I'll be upgrading to 7.2.1 shortly and wonder how long the MYSQL table upgrade script has taken other people to run?

    In the release notes the example is for a 4000 mailbox, 250 MB mailbox size, the script could take about 70 minutes to run.

    Now I only have 170 mailboxes but most of those are GB's in size, with the average about 4GB

    So anybody remember how long theirs took and how many mailboxes + size?

    Thanks
    When upgrading from 6.0.10 -> 7.2.0P1, the script took about 90 minutes per mail store (we have two, currently). There were close to 1600 accounts split between them, average size of a mailbox was around 4.5GB. Each mail store has about 50GB of MySQL metadata and 4TB of mail. Therefore, total size was about 100GB of MySQL metadata and 8TB of mail.

    I highly recommend running the script in a 'screen' session just in case you get disconnected.

  3. #3
    alto is offline Special Member
    Join Date
    Feb 2007
    Location
    Ireland
    Posts
    125
    Rep Power
    8

    Default

    Thanks for that, exactly the type of info I was looking for. Did you run the script immediately after the upgrade or run a backup first?

  4. #4
    iehrenwaldTA is offline Starter Member
    Join Date
    Sep 2012
    Posts
    2
    Rep Power
    2

    Default

    Quote Originally Posted by alto View Post
    Thanks for that, exactly the type of info I was looking for. Did you run the script immediately after the upgrade or run a backup first?
    Our NetApp takes storage-level snapshots of our volumes hourly through VMWare using SMVI. We also manually took a storage-level snapshot of our Zimbra volumes on our NetApp before we started the upgrade in case we had to roll back. Additionally, I highly recommend cutting off all network communication to the Zimbra hosts while you do the upgrade so everything is in a known, consistant state and in case you do have to roll back, nothing has changed and your users won't be missing anything. I'm speaking as someone who has done two pretty large migrations and upgrades with the help of Zimbra Professional Services. If you can afford it, they're indispensable when it comes to enterprise-level planning/support.

  5. #5
    alto is offline Special Member
    Join Date
    Feb 2007
    Location
    Ireland
    Posts
    125
    Rep Power
    8

    Default

    The script only took 12 minutes to run.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 12-05-2011, 11:50 AM
  2. ZD - Signature too long
    By zigaj in forum Error Reports
    Replies: 2
    Last Post: 10-21-2009, 08:15 AM
  3. filename long
    By Alexander Villanueva Clar in forum Users
    Replies: 0
    Last Post: 07-31-2008, 09:22 AM
  4. Long way from FOSS to NE
    By Kristaps in forum Zimbra Success Stories
    Replies: 1
    Last Post: 01-07-2008, 09:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •