the power of postgres plus cloud database
DESCRIPTION
During this presentation, cloud database architect Hans Hrasna, reviews how to leverage the cloud to: Extend the benefits of the Postgres systems already running in your datacenter Save your company time and money Optimize and protect your database deployments Expand your options for development or deploymentTRANSCRIPT
© 2014 EnterpriseDB Corporation. All rights reserved. 1
Postgres Plus Cloud Database
Hans Hrasna, Sr. Architect, EDB 2014
© 2014 EnterpriseDB Corporation. All rights reserved. 2
POSTGRES innovation
ENTERPRISE reliability
24/7 support
Services & training
Enterprise-class features & tools
Indemnification
Product road-map
Control
Thousands of developers
Fast development
cycles
Low cost
No vendor lock-in
Advanced features
Get The Best Of Both Worlds
© 2014 EnterpriseDB Corporation. All rights reserved. 3
Postgres Plus Advanced Server Postgres Plus
Cloud Database
High Availability Performance Management
REMOTE DBA 24x7
SUPPORT PROFESSIONAL
SERVICES
TRAINING
EDB Serves All Your Postgres Needs
PostgreSQL
Security
© 2014 EnterpriseDB Corporation. All rights reserved. 4
Postgres Plus: everything in PostgreSQL PLUS...
4
Security: • Fine Grained Audit Logging • Row Level Security (VPD) • SQL Injection attack guard • Server-side code protection • EAL2 certification
Bundled Tools:
• Oracle & SQL Server to Postgres replication
• Enterprise management, monitoring, and tuning
• Oracle & SQL Server to Postgres Migration Tools
• Update Monitor
Oracle Compatibility: • 60% of customers migrate
in <2 weeks • PL/SQL, OCI support • Oracle SQL extensions • User defined objects • Function packages • Database links • Oracle-like tools:
EDB*Loader, EDB*Plus, EDB*Wrap
Performance:
• Partitioning: -400x faster writes -76x faster selects
• SQL Profiler--find / fix slow SQL workloads
• Bulk Data Loader--2x faster • Index Advisor—speeds up
slow queries • Query Hints--optimizer control • DynaTune—auto-tunes for memory upgrades • Bulk Collect/Fetch/Binding of arrays • Dynamic runtime statistics reveals SQL wait bottlenecks
© 2014 EnterpriseDB Corporation. All rights reserved. 5
• Easy, fast start-up in minutes
• Elastic storage Adds disk space when needed
• Elastic scale out Adds clusters automatically based on usage levels
• Self-healing clusters • Scheduled backups • Automatic failover • Easy to use monitoring
EASY
• Private instances Not shared
• Set your own scale-out and back-up parameters • Access to set your own tuning configurations
MAXIMUM CONTROL
• Run PostgreSQL or Postgres Plus • Same DB in Cloud as in DC Portability between environments
• AWS, OpenStack, CloudStack or bare metal environments
PORTABILITY
© 2014 EnterpriseDB Corporation. All rights reserved. 5
CLOUD DATABASE
POSTGRES
PLUS
Enterprise Control & Portability
© 2014 EnterpriseDB Corporation. All rights reserved. 6
Use Case: Expand Data Space
© 2014 EnterpriseDB Corporation. All rights reserved. 7
Use Case: Increase Read Bandwidth
© 2014 EnterpriseDB Corporation. All rights reserved. 8
Use Case: Master Fail-over to new VM
© 2014 EnterpriseDB Corporation. All rights reserved. 9
Use Case: Master Fail-over to Slave
© 2014 EnterpriseDB Corporation. All rights reserved. 10
DATABASE CLUSTER
Master Database
Writes Reads
Streaming Replication
Master Replicas Master Replicas Master Replicas
AUTOMATICALLY CREATED
Connection Pooler & Load Balancer
Postgres Plus Cloud Database
Cluster Manager Auto-provisioning, Health Check, Auto: Failover, Scaling, Backup
GUI Cloud Console
Admin App or Terminal
Cloud Resources Network, Elastic IP, Elastic Storage, VMs, Security, Hardware
Client Apps/Users
Auto Elastic
Scale-Out
© 2014 EnterpriseDB Corporation. All rights reserved. 11
Architecture Detail
© 2014 EnterpriseDB Corporation. All rights reserved. 12
Postgres Plus Cloud Database
ssh
1
2
3
4 7
6
5
8
1 Scale replicas up / down 2 Clone cluster 3 Upgrade Postgres version 4 Scale server class 5 Server DNS / Port 6 Failover modes 7 User selectable scaling thresholds 8 DB Configuration, monitors, log
© 2014 EnterpriseDB Corporation. All rights reserved. 13
Demo
© 2014 EnterpriseDB Corporation. All rights reserved. 14
Postgres Cloud Database References
• How It Works
• www.enterprisedb.com/cloud/how-it-works
• Free Trial or Buy it Now
• www.enterprisedb.com/cloud
• Contact us for more information
© 2014 EnterpriseDB Corporation. All rights reserved. 15