postgres plus cloud database on openstack

© 2013 EDB All rights reserved 8.1. 1

Postgres Plus Cloud Database on OpenStack

© 2013 EDB All rights reserved 8.1. 2

•  Who is EDB?

•  A quick bit on PostgreSQL

•  What is PPCD

•  Architecture

•  Open Stack details

•  Demo

Agenda

© 2013 EDB All rights reserved 8.1. 3

•  Founded in 2004

•  Largest Commercial entity behind PostgreSQL

•  Have a product based on PostgreSQL

•  Employ 2 of the 6 core team members

•  4 of the 20 committers

•  Introduced our Postgres Plus Cloud database 2 years ago

•  Roughly 200 hundred customers

•  Some on HP Cloud Services

•  Majority on AWS −  About to change

Who is EDB

© 2013 EDB All rights reserved 8.1. 4

•  The most feature rich open source database

•  Performs extremely well

•  The most pristine source code base you have ever seen

•  Extremely reliable

•  Beats MySQL in most benchmarks – after proper tuning

•  Culture of perfection

What you need to know about Postgres

© 2013 EDB All rights reserved 8.1. 5

PostgreSQL Success To do: Need more customers.

© 2013 EDB All rights reserved 8.1. 6

PostgreSQL Jobs Growth Ineed.com"

6 © 2012 EnterpriseDB. Confidential and Proprietary. All rights reserved.

© 2013 EnterpriseDB. All rights reserved.

© 2013 EDB All rights reserved 8.1. 7

What is Postgres Plus Cloud Database ? Features Benefits

PostgreSQL database Enterprise-class database features & performance; fully Postgres compatible

Transparent/Elastic scaling Add data capacity and redundancy online with no business interruption

Automatic load balancing Increases read performance across multiple nodes

Automatic failover Built-in high-availability in case of primary database failure

Web-based interface Point-and-click management from start to finish from all popular web browsers

Status management/monitoring View global status & performance of complete cloud deployment

Online backup and recovery Full protection of data in the cloud; protects against data mishaps

Clone database Easily create developer ‘sandboxes’

Support for public, private cloud as well as in-house data center installs

Run anywhere and anyway that is desired

Oracle compatibility Allows cost-effective and easy way to move Oracle applications to the Cloud

© 2013 EDB All rights reserved 8.1. 8

Architecture

© 2013 EDB All rights reserved 8.1. 9

Screen Shot

© 2013 EDB All rights reserved 8.1. 10

Architecture detail

© 2013 EDB All rights reserved 8.1. 11

Use case: expand data

© 2013 EDB All rights reserved 8.1. 12

Use case: FailOver to replica

© 2013 EDB All rights reserved 8.1. 13

About the OpenStack API

Dynamic Storage

Elastic IP

© 2013 EDB All rights reserved 8.1. 14

Additional Information

Current release on HP Cloud 12.12 (Essex) Evaluating HP Cloud 13.5 (Havana) www.enterprisedb.com/products-services-training/products-overview/postgres-plus-cloud-database Tom.Kincaid@enterprisedb.com @tjkincaid

© 2013 EDB All rights reserved 8.1. 15

•  Have relied on the JCLOUDS abstraction layer

•  Market demand has been on AWS

•  Initial releases had limited volume creation and moving support

•  Factors that are bringing us to OpenStack −  Private Cloud −  AWS is going to be in every aspect of the stack

About the Open Stack implementation

© 2013 EDB All rights reserved 8.1. 16