PrepAway - Latest Free Exam Questions & Answers

10 Comments on “Can I test my DB Instance against a new version before upgrading?

      1. Ashebrethafe says:

        I’d still say no, or at least argue that the question is badly written. It seems to be asking whether RDS has a feature allowing a user to compare the performance of two different versions of a database before deciding which one to keep. The link doesn’t say that it has any such feature, or even a feature allowing a user to compare the performance of a single version of the database on two different versions of the engine (if that’s what the question was asking); instead, it says that you should manually copy the RDS instance, upgrade the engine for the copy, and run your own tests on the copy before upgrading the engine on the original instance.




        3



        0
        1. Mahendra says:

          Database Engine Version Upgrade

          DB instance engine version can be upgraded when a new DB engine version is supported by RDS.
          Database version upgrades consist of major and minor version upgrades.
          Major database version upgrades
          can contain changes that are not backward-compatible
          RDS doesn’t apply major version upgrades automatically
          DB instance should be manually modified and thoroughly tested before applying it to the production instances.
          Minor version upgrades
          Each DB engine handles minor version upgrade slightly differently
          for e.g. RDS automatically apply minor version upgrades to a DB instance running PostgreSQL, but must be manually applied to a DB instance running Oracle.
          Amazon posts an announcement to the forums announcement page and sends a customer e-mail notification before upgrading an DB instance
          Amazon schedule the upgrades at specific times through the year, to help plan around them, because downtime is required to upgrade a DB engine version, even for Multi-AZ instances.
          RDS takes two DB snapshots during the upgrade process.
          First DB snapshot is of the DB instance before any upgrade changes have been made. If the upgrade fails, it can be restored from the snapshot to create a DB instance running the old version.
          Second DB snapshot is taken when the upgrade completes. After the upgrade is complete, database engine can’t be reverted to the previous version. For returning to the previous version, restore the first DB snapshot taken to create a new DB instance.
          If the DB instance is using read replication, all of the Read Replicas must be upgraded before upgrading the source instance.
          If the DB instance is in a Multi-AZ deployment, both the primary and standby replicas are upgraded at the same time and would result in an outage. The time for the outage varies based on your database engine, version, and the size of your DB instance.




          2



          0
  1. zhouyl says:

    Well, should look up here:https://amazonaws-china.com/rds/faqs/?nc1=h_ls

    Q: Can I test my DB instance with a new version before upgrading?

    Yes. You can do so by creating a DB snapshot of your existing DB instance, restoring from the DB snapshot to create a new DB instance, and then initiating a version upgrade for the new DB instance. You can then experiment safely on the upgraded copy of your DB instance before deciding whether or not to upgrade your original DB instance.

    For more information about restoring a DB snapshot, refer to the Amazon RDS User Guide.




    3



    0

Leave a Reply

Your email address will not be published. Required fields are marked *