This website uses cookies to ensure you have the best experience. Learn more

Mysql On Ec2 Vs Rds Essay

1549 words - 7 pages

INTRODUCTION: With cloud computing, Amazon has enabled the usage of internet and central remote servers to maintain data and applications and created an environment where connectivity and availability is unobtrusive and prevalent. Amazon offers two options for hosting applications and databases. Amazon EC2 with Elastic Block Storage allows one to run a MySQL database server on Elastic Compute Cloud, an Infrastructure-as-a-Service provider, with Elastic Block Storage (EBS). Meanwhile, another option called Amazon’s Relational Database Services (RDS) is a scalable relational database in the cloud with high availability.

COMPARISON: Below is a detailed comparison of different features of both options.

• SET-UP: Once a MySQL is mounted on an instance of EC2, it can be up and running instantly without much time or effort required. Amazon’s EC2 comes with a set of API command line tools for different Linux distributions and for use with different File Systems to facilitate easy transition to the cloud. If a MySQL database exists already, it can be easily migrated to EC2 by creating an EBS volume, attaching that volume to EC2 and finally mounting the MySQL on that volume.

On the other hand, Amazon RDS has an efficient management console that helps with easy set-up and monitoring of resources. RDS provides instant access to the user’s own database software by deploying it over their own database instance. It also provides 10 GB of free data tier for people to experiment with RDS before taking the big step. Amazon RDS is more suited for new projects because it is easier to start fresh on RDS rather than migrate GBs worth of data to an unfamiliar territory. It also offers multiple features during initial set up such as Multi-AZ deployment, maintenance windows, automatic scaling and so on.

• DATA STORAGE: Both options don’t differ much when it comes to data storage. EBS offers large data storage of up to 1 TB in size and as a result, you can structure your database and tables around different EBS volumes or within the same EBS volume with MySQL hosted over EC2. Hierarchy and management of growth of the Database is relatively simple and traceable with EC2 and EBS.

Amazon RDS also provides large data storage with the pay-per-usage scheme. But to manage different databases, it would be more efficient to create different DB instances. With EBS, a certain amount of pre-determined storage is required initially. But with RDS, we get to create the space that we will definitely use and buy additional storage space only if needed. RDS provides very easy scalability solutions.

• PERFORMANCE AND QUERY-THROUGHPUT: Several tests have been performed by several experts to analyze which option provides high query throughput and performance. The vanilla MySQL over EC2 without RAID0 gives very sub-average performance. MySQL hosted over EC2 with EBS Raid 0, proper optimization and adjusted MySQL parameters produces optimal performance and results. But it fails...

Find Another Essay On mysql on ec2 vs rds

Microsoft's competitve environment Essay

942 words - 4 pages -the-decade.htmlMiller, R. (2014). Apple, Google, Microsoft, and the struggle to remain on top. CITEworld. Retrieved 7 October 2014, from,. (2011). Microsoft vs. the World: Can Microsoft Knock Out Its 6 Biggest Rivals? -- Redmond Channel Partner. Retrieved 7 October 2014, from

competitive environment Essay

942 words - 4 pages -the-decade.htmlMiller, R. (2014). Apple, Google, Microsoft, and the struggle to remain on top. CITEworld. Retrieved 7 October 2014, from,. (2011). Microsoft vs. the World: Can Microsoft Knock Out Its 6 Biggest Rivals? -- Redmond Channel Partner. Retrieved 7 October 2014, from

Business Utilization Of Open Source Software

1955 words - 8 pages Open Office. Open system vs. closed system. Closed systems such as Microsoft products are the property of the company who developed and is protected under patents or copyright laws. The codes and languages that the products are based on are kept secret and the source codes are not visible. With closed source it is also illegal to copy, redistribute or change the code in any way. Open source however, is the opposite. Open source software must

Executive Proposal

1430 words - 6 pages As threats evolve and change with each new technology introduced organizations will also have to strive to improve the techniques used to protect their critical Information Technology (IT) assets. Gartner's IT Key Metrics Data for 2010 which was based on a survey of companies worldwide found that a company spent 5% of their IT budget on IT Security (Kirk, 2010). Connie Guglielmo, a Forbes staff member noted that IT spending will hit $2

Red Hat Linux vs. Windows 2000

5256 words - 21 pages ;fulldump.dbOnce that is complete you can add 25% of the body to calculate the total size requirements. It is a good rule of thumb to allow an extra 50% on top of this for growth.A classic Windows 2000 installation requires approximate 1.5GB of space. Adding SQL Server or additional applications such as Java, Perl, or MySQL will push the base requirements up to 2GB.A UNIX is a multi-user operating system, which means users must share the computing

Windows Versus LINUX: A Comparison

2398 words - 10 pages Microsoft Windows has long dominated the business and home desktop market but there is a new contender on the block in the shape of LINUX that is beginning to compete with Microsoft Windows on many different fronts. What is this LINUX and how does it compare and contrast with the Microsoft Windows operating system?Microsoft Windows has been around since 1983 and it's present incarnation, Microsoft Windows 2000, owes its roots to Windows 3.x

Huffman Trucking

2882 words - 12 pages located elsewhere and handled by another storage management system (e.g. MySQL server). ❖ Costs – It will vary based on the selective packages available that interest Huffman Trucking needs. By approving this DBMS proposal, Huffman Trucking will have a preventive maintenance system that will expose the older trucks that are costing more money in maintenance and upkeep than they are worth. Replacing the older trucks with new ones

Unix vs. Windows

3158 words - 13 pages to calculate potential ROI for an operating system implementation. However, it is common to find that Windows and Linux cost about the same in hardware, with support costs tipping the equation one way or the other. However, analysts cannot agree on whether personal (vs. commercial) Windows or Linux support costs more over the long run. Commercial UNIX is another story, which analysts say just plain costs more in both hardware and support. Linux

Global Communications Benchmarking-Univerisity of Phoenix-MMPBL500

4235 words - 17 pages internet access at broadband speed" (Associated Press, 2004). How would this merge benefit both companies?CEO and President of Cingular Wireless, Stan Sigman said, "This combination is expected to create customer benefits and growth prospects neither company could have achieved on its own and will mean better coverage, improved reliability, enhanced call quality and a wide array of new and innovative services" (Associated Press, 2004). An

Operating Systems Comparison Analysis

6485 words - 26 pages both open-source and comparable to WinZip. According to the program's author, "GNOZIP is a GUI front-end to many compression/archiving utilities, such as tar, zip, gzip, bzip2, etc" (, 2008).Lastly, for both businesses choosing the Windows or Linux platforms, a database management application will probably be necessary. MySQL provides an open-source product for multiple platforms including Windows and Linux. Depending on their

sql injection

5877 words - 24 pages like MS SQL Server, Oracle, DB2, MySQL, and PostgreSQL. 4.1 Authorization by pass (SQL manipulation) This technique would give the attacker access to the with the privileges of the first user in the database. This attack would be used to by pass the log on screen. The SQL statement used by the application is: 1. SQL= SELECT Username FROM Users WHERE Username= &strInputUsername& AND Password = &strInputPassword& 2

Similar Essays

Database Comparison Of Sql Server 2000, Access, My Sql, Db2, And Oracle

1075 words - 4 pages Introduction This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of

Advantages Of My Sql Over Oracle Essay

1507 words - 6 pages less effective on the system and is mainly used by companies that are processing large amounts of data such a data warehouse. Oracle’s backup feature is much faster and better than the MySQL, It saves a backup in seconds/minutes whereas MySQL can take forever. 2014. MySQL vs. Oracle Security Concurrency Concurrency is a feature that allow multiple users of a database to read, modify or update multiple transactions of a shared

Netflix Architechture And Understanding Iimproving Multi Cdn Delivery

2300 words - 10 pages amazon cloud services, ranging from EC2 and S3 to SDB and VPC. Altogether five key points for using AWS according to (Badcock, 2013) are: • Weigh costs vs Business Goals. • Plan ahead for disaster: According to Netflix chief cloud architect Adrian Cockcroft “Netflix wants 50% of its operations in one region and 50% in another with one region serving as the fail-over site for the other.” • Use Reserved Instances appropriately: Reserved instance

Cloud Computing Software Essay

2192 words - 9 pages as we know it today. It then goes on to define and discuss the types of cloud deployment methods also known as the different ways of approaching the cloud. They are the public, community, private and hybrid cloud. The next section then again defines and discusses the three main cloud delivery models which are the Platform-as-a-service, Infrastructure-as-a-service and software-as-a-service. A brief conclusion will be delivered at the end of the