SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    List Admin Announcement

    User Rick Rountree (rick@dundee.net) posted:

    Greetings,

    This is just a "heads-up" to let you know we are going to be moving this
    list to a new server sometime in the next few days. We are migrating from
    the Codebase data schema for the Lyris List Server to a SQL data schema.
    This involves consolidating several list servers into one large one. In
    addition to moving to a new server, we are also moving to a new data
    facility soon after the lists have been migrated to the new SQL server.
    You may see some downtime during this transition.

    I have included a FAQ below if you want to know more.

    I am going to make every attempt to keep everyone's settings for digests,
    indexes, etc., however, it is possible I might miss one or two so be
    prepared to reset your list settings if I mess them up.

    FAQ about this move:

    1) Why do you have so many list servers in the first place?

    The reason we had several servers was that the Lyris software operated
    using a Codebase (FoxPro) database. The Codebase database had only one
    thing going for it...it was fast. The down side was it had a 2 gigabyte
    limit to the file size hence the need to operate many servers and to move
    lists around to work around the file size limitation.

    2) Why do you have to do so much server maintenance?

    The Codebase schema including the need for periodic re-indexing of the
    data tables and it could not be backed up or re-indexed while the server
    was running thus the need to take the server down while these operations
    were performed.

    3) Why are you finally getting around to doing something about these
    Codebase problems?

    Lyris Technologies recognized these Codebase limits several years ago and
    have had a SQL database version in development for the past 2 years. The
    commercial release was made on 2-27-01 and we immediately upgraded two of
    our servers to try it out. We identified and Lyris fixed several issues
    and we are satisfied of the quality of the release to import all our lists
    to the SQL version.

    4) Why didn't you just upgrade each server instead of consolidating them?

    We consolidated because the Lyris SQL version is over $32,000 a for the
    license level we use and the SQL version is more than capable of handling
    the load of all lists we run.

    5) What are the main advantages to the SQL version?

    The SQL version is faster than Codebase plus it does not have any file
    size limitations and we can backup the databases while it is running. In
    addition, the tables are re-indexed continually so the need to take the
    server down for hours every few weeks is eliminated. SQL is also vastly
    more stable and geared towards running enterprise size projects.

    6) Why are you moving to a new data center at the same time you are
    transferring lists?

    This one wasn't our choice...the current facility is closing down. But
    it's working out better for us and you in the long term. The new facility
    has better connections to the Internet, better security, better fire
    suppression, better air conditioning...it makes the place we were in now
    look amateurish...it's a

  2. #2
    Advanced Member
    Join Date
    Jan 2006
    Posts
    995
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: List Admin Announcement

    Note from the administrator:

    This last posting, does not apply to QAForums in any way. It applies only to the Robot email list server. This forum should not be affected.

    Thank you.

    ------------------
    Administrator

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 13.64%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 01:49 AM.

Copyright BetaSoft Inc.