Ming the Mechanic:
Server move

The NewsLog of Flemming Funch
 Server move2003-07-04 23:39
by Flemming Funch

I moved most of the contents of my server yesterday. It went reasonably well. That is, however, always a time when thing can go horribly wrong very quickly. The configuration of a linux server usually consists of hundreds of little details that have been done at different times, and it is not easy to make sure the same environment will exist on a new server.

What went most wrong sofar was the mysql database for NCN. Since it is a community site with many facilities and there's always somebody there, I was trying to minimize the downtime, so I was planning on going for a replication scheme. See, because of the way DNS lookups work there will be a period of time where a visitor might be sent to either the old site or the new site, and there's not a good way of knowing which one. And no matter what they do on that site, there will be database records created. Now, mysql has some neat replication features which would allow the database in two locations to be closely in sync in real-time, and which in principle would allow that changes could be made in either place and nothing would be lost. But I failed to notice that the replication process had stopped sometime during the day. And I didn't get that fixed before some people had jumped from the old to the new site and become surprised that their newslog entries and comments and recent changes suddenly had disappeared, and after new stuff had been posted in the new location. So, when I then activated the replicatation process again, all the lost content for the day did indeed appear, but there were conflicts in id numbers for various records, so a few things ended up in the wrong place. Mostly comments that got applied in the wrong place it seems.

Could be worse. Most things work, including the many majordomo mailing lists. I just need to fix some things about webbased mail, upload of gif files, and java support.

[< Back] [Ming the Mechanic]



5 Jul 2003 @ 01:17 by shawa : Thanks for the work, Ming!
As Vibrani said, never write something that you wouldn´t say to a person´s face! Given the circumstances, that´s sound advice!

5 Jul 2003 @ 01:48 by ming : Heheh
That's probably sound advice in general. On the Internet things might easily pop up to bite you. But don't worry too much. Things should be mostly back to normal now.  

5 Jul 2003 @ 06:48 by martha : thanks ming
for explaining the process. You had a lot of data to handle so a bit of a mix up can be expected.  

5 Jul 2003 @ 11:46 by sharie : Thank you Ming for all that you do ..
confident that the world will be a better place because of it.


5 Jul 2003 @ 15:49 by maxtobin : As Always
My thanks Ming for your committment to the NCN community/experiment.
Alana and I thank you for the time and effort that this involves. I too sense the service to evolving community this creates, enormous opportunites for growth and resonance to lead us to "who knows where who knows what!" I have been watching with interest the "phenomena" of interaction of late and "see" many examples of opportunity for growth that is neatly side stepped by those of us who could benefit from some good honest/integral interaction.  

7 Jul 2003 @ 11:55 by scotty : often we forget
to thank you Ming ! I do so now - sincerely !  

8 Jul 2003 @ 00:58 by ming : Job
I appreciate it, guys. Server moves isn't exactly what I enjoy the most. It is a bit like brain transplanting. A few minor remaining issues and we're back to normal I think, with the new brain.  

Other stories in
2012-05-03 00:04: An evolving path
2012-01-02 13:52: 2011 Accomplishments and 2012 Aims
2011-11-17 02:20: Your inner piece
2011-02-01 00:05: Slow Mo Flow
2011-01-22 18:40: Recognition
2010-08-23 00:36: Where's Ming?
2010-07-20 14:24: Getting other people to do stuff
2010-06-22 00:27: Inventory
2010-06-19 23:10: Conversations
2009-10-28 12:31: Then a miracle occurs

[< Back] [Ming the Mechanic] [PermaLink]? 

Link to this article as: http://ming.tv/flemming2.php/__show_article/_a000010-000856.htm
Main Page: ming.tv