Title: MySQL on the Cloud
1MySQL on the Cloud AWS EC2 v/s AWS RDS
2 About Neev
Key Company Highlights
Web
Mobile
Cloud
Magento eCommerce SaaS Applications Video
Streaming Portals Rich Internet Apps Custom
Development
AWS Consulting Partner Rackspace Joyent
Heroku Google App Engine
iPhone Android Windows Phone 7 HTML5 Apps
250 team with experience in managing offshore,
distributed development.Neev Technologies
established in Jan 05 VC Funding in 2009 By
Basil Partners Part of Publicis Groupe Member
of NASSCOM.Development Centers in Bangalore
and Pune. Offices at Bangalore, USA, Delhi,
Pune, Singapore and Stockholm.
User Interface Design and User Experience Design
Performance Consulting Practices
Quality Assurance Testing
Outsourced Product Development
3 AWS EC2 An unwanted Gift ?
- There are many disadvantages to the traditional
method of running MySQL on the cloud. A few of
them are - Installation of database software like MySQL is
necessary - Regular patches have to be made to the instance
- Managing backups is difficult
- Replication failures need to be handled
4 AWS RDS How it helps
- With just a few clicks , AWS RDS
- takes care of provisioning the infrastructure
capacity you request and installing the database
software. - performs automated backups as configured with
point-in-time recovery options. You may also
manually initiate a DB snapshot to backup your DB
in a known state. - offers backup retention for up to the last 35
days. - applies patches that are security and durability
related. - manages synchronous data replication across
physically distinct locations (Multi-AZ
deployments). - performs automatic failovers in case of certain
failures and no need for manual administrative
intervention on Multi-AZ deployments. - creates Read Replicas (similar to MySQL Slaves)
as requested for read intensive workloads. - Enables Monitoring the compute and storage
resource utilization of your DB Instance, for no
additional charge, via Amazon CloudWatch.
5 AWS EC2 vs AWS RDS
- Amazon RDS automatically stripes across multiple
EBS volumes to enhance IOPS (input/output
operations per second) performance. Similar
performance may be realized on EC2 only by going
with a RAID0 EBS but doing RAID0 EBS requires a
significant amount of maintenance overhead. - In addition, for I/O intensive transactional
workloads that need consistent performance, RDS
Provisioned IOPS lets one specify an IOPS rate
when creating a DB Instance. Amazon RDS will then
provision that IOPS rate for the lifetime of the
DB instance. You can provision a MySQL instance
with up to 30,000 IOPS! - Just as in the case of EC2, you can increase or
decrease the CPU and memory available to a DB
instance by changing its instance class. Amazon
RDS will perform the upgrade during the next
maintenance window. The Amazon RDS maintenance
window provides an opportunity to control when DB
Instance modifications (such as changing DB
Instance class) and software patching must occur.
6Easy Replication and Automatic Failover with RDS
- Running your DB Instance as a Multi-AZ deployment
can further reduce the impact of a maintenance
event or a DB instance failure. - In a Multi-AZ deployment, Amazon RDS
automatically provisions and maintains a
synchronous standby replica in a different
Availability Zone. - During certain types of planned maintenance, or
in the event of DB Instance failure or
Availability Zone failure, Amazon RDS will
automatically failover to the standby and your
application can resume database operations
without the need for manual administrative
intervention. - If you need to scale-out for read intensive
workloads, you can create any number of Read
Replicas. Database updates on the source DB
Instance will be replicated using MySQLs native,
asynchronous replication. - You may also want to run reporting queries
against a Read Replica, rather than on your
primary, production DB Instance. RDS provides
excellent options to tune Read Replicas for such
specific operations. See here for more info
http//aws.amazon.com/rds/faqs/95
7Automated Backup with RDS
- Amazon RDS offers automated backups with
point-in-time recovery and once configured,
automatically performs a full daily snapshot of
your data and captures transaction logs (as
updates to your DB Instance are made). - Amazon RDS retains backups of a DB Instance for
upto the last 35 days (configurable). - DB Snapshots can also be user-initiated and
enables you to back up your DB Instance in a
known state as frequently as you wish, and then
restore to that specific state at any time.
8Database Tuning with RDS
- In order to tune an RDS instance, you use a
database parameter group which acts as a
container for engine configuration values that
can be applied to one or more DB Instances. - This allows you to create a certain tuned
parameter set that can be easily reused across DB
instances. - By default however, Amazon RDS chooses the
optimal configuration parameters for your DB
Instance taking into account the DB Instances
compute resource and storage capacity.
9Clients
10 Partnerships
11sales_at_neevtech.com
Neev Information Technologies Pvt. Ltd.
Sweden
Singapore
India - Bangalore
USA
India - Pune
Neev AB, Birger Jarlsgatan 53, 6tr, 11145,
Stockholm Phone 46723250723
13 LSquare, 3rd Floor Parihar Chowk,
Aundh, Pune 411007. Phone 91-64103338
The Estate, 121,6th Floor, Dickenson
Road Bangalore-560042 Phone 91 80 25594416
08-03 SGX Centre 2, 4 Shenton Way, Singapore
068807 Phone 65 6435 1961
1121 Boyce Rd Ste 1400,Pittsburgh PA 15241 Phone
1 888-979-7860
For more info on our offerings, visit
www.neevtech.com