Applying SQL Anywhere EBFs in a read-only scale-out system

 Upgrading databases that use read-only scale-out

This procedure describes how to upgrade a database being used in a scale-out system, including when scale-out is being used with database mirroring.

To apply an EBF in a read-only scale-out system, you shut down the database for the node and install the EBF. You do not have to install the EBF at the root node first.

  1. Make a backup of the database and rename the transaction log.

  2. Upgrade or rebuild the backup copy of the database on a different computer. See The upgrade process for version 10 and later databases or The rebuild process for version 10 and later databases.

  3. Stop the database servers for all of the copy nodes in the system.

  4. Shut down the root server. If you are using database mirroring in conjunction with scale-out, you must shut down both the primary and mirror servers.

  5. Save the current copy of the transaction log on the primary database.

  6. Use the dbtran utility to translate the transaction log saved in step 4.

    This transaction log contains any changes made to the database since the backup in step 1.

  7. Start the rebuilt database using a local database server.

  8. Apply the translated transaction log using the READ statement from Interactive SQL.

  9. Stop the rebuilt database.

  10. Copy the upgraded or rebuilt database and its transaction log to the root database server.

  11. Copy the upgraded database and an empty transaction log files to each copy server.

  12. Start the root database server. If you are using database mirroring with scale-out, you must start both the primary and the mirror servers.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1