Its a great place to be when you initial platform is ready to scale and having performance issues. This clear shows that we are growing and in the process making right decisions in chosing and building our platform. One of our data sore is PostgresSQL hosted on AWS through our provider elephantsql. We have been quite happy with this provider as they met our needs during the early stages and continue to do so. We will continue to leverage them in the future. However, one of the key issue is the growth of our data and the amount of cost involved to pay for that infrastructure. We feel that pay per use model of clouds are a perfect campaion for startups.

We are building a new platform for which we feel that a solution like Redshift makes a great sense. So if we have to migrate some of our data into this new DB how do we go about it? There are 2 approaches

  • Use the standard approach of backup and restore with additional task of schema and data type management.
  • Use a provider who will support this migration and make your life a bit simpler but of course at a small price.

AWS DMS

AWS DMS is a great service if you haven’t used it. Few of the features that it provides are of great help to businesses who love to not dirty their hands 🙂 for non-needed tasks.

  1. Replication
  2. Data streaming
  3. Synchronization between the source and destination

Redshift which is a MPP DB mainly suited for Datawarehouse related large data processing is ideally suited if you need to handle data growing from a small single node to a multiple multi node cluster.

One of the neat features is that you can add or remove compute nodes to the cluster without any interruption to the service. This is fantastic as this enables you to handle your performance based on your traffic growth. Other key features which Redshift supports are you normal Admin activities such as backup, replication, monitoring on cloudwatch to name a few.

We highly recommend trying out AWS DMS as it can provide a great deal of stability, quality and performance for your DB migration related tasks.

At Intentwise, we provide SAAS software that helps with AMS  Reporting, AMS Analytics, and AMS recommendations based on our machine learning based recommendation engine. The Intentwise tool will help maximize your PPC returns while optimizing spend. If you are interested in trying out the tool that supports Amazon’s AMS automation, schedule a Demo now!