I have a transaction table in MySQL which get updated almost every second. The table has about 20 million records and counting. I have been running queries directly on this table in my app development which has been having serious impact on performance especially when I have to call some queries using aggregate functions.
I want to connect the MYSQL to Amazon Redshift.
The problem is I want my connection to Redshift to be live. ie. Get Redshift updated with every insert in my tales in mysql.
- How do I create the live connection to Amazon Redshift?
- Is there any other way I can manage data without using Amazon Redshift?