FlyData Blog

MySQL to Redshift: 4 Ways to Replicate Your Data
MySQL is the most popular open source cloud database in the world, and for good reason. It’s powerful, flexible, and extremely reliable. Tens of thousands of companies use MySQL to power their web-based applications and services every day. But when it comes to data analytics, it’s a different ...
Amazon Redshift February 2016 Updates: ALTER TABLE APPEND
In February, Amazon released some interesting features related Amazon Redshift. One of them is a new DDL, “ALTER TABLE APPEND”. When you need to migrate data from one table to another, you can use the “CREATE TABLE AS” statement. But there are situations where the query can be quite sluggish, esp...
New Amazon Redshift Feature - Automatic Queue Hopping for Timed-out Queries
Amazon Redshift controls the workload on the console called WLM.  One of the latest additions from Amazon is the support for automatic queue hopping.  This is a great feature for users who want to run large queries and be able to handle the priority more intelligently. Before releasing this func...
How to Improve Amazon Redshift Upload Performance
Amazon Redshift offers amazing performance at a fraction of the cost of traditional BI databases. But when it comes to data manipulation such as INSERT, UPDATE, and DELETE queries, there are some Redshift specific techniques that you should know, in order to perform the queries quickly and effici...
Optimal WLM Settings for Redshift
Fast Queries Running Slower in Redshift? When you have query performance issues with queries that should be running quickly in Amazon Redshift, one of the reasons might be that the query queue is filled with other queries. When the query queue is filled, your query is enqueued into a waiting lis...
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.