Downloaded 32 times
Uploaded byGary Carter
Postgres Plus Cloud Database
EnterpriseDB's Postgres Plus Cloud Database provides fully automated and self-healing PostgreSQL clusters in the cloud. It offers features like high availability, elastic scaling, load balancing, automatic backups, and failover. The solution is database vendor independent, supports multiple cloud platforms, and provides a simple GUI for management. It aims to make cloud databases more fully featured while reducing the operational burden on database administrators.
More Related Content
Similar to Postgres Plus Cloud Database
![UiPath Automation Suite Installation (Hands-On) [2/3]](https://cdn.slidesharecdn.com/ss_thumbnails/automationsuitecommunitysession2-251015095633-a6d862f1-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Postgres Plus Cloud Database
- 1. Postgres Plus CloudDatabase from EnterpriseDB What’s it all about? October 2012 EnterpriseDB, Postgres Plus and Dynatune are trademarks of EnterpriseDB Corporation. Other names may be trademarks of their 1 respective owners. © 2010. All rights reserved.
- 2. Why are organizationsmoving to the cloud? Lower Costs • Utility style pricing allows you to pay only for what you use • Reduced on-premise spend (hardware, real estate, energy, licensing) • Cloud computing offers the capability to scale without the upfront costs On-premise data center vs. Cloud computing Backup Storage Applications House Maintain High Availability Productivity tools Build Buy Monitoring Hardware Hire Capital Investment Utility-like use/pricing © 2012 EnterpriseDB. All rights reserved. 2
- 3. Why are organizationsmoving to the cloud? Ease of Use • Pre-packaged setups (e.g. feature rich HA database clusters) • Automatic maintenance (DBaaS) • Little to no database administration expertise needed Running a Database in the Cloud vs. Running a Cloud Database © 2012 EnterpriseDB. All rights reserved. 3
- 4. Why are organizationsmoving to the cloud? Availability and Accessibility • Virtualization and Cloud offer the promise of 24 x 7 x 365 operations • Automation of previously difficult operations like scale up / out Europe N.A. APAC Africa S.A. © 2012 EnterpriseDB. All rights reserved. 4
- 5. Cloud Use Cases New Application Development • Easy to setup robust database clusters for short or long lived project work Small Startup Companies or projects • Allows focus on product development and not infrastructure setup Platform as a Service vendors • Integrate a scalable cloud database tier into their offerings • E.g. CloudBees or Engine Yard Migrating traditional workloads • Cost reduction initiatives Oracle cost reduction • Utilizing Postgres Plus Advanced Server in an HA cloud environment Smaller applications in need of world wide access • Developed by small organizations, non-profits, and individuals Offsite Disaster Recovery © 2012 EnterpriseDB. All rights reserved. 5
- 6. Today’s Cloud Databases… …many fail to take advantage of all the Cloud features • Elastic storage and auto-scaling of storage • Elastic load-balancing and connection pooling • Self-healing with failover and replacement • Automatic replication What else is missing? • User configurability: most solutions are ‘black box’ with no user control • Extensions like geo-spatial support Vendor Lock In • Each solution is tied to a vendor with special interests • A true cloud database is platform agnostic giving users choice and portability © 2012 EnterpriseDB. All rights reserved. 6
- 7. What should theCloud RDBMS look like? Postgres Plus Features Characteristics Cloud Database Open source based Mature, SQL standard, ACID compliant, high Enterprise grade RDBMS R/W performance Automatically create self Multi-server clusters with auto-backup, healing HA configurations replication, load balancing and connection and automate other Admin pooling. Clone database for sandbox tasks development. Daily grandfathered backups. Elastic Scale Up and Out Add storage and CPUs automatically and transparently Any Platform Public cloud, Private Cloud, or Bare Metal Cloud Vendor Independent Amazom, HP Compute Cloud, RackSpace Cloud, OpenStack, CloudBees, Engine Yard Black or white box control Serves novice and hands-on users with point and click GUI Other value adds NoSQL and Hadoop connectivity, enterprise monitoring options, Oracle compatibility © 2012 EnterpriseDB. All rights reserved. 7
- 8. Introducing… © 2012 EnterpriseDB.All rights reserved. 8
- 9. What is PostgresPlus Cloud Database? Pushbutton provisioning of high availability database clusters • Streaming replication between master and replicas • Connection pooling handle more users over time • Load-balancing of READS over the whole cluster • SQL Routing for WRITES to master with white and black listing of SQL • No special DBA or Administrative skills required • Start, Connect and code Self Healing clusters • Constant health and stats monitoring • Transaction preferred failover prevents loss of all committed transactions • Recovery Time preferred failover prioritizes recovery time • Cluster configuration fully restored after failover • Unattended operation © 2012 EnterpriseDB. All rights reserved. 9
- 10. What is PostgresPlus Cloud Database? Elastic Cloud features • Horizontal auto-scaling of replicas for spikey READ loads • Auto-scaling of storage based on user set threshold • Scale up server class size • Elastic IP maintains connection parameters for apps after failover Trouble Free Management features: • Daily automatic backups • Pushbutton cloning for developer sandboxes • Pushbutton version upgrade • GUI web console • Extensions friendly (e.g. GeoSpatial support) © 2012 EnterpriseDB. All rights reserved. 10
- 11. Feature Rich Easyto Use GUI 1 5 2 1 Scale replicas up / down 2 Clone cluster 3 Upgrade Postgres version 3 6 4 Scale server class 5 Server DNS / Port 4 6 Failover modes 7 7 User selectable scaling thresholds 8 DB Configuration, monitors, log 8 © 2012 EnterpriseDB. All rights reserved. 11
- 12. Cloud Database –Marketecture ssh © 2012 EnterpriseDB. All rights reserved. 12
- 13. What makes CloudDatabase unique? Built by the PostgreSQL company • Pure unforked community PostgreSQL • Community resources for support and troubleshooting Multi-platform: Amazon, CloudStack, OpenStack • No vendor lock-in Supports public cloud, private cloud and bare metal deployments Oracle Compatibility option © 2012 EnterpriseDB. All rights reserved.
- 14. Compatibility – Akey differentiator Move existing Oracle applications to use a much less expensive Oracle-compatible database in the Cloud Reuse existing Oracle development skills and create new applications that target Postgres Plus Cloud Database © 2012 EnterpriseDB. All rights reserved. 14
- 15. Postgres Plus CloudDatabase Product Detail Feature Benefits PostgreSQL based databases Pure community PostgreSQL – no forks, or with Enterprise-class features Postgres Plus Advanced Server CreateHigh Availability clusters in Saves hours and days of setup, DBAs can minutes with point and click GUI manage more servers, novice user accessible Transparent and Elastic auto- Add storage or read replicas with no application scaling changes, business interruption, or human action Binary replication Automatically setup and keeps all servers in the cluster up to date with the master Load balancing Automatically setup to Increase read performance across multiple cluster nodes Connection Pooling Automatically setup to serve more client connections efficiently Grandfathered auto-backups daily Automatically setup to protectdata in the cloud and guard against mishaps Automatic failover 2 Self-healing options replace downed master or replicas without human intervention Status management/monitoring View globalstatus & performance of completecloud deployment Clone database Create developer ‘sandboxes’ in minutes based on production data Oracle compatibility Allows cost-effective and easy way to move Oracle applications to the Cloud © 2012 EnterpriseDB. All rights reserved. 15
- 16.
- 17. Demo: Register andLogin © 2012 EnterpriseDB. All rights reserved. 17
- 18. Demo: the Dashboard ©2012 EnterpriseDB. All rights reserved. 18
- 19. Demo: Create aNew Cluster - servers © 2012 EnterpriseDB. All rights reserved. 19
- 20. Demo: Create aNew Cluster - backups © 2012 EnterpriseDB. All rights reserved. 20
- 21. Demo: Cluster startedin minutes © 2012 EnterpriseDB. All rights reserved. 21
- 22. Demo: Scale-Up © 2012EnterpriseDB. All rights reserved. 22
- 23. Demo: Scale-Up Events ©2012 EnterpriseDB. All rights reserved. 23
- 24. Demo: User Management ©2012 EnterpriseDB. All rights reserved. 24
- 25. Pricing Standard Amazon EC2 based pricing • Multiple components to pricing: data xfer, instance size, usage time, … • EnterpriseDB only marks up the EC2 On-Demand Instances component Cloud Database Pricing • http://www.enterprisedb.com/cloud-database/pricing Help Calculating Pricing • http://www.enterprisedb.com/cloud-database/faqs#estimatecosts © 2012 EnterpriseDB. All rights reserved. Confidential & Proprietary. 25
- 26. Get Started Today! Test drive the Free Trial • http://www.enterprisedb.com/cloud-database/amzn-launch-guide-free-trial Participate in our Forums • http://forums.enterprisedb.com/forums/show/21.page Sign up today for the DBaaS • http://www.enterprisedb.com/cloud-database/amzn-launch-guide-dbaas Need assistance? We have services to help: • http://www.enterprisedb.com/products-services-training/services © 2012 EnterpriseDB. All rights reserved. Confidential & Proprietary. 26
- 27.
Editor's Notes
- #4 While mature and well understood, database technology is as complex as the new platform you are buildingDeveloping new features, maintaining existing builds, making performance enhancements, etc. requires expertise and dedicated focus that is a distraction from the main purpose of the platformOff-the-shelf PostgreSQL does not give you (and your customers) the cloud features needed in your platform