MySQL on the Cloud

About This Presentation
Title:

MySQL on the Cloud

Description:

MySQL on the Cloud – PowerPoint PPT presentation

Number of Views:15

less

Transcript and Presenter's Notes

Title: MySQL on the Cloud


1
MySQL 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.

6
Easy 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

7
Automated 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.

8
Database 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.

9
Clients
10
Partnerships
11
sales_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
Write a Comment
User Comments (0)