Value for money with amazing customer support
What do you like best?
For the most part it just works. When MySQL replication has stalled it ha been due to high load or bad reconfiguration on our side, and their support team has been very proactive in reaching out to alert us with suggestions on how to resolve the issue. Any questions are answered promptly and the support team always ensures that the customer is totally happy before closing the case. It's very well priced and the pay-as-you-go model works for us.
What do you dislike?
Running an SSH tunnel on a dedicated EC2 instance instead of VPC peering is an overhead I would prefer to avoid if possible, and only a Cloudformation template is provided (our company standard is Terraform so there was additional work required to convert). Customer support is not quite 24/7, though to be fair it still seems like they are responding at all hours of the day..
What problems are you solving with the product? What benefits have you realized?
We use Flydata for replicating MySQL data from our Production system into Redshift. Over the last year we have had zero issues on the Flydata side in this regard - for the most part we don't even need to think of it and our MySQL data is always in sync in the data warehouse.
This allows our analysts to work with Production data in near-real-time within a system dedicated to reporting, and where there is no additional load put on our Production system.
Without Flydata we would need to run additional infrastructure like Kakfa/Kafka Connect or write a custom solution to replicate the data, which would of course require engineering work and ongoing maintenance.
