Initial FlyData Sync

Now that you’ve primed everything–your MySQL server, FlyData’s server, and Amazon Redshift–you’re ready to do an initial synchronization. This will copy all of the data from your MySQL server for the database and tables you specified, to Amazon Redshift.

$ flydata start

It’s simple, but it will start the initial synchronization. It could take from a few minutes to several hours, depending on the amount of data contained in the tables you’re replicating on Amazon Redshift.

When the initial synchronization is finished, your FlyData Sync setup is completed. From that point on, any updates to the data in the replicated tables on your MySQL server (i.e., the master) will be made on your Amazon Redshift cluster from five to fifteen minutes later. You can do your do your analysis on Amazon at any time.