1 / 11

MySQL on the cloud

MySQL on the cloud

neevtech
Download Presentation

MySQL on the cloud

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL on the Cloud: AWS EC2 v/s AWS RDS

  2. About Neev Key Company Highlights Web Mobile Cloud MagentoeCommerceSaaS 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 PublicisGroupe 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 MySQL’s 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 Instance’s compute resource and storage capacity.

  9. Clients

  10. Partnerships

  11. sales@neevtech.com Neev Information Technologies Pvt. Ltd. Sweden Singapore India - Bangalore India- Pune USA Neev AB, BirgerJarlsgatan 53, 6tr, 11145, Stockholm Phone: +46723250723 #13 L’Square, 3rd Floor PariharChowk, 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

More Related