Showing posts with label mbps. Show all posts
Showing posts with label mbps. Show all posts

Monday, January 6, 2014

Instance types and network throughput

Network throughout is a very good metrics to know when running an Oracle Database on AWS or for any time you are moving data from different AWS services other AWS services. Maximum throughput for different Amazon EC2 instance types can be found here:
http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSOptimized.html

This 2013 AWS reInvent session also has details http://www.slideshare.net/AmazonWebServices/stg302-28617072 (Slide 19)


The m1.xlarge instance maximum network through put is 128 MBPS / 1K Mbps. The CC2.8xlarge, CR1.8xlarge, hi1.4xlarge, and cg1.xlarge (http://www.slideshare.net/AmazonWebServices/stg302-28617072) can provide up to 800 MPBS.

Monday, February 11, 2013

Oracle DB data transfer to AWS


A typical Oracle database is 1 TB or more in size. This will mean that a T3 line or higher speed line will be needed to move this much data. Otherwise, the AWS import export service can be used. The information below is from the http://aws.amazon.com/importexport/ web page but repeated here for easy of finding.

Connection           Theoretical 80% Utilization    AWS Imp/Exp
T1 (1.544Mb)        82 days                                    100GB or more
10Mbps                  13 days                                    600GB or more
T3 (44.736Mbps)    3 days                                      2TB or more
100Mbps               1 to 2 days                                 5TB or more
1000Mbps             Less than 1 day                         60TB or more

Elapsed time is going to depend on many factors: speed of connection, compression used (if any), can load be done in parallel etc. The fastest load times will happen using AWS import/export (http://aws.amazon.com/importexport/ ). The next fastest will be using AWS Direct Connect (http://aws.amazon.com/directconnect). 

Direct Connect provides speeds of 1 Gbps to 10 Gbps. Using a 1 Gbps line, it would take about 3-4 hours (here is a good site: http://fasterdata.es.net/fasterdata-home/requirements-and-expectations/).