John Kaster

Behind the Screen

Upgrading InterBase 2009 to InterBase XE 64-bit

with 3 comments

Starting at 7pm Friday, October 29th, 2010 we will be upgrading InterBase servers from 2009 to the XE 64-bit release. In addition to the obvious benefits of full 64-bit memory addressing, better CPU usage, stronger passwords, and other security improvements, there are some other things we get by upgrading to XE.

By simply doing a backup and restore of the databases with InterBase XE, the On-Disk Structure (ODS) version will be 15. With OSD 15, we gain:

  • index key sizes can now be 2K rather than 252 bytes
  • faster, incremental sweeps (the InterBase garbage collector)
  • much faster blob handling: if you have a query for a table that contains blobs, but the query doesn’t request any of the blobs in its result set, the blobs are basically ignored, resulting in much faster queries

Here’s the 10 step process we’re going to take for our upgrade:

  1. Put our web servers into maintenance mode
  2. Uninstall our InterBase 2009 instances
  3. Install InterBase XE instances
  4. Register the XE instances
  5. Copy our preferred ibconfig to each instance
  6. Backup our admin.ib from our XE 64-bit test instance and restore it for each production XE instance (for strong password support)
  7. Backup and restore every InterBase database so it gets the latest version of ODS. (We have a batch file for this.)
  8. Before or during the InterBase XE process, update all our InterBase clients on the various servers that talk to our InterBase servers with the XE client, so they support the new stronger password feature. This client can be updated directly over the existing client. We may have to stop some IIS instances to replace the client, other the InterBase client may still be in use when we try to replace it.
  9. Take our web servers out of maintenance mode
  10. Enjoy the increased performance and stability of InterBase XE!

P.S. We have one custom UDF that’s not yet available for 64-bit InterBase, so one server instance will be 32-bit rather than 64-bit.

Advertisements

Written by John Kaster

October 28, 2010 at 1:58 pm

3 Responses

Subscribe to comments with RSS.

  1. Hi,
    I know that InterBase SMP 2009 is using ODS 13, and you said above that InterBase XE x64 is using ODS 15. Is ODS 14 used on InterBase XE x86?

    Hikaru FUKUSHI

    October 28, 2010 at 11:14 pm

  2. @Hikaru, Good question. I got an answer from Sriram Balsubramanian regarding the ODS version:
    InterBase 2009 had a special ODS 14 to resolve some index corruption issues; so we skipped creating ODS 14 with InterBase XE. InterBase XE will still service any ODS 13/14/15 databases, but only will create ODS 15 from a new CREATE call or restore.

    John Kaster

    October 29, 2010 at 9:45 am

  3. John, Thank you for your answer.

    Hikaru FUKUSHI

    October 31, 2010 at 9:58 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: