List Admin Announcement
User Rick Rountree (firstname.lastname@example.org) posted:
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
3) Why are you finally getting around to doing something about these
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
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
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.