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

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, i
Read more

How To Attach Your EBS volume to multiple EC2 instances

Image
Are you exhausted from the complexities and the extra cost associated with the EFS? What if you simply need to share the EBS volume between two EC2 instances? Say no more - Amazon Web Services has an answer for you! Starting today, customers running Linux on Amazon Elastic Compute Cloud (EC2) can take advantage of new support for  attaching  Provisioned IOPS ( io1 ) EBS volumes to  multiple EC2 instances , at  no extra charge ! Multi-Attach option in EBS According to AWS, the Multi-Attach capability makes it easier to achieve higher availability for applications that provide write-ordering to maintain storage consistency. Consider the following scenario: you are running a web application behind the load balancer, and the application expects static assets, such as WordPress media uploads, theme or configuration files, shared between the instances. Instead of using EFS, you could create new PIOPS EBS volume with the Multi-Attach option, mount the volume on each s
Read more