Setup and Register RDS MySQL with FlyData

The point of FlyData Sync in particular, is to replicate selected databases and tables on Amazon Redshift. To do this, you will need to register Amazon RDS MySQL on FlyData. You will also need to make sure the binary logs are enabled on your MySQL server. Let’s do that first.

Create a Read Replica

Next you need to create a read replica. Do this in your Amazon RDS Dashboard. Select Instance Actions and then Create Read Replica.

Next click on Parameter Groups and then Create DB Parameter Group, as shown in the screenshot below:

 

A dialog box will appear asking you to set parameters for the group.

 

Set these parameters as follows:

  • DB Parameter Group Family: mysql5.6
  • DB Parameter Group Name: mysql56sync
  • DB Parameter Group Description: MySQL5.6 for Sync

When you’re finished, click on Yes, Create. Then select the icon next to the newly created parameter group,mysql56sync. Click on Edit Parameters. You should then see a box like the one shown below:

 

You will need to set just a few of the parameters, the ones that follow:

  • binlog_format: ROW
  • log_bin_use_v1_row_events: 1
  • read_only: 0
  • net_read_timeout: 3600
  • net_write_timeout: 3600
  • wait_timeout: 86400

When you’re finished, click Save Changes to save your changes.

Now you will need to configure the read replica. To do this, click on Instance Actions and then Modify, as shown in the screenshot below:

 

When you do so, you will see a dialog box like the one in the screenshot below:

 

For most of the values, the default may be used or they may be left blank. However, you will need to set a few of the values as follows:

  • DB Engine Version: MySQL 5.6.xx(default)
  • New Master Password: password
  • Parameter Group: mysql56sync
  • Apply Immediately: Check

You need to enter a password for the New Master Password so as to reset the default parameters. User may use the same password as you used previously for the master password. You don’t have to change it, but it needs to be entered again, although it says New. For the DB Parameter Group, enter the name of the one you just created.

When you’re finished entering these parameters, Select Apply Immediately and click on Continue. When asked for confirmation, click on the button labeled, Modify DB Instance (see screenshot below).

 

You will need to wait for the instance to become available before proceeding. When it does, select Instance Actions and then Modify. And Set :

  • Backup Retention Period: 7days
  • Apply Immediately: Check

Now that you’ve modified the instance, wait until it becomes available again before proceeding.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk