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.

READ MORE

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.

READ MORE