Downloaded 12 times
Uploaded byEDB
How to Build On-demand Oracle Compatible Postgres Database in Minutes
The document outlines the features and capabilities of EDB's Postgres Cloud Database Service, targeting various user cases from migration to providing managed development environments. It emphasizes key offerings such as Oracle compatibility, automated support, robust monitoring, and cloud security measures. The service is designed for both new and experienced users, ensuring scalability, resilience, and ease of access in cloud environments.
How to Build On-demand Oracle Compatible Postgres Database in Minutes
- 1. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.1 Kanchan Mohitey CLOUD DATABASE SERVICE (CDS)
- 2. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2018. All rights reserved.
- 3. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved. EDB POSTGRES CLOUD DATABASE SERVICE Target user cases NEW USER • Quickly try Postgres MIGRATION USER • Validate Oracle™ to EDB Postgres migrations CLOUD USER • Looking for Oracle compatible alternative EXPERIENCED USER • Rapid set up/tear down postgres cluster • Same Postgres everywhere • Managed dev/test environment
- 4. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved. EDB POSTGRES CLOUD DATABASE SERVICE Hosted EDB Postgres on the public cloud ● On Demand and Reserved ü Easy access and provisioning ü Use case based Pre-defined templates ● Highly available and resilient ü Load balancing, automatic failover and elastic scale-out ü Secure data encryption ● Oracle Compatible ü EDB Postgres with Oracle compatibility ü Integrated with EDB Migration Portal ● True Postgres ü Same Postgres everywhere ü Complete DBA management
- 5. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.5 DEMO Migration to Management
- 6. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved. EDB POSTGRES CLOUD DATABASE SERVICE Features MIGRATION TESTING Deploy the schema directly as a Cloud Database Service instance SUPPORT INCLUDED for no additional fee Support from certified Postgres experts via email and online Portal ENTERPRISE FEATURES Database Automation, Resiliency, Templates
- 7. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved. PGR COMMUNITY CDS Help Desk & CDS Resource Center EDB’s Online Postgres Community Resources for all things Postgres
- 8. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.8 EDB POSTGRES MONITORING Monitoring using PEM Postgres Expert ü Analyzes Configuration, Schema & Security ü Provide Advice
- 9. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.9 EDB POSTGRES MONITORING Monitoring using PEM Alerts ü Trigger Alerts based boundaries set ü Alert statistics ü Alerts configured to be sent ü Define Post Alert actions
- 10. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.10 EDB POSTGRES MONITORING Monitoring using PEM Tuning Wizard ü Review server Installation ü Recommends tune-up based on the anticipated workload
- 11. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.11 EDB POSTGRES MONITORING Monitoring using PEM Performance Diagnostic ü Analyze database performance monitoring the wait events
- 12. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved. EDB POSTGRES MONITORING Prometheus
- 13. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.13 CLOUD SECURITY Pertaining to the infrastructure Access ü Cloud Infrastructure, ü Application Server ü Database Server Encryption ü At Rest – Checkbox in dialogue ü In transit – Always enabled Network to/from Server ü Client connection allowed over secure protocol & ciphers. ü Server configured to reject anything insecure Monitoring & Alerting ü Alerting based on cloud-watch logs ü Alarm triggers emails Auditing ü OS Auditing ü Database Auditing ü Audit trails maintained by Separate team.
- 14. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.14 THE FASTEST WAY OFF ORACLE TO THE CLOUD Migration Portal Combines • Native Oracle Compatibility ü Schemas ü DB Code ü Application interfaces • Rich knowledge base from 10+ years of migrations • Crowd sourced discovery of new code translations
- 15. CONFIDENTIAL © CopyrightEnterpriseDB Corporation, 2019. All rights reserved.15 THANK YOU CLOUD DATABASE SERVICE