Migrating from rusetti to pinsetti has gone extremely well.

It’s unbelieveable that all MySQL databases with all user privileges were perfectly transferred simply by copying the data directory of MySQL to the new server. The database was running in “production use” all the time when backup was being made. It means that the server query thingie, PS3, PS2 and messageboard were possibly writing or reading stuff from the database as it was being copied. That may have caused, and probably did, that the database file wasn’t the same when copying was started and when it was finished. However, MySQL is flexible little pig and it doesn’t seem to have suffered fatal injuries :).

Also the new server query system worked like a charm on a new server, almost. There was one little problem which took about hour to solve. For some reason it was complaining that there is an error in SQL syntax even though the very same SQL queries were being done on rusetti at the same time. The problem was years old Perl MySQL module - SuSE quality (made in Germany). It took minute to update, but an hour to resolve.

Some compromises had to be done. There are no longer “servers on map” or “masterserver rank” graphs. They were based on the old file based server query thing and are no longer supported. For masterserver rank there is already equivalent database solution, but it has jammed the old server once - even though it worked ten times before that. It could be that the new server is juicier and can handle it better, but it remains to be seen.

Currently there are still open issues in the migration. There are lots of Setti Masterserver users who still use the old system. The old system will disappear in less than two weeks leaving thousands of players without server list. Release groups and 3rd party server browser developers should update their clients to use new IP address for the masterserver. It could be that they don’t realize what’s going to happen, even though there is notification in the old masterserver.