Amazon RDS Switch to MySQL 5.5

Upgrading your Amazon RDS instance from MySQL version 5.1 to MySQL 5.5 has never been easier, as Amazon Web Services announced earlier this week. Now you can modify your MySQL RDS instance using feature called Major Feature Upgrade.

MySQL 5.5 includes several features and performance benefits over MySQL that may be of interest to you including enhanced multi-core scaling, better use of I/O capacity, and enhanced monitoring by means of the performance schema. MySQL 5.5 defaults to version 1.1 of the InnoDB Plugin, which improves on version 1.0 (the default for MySQL 5.1) by adding faster recovery, multiple buffer pool instances, and asynchronous I/O.
Here's how you can upgrade your RDS instance:

  • Log in to your AWS Console
  • Go to RDS, and select your instance
  • From Instance Actions drop down, choose Modify
  • Select latest version of MySQL 5.5 from the drop down,
  • To upgrade immediately, select the Apply Immediately check box. To delay the upgrade to the next maintenance window, clear the checkbox.
  • Press Continue
According to AWS, MySQL major version upgrades typically complete in about 10 minutes; your database is unavailable until the upgrade process is complete.

And of course before upgrading, I recommend to test your application before major db upgrade:
  1. Take snapshot of existing database
  2. Launch new server from the snapshot (don't worry, you are only paying hourly fee with RDS)
  3. Point staging application to newly launched server
  4. Run tests against upgraded database
  5. Adjust application if needed
  6. Stop the test database server
  7. Initiate RDS instance upgrade

Comments

Post a Comment

Popular posts from this blog

Stubbing and Mocking Static Methods with PHPUnit

Image
PHPUnit has ability to stub and mock static methods. Consider the class Foo : <?php class Foo { public static function doSomething() { return static::helper(); } public static function helper() { return 'foo'; } } ?> To test the static helper() function with PHPUnit, you can write you test like that: <?php class FooTest extends PHPUnit_Framework_TestCase { public function testDoSomething() { $class = $this->getMockClass( 'Foo', /* name of class to mock */ array('helper') /* list of methods to mock */ ); $class::staticExpects($this->any()) ->method('helper') ->will($this->returnValue('bar')); $this->assertEquals( 'bar', $class::doSomething() ); } } ?> The new staticExpects() method works similar to the non-static expects...
Read more

MongoDB: Remove an Arbiter From a Replica Set

Image
Removing an arbiter from MongoDB Replica Set can be quite tricky, and official MongoDB documentation does not say it directly how to do it. I assume that you have auth enabled (just like I have), so lets start with connecting to your ReplicaSet "repl" master as an administrator: mongo mongo.domain.com/admin -u admin -p pass You will see the following prompt: repl:PRIMARY> Type in conf=rs.conf() repl:PRIMARY> conf = rs.conf() { "_id" : "repl", "version" : 8, "members" : [ { "_id" : 0, "host" : "mongo.server.com:27017", "priority" : 2 }, { "_id" : 1, "host" : "mongo1.server.com:27017" }, { "_id" : 2, "host" : "arbiter.server.com:27017", "arbiterOnly" : true }, { "_id" : 3, "host" : "mongo2.server.com:27017" } ] } Now lets adjus...
Read more

Enable HTTP/2 Support in AWS ELB

Image
This thread  was started more than a year ago, asking for when Amazon Web Services will add support for HTTP/2  into their ELB. In addition to that, people are also asking, how to configure ELB to support multiple SSL certificates. AWS support team has been reluctant on giving out any specific details on when both of these features will be available, citing: I've verified that the ELB team is aware of the interest in ELB supporting HTTP/2. Please keep an eye on What's New from Amazon Web Services: http://aws.amazon.com/new/ for any updates. What is HTTP/2? HTTP/2 is a replacement for how HTTP is expressed “on the wire.” It is not a ground-up rewrite of the protocol; HTTP methods, status codes and semantics are the same, and it should be possible to use the same APIs as HTTP/1.x (possibly with some small additions) to represent the protocol. HTTP/2 protocol is supported by major modern browsers including IE11, Edge 13, Firefox 47, Chrome 52, Safari 9.1, Opera 38, ...
Read more