May 2016

Amazon Web Services (AWS) release new X1 instance

Last week, Amazon Web Services (AWS) released its largest ever virtual server for its Elastic Compute Cloud (EC2). The 2TB X1 instance was originally announced by AWS CTO, Werner Vogels last year at the 2015 AWS RE:Invent conference, and aims to make AWS more usable for enterprise applications and massively large data sets.

Continue Reading…

Benefits of having your development environment on AWS EC2

In Web development – there are a number of ways to create your own working environment. Some people like to have all code locally, but every day more and more developers are choosing to work in the cloud. With cloud services provided by Amazon Web Services (AWS) – it is very easy to create a machine, that will make your workspace accessible anywhere. In this post, we will show you how to create and setup EC2 instance for working on your code online.

Continue Reading…

How do I reduce the MySQL database size on AWS RDS?

We’ve recently encountered a challenge with one of our internal apps – How do I reduce the MySQL database size on AWS RDS? When it comes to increasing size of the db – there is no easier thing – you just go to the AWS console and modify instance, but if you try to shrink storage then AWS console doesn’t allow to do it – saying it can just go up. And because we’ve managed to change our application to use less storage – to avoid extra cost – we needed to reduce the size of our database. The easiest thing to do would be a mysqldump and use that dump to recreate db, but our db was big enough and it took too much time to create it and we couldn’t afford any longer downtime. After some time spent on dba.stackexchange and stackoverflow and a couple of tryouts of different approaches we’ve managed to copy our db to a smaller instance.

Continue Reading…