1 / 24

Mastering Amazon RDS

Mastering Amazon RDS. Data Masters. Special Thanks To…. Miami Innovation Center for Entrepreneurship www.startup-miami.com/ mice. Our Sponsor!. John Jadvani 954-527-0090. Short bio about me… Andrew Simkovsky 15 years working with database technology

varana
Download Presentation

Mastering Amazon RDS

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. MasteringAmazon RDS Data Masters

  2. Special Thanks To… Miami Innovation Center for Entrepreneurship www.startup-miami.com/mice

  3. Our Sponsor! John Jadvani 954-527-0090

  4. Short bio about me… • Andrew Simkovsky • 15 years working with database technology • Oracle, MySQL/MariaDB, SQL Server, Postgres • Redis, MongoDB, CouchDB, Cassandra, Neo4j • Worked across many industries • Consulting, Retail, Telecommunications, Energy • Data, Marketing, Gaming, Health care

  5. DBTekPro www.dbtekpro.com andrew@dbtekpro.com @asimkovsky

  6. Let’s Get Started!

  7. What is the “Cloud”? Fancy Hosting

  8. Evolution of the Cloud • Website on a shared hosted server • Website on a dedicated hosted server • Virtualized servers with a management toolset • Abstract services: • Storage as a service • Database as a service • Applications as a service • Most are “pay as you go”

  9. Cloud Service Providers

  10. Some Cloud-based Solutions

  11. Amazon Web Services • EC2 (Elastic Cloud 2) – virtualized servers • EBS (Elastic Block Storage) – disk volumes • S3 (scalable storage) – arbitrary storage • Glacier – archive / backup storage • RDS – relational database service • Elastic Beanstalk – application containers

  12. RDS • Dynamically provisioned database storage • No operating system for you to access • Platforms: • MySQL • Oracle • SQL Server • PostgreSQL • “Mostly” pre-configured

  13. Some cool features… • On-demand provisioning • Basic monitoring / metrics provided • Automated backups • Automated recovery • User initiated “snapshots” • Automated replication • Software upgrades provided

  14. Some gotchas… • Failovers are NOT instant. • Can take up to 6 minutes. Maybe more, depending on database size • Only limited platforms / versions are supported. • Upgrades / patching requires downtime. • You set an allowable maintenance window. Amazon will upgrade sometime during that window. • Can suffer from “noisy neighbor” syndrome. • Performance issues are sometimes hard to pinpoint • Master-Master replication is NOT supported

  15. RDS vs EC2+Database RDS EC2+Database You manage it yourself OS & storage overhead Software / version management Configuration Usually more costly More control over config / performance Allows more complex setups • Quick provisioning • “Easy” management • Simple environment setup • Simplified replication strategy • No OS-level control • Limited granular fine tuning • Limited platform / versions Easeof use Power & Control

  16. Some General AWS Concepts

  17. Amazon Regions

  18. Availability Zones REGION AZ1 AZ2 M S AZ3 AZ4 S S

  19. Security Groups • A “virtual” firewall • Can create a security group and place resources inside them • Can set access rules between security groups • Access rules can specify source/destination IP addresses, port numbers, etc.

  20. Security Groups Server Server Cache Servers Server Server Application Servers Database Database Database Servers

  21. Amazon AWS Free Tier (first 12 months) • 750 hours EC2 Linux “micro” server • 750 hours EC2 Windows “micro” server • 750 hours Elastic Load Balancer • 30gb EBS Storage • 5gb S3 Storage • 100mb DynamoDB storage • 750 hours RDS “micro” instance with 20gb of storage • 750 ElastiCache

  22. Live Demo!

  23. Questions?

  24. Thank You For Coming! Please rate this Meet Up: www.meetup.com/data-masters (or go there to join!) Check out my blog and forums: www.dbtekpro.com

More Related