Get Data Moving 1
Results 1 to 2 of 2

Thread: When to install the Attunity Replicate when MySQL RDS is the source

  1. #1
    anuragbiswas is offline Junior Member
    Join Date
    Oct 2014
    Posts
    6
    Rep Power
    0

    When to install the Attunity Replicate when MySQL RDS is the source

    The guidelines for on-premise Oracle to Redshift say that the Attunity replicate should be installed in the same network as the on-premise database. Is it possible that Attunity Replicate be installed in an EC2 box when we want to replicate an on-premise Oracle database?

    When our source DB is MySQL RDS, should the replicate software be situated on a on-premise box or on an EC2 instance? In this case, can the same box be used for Attunity Replicate where the Attunity Cloudbeam is also installed?

    Will the location of where Attunity Replicate is installed matter, if the AWS VPC becomes part of our organizational VPN?

    Since Attunity Replicate does the data extraction, is it limited to the machine resources it is installed on or since the data is stremed to the Cloudbeam, it does not matter to that extent? Which is more important for the Replicate software - memory or cpu or both?

    We loaded the below tables. It took 1 hr 42 min. Is this the expected performance or will a bigger box improve the performance?
    tablename:Table1 rows:6962388 rowlength:805
    tablename:Table2 rows:13924776 rowlength:805
    tablename:Table3 rows:3481194 rowlength:805

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Quote Originally Posted by anuragbiswas View Post
    The guidelines for on-premise Oracle to Redshift say that the Attunity replicate should be installed in the same network as the on-premise database. Is it possible that Attunity Replicate be installed in an EC2 box when we want to replicate an on-premise Oracle database?

    When our source DB is MySQL RDS, should the replicate software be situated on a on-premise box or on an EC2 instance? In this case, can the same box be used for Attunity Replicate where the Attunity Cloudbeam is also installed?

    Will the location of where Attunity Replicate is installed matter, if the AWS VPC becomes part of our organizational VPN?

    Since Attunity Replicate does the data extraction, is it limited to the machine resources it is installed on or since the data is stremed to the Cloudbeam, it does not matter to that extent? Which is more important for the Replicate software - memory or cpu or both?

    We loaded the below tables. It took 1 hr 42 min. Is this the expected performance or will a bigger box improve the performance?
    tablename:Table1 rows:6962388 rowlength:805
    tablename:Table2 rows:13924776 rowlength:805
    tablename:Table3 rows:3481194 rowlength:805

    1. The guidelines for on-premise Oracle to Redshift say that the Attunity replicate should be installed in the same network as the on-premise database.
    ans. This is correct.

    2. Is it possible that Attunity Replicate be installed in an EC2 box when we want to replicate an on-premise Oracle database?
    ans. Yes as long as the Attunity Replicate able to connect to your on-premise Oracle database. Also, the performance will be effected.

    3. When our source DB is MySQL RDS, should the replicate software be situated on a on-premise box or on an EC2 instance?
    ans. Since your source is MySQL RDS, then Attunity Replicate would need to be on and Windows EC2 instance.

    4. Can the same box be used for Attunity Replicate where the Attunity Cloudbeam is also installed?
    ans. Yes, but the performance will be effected, as Replicate server does request more CPU and Memory.

    5. Will the location of where Attunity Replicate is installed matter, if the AWS VPC becomes part of our organizational VPN?
    ans. It is best to have your Attunity Replicate EC2 server be in the same region as your MySQL RDS DB region.

    6. Which is more important for the Replicate software - memory or cpu or both?
    ans. Both, Replicate server prefer more memory and CPU.

    for performance, I am assuming that your source is MySQL RDS and target is Redshift.
    if so, a Larger Replicate EC2 server, would have a little better performance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •